The State of Wisconsin DCF is looking for two (2) Data Warehouse Developer II's

Top Skills:

• Moderate experience in data warehousing process design, development, performance & tuning using the Informatica data warehousing tool suite (4+ years)

• Developing skills in the architecture of data warehouse and data integration strategies and solutions

• Knowledge in relational database technologies, e.g. Oracle, DB2, SQL Server (3+ years)

• Strong data management and data analysis using SQL (4+ years)

• Must have strong hands-on experience with Informatica IDMC. (3+ years)

IMPORTANT NOTES:

• Candidate MUST be physically located in the United States. International candidates/phone numbers will not be accepted.

• Candidate must follow ALL DCF work rules

• Candidate must be available to perform all work during the Central Standard Time (CST) business hours 9:00 am – 3 pm (or CST hours as defined by the hiring manager)

• Candidate will be required to provide their own equipment for this position (See job description for required specifications.)

Onsite, hybrid or remote: Candidate MUST be a WI resident or willing to relocate to WI prior to starting the role at their own expense. 90-100% remote but can require staff to come onsite as necessary with sufficient notice. Onsite work is not likely, but candidate should be prepared to come onsite if required.

Project details: This role is responsible for designing, developing, testing, and implementing ETL solutions using Informatica Data Management Cloud (IDMC). This role requires strong hands-on experience with Data Integration (DI), Taskflows, Mappings, parameter files, and reusable transformations to build scalable, secure, and high-performing data pipelines. The candidate will manage metadata, ensure data accuracy and integrity, and drive continuous optimization within the IDMC and data warehouse environment.