Informatica & Python ETL Engineer and Tester

Infosys Limited; Hartford, Raleigh, Richardson, Tempe (CT, NC, TX, AZ); On-site; USD 110,000 - 140,000; Full time

Benefits offered by this job

Long-term/Short-term Disability

Health and Dependent Care Reimb. Acc.

Insurance (Accident, Critical Illness,

401(k) plan

Job summary

Infosys Limited is seeking a capable Informatica Python ETL Data Engineer & Tester to join our Delivery team in the US. The role focuses on Python-based ETL development, data testing, and validation across banking and financial services projects.

You will collaborate with cross-functional teams to elicit requirements, design solutions, and implement robust data pipelines. Ideal candidates bring experience in ETL testing, data quality checks, and validation using SQL/Oracle, plus familiarity with

Qualifications

• Informatica development, Python, AWS, SQL, Oracle, and GitLab.
• ETL Testing, Data Warehouse Testing, and Data Migration Testing.
• Python-based ETL and data test automation for source-to-target validation, reconciliation, and regression testing.
• SQL query writing and Oracle database validation.
• Source-to-target mapping validation, transformation rule validation, data lineage validation, and business rule validation.
• Data reconciliation, completeness checks, referential integrity validation, duplicate detection, and data quality testing.
• Data Warehousing concepts including Facts, Dimensions, Star Schema, and SCD validations.
• AWS data platform validation.
• GitLab, batch job validation, workflow monitoring, and scheduling tools such as Autosys, Control-M, or Airflow.
• Python or Shell scripting for ETL and data validation activities.
• Test strategy preparation, test case execution, result analysis, and defect resolution.
• Collaboration with business teams, development teams, and data engineering teams.
• Documentation of test scenarios, SQL validations, automation assets, and testing processes

Responsibilities

• Contribute to the requirements elicitation process by documenting assigned parts of business requirements.
• Facilitate software application design discussions, and document design decisions to guide the technical team towards building software solutions.
• Participate in coding and integrate new features or updates into existing applications, with a focus on maintaining system stability.
• Conduct code reviews, do changes to the codebase and maintain code repositories.
• Implement test strategies, analyse results, and coordinate bug fixes to uphold the software quality standards.
• Develop user training programs, documentation, and support frameworks to ensure a smooth transition to new software applications.
• Actively participate in resolving production issues and recommend preventive strategies to enhance system reliability.
• Maintain detailed records of code, testing techniques, and support activities to enrich the knowledge base and assist other similar projects

Skills

Informatica development

Python

AWS

SQL

Oracle

GitLab

ETL Testing

Data Warehouse Testing

Data Migration Testing

Python-based ETL

Data validation

SQL query writing

Oracle database validation

Data reconciliation

Data quality testing

Data Warehousing concepts

AWS data platform validation

Airflow

Autosys

Control-M

Education

Bachelor’s degree or foreign equivalent

Tools

GitLab

Autosys

Control-M

Airflow

Job description

Infosys Limited is seeking a capable Informatica Python ETL Data Engineer & Tester to join our Delivery team in the US. The role focuses on Python-based ETL development, data testing, and validation across banking and financial services projects.

You will collaborate with cross-functional teams to elicit requirements, design solutions, and implement robust data pipelines. Ideal candidates bring experience in ETL testing, data quality checks, and validation using SQL/Oracle, plus familiarity with