Position: Datawarehouse Developer-3
Location: Madison, WI (Hybrid)
Duration: Long Term
Job Summary:
Ideal candidate will have skills and experience in the following areas:
- Knowledge in data warehouse best practice standards
- Strong experience in PowerCenter to IDMC migration.
- Experience in design, development, and testing in IDMC.
- Proficient in writing and analyzing complex SQL queries in Oracle, DB2, SQL Server.
- Hands-on experience using Control-M for job scheduling and workflow automation.
- Moderate skills working with relational and dimensional data models
- Moderate skills working with slowly changing dimensions
- Proven ability to diagnose and remediate ETL and DB Query performance bottlenecks.
- 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, MS Outlook, and Jira
List any special qualifications & years of experience: (List any specific skills, software, or requirements the position will require. Optional format below)
Project Details (project overview, who the contractor will work with, soft skills needed, etc.):
Optional format: (Add as many lines as needed.)
| Qualification | Desired Experience |
| 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 |
| IDMC (Informatica Intelligent Data Management Cloud) | 3+ years |
| DB2 | 2 years |
| 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 |
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)
Never miss an opportunity! Create an alert based on the job you applied for.
