Senior system engineer

Infosys

2–3 yrs Bengaluru Full Time Work from office
Infosys logo
Posted : today
Actively hiring

Job description

Infosys is seeking a Senior Systems Engineer with a strong background in data validation and quality assurance. This role is crucial for ensuring the integrity and accuracy of our data systems. The ideal candidate will possess extensive experience in ETL and Data Warehouse testing, coupled with a deep understanding of data warehousing principles.

This position offers an excellent opportunity to contribute to critical data projects within Infosys Quality Engineering. We are looking for a detail-oriented professional who can effectively manage and validate complex data transformations.

Responsibilities

Conduct comprehensive ETL and Data Warehouse testing to ensure data accuracy and consistency. Write and execute complex SQL queries for data validation and analysis. Validate source-to-target mappings and perform data reconciliation. Collaborate with development teams to identify and resolve data-related issues. Understand and apply SDLC, STLC, and Agile methodologies in testing processes. Utilize defect management tools like JIRA to track and manage issues.

Qualifications

Requires 2-3 years of experience in ETL Testing and Data Warehouse Testing. Must have proficiency in SQL, including writing 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 is essential. Solid understanding of Data Warehousing Concepts (Fact Tables, Dimension Tables, Star Schema, Snowflake Schema). Experience validating source-to-target mappings and knowledge of data migration/reconciliation. Familiarity with relational databases (Oracle, SQL Server, MySQL, PostgreSQL, Teradata). Understanding of SDLC, STLC, and Agile methodologies, and experience with JIRA are required.

Essential Skills

ETL TestingData Warehouse TestingSQLInformaticaTalendDataStageSSISAb InitioData Warehousing ConceptsFact TablesDimension TablesStar SchemaSnowflake SchemaSource-to-target mapping validationData migrationData reconciliationOracleSQL ServerMySQLPostgreSQLTeradataSDLCSTLCAgile methodologiesJIRA

Good to Have

AWS RedshiftSnowflakeAzure SynapseGoogle BigQueryHadoopSparkDatabricksETL automationPython scriptingShell scriptingInformatica DQGreat ExpectationsPower BITableauQlikCI/CD pipelinesDevOps practices

Highlights

  • Actively hiring

More Details

RoleSenior system engineer
Employment TypeFull Time, Work from office

About the Company

Infosys logo

Infosys

IT Consulting

Senior system engineer at Infosys | SkillMX | SkillMX