Data Warehouse Architect: MDM & ODI Specialist

US staffing Inc; City of Albany (NY); On-site; USD 120,000 - 160,000; Full time

Job summary

US staffing Inc. seeks a Datawarehouse Architect with Master Data Management (MDM) and Oracle Data Integrator (ODI) for a 30-month engagement in Albany, NY. The role focuses on designing data warehouse solutions, integrating COTS and custom applications, and implementing MDM strategies.

The candidate should have extensive experience with ODI, SQL, data modeling, and ETL processes, plus familiarity with Kafka integrations and enterprise BI environments.

Qualifications

• 84 months experience working with agency/business subject matter experts to understand business needs/requirements.
• 84 months experience architecting, designing, documenting, and implementing data warehousing, COTS and Custom business application integrations, and master data management.
• 84 months experience data modeling and designing normalized Data Warehouse environments for enterprise level applications; and, implementing those designs using Oracle Data Integrator (ODI) and Extract, Transform, Load technologies
• 84 months experience developing data integrations for heterogeneous systems and business intelligence using SQL (Structured Query Language).
• 72 months experience performing database comparative analysis for designing new transactional databases and data warehouses, as well as improvements in existing transactional databases and data warehouses.
• 60 months experience in analytical reasoning, computation, interpretation, and presentation of data to solve business problems.
• 48 months experience implementing systematic Data Error/Recovery and Cleanup procedures
• 24 months experience integrating with Kafka.

Skills

Data warehousing

MDM

SQL

ETL

Tools

Oracle ODI

Kafka

Job description

US staffing Inc. seeks a Datawarehouse Architect with Master Data Management (MDM) and Oracle Data Integrator (ODI) for a 30-month engagement in Albany, NY. The role focuses on designing data warehouse solutions, integrating COTS and custom applications, and implementing MDM strategies.

The candidate should have extensive experience with ODI, SQL, data modeling, and ETL processes, plus familiarity with Kafka integrations and enterprise BI environments.