ETL Test lead

Infosys; Bengaluru; On-site; INR 800,000 - 1,200,000; Full time

Job summary

Infosys Bengaluru seeks a skilled Data Warehouse Tester with strong ETL testing experience to validate source-to-target mappings and data quality. You will work across ETL tools such as Informatica and Talend, ensure data accuracy, and collaborate with BI teams.

Candidate should be proficient in SQL, understand data warehousing concepts, and follow SDLC/STLC and Agile practices; experience with JIRA is a plus.

Qualifications

• Experience in ETL testing and data warehouse testing.
• Strong SQL skills with complex queries and data validation.
• Hands-on with ETL tools such as Informatica/Talend/DataStage/SSIS.
• Knowledge of data warehousing concepts and mappings.

Responsibilities

• Validate source-to-target mappings and data quality.
• Hands-on testing across ETL jobs and 데이터 pipelines.
• Collaborate with BI and data teams using Agile methodologies.
• Track defects using JIRA and ensure SDLC compliance.

Skills

ETL Testing

Data Warehouse Testing

SQL

ETL tools

Data warehousing concepts

S2T mappings

Data migration

Relational databases

SDLC/STLC/Agile

JIRA

Education

MCA

MSc

MTech

Bachelor of Engineering

BCA

BSc

BTech

Tools

Informatica

Talend

DataStage

SSIS

Ab Initio

Job description

Roles & Responsibilities

• Strong experience in ETL Testing and Data Warehouse Testing.
• Proficiency in SQL with the ability to write complex queries, joins, stored procedures, and data validation scripts.
• Hands-on experience with ETL tools such as Informatica, Talend, DataStage, SSIS, Ab Initio, or similar.
• Strong understanding of Data Warehousing Concepts, including Fact Tables, Dimension Tables, Star Schema, and Snowflake Schema.
• Experience in validating source-to-target mappings.
• Knowledge of data migration and data reconciliation techniques.
• Experience working with relational databases such as Oracle, SQL Server, MySQL, PostgreSQL, or Teradata.
• Strong understanding of SDLC, STLC, and Agile methodologies.
• Experience with defect management tools like JIRA.

Preferred Skills

• Experience with Cloud Data Platforms such as AWS Redshift, Snowflake, Azure Synapse, or Google BigQuery.
• Exposure to Big Data Testing using Hadoop, Spark, or Databricks.
• Knowledge of ETL automation tools and scripting using Python or Shell scripting.
• Experience with data quality tools such as Informatica DQ or Great Expectations.
• Familiarity with BI tools such as Power BI, Tableau, or Qlik.
• Understanding of CI/CD pipelines and DevOps practices.

Technical Requirement

• Primary skills:Technology->Data Services Testing->Data Warehouse Testing,Technology->ETL & Data Quality->ETL - Others
• Educational RequirementMCA,MSc,MTech,Bachelor of Engineering,BCA,BSc,BTech
• Preferred SkillsTechnology->ETL & Data Quality->ETL - Others,Technology->Data Services Testing->Data Warehouse Testing
• Service LineInfosys Quality Engineering