Data Modeler (Bengaluru)

Data Modeler (Bengaluru)

19 Nov
|
AANLEY SERVICES PRIVATE
|
Bengaluru

19 Nov

AANLEY SERVICES PRIVATE

Bengaluru

Job Summary

We are seeking a highly skilled and detail-oriented Data Modeler to join our Data

Management team. The ideal candidate will be responsible for designing and

implementing logical and physical data models to support enterprise data

initiatives. This role requires close collaboration with business stakeholders, data

architects, and engineers to ensure data is structured and accessible for analytics,

reporting, and operational needs.

The successful candidate will:

Provides technical expertise in needs identification, data modelling, data

movement and transformation mapping (source to target), automation and testing

strategies, translating business needs into technical solutions with adherence to

established data guidelines and approaches from a business unit or project

perspective, maintaining Data Vault 2.0–based enterprise data warehouses, with

solid knowledge of data modeling.

Be responsible for the development of the conceptual, logical, and physical data

models, the implementation of RDBMS, operational data store (ODS), data marts,

and data lakes on target platforms (SQL/NoSQL).

Oversee and govern the expansion of existing data architecture and the

optimization of data query performance via best practices. The candidate must be

able to work independently and collaboratively.

Leadership not only in the conventional sense, but also within a team we expect

people to be leaders. Candidate should elicit leadership qualities such as

Innovation, Critical thinking, optimism/positivity, Communication, Time

Management, Collaboration, Problem-solving, Acting Independently, Knowledge

sharing and Approachable.

Essential Duties:

Understand and translate business needs into data models supporting long-term solu

tions.

Work with the Application Development team to implement datastrategie

s, build data flows and develop conceptual data models.© 2021 Ex

lService Holdings, Inc. All rights reserved

Create and maintain conceptual, logical and physical data models usingbest prac

tices to ensure high data quality and reduced redundancy, alongwith corr

esponding metadata.

Optimize and update logical and physical data models to support new andexisting

projects.

Design and develop Data Vault 2.0 models (Hubs, Links, Satellites) alignedwith busi

ness keys and source system structures.

Translate business requirements into raw vault and business vaultcomponestrong>nts.

Ensure models follow DV2.0 standards for auditability, lineage, scalability,and flexi

bility.

Work with enterprise architects to define best practices and modelingguidel

trong>ines

Develop best practices for standard naming conventions and codingpractices

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 andSQL scri<

/strong>pts.

Participate in data integration and data warehousing efforts, supportingreporting

and BI solutions.

Conduct data profiling and data analysis to understand data quality andstruc

rong>ture

Evaluate data models and physical databases for variances anddiscrepan

cies.

Validate business data objects for accuracy and completeness.

Analyse data-related system integration challenges and proposeappropria

te solutions.

Develop data models according to company standards. Guide SystemAnalysts,

Engineers, Programmers and others on project limitations andcapabilit

ies,



performance requirements and interfaces.

Review modifications to existing software to improve efficiency andperforma<

/strong>nce.

Examine new application design and recommend corrections if required.

Assist with and support setting the data architecture direction (includingdata move

ment approach, architecture / technology strategy, and anyother dat

a-related considerations to ensure business value,) ensuring dataarchitect

ure deliverables are developed, ensuring compliance to standards© 2021 Ex

lService Holdings, Inc. All rights reservedand guide

lines, implementing the data architecture, and supportingtechnical

developers at a project or business unit level.

Coordinate and consult with the project manager, client business staff,client te

chnical staff and project developers in data architecture bestpractices

and anything else that is data related at the project or businessunit leve

ls.Required

Qualifications:

7-10 Years industry implementation experience with one or more datamodelling

tools such as Erwin, ERStudio, PowerDesigner etc.

Minimum of 8 years of data architecture, data modelling or similarexperi

trong>ence

5-7 years of management experience required

5-7 years consulting experience preferred

Experience working with dimensionally modelled data

Bachelor's degree or equivalent experience, Master's Degree Preferred

Understanding of cloud (Azure, AWS, GCP, Snowflake preferred) and onpremises

architectures

Experience in data analysis and profiling

Strong data warehousing and OLTP systems from an integration perspective

Strong understanding of data integration best practices and concepts

Strong SQL skills required scripting preferred

Strong Knowledge of all phases of the system development life cycle

Experience with major database and big data platforms (e.g. RDS, Aurora,Redshift,

Databricks, MySQL, Oracle, PostgresSQL, Hadoop, Snowflake, etc.)

Understanding and experience with major Data Architecture philosophies(Dimensio

nal, ODS, Data Vault, etc.)

Understanding of modern data warehouse capabilities and technologiessuch as r

eal-time, cloud, Big Data.Preferred

Skills & Experience:

Involved in documenting user requirements, business process andtranslati

on of business process into technical documents.

Created Data Architect designs/documents for business processingrequireme

nts.

Analyzed and audited Requirements & Business Processes.© 2021 Ex

lService Holdings, Inc. All rights reserved

Prepared Business Matrix diagram to identify business processes,dimension

s, facts, conformed dimensions, junk and degeneratedimensi

strong>ons.

Worked as a part of the review and collaboration sessions regardingbusiness

processes, canonical (BOM) modeling.

Profile the source system data to identify the business process and businessrequireme

nt with operational system data.

Designed/captured the business processes & then mapped them to theconceptua

l data model.

Involved in modeling business processes through UML diagrams usingRational

Rose.

Prepared Test Scenarios based on understanding of business process flow.





Assisted in process model development, identifying business process needsand requi

rements and modeling into useable, business-driven dataproces

trong>ses.

Participate in requirement gathering, design review and code reviewmeetings

Analyse business process and optimize existing extract storedprocedu

strong>res.

Redefined many attributes and relationships in the reverse engineeredmodel and

cleansed unwanted table/columns as part of data analysisresponsib

ility.

Reviewed Entities and relationships in the engineered model and cleansedunwanted

tables/ columns as part of data analysis responsibilities.

Conducted logical data analysis and data modeling joint application design(JAD) ses

sions, documented data-related standards.

Performed data analysis to support mapping and transformation of datafrom lega

cy systems to physical data models.

Gather accurate data by data analysis and functional analysis.

Conduct logical data modeling and data analysis.

Involved in developing SQL queries for extracting data from test andproductio

n databases to perform data analysis and data quality checks.

Worked with tools like TOAD for data analysis, SQL assistant, Tortoise SVNand red g

ate's SQL compare.

Developed robust and efficient oracle PL/SQL procedures, packages andfunctions

that were useful for day to day data analysis.

Conducted data analysis on application views, functions and triggers, andtuned for

performance, fixed missing/wrongly mapped data.© 2021 Ex

lService Holdings, Inc. All rights reserved

Involved in the data mapping, data analysis and Gap analysis between theLegacy sy

stems and the Vendor Packages.

Performed Data Profiling and Data Analysis using SQL queries looking forData issu

es, Data anomalies.

Defined Data architecture Strategy, Data Management Strategy, datastandards

, Data architectural.

Consolidated and generated database standards and naming conventionsto enhanc

e Enterprise Data Architecture processes.

Developed an activity centered data architecture and a process architecturefor autom

ated data extraction.

Analyzed, documented and articulated the customer's current datawarehouse

/data mart architecture.

Generated Logical Data Models for old databases using Reverse engineeringand docum

ented in order to implement Forward Engineering procedures.

Designed and implemented procedures for mapping interface databetween l

egacy systems and a new implementation.

Revised and rewrote their design specifications, established internalprocedure

s for product certification.

Designed standards and procedures to manage metadata in a structuredand unstr

uctured data environments.

Mentored existing staff on data administrative processes procedures andstanda

trong>rds.

Created standards and procedures for metadata collection and repositorymaintena<

/strong>nce.

Designed and developed several complex database procedures, packages.

Developed business specific custom reports using PL/SQL procedures.

Established auditing procedures to ensure data integrity.

Developed stored procedures to implement business logic.

Design Functional Testing Standard Operating Procedures.

Worked with different team to provide them with the essential storedprocedure

s and packages and the required access to the data.

Developed and optimized database structures, stored procedures, dynamicmanagemen

t views, DDL triggers, cursors and user defined functions

📌 Data Modeler (Bengaluru)
🏢 AANLEY SERVICES PRIVATE
📍 Bengaluru

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: data modeler (bengaluru) / bengaluru