Job Description

Experience: 5-10 years
Location: Bangalore, Pune, Kolkata, Gurgaon, Chennai
We are seeking highly motivated and result-oriented professionals with a problem-solving mindset to join our dynamic team. As a consultant, you will be instrumental in designing and delivering efficient data solutions, optimizing existing processes, and driving timely execution across projects.
Your Key Responsibilities

• Design, develop, and maintain ETL pipelines to ingest, transform, and load data from various sources.
• Write efficient and optimized SQL queries for data extraction, transformation, and reporting.
• Develop and maintain Python scripts for data processing, automation, and integration tasks.
• Create and manage data models that support analytics and business intelligence needs.

• Integrate data from multiple sources using RESTful APIs, ensuring consistency, accuracy, and performance.

• Conduct unit testing, regression testing, performance testing, and concurrency testing to ensure data integrity and system reliability.
• Monitor and optimize data pipeline performance and troubleshoot issues proactively.
• Collaborate with cross-functional teams including data scientists, business analysts, product owner and business stakeholders.
• Use JIRA or equivalent project management tools to manage tasks, track progress, and document work.
• Maintain comprehensive technical documentation for data flows, architecture, and processes.

Skills and Attributes for Success

• Strong analytical and logical thinking.
• Ability to simplify complex problems and deliver optimized solutions.
• Commitment to timely delivery and continuous improvement.
• Proactive approach to learning and adopting new technologies.
• Effective communication and collaboration skills.

To Qualify for the Role, You Must Have

• Experience: 5-10 years in SQL / ETL development.
• Mandatory Skills:

• Proficiency in writing complex SQL queries, Python scripts and Java for UI development
• Understanding of database management systems.
• Familiarity with basic process algorithms.
• Comfort with looping and conditional logic.
• Added Advantage:

• Knowledge of JavaScript or Python.
• Industry Experience:

• Exposure to one or more of the following domains: Consumer Goods, Manufacturing, Automotive and Life Sciences
• Experience in Data Analytics or as a SQL Developer.
• Good to Have Skills:

• AERA SB certification.
• Basic understanding of supply chain concepts.
• ERP (SAP ECC) system knowledge.

What We Look For

• A self-starter with a passion for data and problem-solving.
• Ability to work independently and in teams.
• A mindset geared towards continuous learning and improvement.
• Strong ownership and accountability for deliverables.

What Working Here Offers
At EY, we're dedicated to helping our clients, from startups to Fortune 500 companies - and the work we do with them is as varied as they are.
You get to work with inspiring and meaningful projects. Our focus is education and coaching alongside practical experience to ensure your personal development. We value our employees, and you will be able to control your own development with an individual progression plan. You will quickly grow into a responsible role with challenging and stimulating assignments. Moreover, you will be part of an interdisciplinary environment that emphasizes high quality and knowledge exchange. Plus, we offer:

• Support, coaching and feedback from some of the most engaging colleagues around
• Opportunities to develop new skills and progress your career
• The freedom and flexibility to handle your role in a way that's right for you

EY | Building a better working world
EY exists to build a better working world, helping to create long-term value for clients, people and society and build trust in the capital markets.
Enabled by data and technology, diverse EY teams in over 150 countries provide trust through assurance and help clients grow, transform and operate.
Working across assurance, consulting, law, strategy, tax and transactions, EY teams ask better questions to find new answers for the complex issues facing our world today.