Overview

Service Line – ETL; Position Title - Senior

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.
• 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
• 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
• 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)

Benefits

• 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.
• Are you ready to shape your future with confidence? Apply today.
• 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.
• 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. We're united by a commitment to create an environment where every individual's 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.
• How to Apply: If you are passionate to join us and are aligned with our commitment to building a better working world, we invite you to apply by completing our user-friendly form with personal and professional information and by providing your consent to data privacy.
• Successful candidates advance to a competency-based interview. If mutual interest persists, a job offer awaits.
• “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.