Senior ETL IDMC Engineer - Onsite (San Antonio)

Themesoft Inc; San Antonio (TX); On-site; USD 90,000 - 152,000; Part time

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

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.