Request ID: 110254-1
Job Title: Senior ETL Informatica IDMC Engineer
Locations: Onsite: San Antonio, TX (Day 1 Onsite)
Duration: 6 Months
Pay Range: $35 - $41/Hour on W2/C2C (All inclusive)
Skills: Informatica Powercentre
Experience Required: 6-8
Job Summary
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, mClientts, 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)
Company Benefits & Culture
• Inclusive and diverse work environment
• Opportunities for professional growth and development
• Comprehensive health and wellness benefits