Senior Informatica IDMC ETL Developer

• Hi, Everyone
• Immediate Requirement, 100% Closure position

****CONTRACT POSITION***CONTRACT POSITION****

• Job Title : Senior Informatica IDMC ETL Developer
• Location : San Antonio, TX- onsite
• Job Description:

• Role Descriptions: ETL developer
• Essential Skills: ETL developer
• Skills: Informatica Power center
• Experience Required: 6-8

Job Summary

Senior ETL Informatica IDMC Engineer

We are looking for an experienced Senior ETL / Informatica IDMC Engineer with 7+ years of experience in data integration and ETL development. The ideal candidate will have strong hands-on experience with Informatica Intelligent Data Management Cloud (IDMC) and Teradata, along with basic Python skills.

The candidate should be comfortable working in a collaborative banking/data environment, coordinating with multiple technology and business teams, and providing production support when required.

• Key Responsibilities
• • Design, develop, test, and maintain ETL/data integration solutions using Informatica IDMC.
• • Develop and maintain mappings, mapplets, workflows, and data integration processes.
• • Work extensively with Teradata for data extraction, transformation, loading, and validation.
• • Write and optimize SQL queries for data analysis, reconciliation, and troubleshooting.
• • Perform data validation, reconciliation, and root-cause analysis for ETL/data quality issues.
• • Troubleshoot production issues and coordinate with upstream/downstream application teams.
• • Work closely with business analysts, data architects, QA teams, application teams, and other technology teams.
• • Participate in deployments, release activities, and production support.
• • Develop basic Python scripts for automation, data validation, file processing, or operational tasks.
• • Understand and follow enterprise data management, security, and development standards.
• • Document technical solutions, data flows, and operational procedures.
• • Participate in on-call or weekend support activities when required.

• Required Skills & Experience
• • 7+ years of experience in ETL/data integration development.
• • Strong hands-on experience with Informatica IDMC / Informatica Cloud Data Integration (CDI).
• • Strong Teradata experience.
• • Strong SQL development and troubleshooting skills.
• • Experience working with flat files, relational databases, and enterprise data warehouses.
• • Understanding of ETL concepts including transformations, lookups, joins, aggregations, error handling, and data reconciliation.
• • Basic Python programming/scripting knowledge.
• • Experience working in Agile or enterprise development environments.
• • Strong problem-solving and troubleshooting skills.
• • Good written and verbal communication skills.
• • Ability to collaborate effectively with multiple teams.

• Preferred / Nice-to-Have Skills
• • Previous experience in the banking or financial services domain.
• • Knowledge of banking data, transactions, accounts, customers, payments, or regulatory data.
• • Experience with data warehouse and enterprise data platforms.
• • Experience with ETL production support and incident management.
• • Knowledge of cloud-based data integration and modern data platforms.
• • Experience with scheduling and monitoring ETL jobs.

• Professional Expectations
• • Demonstrates a positive and collaborative attitude.
• • Communicates clearly and professionally with technical and non-technical teams.
• • Takes ownership of assigned tasks and production issues.
• • Able to work effectively across multiple teams and time zones.
• • Demonstrates flexibility when business or production requirements change.
• • Occasional evening/weekend support may be required based on production needs and support schedules.

Education

Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field, or equivalent professional experience.

Core Technology Stack

• Primary: Informatica IDMC, Teradata, SQL
• Secondary: Python, ETL/Data Warehousing
• Domain: Banking / Financial Services (preferred)