Data Integration Engineer / ETL Developer

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

Job Tittle: Systems Analyst – Senior Data Integration Engineer

Location: Austin, Texas

client: Texas Health & Human Services Commission

Experience: 8+ years

Job ID: 529701785

Work Model: Hybrid – 3 days onsite & 2 days remote

Candidate must be local to the Austin

Mandatary skills:

Experience as a Data Engineer/Systems Analyst designing, developing, and supporting data integration solutions in an enterprise environment

Hands-on experience developing and maintaining ETL workflows using Informatica PowerCenter, including mappings, sessions, workflows, and reusable transformations

Experience ingesting data from multiple heterogeneous source systems (flat files, APIs, relational databases, mainframe extracts, etc.) into Oracle databases

Strong working knowledge of Oracle SQL/PL-SQL, including stored procedures, packages, and performance tuning of ETL-related queries

Experience with Snowflake, including data loading, schema design, and query performance optimization

Experience with Informatica Power center / Informatica Cloud Data Integration for cloud-based ETL/ELT development

Experience gathering data requirements, performing source-to-target mapping, and documenting data flow/design specifications

Experience troubleshooting and resolving data quality issues, job failures, and performance bottlenecks in production ETL pipelines

Experience with job scheduling/orchestration tools (e.g., Control-M, Autosys, or Informatica scheduler) supporting batch data loads

Experience with SAP Business Objects Universe design and/or maintenance 11

Experience working in a state government or large enterprise IT environment, following formal SDLC and change management processes