The company is conducting a feasibility Study for a data warehouse redesign. The main goal of the project is to replatform mainframe DB2 to UNIX. The company also wants to enhance the BI (business intelligence) layer and address infrastructure gaps to support the new data environment.
The projects consist of the 3 work areas.
1. Looking at Mainframe codes for ETL and rewrite the specs to develop those for Informatica Mapping/Workflow.
2. From the infrastructure capacity views, come up with the clustering techniques to create the most calible infrastructure architecture. The company is migrating to BOBJ 4.0. And redesigning the existing data mart.
3. Redesign BI (business intelligence) Reports on the mainframe for UNIX. BOBJ is in the legacy environment.
OBIEE is in the new environment. No business requirements for new report.
Participate in the feasibility Study for data warehouse re-platform and re-design. (re-platform mainframe COBOL, DB2 Procs to Informatica and DB2 on UNIX).
Logical and Physical Data Modeling to meet business requirements, ETL data transformation needs and reporting requirements.
Work with ETL and BI Architects / Analysts to design a scalable data architecture to support the new data environment.
10 years of experience in Data Architecture, Data Modeling and Data Warehouse/ Data Marts
5 years of experience in designing Logical and Physical Data Models for data warehouse using DB2
Familiarity with multiple ETL & BI tools
Informatica Expertise and Experience
BOBJ knowledge is preferred
10 years Data Architecture
10 years Data warehouse experience
10 years Data Modeling
5 years Infrastructure of ETL/BI
3 years Financial Services Experience
This is a full-time salaried position with a group company within NTT DATA. Please note, 1099 or corp-2-corp contractors will NOT be considered. This position is only available to those interested in direct staff employment opportunities. We offer a full comprehensive benefits package that starts from your first day of employment.
About NTT DATA
NTT DATA is your Innovation Partner anywhere around the world. With business operations in more than 35 countries, we put emphasis on long-term commitment and combine global reach and local intimacy to provide premier professional services from consulting, system development, business process and IT outsourcing to cloud-based solutions.
to learn how our consultants, projects, managed services, and outsourcing engagements deliver value for a range of businesses and government agencies.
NTT DATA - 2 years ago
NTT DATA is your Innovation Partner anywhere around the world, with operations in more than 40 countries. The 6th largest global IT services...