ETL Informatica IDMC Engineer

Quantum Technologies. LLC; San Antonio (TX); On-site; USD 77,000 - 110,000; Full time

Job summary

Quantum Technologies. LLC is seeking an ETL Informatica IDMC Engineer for a San Antonio, TX engagement. The contractor will design, develop, test, and maintain ETL and data integration solutions using Informatica IDMC, with strong Teradata data extraction and SQL optimization skills.

The role includes on-call support and collaboration across analysts, architects, QA, and application teams. The position supports 8 months with potential extension.

Qualifications

• Design, develop, test, and maintain ETL/data integration solutions using Informatica IDMC.
• Develop and maintain Informatica mappings, mapplets, workflows, and data integration processes.
• Strong hands-on Teradata experience for data extraction, transformation, loading, and validation.
• Write, analyze, and optimize complex SQL queries for data processing and troubleshooting.
• Perform data validation, data reconciliation, and data quality checks.

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

ETL Informatica IDMC

Informatica mappings/workflows

SQL

Python scripting

Teradata

Data validation

Tools

Teradata

Python

Job description

US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other

Job Title: ETL Informatica IDMC Engineer
Location: San Antonio,TX
Duration: 8 Months + Extension
Bill Rate: $68/hour
Job Type: W-2, 1099, C2C
Client: To Be Discussed Later
Work Authorization: US-Citizen, H-1B, OPT-EAD, GC-EAD

Job Description

Design, develop, test, and maintain ETL and data integration solutions using Informatica IDMC.

Develop and maintain Informatica mappings, mapplets, workflows, and data integration processes.

Strong hands-on experience with Teradata for data extraction, transformation, loading, and validation.

Write, analyze, and optimize complex SQL queries for data processing and troubleshooting.

Perform data validation, data reconciliation, and data quality checks.

Conduct root-cause analysis and resolve ETL and data integration issues.

Troubleshoot production issues and coordinate with upstream and downstream application teams.

Develop basic Python scripts for automation, data validation, file processing, and operational activities.

Collaborate with Business Analysts, Data Architects, QA, application, and technology teams.

Participate in deployment activities, release management, and production support.

Follow enterprise data management, security, and development standards.

Prepare and maintain technical documentation, data flows, and operational procedures.

Provide on-call and weekend 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.

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.