Quality Engineering Lead

8119 ASOL Gurgaon 5 SEZ Company; Gurugram District; Hybrid; INR 1,200,000 - 2,000,000; Full time

Job summary

Accenture is seeking an experienced Software Development Engineer in Test (SDET) Lead for our Gurugram client office. The role focuses on ETL testing, data warehouse validation, and Python-based automation to ensure data integrity across banking systems.

The candidate should have 6+ years of experience in data warehousing ETL testing, with strong SQL and Python skills, and familiarity with CI/CD pipelines. This hybrid role requires three days on client location weekly in Gurugram.

Qualifications

• Must have Data Warehouse ETL Testing, Python, and Microsoft SQL Server.
• Good to have Automated Testing experience.
• Strong understanding of data warehousing concepts and ETL processes.

Responsibilities

• Design and develop Python-based automation frameworks and reusable utilities for ETL validation and data reconciliation.
• Conduct end-to-end ETL testing, including source-to-target validation, transformation logic verification, and data completeness checks.
• Write, review, and optimize SQL queries (joins, CTEs, window functions) to validate complex business rules and data transformations.
• Execute Unix/Linux commands and shell scripts for ETL job monitoring, file validation, and log analysis.
• Work with Mainframe systems for flat file validation, dataset checks, and job executions in ETL processes.
• Test data warehouse components such as staging, fact, and dimension tables, including Slowly Changing Dimensions (SCDs).
• Integrate automated validation into ETL CI/CD pipelines (Jenkins, GitHub Actions).
• Collaborate with ETL developers, data modelers, and business analysts to investigate issues and ensure accurate data flow across banking systems.
• Prepare test evidence, automation reports, and dashboards for traceability and coverage metrics.

Skills

Data Warehouse ETL Testing

Python

Microsoft SQL Server

Automated Testing

Education

15 years full time education

Tools

Unix/Linux

Job description

Project Role

Quality Engineering Lead Project Role Description : Leads a team of quality engineers through multi-disciplinary team planning and ecosystem integration to accelerate delivery and drive quality across the application lifecycle. Applies business and functional knowledge to develop end-to-end testing strategies through the use of quality processes and methodologies. Applies testing methodologies, principles and processes to define and implement key metrics to manage and assess the testing process including test execution and defect resolution.

Must have skills : Data Warehouse ETL Testing, Python (Programming Language), Microsoft SQL Server

Good to have skills : Automated Testing, Microsoft SDET

Minimum 5 year(s) of experience is required

Educational Qualification : 15 years full time education

Summary

• We are looking for an experienced Software Development Engineer in Test (SDET) with strong expertise in ETL testing, database validation, and Python-based automation.
• The ideal candidate will ensure data integrity and accuracy across ETL pipelines and data warehouse systems, while leveraging deep technical and analytical skills.
• Exposure to banking domain, especially Corporate & Institutional Banking and Personal Banking, will be a strong advantage.

Roles & Responsibilities

• Design and develop Python-based automation frameworks and reusable utilities for ETL validation and data reconciliation.
• Conduct end-to-end ETL testing, including source-to-target validation, transformation logic verification, and data completeness checks.
• Write, review, and optimize SQL queries (joins, CTEs, window functions) to validate complex business rules and data transformations.
• Execute Unix/Linux commands and shell scripts for ETL job monitoring, file validation, and log analysis.
• Work with Mainframe systems for flat file validation, dataset checks, and job executions in ETL processes.
• Test data warehouse components such as staging, fact, and dimension tables, including Slowly Changing Dimensions (SCDs).
• Integrate automated validation into ETL CI/CD pipelines (Jenkins, GitHub Actions).
• Collaborate with ETL developers, data modelers, and business analysts to investigate issues and ensure accurate data flow across banking systems.
• Prepare test evidence, automation reports, and dashboards for traceability and coverage metrics.

Professional & Technical Skills

• Must To Have Skills: Proficiency in Data Warehouse ETL Testing, Python (Programming Language), Microsoft SQL Server.
• Good To Have Skills: Experience with Automated Testing.
• Strong understanding of data warehousing concepts and ETL processes.
• Strong proficiency in Python (pandas, pyodbc, data comparison and validation frameworks).
• Expertise in SQL — complex joins, aggregations, subqueries, and analytical functions.
• Strong understanding of Oracle databases/data warehouse and relational data modeling.
• Proficiency in Unix/Linux commands (grep, awk, sed, shell scripting).
• Basic knowledge of Mainframe systems for dataset handling.
• Good understanding of Data Warehousing concepts — staging, data marts, fact/dimension modeling, and SCD handling.
• Familiarity with test management tools (Rally, JIRA, Qtest) and CI/CD tools (Git, Jenkins).

Good to have skill – Banking domain exposure, especially in:

• Corporate & Institutional Banking (e.g., treasury, lending, payments, trade finance).
• Personal Banking (e.g., retail accounts, loans, deposits, credit cards).
• Knowledge of data governance and quality frameworks.
• Exposure to API testing for data ingestion and integration layers.
• Ability to implement data validation automation within ETL CI/CD pipelines.

Additional Information

• The candidate should have minimum 6 years of experience in Data Warehouse ETL Testing.
• This position is based at our Gurugram Client office and it is mandate to work from client location 3 days/week.
• Strong analytical and problem-solving skills with keen attention to data accuracy.
• Excellent communication and collaboration with cross-functional teams.
• Ability to work independently in fast-paced Agile environments.
• Detail-oriented, proactive, and quality-driven mindset.
• A 15 years full time education is required.

About Accenture

Accenture is a leading global professional services company that helps the world’s leading businesses, governments and other organizations build their digital core, optimize their operations, accelerate revenue growth and enhance citizen services—creating tangible value at speed and scale. We are a talent- and innovation-led company with approximately 791,000 people serving clients in more than 120 countries. Technology is at the core of change today, and we are one of the world’s leaders in helping drive that change, with strong ecosystem relationships. We combine our strength in technology and leadership in cloud, data and AI with unmatched industry experience, functional expertise and global delivery capability. Our broad range of services, solutions and assets across Strategy & Consulting, Technology, Operations, Industry X and Song, together with our culture of shared success and commitment to creating 360° value, enable us to help our clients reinvent and build trusted, lasting relationships. We measure our success by the 360° value we create for our clients, each other, our shareholders, partners and communities. Visit us at www.accenture.com

Equal Employment Opportunity Statement

We believe that no one should be discriminated against because of their differences.

All employment decisions shall be made without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, military veteran status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status or any other basis as protected by applicable law.

Our rich diversity makes us more innovative, more competitive, and more creative, which helps us better serve our clients and our communities.

Bring your incredible skills and join our global team of innovators. We come together from different backgrounds across the world and work with the latest technologies to create value and growth for our clients. With us, you’ll continue to learn and grow so you can advance in your career. Your personal dreams and ambitions are just as important to us; that’s why we offer support any way we can—when you thrive, we all thrive.

Explore your next step at Accenture Belong. Grow. Thrive. Join a great place to work for reinventors who drive meaningful change for our clients, communities, and the world. Wo rld. Explore your next step at Accenture