Lead Consultant, QA Automation Engineer – Data & ETL Testing

Ready to build the future with AI
At Genpact we dont just keep up with technologywe set the pace. AI and digital innovation are redefining industries and were leading the charge. Genpacts AI Gigafactory our industry-first accelerator is an example of how were scaling advanced technology solutions to help global enterprises work smarter grow faster and transform at scale. From large-scale models to agentic AI our breakthrough solutions tackle companies most complex challenges.
If you thrive in a fast-moving innovation-driven environment love building and deploying cutting-edge AI solutions and want to push the boundaries of whats possible this is your moment.
Genpact (NYSE: G) is an advanced technology services and solutions company that delivers lasting value for leading enterprises globally. Through our deep business knowledge operational excellence and cutting-edge solutions we help companies across industries get ahead and stay ahead. Powered by curiosity courage and innovation our teams implement data technology and AI to create tomorrow today. Get to know us at and on LinkedIn X YouTube and Facebook.
Inviting applications for the role of Lead Consultant QA Automation Engineer Data & ETL Testing
We are seeking a highly skilled QA Automation Engineer Data & ETL Testing with 46 years of experience in building automated validation frameworks for data pipelines and data warehouse systems. The ideal candidate will have strong expertise in data validation ETL/ELT testing and automation development to support both modern cloud data platforms and legacy data warehouse environments.
This role will support next-generation data stacks built on Snowflake Fivetran and dbt while also validating and maintaining legacy systems such as Oracle Database Data Warehouse platforms.
Responsibilities
Automation Framework Development
Design and develop automated data validation frameworks.
Build reusable SQL and Python-based automation scripts for ETL validation.
Integrate data validation scripts into CI/CD pipelines.
Automate source-to-target reconciliation and regression testing.
Implement automated data quality checks and anomaly detection.
Modern Data Stack Testing
Automate validation of data ingestion pipelines using Fivetran.
Validate dbt models (tests transformations incremental loads).
Develop automated checks for Snowflake data warehouse objects.
Support automated validation during migration from Oracle DW to Snowflake.
Monitor data pipeline health and automated test reporting.
Legacy Data Warehouse Testing
Automate validation of Oracle DW data transformations.
Test PL/SQL-based ETL logic and stored procedures.
Perform cross-platform data comparison between legacy and modern systems.
Support regression testing and release validation cycles.
Data Quality & Governance
Implement automated data quality rules (completeness accuracy consistency).
Validate business rules and transformation logic.
Ensure compliance with enterprise data governance standards.
Collaboration & Reporting
Work closely with Data Engineers Architects and DevOps teams.
Participate in Agile ceremonies and release planning.
Document automation frameworks and test artifacts.
Provide detailed test execution and defect reports.
Qualifications we seek in you!
Minimum Qualifications
46 years of experience in QA Automation with strong focus on Data/ETL testing.
Strong SQL skills (complex queries window functions performance validation).
Strong experience with Python for automation.
Hands-on experience testing and validating:
Snowflake data warehouse
Oracle Data Warehouse
ETL/ELT pipelines
Experience validating data pipelines built using Fivetran.
Experience testing dbt models and transformations.
Strong understanding of
Data warehousing concepts (Star Schema Snowflake Schema)
Dimensional modeling
Source-to-target mapping
Experience integrating automation with CI/CD tools (Jenkins GitHub Actions Azure DevOps etc.).
Familiarity with UNIX/Linux commands.

Preferred Qualifications/ Skills
Experience with orchestration tools (Airflow or similar).
Knowledge of data profiling tools.
Exposure to cloud platforms (AWS/Azure/GCP).
Experience with test automation frameworks (PyTest Robot Framework etc.).
Experience in large-scale data migration programs.
Strong analytical and debugging skills
High attention to detail
Proactive problem-solving mindset
Strong documentation and communication skills
Ability to work across modern and legacy stacks

Why join Genpact
Lead AI-first transformation Build and scale AI solutions that redefine industries
Make an impact Drive change for global enterprises and solve business challenges that matter
Accelerate your careerGain hands-on experience world-class training mentorship and AI certifications to advance your skills
Grow with the best Learn from top engineers data scientists and AI experts in a dynamic fast-moving workplace
Committed to ethical AI Work in an environment where governance transparency and security are at the core of everything we build
Thrive in a values-driven culture Our courage curiosity and incisiveness - built on a foundation of integrity and inclusion - allow your ideas to fuel progress
Come join the 140000 coders tech shapers and growth makers at Genpact and take your career in the only direction that matters: Up.
Lets build tomorrow together.

Genpact is an Equal Opportunity Employer and considers applicants for all positions without regard to race color religion or belief sex age national origin citizenship status marital status military/veteran status genetic information sexual orientation gender identity physical or mental disability or any other characteristic protected by applicable laws. Genpact is committed to creating a dynamic work environment that values respect and integrity customer focus and innovation.
Furthermore please do note that Genpact does not charge fees to process job applications and applicants are not required to pay to participate in our hiring process in any other way. Examples of such scams include purchasing a starter kit paying to apply or purchasing equipment or training.