Role:- Senior Lead Data Modeler (Telecom)

Job Location:  Mumbai/ Pune

Educational Qualification – Bachelor or Master of Engineering

Job Description for Communication / Telecom Industry Data modeller.

• 10-12 years of experience in Data warehousing in which 4-6 in data modelling.
• Work with the Application Development team to implement data strategies, build data flows and develop conceptual data models for Data warehouse.
• Create logical and physical data models using Erwin tool by best practices to ensure high data quality and reduced redundancy.
• Good Understanding of key Processes in Operating support system (OSS) and Billing Support System (BSS) stacks.
• Experience in working with Teradata Communication model (CLDM) or Sound business knowledge of any Telecom industry data model for data warehouse.
• Good to have knowledge of other industry data models. Implement Data Profiling and develop/maintain complete source to target mappings.
• Create, manage and modify logical and physical data models using a variety of data modelling philosophies and techniques including Inmon and Kimball.
• Stakeholder’s interaction includes Enterprise Architects, Development Team, Business Intelligence team, technology vendors etc.

Desired Skills

• Logical Modeling, Physical Modelling, Data profiling and Data Mapping
• Working experience with Teradata database, Indexes, TD SQLs, PI, MLPPI, Compression, Data Type selection and rightsizing, SI, JI, SOFT RI etc.
• Must be Ready to travel short-term and long-term for project assignment.
• Attitude towards learning business rules and integrate with data Model.
• Good understanding of Teradata database architecture and Teradata Physical Design.
• Good understanding of Data warehouse concepts, Data Governance and standardization processes.
• Understanding the Logical Data Model and creating the Physical
• Working Knowledge on multiple industries viz. Communication, Finance, Retail, Aviation, Manufacturing etc.

Job Responsibilities

• Analyze business requirements to determine the data elements needed in the Semantic Layer and Core Layer data models to support the solution
• Interact with Business SMEs to understand required data elements, the business rules governing them and confirm definitions
• Create, manage and modify conceptual, logical and physical data models for the Core and Semantic Layers.   Present data models to business and technical audiences for review and validation
• Create the PDM for the Landing, Staging and Source Image areas of the Acquisition Layer and Conduct the PDM review.