Senior Data Integration Engineer — Hybrid ETL Expert

COGENT DATA SOLUTIONS LLC; Austin (TX); Hybrid; USD 110,000 - 160,000; Full time

Job summary

COGENT DATA SOLUTIONS LLC is seeking a Systems Analyst – Senior Data Integration Engineer in Austin, TX. The role emphasizes data integration design, ETL development, and production support within a hybrid work model (3 days onsite, 2 days remote).

The candidate should bring extensive experience with Informatica PowerCenter, Oracle SQL/PL-SQL, Snowflake, and data governance in large enterprise environments, including SDLC adherence.

Qualifications

• Experience as a Data Engineer/Systems Analyst designing, developing, and supporting data integration solutions in enterprise environments.
• Hands-on ETL workflows using Informatica PowerCenter (mappings, sessions, workflows, reusable transformations).
• Ingesting data from multiple heterogeneous sources into Oracle databases.

Responsibilities

• Design, develop, and support data integration solutions in an enterprise setting.
• Gather data requirements and perform source-to-target mapping.
• Document data flow and design specifications; troubleshoot production ETL pipelines.

Skills

ETL design & development

Informatica PowerCenter

Informatica Cloud Data Integration

Oracle SQL/PL-SQL

Snowflake

Source-to-target data mapping

Production ETL troubleshooting

Job scheduling tools (Control-M/Autos)

Data quality issue resolution

SDLC & change management

Tools

Control-M

Autosys

Informatica Scheduler

Job description

COGENT DATA SOLUTIONS LLC is seeking a Systems Analyst – Senior Data Integration Engineer in Austin, TX. The role emphasizes data integration design, ETL development, and production support within a hybrid work model (3 days onsite, 2 days remote).

The candidate should bring extensive experience with Informatica PowerCenter, Oracle SQL/PL-SQL, Snowflake, and data governance in large enterprise environments, including SDLC adherence.