Data Modeler
- Data Economy
- 2 - 5 years
- Pune
- 5 months ago
- Email to a friend
- Report this job
Job Description
Job Description of the Data Modeler Role
The Data Modeler will work towardsdesign and implementation of new data structures to support the project teamsdelivering on ETL, Datawarehouse design , managingthe enterprise data model , the maintenance of the data , and enterprise data integration approaches.
Technical Responsibilities
Build and maintain out ofstandards data models to report disparate data sets in a reliable, consistentand interpretable manner.
Gather, distil andharmonize data requirements and to design coherent Conceptual, logical andphysical data models and associated physical feed formats to support these dataflows.
Articulate businessrequirements and build source-to-target mappings having complex ETLtransformation.
Write complex SQL statements and profile source data to validate data transformations.
Contribute to requirement analysisand database design -Transactional and Dimensional data modelling. Normalize/ De-normalizedata structures, introduce hierarchies and inheritance wherever required inexisting/ new data models.
Develop and implement data warehouse projects independently.
Work with data consumersand data suppliers to understand detailed requirements, and to proposestandardized data models.
Contribute to improvingthe Data Management data models.
Be an influencer to present and facilitate discussions tounderstand business requirements and develop dimension data models based onthese capabilities and industry best practices.
Requirements
Extensive practicalexperience in Information Technology and software development projects of with atleast 8+ years of experience in designing Operational data store data warehouse.
Extensive experience inany of Data Modelling tools Erwin/ SAP power designer.
Strong understanding ofETL and data warehouse concepts processes and best practices.
Proficient in Data Modellingincluding conceptual, logical and physical data modelling for both OLTP andOLAP.
Ability to write complexSQL for data transformations and data profiling in source and target systems
Basic understanding of SQL vs NoSQL databases.
Possess a combination ofsolid business knowledge and technical expertise with strong communicationskills. Demonstrate excellent analytical and logical thinking.
Good verbal written communication skills and Ability to workindependently as well as in a team environment providing structure in ambiguoussituation.
Good to have
Understanding of Insurance Domain
Basic understanding of AWS cloud
Good understanding ofMaster Data Management, Data Quality and Data Governance.
Basicunderstanding of datavisualization tools like SAS VA, Tableau
Goodunderstanding of implementing architecting data solutions using the informatica, SQL server/Oracle
","
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QARole Category: DBA / Data warehousingRole: DBA / Data warehousing - OtherEmployement Type: Full timeContact Details:
Company: Data EconomyLocation(s): Pune+ View Contact
Keyskills: SAP SAS Data management Database design Data structures Informatica data visualization Oracle Data warehousing SQL
Fraud Alert to job seekers!
₹ Not Disclosed
Similar positions
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in