ETL IDMC Engineer, Informatica IDMC Engineer
- Talent Software Services, Inc.
12 Hours Ago
42-42 per Hourly
W2
San Antonio-TX
8-10 Years
Required Skills: ETL, data integration development, Informatica IDMC, Informatica Cloud Data Integration, CDI, Teradata, SQL development and troubleshooting, Python programming, Python scripting
Job Description
ETL/Informatica IDMC Engineer
We are seeking a talented and experienced Senior ETL/Informatica IDMC Engineer with a strong background in data integration and ETL development. The ideal candidate will have a minimum of 7 years of experience, with hands-on expertise in Informatica Intelligent Data Management Cloud (IDMC) and Teradata, as well as basic Python skills.
This role requires a professional who is comfortable working in a collaborative banking/data environment, coordinating with multiple technology and business teams, and providing production support when necessary.
Key Responsibilities
This role requires a professional who is comfortable working in a collaborative banking/data environment, coordinating with multiple technology and business teams, and providing production support when necessary.
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.
- Collaborate 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.
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
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)
