Data Modeler

About Company:

A Global IT MNC Company

Experience: 16 to 22Years

Location: Chennai, Bangalore, Mumbai, Pune, Noida

Work Mode: WFO

Data Modelller

\n
• Conduct data analysis and capture data requirements.
\n
• Perform data mapping based on data source schemas and reverse engineering of existing transformations from multiple source database systems on cloud data platform to meet the corporate standards.
\n
• Work closely with all the squad and product owners to implement data strategies.
\n
• Validate logical data models with business subject matter experts.
\n
• Work with the development team to ensure all requirements are captured and reflected in the data model.
\n
• Work with the DBA team to design physical models to satisfy optimal performance.
\n
• Active participation in metadata definition and management.
\n
• Data modeling techniques such as Erwin, ER/Studio, Power Designer.
\n
• Good learning ability
\n
• Good communication skills
\n

Responsibilities:

\n
• Maintain knowledge of data processing trends and innovations in programming languages, development environments, and database capabilities
\n
• Create an enterprise view of the data objects and drive metadata capture through data modeling application
\n
• Lead requirements gathering meetings with application teams, Database Administrators, and/or business partners to understand business needs
\n
• Develop and design the conceptual, logical, and physical data model using data modeling software like ERWIN for staging, analytics, reporting,
\n
• Contribute and participate in discussions with implementation of metadata tools for client (business glossary, data lineage)
\n
• Provide technical support on topics, such as efficient data modeling techniques, application development, manipulation of extremely large client datasets, general task automation etc
\n
• Create appropriate documentation as part of work assignments, such as program code, flowcharts and technical requirements
\n
• Perform design implementation and support of building greenfield application development, Enterprise Data Management (EDM), and data structures within all layers of EDW
\n
• Drive design of data structures
\n