Onsite_ETL Informatica IDMC Engineer -- San Antonio, TX

Themesoft Inc

San Antonio (TX)

On-site

USD 90,000 - 152,000

Part time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

The Themesoft Inc in San Antonio, TX is seeking a Senior ETL Informatica IDMC Engineer with 5+ years of data integration experience for an onsite contract role. The position emphasizes IDMC, Teradata, SQL, and basic Python scripting to support automation and data quality.

You will design, develop, test, and maintain ETL pipelines, mappings, workflows, and data integration processes; perform data validation and reconciliation; and troubleshoot production issues.

Qualifications

  • 5+ years of experience in ETL/data integration development.
  • Strong hands-on experience with Informatica IDMC / CDI.
  • Strong Teradata and SQL development skills.

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.

Skills

Informatica IDMC
Teradata
SQL
Python

Job description

Job Id : OOJ - 27237

Posted Date : 09/23/2026

Experience : 4-8

Job Type : Contractual

Location : SAN ANTONIO

Overview

Location: San Antonio, TX - Onsite – Locals
EmploymentType: Contract
ContractDuration: 6-12months
Skills: Informatica Powercentre

Senior ETL Informatica IDMC Engineer

We are looking for an experienced Senior ETL / Informatica IDMC Engineer with 5+ 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.

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
  • 5+ 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.

Experience Required: 4-8

Core Technology Stack

Primary: Informatica IDMC, Teradata, SQL

Secondary: Python, ETL/Data Warehousing

Domain: Banking / Financial Services (preferred)

Work Authorization

ApplicantsmustbelegallyauthorizedtoworkintheUnitedStates.

Equal Employment Opportunity

[ThemesoftInc]isanEqualEmploymentOpportunityemployer.Weconsiderqualifiedapplicantswithoutregardtorace,color,religion,sex,sexualorientation,genderidentity,nationalorigin,age,disability,veteranstatus,oranyotherstatusprotectedbyapplicablefederal,state,orlocallaw.

Skills :

PYTHON,DATA INTEGRATION,TERADATA,AGILE,SQL,MAPPLETS,INFORMATICA

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

ETL Informatica IDMC Engineer
ETL Informatica IDMC Engineer

Quantum Technologies LLC • San Antonio (TX)

On-site
USD 77,000 - 110,000
ETL Informatica IDMC Engineer
ETL Informatica IDMC Engineer

Ethereum Technologies LLC • San Antonio (TX)

On-site
USD 77,000 - 110,000
ETL Informatica IDMC Engineer
ETL Informatica IDMC Engineer

Valiant Technologies LLC • San Antonio (TX)

On-site
USD 77,000 - 110,000
Informatica Developer
Informatica Developer

Valiant Technologies LLC • Atlanta (GA)

On-site
USD 120,000 - 160,000
Senior ETL IDMC Engineer - Onsite (San Antonio)
Senior ETL IDMC Engineer - Onsite (San Antonio)

Themesoft Inc • San Antonio (TX)

On-site
USD 90,000 - 152,000
Informatica Developer
Informatica Developer

Quantum Technologies LLC • Atlanta (GA)

On-site
USD 90,000 - 130,000
Informatica Developer
Informatica Developer

Ethereum Technologies LLC • Atlanta (GA)

On-site
USD 110,000 - 150,000
ETL IDMC Engineer: Informatica + Teradata Expert
ETL IDMC Engineer: Informatica + Teradata Expert

Ethereum Technologies • San Antonio (TX)

On-site
USD 77,000 - 110,000
ETL Engineer
ETL Engineer

Quantum Technologies LLC • Columbia (SC)

On-site
USD 110,000 - 140,000
Informatica IDMC ETL Engineer – Teradata & SQL Pro
Informatica IDMC ETL Engineer – Teradata & SQL Pro

Valiant Technologies LLC • San Antonio (TX)

On-site
USD 77,000 - 110,000