Senior ETL Informatica IDMC Engineer

San Antonio, TX, TX

$35–$37 Per Hour
Instant Apply

4 days ago

Job Description

Job Title: Senior ETL Informatica IDMC Engineer
Location: San Antonio, TX – 100% Onsite from Day 1
Duration: 6 Months

Salary Range: $35.00 - $37.00/Hour on W2 (Without Benefits).
Applicants must be willing to work on W2.

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, 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.
7+ years of experience in Informatica CDI (Cloud Data Integration).
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.
Previous experience in the Commercial Banking domain is a must-have.

Preferred / Nice-to-Have Skills

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.

Numbers & Facts

Location	San Antonio, TX, TX
Salary	$35–$37 Per Hour

Skills

Agile Programming Methodologiesunmatched
Banking Servicesunmatched
Business Analysisunmatched
Cloud Computingunmatched
Commercial Bankingunmatched
Communication Skillsunmatched
Computer Scienceunmatched
Data Analysisunmatched
Data Managementunmatched
Data Qualityunmatched
Data Warehousingunmatched
Database Extract Transform and Load (ETL)unmatched
Error Handlingunmatched
Financial Transactionsunmatched
Identify Issuesunmatched
Incident Managementunmatched
Informaticaunmatched
Information Technology & Information Systemsunmatched
NCR Teradataunmatched
On Callunmatched
Operations Processesunmatched
Presentation/Verbal Skillsunmatched
Problem Solving Skillsunmatched
Production Supportunmatched
Python Programming/Scripting Languageunmatched
Quality Assuranceunmatched
Query Analysisunmatched
Query Optimizationunmatched
Reconciliationunmatched
Regulationsunmatched
Relational Databases (RDBMS)unmatched
Root Cause Analysisunmatched
SQL (Structured Query Language)unmatched
Scripting (Scripting Languages)unmatched
Security Information and Event Management (SIEM)unmatched
Team Playerunmatched
Technical Writingunmatched
Test Plan/Scheduleunmatched
Writing Skillsunmatched

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Resume Builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Resume Builder