ETL Test lead

Infosys

5–8 yrs Bengaluru Full Time Work from office
Infosys logo
Posted : today
Actively hiring

Job description

Join our team as an ETL Test Lead, a pivotal role focused on ensuring the integrity and quality of our data solutions. This position offers a significant opportunity to leverage your expertise in ETL and Data Warehouse testing within a dynamic environment.

We are seeking a seasoned professional to lead testing efforts, uphold data quality standards, and contribute to the success of our data initiatives. This role is integral to our Quality Engineering unit at Infosys Limited.

Responsibilities

Lead comprehensive ETL and Data Warehouse testing initiatives, ensuring accuracy and completeness of data transformations. Develop and execute complex SQL queries for data validation, including writing stored procedures and advanced data validation scripts. Collaborate with development teams to validate source-to-target mappings and identify discrepancies. Guide the team in implementing data migration and reconciliation strategies, maintaining data integrity throughout the process. Manage defect tracking and resolution using tools like JIRA, ensuring timely closure of identified issues.

Qualifications

A strong foundation in ETL and Data Warehouse Testing is essential, supported by hands-on experience with industry-leading ETL tools (e.g., Informatica, Talend, DataStage, SSIS). Proficiency in SQL is a must, with the ability to construct intricate queries and understand database concepts. Demonstrate a solid understanding of Data Warehousing principles, including star and snowflake schemas, and fact/dimension tables. Familiarity with relational databases (Oracle, SQL Server, MySQL, PostgreSQL, Teradata) is required. Experience with SDLC, STLC, and Agile methodologies is expected, along with experience in defect management tools such as JIRA.

Essential Skills

ETL TestingData Warehouse TestingSQLInformaticaTalendDataStageSSISAb InitioData Warehousing ConceptsSDLCSTLCAgileJIRA

Good to Have

AWS RedshiftSnowflakeAzure SynapseGoogle BigQueryHadoopSparkDatabricksPythonShell scriptingInformatica DQGreat ExpectationsPower BITableauQlikCI/CDDevOps

Highlights

  • Actively hiring

More Details

RoleETL Test lead
DepartmentTechnology Lead
Employment TypeFull Time, Work from office

About the Company

Infosys logo

Infosys

IT Consulting

ETL Test lead at Infosys | SkillMX | SkillMX