Etl Tester(1-13 yrs)-s

Company: Infosys Ltd.
Location: Pan India
Experience: 1-13 Years
Employment Type: Full-Time

Job Summary

Infosys is looking for an experienced ETL Testing Engineer with strong expertise in Data Warehouse (DWH) Testing, ETL Validation, and Big Data Testing. The candidate will be responsible for validating data transformation, data migration, data quality, and end-to-end data flows across enterprise data platforms.

Key Responsibilities

• Analyze source-to-target mapping documents, business requirements, and technical specifications.
• Validate ETL processes and ensure accurate data movement from source systems to target data warehouses.
• Design, develop, and execute ETL test cases, test plans, and test scenarios.
• Perform data validation, data reconciliation, and data quality testing.
• Execute database testing using SQL queries.
• Verify data completeness, accuracy, integrity, and transformation rules.
• Perform batch testing and schedule validation.
• Identify, track, and report defects using defect management tools.
• Work closely with ETL developers, data engineers, business analysts, and stakeholders.
• Participate in Agile/Scrum development processes.
• Validate large volumes of structured and unstructured data in Big Data environments.

Required Skills

ETL & Data Warehouse Testing

• Strong experience in ETL Testing and Data Warehouse Testing.
• Hands-on experience validating ETL workflows and data pipelines.
• Experience with source-to-target data validation.
• Knowledge of Data Migration and Data Reconciliation Testing.
• Understanding of Star Schema and Snowflake Schema concepts.
• Experience in dimensional modeling and data warehousing concepts.

SQL & Database Testing

• Strong SQL querying skills.
• Experience with Oracle, SQL Server, Teradata, PostgreSQL, DB2, or MySQL.
• Ability to write complex joins, subqueries, stored procedures, and data validation scripts.

Big Data Testing

• Experience with Hadoop Ecosystem.
• Knowledge of Hive, HDFS, Spark, Impala, and Kafka.
• Experience validating datasets in Big Data environments.
• Understanding of Data Lake concepts.