We are seeking a skilled ETL Testing Engineer with 4 to 9 years of hands-on ETL testing experience, and expertise in data validation and quality assurance. Validate data extraction, transformation, and loading processes in data warehouse and business intelligence environments. The ideal candidate should possess strong SQL skills,
Key Responsibilities
- Analyze business and technical requirements related to data migration and ETL processes.
- Design and execute ETL test cases, test plans, and test scenarios.
- Validate data extraction, transformation, and loading from source systems to target databases.
- Perform data integrity, completeness, and reconciliation testing.
- Verify data mappings, transformation rules, and business logic.
- Execute database testing using complex SQL queries.
- Identify, document, and track defects through defect management tools.
- Perform regression, integration, system, and UAT support testing.
- Validate data quality and consistency across multiple platforms.
- Collaborate with developers, data engineers, business analysts, and stakeholders.
- Prepare test metrics, reports, and test execution status updates.
Required Skills
- Strong knowledge of ETL Testing concepts and methodologies.
- Hands-on experience with ETL tools such as:
- Informatica
- SSIS (SQL Server Integration Services)
- Talend
- DataStage
- Ab Initio
- Advanced SQL skills for data validation and reconciliation.
- Experience with Data Warehouse concepts including:
- Star Schema
- Snowflake Schema
- Fact and Dimension Tables
- Slowly Changing Dimensions (SCD)
- Experience with database platforms such as Oracle, SQL Server, MySQL, PostgreSQL, or Teradata.
- Expertise in data quality and data migration testing.
- Familiarity with defect tracking tools (JIRA, Azure DevOps).
Preferred Skills
- Automation experience using Python, Selenium, or ETL automation frameworks.
- Experience with cloud data platforms:
- Azure Data Factory (ADF)
- Azure Synapse
- AWS Glue
- Snowflake
- Databricks
- Knowledge of Big Data technologies (Hive, Hadoop, Spark).
- Understanding of CI/ CD and DevOps practices.
- Performance and volume testing experience.
Qualifications
- Bachelor’s degree in Computer Science, Information Technology, Engineering, or related field.
- Certification in ETL, Data Warehousing, or Database technologies is a plus.
Company Profile
Infosys is a global leader in next-generation digital services and consulting. Over 300,000 of our people work to amplify human potential and create the next opportunity for people, businesses and communities. With over four decades of experience in managing the systems and workings of global enterprises, we expertly steer clients, in more than 50 countries, as they navigate their digital transformation powered by the cloud. We enable them with an AI-powered core, empower the business with agile digital at scale and drive continuous improvement with always-on learning through the transfer of digital skills, expertise, and ideas from our innovation ecosystem. We are deeply committed to being a well-governed, environmentally sustainable organization where diverse talent thrives in an inclusive workplace.
