Project Role : Quality Engineering Lead (Test 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, Microsoft SQL Server, Python (Programming Language)
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.

15 years full time education

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.