Informatica Python ETL Data Engineer & Tester

Infosys Limited Digital$100K — $120K *
Information Technology
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • Bachelor's degree or equivalent experience in a relevant field.
  • 5-7 years of experience in Informatica development, Python, AWS, SQL, Oracle, and GitLab.
  • Strong knowledge of ETL Testing, Data Warehouse Testing, and Data Migration Testing.
  • Experience with Python-based ETL and data test automation processes.
  • Familiarity with SQL query writing and Oracle database validation techniques.
  • Knowledge of Data Warehousing concepts and data validation practices.
  • Proficiency in collaborating with cross-functional teams.

Responsibilities

  • Document business requirements during the requirements elicitation process.
  • Facilitate and document software application design discussions.
  • Participate in coding and application feature integration.
  • Conduct code reviews and manage changes to the codebase.
  • Implement test strategies and coordinate bug fixes to maintain software quality.
  • Develop user training programs and support documentation for new applications.
  • Assist in resolving production issues and recommend preventive solutions.

Benefits

  • Medical/Dental/Vision/Life Insurance
  • Long-term/Short-term Disability
  • Health and Dependent Care Reimbursement Accounts
  • 401(k) plan and contributions dependent on salary level
  • Paid holidays plus Paid Time Off
Full Job Description
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.

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

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.

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.

About Infosys Limited Digital

Infosys Limited Digital Careers

Joining Infosys Limited Digital offers a unique opportunity to be part of a global team of professionals who are at the forefront of digital innovation and transformation. Infosys Limited Digital is renowned for its commitment to leadership in technology services and consulting, making it an ideal place for ambitious individuals seeking growth and career advancement.

Explore Job Opportunities

Infosys Limited Digital is actively seeking talented individuals to join their team. With a variety of job opportunities available, candidates can find positions that match their skills and interests. The company values diversity and inclusivity, ensuring that all team members have the opportunity to contribute to their fullest potential.

Experience Professional Growth

At Infosys Limited Digital, professional growth is a priority. The company offers comprehensive benefits and diversity training programs that support both personal and professional development. Employees are encouraged to take leadership roles within projects, fostering a culture of innovation and continuous improvement.

Engage in Meaningful Work

Employees at Infosys Limited Digital engage in projects that transform businesses and industries worldwide. By leveraging cutting-edge technology and deep industry expertise, the team delivers solutions that meet the complex demands of today's digital landscape.

Internship Programs

For those starting their careers, Infosys Limited Digital’s internship programs provide a robust platform for learning and development. Interns gain hands-on experience, working alongside seasoned professionals on real-world projects. This not only enhances their skills but also prepares them for future employment opportunities within the company.

Join a Collaborative Team

Infosys Limited Digital prides itself on its collaborative culture. Team members from around the globe come together to share ideas and strategies, ensuring the best outcomes for clients and stakeholders. Networking within the company is highly encouraged, opening doors to myriad opportunities for career advancement.

Prepare for Your Interview

When applying for a position at Infosys Limited Digital, it is crucial to tailor your resume to highlight relevant experience and skills. Preparation for the interview process is key, as it is a chance to demonstrate how your background aligns with the company’s needs and values.

Stay Connected with Career Insights

Keep up to date with the latest in career opportunities and industry trends by subscribing to Infosys Limited Digital’s career blog. Gain insights from insiders and stay informed about new openings and company news.

Apply Now

Discover the exciting and rewarding career opportunities at Infosys Limited Digital. Search for open positions that align with your professional skills and interests. Infosys Limited Digital is looking for passionate, curious, and innovative team players ready to make a significant impact in the digital world.

SEARCH INFOSYS LIMITED DIGITAL JOBS

READ CAREERS BLOG

Job Alert Emails

Customize your subscription to receive job alerts and insider tips tailored to your preferences. Explore the diverse and dynamic career paths available at Infosys Limited Digital.
Learn more about Infosys Limited Digital

Similar Jobs

  • Data Engineer
    $110K — $130K *
    Infosys Limited Digital
    Basking Ridge, NJ 07920 (Somerset County)
  • Colgate Palmolive
    Platform Engineer
    $86K — $121K *
    Colgate Palmolive
    Piscataway, NJ 08854 (Middlesex County)
  • Datastage Developer
    $100K — $120K *
    Infosys Limited Digital
    Florida, NY 10921 (Orange County)
  • The Hartford Financial Services Group, Inc
    Associate Data and AI Engineer
    $74K — $111K *
    The Hartford Financial Services Group, Inc
    Hartford, CT 06106 (Capitol County)
  • Data & AI Engineer
    $110K *
    U.S. Citizenship and Immigration Services
    New York, NY 10025 (New York County)
  • Ensemble Health Partners
    Engineer, Data
    $101K — $144K *
    Ensemble Health Partners
    Remote

More Jobs at Infosys Limited Digital

More Information Technology Jobs

Find similar Informatica Python ETL Data Engineer & Tester jobs: