> Markdown version of [/jobs/ext/2881378-data-warehouse-developer-informatica-powercenter-wi](https://www.wearedevelopers.com/jobs/ext/2881378-data-warehouse-developer-informatica-powercenter-wi). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Warehouse Developer/ Informatica PowerCenter - WI - **Company:** Nexiva Inc - **Location:** Wisconsin Rapids, WI, United States (Remote available) - **Experience:** Experienced - **Contract:** Permanent contract - **Skills:** Microsoft Windows, Data Analysis, Microsoft Outlook, Cloud Computing, COBOL (Programming Language), Data Integrity, Extract Transform Load (ETL), Data Warehousing, IBM DB2, Relational Databases, Database Queries, Data Intelligence, Metadata, Microsoft Office, Microsoft Visio, Microsoft SQL Server, Oracle (Applications), Performance Tuning, Systems Development Life Cycle, Software Engineering, SQL Databases, Tableau (Software), Informatica Powercenter, Sap Business Objects, Data Management - **Published:** September 13, 2026 - **Apply:** https://www.careerjet.com/jobad/us826d63977d6af564732a5829ca5f22b9 ## About the Role * 4+ years of Informatica PowerCenter experience. * 2+ years of Informatica IDMC experience. * 2+ years of CDI-PC experience. * Hands-on experience migrating complex PowerCenter assets to IDMC. * Experience with data warehouse design and development. * 4+ years of data warehouse requirements gathering and data analysis. * 4+ years of data warehouse performance tuning. * Strong SQL skills and experience with relational databases. * Experience with Oracle, DB2, and SQL Server. * Experience with relational and dimensional data modeling. * Knowledge of Slowly Changing Dimensions (SCD). * Knowledge of Kimball data warehouse design principles. * Experience developing large and complex data models and processes. * Experience creating technical/design specifications and documentation. * Experience developing test plans, test cases, and test procedures. * Experience identifying defects and implementing QA processes. * Strong understanding of SDLC methodologies and deliverables. * Excellent verbal and written communication skills. * Strong analytical, problem-solving, organizational, and time-management skills. * Ability to work effectively with business users and technical teams. * Experience with COBOL and DB2/mainframe applications is required. * Proficiency with Microsoft Office, Visio, and Outlook. Preferred / Nice-to-Have Skills * Business Objects or other Business Intelligence tools. * Tableau and dashboard development. * Experience designing and utilizing performance measures and reports. * Knowledge of State of Wisconsin privacy regulations. Work Arrangement * Approximately 90% remote / 10% onsite. * Candidate must currently reside in Wisconsin or be willing to relocate to Wisconsin at their own expense within 30 days of the start date. * Candidate must be physically located within the United States. * No work may be performed outside the United States. * Occasional onsite work may be required with notice. * Candidate must be available during Central Time business hours, generally 8:00 AM 5:00 PM CT. * On-call availability is required; weekend coverage is not expected. Technical Requirements for Remote Work The selected candidate must provide their own equipment and maintain compatibility with the current Omnissa Horizon Client. * Windows 11 or supported macOS 13+ * Minimum 8 GB RAM; 16 GB+ preferred * 64-bit processor, * Background check and fingerprinting may be required. * Candidate must be able to complete required security training and onboarding documentation. * Three professional/business references may be required. * Certifications, if applicable, must be provided during the hiring process. Candidates with strong hands-on Informatica PowerCenter to IDMC migration experience are highly encouraged to apply. ## Description Client is seeking a Data Warehouse Developer II to support data warehouse and ETL initiatives, with a primary focus on migrating complex Informatica PowerCenter assets to Informatica Intelligent Data Management Cloud (IDMC). The selected candidate will work with technical teams and business users to understand requirements, develop ETL solutions, perform testing and validation, and support data warehouse performance, reliability, and security. Key Responsibilities * Migrate mappings, mapplets, sessions, and workflows from Informatica PowerCenter to IDMC. * Perform testing, validation, troubleshooting, and performance tuning during migration activities. * Design, develop, test, maintain, and implement ETL/data warehouse solutions. * Develop ETL mapping specifications for loading data into the data warehouse. * Gather and analyze business and technical requirements. * Work with business users and technical teams to recommend and implement effective solutions. * Design and work with relational and dimensional data models. * Develop and maintain data warehouse processes, metadata, and repositories. * Perform data analysis and SQL-based data management. * Monitor and improve data warehouse performance and tuning. * Ensure data reliability, integrity, and security. * Develop test plans, test cases, test procedures, and use cases. * Identify, troubleshoot, and resolve defects. * Prepare technical documentation and design specifications. * Participate throughout the software development life cycle, including planning, analysis, design, development, testing, implementation, and support. * Work independently on complex projects while keeping management informed of progress and issues. * Collaborate effectively with business stakeholders, technical teams, and other IT groups. ## Related Videos - [From Global Capability Centers to AI-Powered Command Centers](https://www.wearedevelopers.com/videos/100096-from-global-capability-centers-to-ai-powered-command-centers) - [Data Fabric in Action - How to enhance a Stock Trading App with ML and Data Virtualization](https://www.wearedevelopers.com/videos/253-data-fabric-in-action-how-to-enhance-a-stock-trading-app-with-ml-and-data-virtualization) - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) - [A Data Mesh needs Open Metadata](https://www.wearedevelopers.com/videos/505-a-data-mesh-needs-open-metadata) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Data Science on Software Data](https://www.wearedevelopers.com/videos/162-data-science-on-software-data) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Fully Remote Software Engineer Jobs](https://www.wearedevelopers.com/magazine/447-fully-remote-software-engineer-jobs) - [How to land a developer job in Amsterdam](https://www.wearedevelopers.com/magazine/36-how-to-land-a-developer-job-in-amsterdam) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Why Attend a Developer Event in 2026?](https://www.wearedevelopers.com/magazine/688-why-attend-a-developer-event-in-2026) - [Mastering Remote Work: Tips for Developers](https://www.wearedevelopers.com/magazine/558-mastering-remote-work-tips-for-developers)