Senior Data Modeler - Data warehousing
Senior Data Modeler - Data warehousing
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Skills:
Data/ Dimensional modelling in data warehousing
Oracle SQL PL/SQL views procedures functions
Experience extracting data (Oracle SQL/ Excel) and creating data model as per customer requirement
Be proficient in SQL and ETL processes ETL and DB performance tuning table partitioning
Any Data Modelling tools (SAP PowerDesigner ERWin Oracle SQL data modeler etc.).
Experience working in DW projects handling cross domain data models
Backend programs to be developed such as stored Procedures Functions Packages cursors collections and triggers and materialized views using SQL and PL/SQL. Know-how of Power BI reports.
Preferred: Azure Cloud fundamentals Python.
Responsibilities:
Interact with customer to understand business requirement and build logical conceptual and physical data models.
Work with requirements spec in preparing the dimensional models / DataVault modeling
Experience with any of Data Modelling tools ERWIn Oracle SQL data modeler SAP Power designer etc..
Work along with source system experts in finalize the source to report mapping
Coordinate with central team to replicate tables from source system to data lake
Convert business requirement to concept/ technical specification
Support Oracle developer in design and development
Design Develop and Deploy solution
Unit & Integration testing
Hand holding key users in report utilization
Support customers during the stabilization phase
Create/ track open point list and co-ordinate with customer to clarify
Qualifications :
Bachelor of Engineering / Computer science
Remote Work :
No
Employment Type :
Full-time
Employment Type
Full-time
