ETL-Automation-GIG

EY; Tada; On-site; INR 1,500,000 - 2,800,000; Full time

Benefits offered by this job

Health & wellness packages

Premium learning opportunities

Job summary

EY is seeking a Senior ETL/Power BI tester to drive comprehensive validation of ETL pipelines, data quality checks and dashboard testing. You will design test strategies, create test cases, and lead UAT coordination with the client analytics team in a fast-paced global delivery environment.

The role emphasizes collaboration with QA, engineering and business teams, knowledge of SQL, data validation, and experience with ETL testing and Power BI dashboards.

Qualifications

• Experience in ETL Testing and Power BI Testing.
• Automation Testing exposure is a plus.
• Ability to design and execute end-to-end test plans for ETL pipelines.

Responsibilities

• Develop detailed test plans for ETL pipelines.
• Design and execute tests based on source-to-target mappings.
• Collaborate with client analytics teams for UAT plans and testing.
• Drive end-to-end test cycles, defect tracking and remediation.
• Coordinate across QA, engineering and business teams.

Skills

Requirement Analysis

Test Scenario Design

Test Case Creation and Execution

UAT Support

Regression Testing

JIRA/Confluence

Agile/Scrum Methodology

Defect Management

Stakeholder Communication

Tools

SQL

Power BI

Job description

Job Description

At EY, you’ll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we’re counting on your unique voice and perspective to help EY become even better, too. Join us and build an exceptional experience for yourself, and a better working world for all.

Service Line – ETL; Position Title - Senior

At EY, we’re all in to shape your future with confidence.

We’ll help you succeed in a globally connected powerhouse of diverse teams and take your career wherever you want it to go.

Join EY and help to build a better working world.

About Global Delivery Services

Global Delivery Services refers to EYs worldwide network of service delivery center. The GDS team plays an important role in EY’s strategy by ensuring effective support to EY’s growth agenda.

Our journey started in 2002 with approximately 200 people. Today we stand at 80,000+ professionals in ten locations around the world. We operate in Argentina, China, Hungary, India, Philippines, Poland, Sri Lanka, Mexico, Spain and the United Kingdom.

Client service is focused on providing Consulting, Assurance, Tax, Strategy & Transactions, and Knowledge support to our clients around the world. The teams enable account teams worldwide to provide seamless, high-quality, value-added support, helping deliver exceptional client service.

Enablement Services provides cost-effective, high-skilled, and innovative services to support EY’s global and local enablement teams. Markets, BMC, AWS, Finance and Accounting, Risk Management, Procurement, People Shared Services, IT Service Delivery and IT Global Infrastructure services, are among the services offered by Enablement Services.

Our innovation specialists serve the GDS Client Service and Enablement Services teams, along with Service Lines, Core Business Services and Sectors. The team brings the desired environment, technologies and skilled teams together for facilitation, rapid prototyping and innovative thinking. The competencies offered include analytics, digital, user experience, mobile technology, infrastructure, Microsoft technologies and open innovation.

The Opportunity

• 5 to 10 years of experience in ETL Testing/PowerBI Testing with basic expertise in Automation Testing.

Your Key Responsibilities

• Develop comprehensive and detailed test plans for ETL pipelines.
• Design and execute test cases based on source-to-target mapping documents across layers.
• Create and manage UAT test plans and test cases based on existing dashboards, in close collaboration with the client’s analytics team.
• Execute test cycles end-to-end, track defects, manage issue resolution, and support iterative testing cycles.
• Ensure clear communication, coordination, and status tracking across QA, engineering, and business teams.
• Responsible for decision-making, optimizing processes, resource management, and overseeing team management as needed for task execution.

Skills and attributes for success

Testing skills

• Requirement Analysis
• Test Scenario Design
• Test Case Creation and Execution
• User Acceptance Testing (UAT) Support
• Regression Testing
• JIRA/Confluence (any QC tool)
• Agile/Scrum Methodology
• Defect Management
• Stakeholder Communication

Core Power BI Skills

• Power BI Dashboard and Report Testing
• Data Validation and Reconciliation Testing
• DAX Formula Validation
• KPI and Metric Verification
• Visualizations Testing (Charts, Tables, Maps, Cards)
• Filter, Slicer, and Bookmark Validation
• Security Role (RLS) Testing
• SQL Query Writing and Validation

Additional Skills

• Strong Structured Query Language (SQL), including window functions (ETL Skillset)
• Experience testing Streaming or Change Data Capture (CDC) pipelines (ETL Skillset)
• Databricks/Snowflake or Apache Spark (ETL Skillset) - Strong understanding of data migration, data quality, and reconciliation processes.
• Ability to work with large datasets, complex reporting structures, and high-volume test scenarios.
• Robot Framework (Automation Skillset)
• Python/Pyspark (ETL/Automation)

What we offer you

At EY, we’ll develop you with future-focused skills and equip you with world-class experiences. We’ll empower you in a flexible environment, and fuel you and your extraordinary talents in a diverse and inclusive culture of globally connected teams. Learn more.

Our Commitment

As a commitment, we persistently endeavour to embody our values, fulfil our purpose, and champion inclusiveness. Our dedication is to cultivate EY into an environment where diverse perspectives are celebrated, creating a supportive atmosphere for individuals to authentically be themselves and contribute their utmost.

Professional Development

From entry-level employees to senior leaders, we believe in continuous learning. We offer opportunities to build new skills, take on leadership roles, and connect and grow through mentorship.

People and Culture

In our dynamic workplace, diversity, equity, and inclusiveness are ingrained in our culture. Were united by a commitment to create an environment where every individuals differences are valued, practices are equitable, fostering a sense of belonging. Our shared values include integrity, respect, teaming, inclusiveness, energy, enthusiasm, courage to lead, and building relationships based on doing the right thing.

Benefits

• Embark on a transformative career journey with us and indulge in a suite of premium benefits, encompassing exclusive health and wellness packages, enticing rewards, and cutting-edge learning opportunities that empower you to continually grow and excel in your professional and personal development.

To help create an equitable and inclusive experience during the recruitment process, please inform us as soon as possible about any disability-related adjustments or accommodations you may need.

We are an equal opportunity employer and are committed to Diversity, Equity & Inclusion.

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.