Semantic Data Modeler

Requisition Number: 214777

External Description:

Role: Semantic Data Modeler  - Finance Industry 

Job Location:- Mumbai/ Pune

Education Requirement

Bachelor’s Degree (or higher) preferably in Computer Science, Information Systems, Mathematics or other related fields

Skills and Attributes

• 6- 12 years of overall experience in data warehouse
• 4 – 6 years of Dimensional Modelling expert – Kimball Approach.
• 2 - 3 years of Database Design experience in Teradata.
• In depth knowledge of Semantic Layer and Integration layer
• Banking Domain knowledge
• Business Understanding
• Good communication skills (both written as well as oral). Communicates equally well with business people and technical team members.
• Work in a collaborative environment
• Focus on immediate project scope without losing sight of the big picture
• Knowledge of data modeling philosophies and techniques, including Inmon and Kimball.
• Provide thought leadership on best practices while designing the foundation and semantic layer
• Good Understanding of key Processes in, Banking (GL/Deposit/Loan/Bills/Instrument/Debit card/Credit card/Internet Banking), Investment Banking (Mutual Fund/IPO/Bond/Derivative /Portfolio management/Merger & Acquisition) and Insurance (General business/Life insurance/ Property & Casualty).
• Knowledge of Teradata Financial Services model (FS-DM) or Sound business knowledge of any Banking/Investment/Insurance industry data model for data warehouse.

 

It would also be nice if the candidate has experience working with Agile Methodology.

Job Responsibilities    

• Creating high level Common Semantic layer Architecture based on customer expectations. Review it with SMEs from client side and baseline the high level model.
• Owning the end to end Semantic modelling work
• Analyze business requirements to determine the data elements needed in the Semantic Layer
• Create necessary access layer objects for Facts, Dimensions to meet the business requirements
• Should have good knowledge of Star Schema Design using the Kimball approach.
• Must have good knowledge of OLAP queries, Aggregates, and usage of analytical functions in SQL queries.
• Good understanding of any one BI tool like Tablue /Cognos/Business Objects etc.
• Must have created interactive dashboards using any of the UI tools.
• 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 Semantic Layers. Present data models to business and technical audiences for review and validation
• Implement Data Profiling Develop/maintain all target-from-source mappings – Business Requirements to Access Layer data model(s); Access Layer data model(s) to Core Layer data model, Core Layer data model to Acquisition Layer ;
• Apply views, indexes and tables as required to meet the defined performance service levels (“SLAs”) for application access of the data warehouse; 
• Stakeholder’s interaction includes Enterprise Architects, Development Team, Business Intelligence team, Business SMEs, technology vendors etc.

 

CountryEEOText_Description: Why We Think You’ll Love Teradata We prioritize a people-first culture because we know our people are at the very heart of our success. We embrace a flexible work model because we trust our people to make decisions about how, when, and where they work. We focus on well-being because we care about our people and their ability to thrive both personally and professionally. We are an anti-racist company because our dedication to Diversity, Equity, and Inclusion is more than a statement. It is a deep commitment to doing the work to foster an equitable environment that celebrates people for all of who they are.

City: Pune

State: Maharashtra

Community / Marketing Title: Semantic Data Modeler

Job Category: Consulting

Company Profile:

Our Company

At Teradata, we believe that people thrive when empowered with better information. That’s why we built the most complete cloud analytics and data platform for AI. By delivering harmonized data, trusted AI, and faster innovation, we uplift and empower our customers—and our customers’ customers—to make better, more confident decisions. The world’s top companies across every major industry trust Teradata to improve business performance, enrich customer experiences, and fully integrate data across the enterprise.

LinkedIn Remote:

Location_formattedLocationLong: Pune, Maharashtra IN