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