Informatica Python ETL Data Engineer & Tester

OVERVIEW

The Infosys Financial Services unit is a global leader in driving digital

transformation for financial institutions. We specialize in leveraging advanced

technologies such as AI, cloud, and data-led innovation to help our clients

accelerate growth and unlock business value. Our AI-driven solutions empower

financial institutions to make smarter decisions, enhance customer experiences,

and achieve operational excellence. Join us to be part of a pioneering team that

is at the forefront of financial services transformation. You'll have the

opportunity to work with cutting-edge AI technologies, collaborate with industry

experts, and contribute to transformative projects across banking, wealth

management, and insurance sectors. If you're passionate about AI and eager to

make a significant impact, the Infosys Financial Services unit is the perfect

place for you to grow and excel.

JOB DESCRIPTION

In the assigned Job Role of Technology Consultant 2, your Area Of Responsibility

will be as below:

⦁ Contribute to the requirements elicitation process by documenting assigned

parts of business requirements, in line with guidance provided

⦁ 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

Your contribution to the team:

⦁ A collaborative spirit and excellent communication skills.

⦁ The ability to handle end to end SDLC phases from requirement gathering to

implementation.

⦁ A knack for translating complex requirements into actionable development

tasks.

⦁ A passion for design and hands-on coding experience

⦁ A proactive approach to testing, troubleshooting, and refining our

applications.

⦁ The ability to work with cross-functional teams and do software integration.

REQUIRED SKILL AND EXPERIENCE

• 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

PREFERRED SKILL AND EXPERIENCE

• BI Reporting validation using Power BI, Tableau, Qlik, or MicroStrategy.

• Big Data technologies including Hadoop, Spark, Hive, and Kafka.

• AI-enabled Data Quality and Data Governance solutions.

• Banking, Capital Markets, Wealth Management, or Mortgage domain experience.

• Azure, Databricks, Snowflake, Redshift, PostgreSQL, BigQuery, or GCP exposure.

ADDITIONAL REQUIRED QUALIFICATIONS

• Bachelor’s degree or foreign equivalent required from an accredited

institution. Will also consider three years of progressive experience in the

specialty in lieu of every year of education.

• This position may require relocation and/or travel to work/project location.

• Candidates authorized to work for any employer in the United States without

employer-based visa sponsorship are welcome to apply. Infosys is unable to

provide immigration sponsorship for this role now or in the future.

EEO/ABOUT US

Benefits

Along with competitive pay, as a full-time Infosys employee you are also

eligible for the following benefits:

* Medical/Dental/Vision/Life Insurance

* Long-term/Short-term Disability

* Health and Dependent Care Reimbursement Accounts

* Insurance (Accident, Critical Illness , Hospital Indemnity, Legal)

* 401(k) plan and contributions dependent on salary level

* Paid holidays plus Paid Time Off

About Us

Infosys is a global leader in next-generation digital services and consulting.

We enable clients in more than 50 countries to navigate their digital

transformation. With over four decades of experience in managing the systems and

workings of global enterprises, we expertly steer our clients through their

digital journey. We do it by enabling the enterprise with an AI-powered core

that helps prioritize the execution of change. We also empower the business with

agile digital at scale to deliver unprecedented levels of performance and

customer delight. Our always-on learning agenda drives their continuous

improvement through building and transferring digital skills, expertise, and

ideas from our innovation ecosystem.

EEO

Infosys provides equal employment opportunities to applicants and employees

without regard to race; color; sex; gender identity; sexual orientation;

religious practices and observances; national origin; pregnancy, childbirth, or

related medical conditions; status as a protected veteran or spouse/family

member of a protected veteran; or disability.