| 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. | |||
| Actual Years Experience |
Years Experience Needed |
Required/ Preferred |
Skills/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 | |