Senior Data Analyst (Oracle, SQL, PLSQL, Unix, Python)

Job description

Job description: Job Description Job briefWe are looking for a Sr. Oracle SQL + PLSQL Developer with experience in building high-performing, scalable, enterprise-grade applications, in Linux environments. You will be part of a talented software team that works on mission-critical applications. You will be responsible for planning and making documented requirements, providing solutions on them, from concept and design to testing.Technical Skills:• Bachelor’s degree in Computer Science / Engineering or a related subject• Minimum 8+ years of Oracle development experience, using SQL/PL-SQL.• Must have in Unix shell/bash scripting/commands.• Must have understanding of Hadoop skill set.• Expert experience in Oracle database data modelling / design• Sound understanding of database query optimization/tuning• Ability to troubleshoot complicated issues and resolve them.• Ability to communicate clearly, both at a technical level with other teammates and at a functional level with business stakeholders and Client• Create Functional, Technical & Testing documentation• Troubleshoot and fix issues reported by QA and Customers and help product support• Nice to have: Experience using JIRA, working on an Agile/Scrum team, Git• Nice to have: some exposure to Redshift Aws environments, Hive Behavioral Skills:• Self-motivated and able to perform with minimal supervision• Must have good verbal, written and interpersonal communication skills• Clearly demonstrated passion for programming• Focused and hardworking individual• Willingness to put in extra effort as and when required• Ability to effectively work as part of a global teamResponsibilities• Design and develop high-volume, low-latency applications for mission-critical systems, delivering high-availability and performance.• Contribute to all phases of the development lifecycle.• Write well designed, testable, scalable, efficient code.• Ensure designs are in compliance with specifications.• Collaborate with cross-functional teams to define, design, and ship new features.• Unit-test code, usability, reliability, and performance testing of code/app.• Work on bug fixing and improving application performance.• Prepare and produce releases of software components. Mandatory Skills : Oracle, SQL, PLSQL, Unix, Python ͏ **Do** 1. Managing the technical scope of the project in line with the requirements at all stages a. Gather information from various sources (data warehouses, database, data integration and modelling) and interpret patterns and trends b. Develop record management process and policies c. Build and maintain relationships at all levels within the client base and understand their requirements. d. Providing sales data, proposals, data insights and account reviews to the client base e. Identify areas to increase efficiency and automation of processes f. Set up and maintain automated data processes g. Identify, evaluate and implement external services and tools to support data validation and cleansing. h. Produce and track key performance indicators 2. Analyze the data sets and provide adequate information a. Liaise with internal and external clients to fully understand data content b. Design and carry out surveys and analyze survey data as per the customer requirement c. Analyze and interpret complex data sets relating to customer’s business and prepare reports for internal and external audiences using business analytics reporting tools d. Create data dashboards, graphs and visualization to showcase business performance and also provide sector and competitor benchmarking e. Mine and analyze large datasets, draw valid inferences and present them successfully to management using a reporting tool f. Develop predictive models and share insights with the clients as per their requirement ͏ **Deliver** NoPerformance ParameterMeasure1.Analyses data sets and provide relevant information to the clientNo. Of automation done, On-Time Delivery, CSAT score, Zero customer escalation, data accuracy͏ ͏ Reinvent your world. We are building a modern Wipro. We are an end-to-end digital transformation partner with the boldest ambitions. To realize them, we need people inspired by reinvention. Of yourself, your career, and your skills. We want to see the constant evolution of our business and our industry. It has always been in our DNA - as the world around us changes, so do we. Join a business powered by purpose and a place that empowers you to design your own reinvention. Come to Wipro. Realize your ambitions. Applications from people with disabilities are explicitly welcome.