Data Warehouse Developer II — IDMC/PowerCenter Expert

V-Soft Consulting Group, Inc.; Madison (WI); On-site; USD 95,000 - 120,000; Full time

Job summary

V-Soft Consulting Group, Madison, WI is seeking an experienced data warehousing and ETL specialist to migrate assets from Informatica PowerCenter to IDMC, including testing, validation and performance tuning. You will design data warehouse processes, work with Oracle/DB2/SQL Server, and develop reports and dashboards using BI tools.

The role requires 2+ years in PowerCenter-to-IDMC migrations, 4+ years in DW design and tuning, and strong SQL skills.

Qualifications

• Experience in migration of assets from Informatica PowerCenter to IDMC, including testing, validation, and performance tuning (2+ years)
• Moderate experience in data warehousing process design, development, performance & tuning using the Informatica data warehousing tool suite - both IDMC and PowerCenter (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 and strong data management and data analysis using SQL (3+ 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+ year

Skills

SQL

Tableau

Business Objects

Informatica PowerCenter

IDMC

Oracle

DB2

SQL Server

Kimball data warehouse design

Tools

Informatica PowerCenter

IDMC

Oracle

DB2

SQL Server

Kimball data warehouse design

Tableau

Business Objects

Job description

V-Soft Consulting Group, Madison, WI is seeking an experienced data warehousing and ETL specialist to migrate assets from Informatica PowerCenter to IDMC, including testing, validation and performance tuning. You will design data warehouse processes, work with Oracle/DB2/SQL Server, and develop reports and dashboards using BI tools.

The role requires 2+ years in PowerCenter-to-IDMC migrations, 4+ years in DW design and tuning, and strong SQL skills.