Hiring Data modeler for one of the global consulting firm for Pan India location.
Experience - 4-10 years
This role works with business analysts, business stakeholders and technical personnel to
translate business data requirements into data models and related data
artefacts, which will form the basis of solutions which meet and fulfil the business requirements.
This role reports to the Lead Data Modeller. Tasks include :
Producing Conceptual, Logical and Physical Data Models and related artefacts to
specified standards
Producing Entity Relationship Diagrams and specifying and documenting the
relationships between entities, specifying and documenting the data attributes for
each entity
Data Vault modelling knowledge and experience
Agreeing entity and attribute definitions with the respective stakeholders
Producing Data Ontologies and Class Diagrams
Generating data model schema scripts, using data modelling tools, from Physical Data
Models
Simultaneously being part of several project teams in order to allow multiple projects
to proceed at pace concurrently
Contributing to data modelling framework design discussions regarding items such as
the design and use of Reference Data
Investigating and providing estimates for data modelling work and, reporting progress
to-date
Working with Business SME and Technical staff to identify the data sources to be used
to meet the business requirements
Data mapping : The identification, specification and documentation of data mappings
and the associated transformations in order to move data from the source systems,
through the data warehouse layers where appropriate and, to present the data to
authorised end users
The clarification and documentation of business rules and data transformations with
technical colleagues and business users (who may be members of senior management)
Working with Database Administrators (DBA’s) and information service designers to
ensure the physical implementation meets the functional and non-functional
requirements
Skills & Experience :
Build data flows and develop conceptual data models Internal
Create logical and physical data models using best practices to ensure high data quality and
reduced redundancy
Optimise and update logical and physical data models to support new and existing projects
Maintain conceptual, logical and physical data models along with corresponding metadata
Develop and maintain best practices for standard naming conventions and coding practices to
ensure consistency of data models
Recommend opportunities for reuse of data models in new environments
Perform reverse engineering of physical data models from databases (Oracle, Microsoft
Azure) and SQL scripts
Good knowledge and experience of metadata management, data modelling, and related tools
Erwin or ERStudio or others) required
Good understanding if graph modelling (neo4J, Star Dog or similar)
Should have good SQL scripting knowledge to perform reverse engineering activities
Examine new application design and recommend correction wherever applicable
Data Modeler • Bengaluru, IN