Data Warehouse Developer II

V-Soft Consulting Group, Inc.; Madison (WI); Presencial; USD 95.000 - 120.000; Jornada completa

Descripción de la vacante

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.

Formación

• 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

Conocimientos

SQL

Tableau

Business Objects

Informatica PowerCenter

IDMC

Oracle

DB2

SQL Server

Kimball data warehouse design

Herramientas

Informatica PowerCenter

IDMC

Oracle

DB2

SQL Server

Kimball data warehouse design

Tableau

Business Objects

Descripción del empleo

Primary Location

Madison, WI

Education and Experience

• 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)

Knowledge, Skills And Abilities

• 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
• evelop 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

V-Soft Consulting Group is recognized among the top 100 fastest growing staffing companies in North America, V-Soft Consulting Group is headquartered in Louisville, KY with strategic locations in India, Canada and the U.S. V-Soft is known as an agile, innovative technology services company holding several awards and distinctions and has a wide variety of partnerships across diverse technology stacks.

As a valued V-Soft Consultant, you're eligible for full benefits (Medical, Dental, Vision), a 401(k) plan, competitive compensation and more. V-Soft is partnered with numerous Fortune 500 companies, exceptionally positioned to advance your career growth.

V-Soft Consulting provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.