Informatica ETL/Data Engineer

Minimum Requirements:
Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity.

Years

Required/Preferred

Experience

8

Required

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

8

Required

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

8

Required

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

8

Required

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

8

Required

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

8

Required

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

8

Required

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

8

Required

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

8

Required

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

3

Preferred

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

3

Preferred

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