Job description

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 role: Technology Consultant 2 Required skills 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 skills • 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. Qualifications and work authorization • 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. Locations: Hartford, CT; Raleigh, NC; Richardson, TX; Tempe, AZ 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.

Requirements

Must-haves

Job role: Technology Consultant 2
Required skills 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

Nice-to-haves

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.
Qualifications and work authorization
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.
Locations: Hartford, CT; Raleigh, NC; Richardson, TX; Tempe, AZ

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

aipythonawssqlazuregcpagile

Platform: infosys
Effort: medium

Benefits

Benefits detected in the listing.

Dental

Vision

401(K)

Paid Time Off