Data Warehouse Developer

Our client is seeking a Data Warehouse Developer to join their team. As a Data Warehouse Developer, you will be part of the Data Management Department supporting data integration and warehousing initiatives. The ideal candidate will have strong analytical skills, excellent communication abilities, and a collaborative mindset which will align successfully in the organization.

Job Title:Data Warehouse Developer

Location: Madison, WI

What's the Job?

• Migrate mappings, mapplets, sessions, and workflows from Informatica PowerCenter to IDMC.
• Assist in ETL design, development, testing, maintenance, and implementation of data warehouse projects.
• Understand user requirements and develop solutions that meet organizational needs with high-quality deliverables.
• Create ETL mapping specifications to ensure reliable data loading into the warehouse.
• Optimize performance and tuning of the data warehouse while maintaining data security standards.

What's Needed?

• Experience in migrating assets from Informatica PowerCenter to IDMC (2+ years).
• Moderate experience in data warehousing process design, development, and performance tuning using Informatica tools (4+ years).
• Knowledge of relational database technologies such as Oracle, DB2, SQL Server, and strong SQL data management skills (3+ years).
• Ability to gather requirements and translate them into technical solutions.
• Excellent verbal and written communication skills, with experience facilitating meetings with technical and non-technical stakeholders.

What's in it for me?

• Opportunity to work on impactful government data projects.
• Collaborative team environment supporting professional growth.
• Potential for contract extension based on project needs.
• Work in a dynamic and supportive organization committed to public service.
• Gain valuable experience in data warehousing and data integration technologies.