Description
SAP Data Modeler urgently required for immediate start in Mumbai for initial 6-month contract
Data modelers for the specific project requires extensive knowledge and hands on experience of working in both Native HANA and BW on HANA environments that are connected to heterogeneous source systems. Exposure to working on Sybase IQ database will be an advantage.
Data modelers will be working with a team of data architects, and will be engaged in translating business requirements into conceptual, logical, and physical data models, who may focus on issues such as reducing redundancy of data within an existing computer system or improving the way in which it moves from one system to another. This position includes use of data profiling tools and techniques, and development of review and QA data requirements.
Business Requirement Analysis:
- Interact with Business Analysts to get the functional requirements.
- Interact with end users and find out the reporting needs.
- Conduct interviews, brain storming discussions with project team to get additional requirements.
- Gather accurate data by data analysis and functional analysis.
- Development of data model:
- Create standard abbreviation document for logical, physical and dimensional data models.
- Create logical, physical and dimensional data models (data warehouse Datamodelling).
- Document logical, physical and dimensional data models (data warehouse Datamodelling).
- Create SQL code from data model and co-ordinate with DBAs to create development, testing, regression and production database.
- Check to see data models and databases are in sync.
- Adding data base objects (like indexes, partitions in database) for performance
- Generate reports from data model.
- Review the data model with functional and technical team.
- Assist developers, ETL, BI team and end users to understand the data model.
- Maintain change log for each data model.
International candidates welcome