SAP Data Warehouse Architect in Mumbai

SAP DATA WAREHOUSE ARCHITECT IN MUMBAI

IN PIXIE SERVICES WE ARE LOOKING FOR A SAP DATA WAREHOUSE ARCHITECT FOR A PROJECT ONSITE IN MUMBAI, STARTING ASAP, FOR AT LEAST 5 MONTHS. IF YOU MEET THE REQUIREMENT, PLEASE APPLY TO THE OFFER WITH YOUR UPDATED CV, RATE PER DAY (ALL INCLUSIVE) AND DATE OF AVAILABILITY.

QUALIFICATIONSensures data is current and meets organizational quality and integrity standards
To demonstrate Extensive experience in the Application Design, Architecture competency, one should demonstrate knowledge of and ability to utilize application design methodologies, tools and techniques to convert business requirements and logical models into a technical application design
To map various source systems with heterogeneous databases to the Analytics platform which will broadly comprise of Sybase IQ/HANA systems
Recommend the right data replication/transfer tools for each source and target combination, considering the volume, complexity of the data and the frequency of the data transfer depending on whether the data is to be analyzed real or near Real Time basis.
Apply and help institute best practices, methodology and standards in DW, ETL and BI design and development to meet project requirements.
Help plan and maintain the physical technical infrastructure, its configuration, performance, and storage requirements.
Also responsible for administering ETL and BI tools and designing a scalable, highly available, fault tolerant, secure infrastructure for the Data Warehouse, ETL and BI platforms that meets enterprise needs.
Develop design & development specifications, and metadata documentation.
Translate business requirements into DW/ETL/BI Technical Design and coordinate with ETLintegrates them with technical design.
Creates and evaluates technical alternatives for complex applications.
Explores and evaluates application design considerations for multiple technologies.

THE DATA WAREHOUSE ARCHITECT IS INVOLVED IN THE FOLLOWING DATA WAREHOUSE PROJECT PHASES:

1.- REQUIREMENTS SPECIFICATION
A solution architect is responsible for ensuring that requirements are sufficiently clear to commence architecture and design and that acceptance requirements have been clearly defined.

2.- CONSTRUCTION OR BUILD
Quality assurance of all architecture and design deliverables. This involves reviewing all development deliverables and certifying that they are complete including: Unit testing and System testing

3.- Quality Assurance
Directing integration testing
Participating in regression testing
Participating in software security testing
Load testing and performance testing; and
Release

4.- ARCHITECTURE AND DESIGN
Responsibility for data warehouse design and providing technical direction to data modelers, data analysts, data integration architects, data integration developers and database administrators.

Data architecture;
Data warehouse operations management including: Process architecture and System processes
Physical data base design, including Star schema and data mart design, and Snowflakes chema design
Change data design, including slowly changing dimensions;
Operational data store design;
Defining database development software;
Specifying Business Intelligence architecture;
Database normalization;
Database partitioning;
Data aggregation;
Data base management solutions;
Data conversion solutions; 
Database design documentation.