Technical Lead

Requisition Number: 200632

External Description:

Role:  Communication / Telecom Industry Data modeler.

Education Requirement:

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

Skills and Attributes:

- 8 to 10 years of overall experience
- 2 - 3 years of Database Design experience in Teradata
- 2 – 3 years of experience with Performance Tuning in Teradata
- 1 – 2 years of Semantic Layer design experience
- 1 – 2 years of experience with Data Modeling tool ERWIN
- Good communication skills (both written as well as oral). Communicates equally well with business people and technical team members.
- Work in a collaborative environment
- Understands and can work with business concepts. Absorbs new concepts quickly
- Drives for clarity and pays attention to detail. Always thorough.
- 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 one or more telecommunications lines of business (Prepaid/Postpaid Mobile, Fixed Line, Broadband and TV) including the CDR/EDR processing cycle, and key processes in the Operations and Business Support Systems (OSS and BSS)
- Experience in working with Teradata Communications data model (C-DM) or Sound business knowledge of any Telecom industry data model for data warehouse.
- It would also be nice if the candidate has experience working with Agile Methodology.

Job Responsibilities:

- Analyze business requirements to determine the data elements needed in the Semantic Layer and Core Layer data models to support the solution
- Prepare Conceptual Data Models for the Semantic and Core Layers for inclusion in the Solution Architecture, showing the information scope of the project
- 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.
- 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.
- Translate detailed physical design into Data Definition Language (“DDL”).
- Implement and test DDL with sample data provided.
- Analyze the data and recommend compression by table and column.
- Provide performance tuning recommendations for the Foundation layer.
- Apply views, indexes and tables as required to meet the defined performance service levels (“SLAs”) for application access of the data warehouse.
- Object migration from development environment to test environment.
- 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: Technical Lead

Job Category: Services

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