Informatica Python ETL Data Engineer & Tester

Overview In this role you contribute to the end-to-end SDLC, driving AI- and data-powered transformation for financial services. You’ll collaborate with cross-functional teams to elicit requirements, design software, implement and test features, and maintain quality. You help translate complex requirements into actionable development tasks and support production stability. This is a hands-on, impact-focused position at Infosys Financial Services, working across banking, wealth management, and insurance domains. Compensation / BenefitsMedical/Dental/Vision/Life InsuranceLong-term/Short-term DisabilityHealth and Dependent Care Reimbursement AccountsInsurance (Accident, Critical Illness, Hospital Indemnity, Legal)401(k) plan and contributionsPaid holidays plus Paid Time Off ResponsibilitiesDocument assigned parts of business requirements per guidanceFacilitate design discussions and capture design decisionsDevelop and integrate new features into existing apps with stability focusConduct code reviews and maintain code repositoriesImplement test strategies, analyze results, coordinate bug fixesDevelop user training, documentation, and support frameworksParticipate in resolving production issues and suggest preventive measuresMaintain detailed records of code, testing techniques, and support activities Key requirementsInformatica development, Python, AWS, SQL, Oracle, GitLabETL testing, Data Warehouse testing, Data Migration testingPython-based ETL and data test automation for validation and regression testingSQL query writing and Oracle validationSource-to-target mapping, transformation, data lineage, and business rule validationData reconciliation, completeness checks, referential integrity, duplicate detection, data quality testingData warehousing concepts (Facts, Dimensions, Star Schema, SCD validations)AWS data platform validationGitLab, batch job validation, workflow monitoring, scheduling tools such as Autosys, Control-M, or AirflowPython or Shell scripting for ETL and data validationTest strategy preparation, test case execution, result analysis, defect resolutionCollaboration with business, development, and data engineering teamsDocumentation of test scenarios, SQL validations, automation assets, and testing processescollaborationexcellent communicationability to work with cross-functional teamsInformaticaPythonAWS