PowerCenter/IDMC Developer- Data Warehouse Developer II
CLIENT LOCATION: 201 W. Washington Avenue, Madison, WI 53703
WORK ARRANGEMENT: Hybrid; approximately 90 100% remote
START / END: October 19, 2026, to June 30, 2027, with possible extensions
Contract
Interview process is expected to be in person
Top 3-4 desired skills required for the position:
- Experience in migration of assets from Informatica PowerCenter to IDMC, including testing, validation, and performance tuning
- Moderate experience in data warehousing process design, development, performance & tuning using the Informatica data warehousing tool suite both IDMC and PowerCenter
- 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 and strong data management and data analysis using SQL
Detailed Job Description: (Please be specific with all job duties required by the hired candidate.) The candidate will be responsible for migrating mappings, mapplets, sessions, and workflows from Informatica PowerCenter to IDMC. Assist in ETL design, development, testing, maintenance, metadata, and implementation of data warehouse initiatives. Understand user requirements and implement solutions that ensure requirements can be achieved through high quality deliverables. Develop ETL mapping specifications for loading information into the data warehouse and for ensuring reliability of information loaded. Seek continuous improvement in performance & tuning of data warehouse and ensure security of data. Works with other IT technical teams and Business users to understand requirements and recommend & implement solutions. Closely supervised with some latitude for independent judgment. Typically requires at least 4 to 5 years of experience or equivalent education.
Ideal candidate will have skills and experience in the following areas:
- Hands on experience migrating complex assets from Informatica PowerCenter
to IDMC
- Knowledge in data warehouse best practice standards
- Moderate skills working with relational and dimensional data models
- Moderate skills working with slowly changing dimensions
- Strong verbal and written communication skills, including facilitation of meetings with customers and technical staff
- Knowledge and skills in the project development life cycle process (i.e., planning, analysis, design, coding, testing, implementation, support)
- Demonstrated knowledge and skills in requirements gathering
- Effective interpersonal relations skills, ability to effectively collaborate with others and work as part of a team
- Skills in navigating a large organization in order to accomplish results
- Ability to initiate and follow through on complex projects of both short- and long-term duration
- Excellent organizational and time management skills.
- Excellent analytical and problem-solving skills
- Ability to work independently, assume responsibility for job development and training, researching and resolving questions and problems, requesting supervisor input and keeping supervisor informed
- Proficiency with MS Office suite, MS Visio, and MS Outlook
- Experience programming mainframe applications using technologies such as COBOL and DB2 databases to implement maintenance and enhance mainframe functionality
List any special qualifications & years of experience: (List any specific skills, software, or requirements the position will require. Optional format below)
| Qualification | Desired Experience |
| IDMC (Informatica Intelligent Data Management Cloud) | 2+ years |
| CDI-PC | 2+ years |
| Expertise in implementation of large, complicated models and processes | 2 years |
| Experience in technical writing and documentation | 3 years |
| Develop design specifications | 3+ years |
| Excellent organization, analytical and communication skills | 3+ years |
| Data analysis | 4+ years |
| Data Warehouse experience in data warehouse design and development | 4+ years |
| Data Warehouse - Experience in requirements gathering for data warehouse | 4+ years |
| Data Warehouse - Performance tuning | 4+ years |
| Informatica PowerCenter | 4+ years |
| DB2 | 2 years |
| SQL Server | |
| Knowledge of Kimball data warehouse design principals | 2+ years |
| Ability to navigate and query a relational database (Oracle) to develop reports | 3+ years |
| Respond to customer requests (verbally and in writing) * | 3+ years |
| Develop Test Plans, Test Cases, and Test Procedures | 3+ years |
| Identify defects | 3+ years |
| Ability to develop and implement quality assurance processes and procedures including test/use cases | 3+ years |
| In-depth knowledge of system development life cycle deliverables for each phase of development | 3+ years |
| Excellent oral and written communication skills | 5+ years |
| Demonstrated experience in the design and utilization of performance measures and reports (nice to have) | 2+ years |
| Business Objects or other BI tools (nice to have) | 3+ years |
| Dashboarding/Tableau (nice to have) | 2+ years |
| State of Wisconsin Privacy Regulations | Yes |
DESCRIPTION
The Client is seeking one Data Warehouse Developer II to migrate mappings, mapplets, sessions, and workflows from Informatica PowerCenter to Informatica Intelligent Data Management Cloud (IDMC).
The developer will assist with ETL design, development, testing, maintenance, metadata, and implementation of data warehouse initiatives. The role includes understanding user requirements; developing ETL mapping specifications for loading information into the data warehouse; ensuring the reliability and security of loaded information; and continuously improving data warehouse performance and tuning.
The developer will work with other IT technical teams and business users to understand requirements and recommend and implement solutions. This is a career-development position that works with moderate supervision and some latitude for independent judgment. The role typically requires four to five years of experience or equivalent education.
The broader assignment includes designing, developing, and maintaining relational databases for data storage and data mining; performing data warehouse design and testing, including data design, database architecture, metadata, and repository creation; and developing processes and procedures for entering information into data warehousing systems and ensuring its reliability.
KEY SKILLS
- Experience migrating assets from Informatica PowerCenter to IDMC, including testing, validation, and performance tuning (2+ years).
- Data warehousing process design, development, performance, and tuning using both IDMC and Informatica PowerCenter (4+ years).
- Architecture of data warehouse and data integration strategies and solutions.
- Relational database technologies, including Oracle, DB2, and SQL Server, with strong SQL-based data management and analysis (3+ years).
- Hands-on experience migrating complex PowerCenter assets to IDMC; IDMC and CDI-PC experience (2+ years each).
- Data warehouse design and development, requirements gathering, data analysis, and performance tuning (4+ years).
- Relational and dimensional data modeling, slowly changing dimensions, and Kimball data warehouse design principles (2+ years for Kimball).
- Implementation of large, complicated models and processes (2 years), plus development of design specifications (3+ years).
- Oracle querying and report development (3+ years), DB2 (2 years), and SQL Server.
- Test plans, test cases, test procedures, defect identification, and quality-assurance processes/use cases (3+ years).
- System development life cycle deliverables across planning, analysis, design, coding, testing, implementation, and support (3+ years).
- Technical writing and documentation (3 years), customer response skills (3+ years), and excellent oral and written communication (5+ years).
- Strong organization, analysis, problem solving, time management, meeting facilitation, collaboration, and interpersonal skills.
- Ability to navigate a large organization, initiate and complete complex short- and long-term projects, and work independently while keeping the supervisor informed.
- Proficiency with Microsoft Office, Visio, and Outlook.
- Experience programming mainframe applications using technologies such as COBOL and DB2 to maintain and enhance mainframe functionality.
- Knowledge of State of Wisconsin privacy regulations.
NICE TO HAVE SKILLS
- Design and use of performance measures and reports (2+ years).
- Business Objects or other business-intelligence tools (3+ years).
- Dashboarding and Tableau (2+ years).
INTERVIEW PROCESS
- Interview process is expected to be in person, although the hiring manager retains discretion to use phone or video interviews at any point.
- Interviews will be scheduled shortly after the posting closes.
- A real-time screenshot photo of the candidate must be uploaded to the bid when the interview is confirmed, following the DCF Realtime Photo Requirement and Instructions.
- Three business references are required for the interview; one must be at the supervisory level.
EQUIPMENT
- The selected candidate must provide personal equipment for remote work and maintain it so it remains compatible with the current Omnissa Horizon Client.
- Home internet: minimum 20 Mbps download and 5 Mbps upload, with the ability to connect the computer by Cat 5a or better network cable.
- Windows: a currently supported version of Windows 11; 8 GB RAM minimum (16 GB+ preferred); 64-bit processor; Direct3D 11-compatible graphics; latest Omnissa Horizon Client.
- Apple: a currently supported version of macOS 13 or higher; 8 GB RAM minimum (16 GB+ preferred); 64-bit Intel or ARM M-series processor; latest Omnissa Horizon Client.
- Full audio/video conferencing capability, including a camera and headset, is required.
- A personal mobile device is not required.
ADDITIONAL DETAILS
- Schedule: 40 hours per week, day shift, generally 8:00 AM 5:00 PM. The candidate must be available during the hiring manager's defined Central Time business hours, including the core period of 9:00 AM 3:00 PM. On-call hours are required; weekend coverage is not required.
- The position is budgeted for 1,960 hours annually, prorated in the first year based on the start date.
- The candidate must be physically located in the United States. All contact information must be domestic, and no work may be performed outside the United States.
- The candidate must follow all DCF work rules. The position does not have access to Federal Tax Information (FTI).
- A seven-year standard background check is required. All offers are contingent on passing required background checks; the selected candidate may also be required to complete criminal background checks and fingerprinting as applicable.
- DCF does not sponsor work visas at hire or later.
- The selected candidate must sign all onboarding documents, complete required security training, and provide copies of applicable certifications.
- Submission requires the Wisconsin Cover Sheet, valid Right to Represent, cover letter, and resume using the candidate's full legal first and last name. Candidate email addresses and phone numbers are prohibited on resumes.
- Candidates who do not meet the stated qualifications, restrictions, or requirements may not be resubmitted to future repostings; false or inaccurate submissions will be reported.
Ayush Sharma Sr. US Technical Recruiter
| Ext:149
| G-talk:
Never miss an opportunity! Create an alert based on the job you applied for.