|
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
|