Senior Data Engineer / ETL/ELT Developer NEW! at Dutech Systems in Austin,TX

Responsibilities

• Supporting enterprise data integration solutions.
• Developing ETL/ELT processes using Informatica PowerCenter and Informatica Cloud Data Integration.
• Integrating data from multiple source systems into Oracle databases.
• Performing source-to-target mapping and documenting data flows.
• Troubleshooting ETL pipelines, data quality issues, and production support.
• Working with enterprise job scheduling and orchestration tools.

Requirements

• 8+ years of experience as a Data Engineer or Systems Analyst supporting enterprise data integration solutions.
• 8+ years of hands-on experience with Informatica PowerCenter ETL development.
• Experience integrating data from multiple source systems into Oracle databases.
• Strong expertise in Oracle SQL and PL/SQL, including stored procedures, packages, and ETL query optimization.
• Experience with Snowflake data loading, schema design, and query performance tuning.
• Experience with Informatica Cloud Data Integration for cloud ETL/ELT development.
• Experience gathering data requirements, performing source-to-target mapping, and documenting data flows.
• Strong troubleshooting skills for ETL pipelines, data quality issues, and production support.
• Experience with enterprise job scheduling and orchestration tools.
• 3+ years of experience with SAP Business Objects Universe design and maintenance.
• Experience working in a State Government or large enterprise IT environment following formal SDLC and change management processes.

Skills

Required

• Informatica PowerCenter
• Informatica Cloud Data Integration
• ETL
• ELT
• Oracle SQL
• PL/SQL
• Snowflake
• Data Integration
• Data Warehousing
• Source-to-Target Mapping
• Control-M
• Autosys