An AI agent that applies to roles like this on employers' own sites. 25 applications free, no card needed.
AI summary of this job
Beta Read in 10 secondsAn ETL Testing Engineer role at Infosys in Hyderabad, Pune, Mumbai (All Areas) for people with 4–9 years of experience. You'll validate data extraction, transformation, and loading processes using SQL, Informatica, SSIS, Talend, DataStage, Ab Initio, Oracle, SQL Server, MySQL, PostgreSQL, or Teradata. You'll design ETL test cases and test plans.
- Hyderabad
- Work from office
- 4–9 years
- Bachelor's degree
What you'll do
- Design and execute ETL test cases
- Perform data integrity and reconciliation testing
- Execute database testing using complex SQL
Good fit if you
- Have strong SQL and ETL testing experience
- Know data warehouse and business intelligence environments
- Understand data quality and migration testing
AI-generated from the job description. Check the full description before you apply.
Job Description
- ETL Testing Engineer
- Job Title
- ETL Testing Engineer / Data Warehouse Tester
- Experience
- 3 -10 Years
- Job Summary
We are seeking a skilled ETL Testing Engineer to validate data extraction, transformation, and loading processes in data warehouse and business intelligence environments. The ideal candidate should possess strong SQL skills, hands-on ETL testing experience, and expertise in data validation and quality assurance.
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.
Skills
DWH TestingETL TestingData Warehouse ETL TestingData Warehouse TestingSoftware TestingData WarehousingETLDataBig Data TechnologiesPythonDevopsQuality AssuranceSql ServerTestingOracleCloudSqlIf a job posting appears fraudulent, asks for payment, contains misleading information, or violates our guidelines, please report it immediately. Our team will review it promptly, Jobaaj does not charge any fee from the applicants.
About Company
Infosys Limited is an Indian multinational information technology company that provides business consulting, information technology and outsourcing services. The company was founded in Pune and is headquartered in Bangalore.
Infosys is a global leader in next-generation digital services and consulting. We enable clients in 45 countries to navigate their digital transformation. With over three decades of experience in managing the systems and workings of global enterprises, we expertly steer our clients through the many nexts of their digital journey. We do it by enabling the enterprise with an AI-powered core that helps prioritize the execution of change.
We also empower the business with agile digital at scale to deliver unprecedented levels of performance and customer delight. Our always-on learning agenda drives their continuous improvement through building and transferring digital skills, expertise and ideas from our innovation ecosystem.
Similar Jobs
View allLooking for something similar?
New IT / Software Development & Related roles in Hyderabad.
One email a day. Unsubscribe any time.

