Manager - Product and Core Platforms

A. Position Overview

The Developer

B. Organizational Relationships

• Reports to

  : SM

• Supervises

  : AVP

C. Job Dimensions

• Geographic Area Covered

  : PAN India

• Stakeholders Internal

  : TDA-BSG and all other TATA AIA internal departments

• External

  : Partners

D. Key Result Areas

• Implement and Optimize Operational data
• Maintain Master Data Management
• Prepare and Organize for Big Data
• Integral Part of BI initiatives
• Design and implement database in accordance to end users information needs and views
• Define and implement database schemas and normalization
• Develop, implement, and optimize stored procedures and functions using T-SQL
• Review and interpret ongoing business report requirements
• Develop procedures and scripts for data migration
• Provide data management support to users
• Ensure performance, security, and availability of databases
• Prepare documentations and specifications for database design, coding, and testing
• Handle common database procedures such as upgrade, backup, recovery, migration, etc.
• Profile server resource usage, and optimize and tweak as necessary
• Collaborate with other team members and stakeholders
• Analyse existing SQL queries for performance improvements
• Perform tests and evaluations regularly to ensure data security, privacy, and integrity
• Resolve database-related issues and provide solutions in a timely manner
• Stay updated with recent technological advancements and industry trends in database development
• Complex query understanding
• Follows all required company policies and practices relating to the System Development Life Cycle.

Technical Tools:

• Databases: MS SQL Server, Teradata
• BI Tools: SSIS, SSRS, ETL
• Good to have: PostgreSQL

E. Competencies (Please copy paste from Competency Dictionary)

Competency For

Proficiency Scale

Proficiency Scale Description

Eg - Business Acumen and Strategic Orientation

• Ability to align with the organization's vision with a fair understanding of the insurance industry, regulations, financial markets and the agency business model in order to deliver profitable and sustainable business growth.
• Has an in-depth understanding of the market of operations and proposes changes if required as per market dynamics.
• Understands how and to what extent business complexities impacts one's own area of work.
• Is able to identify trends and analyze performance of self and various branches in one's geography.
• Has expert knowledge of BA model, BA compensation and Agent commission and progression and uses it to deliver superior performance.
• Is able to devise plans to recruit, develop and sustain distributors on a long-term basis with the organization.
• Strives towards achieving proportionate business contribution from all the branches of assigned territory.

G. Skills Required

Technical

• Min 10 years experience in MS SQL Server, Teradata BI Tools, SSIS, SSRS, ETL
• Good to have: PostgreSQL
• Knowledge of JSON and PostgreSQL support for JSON
• PostGIS proficiency and grasp of core geospatial concepts
• Ability to efficiently write database code without compromising data quality, privacy or security
• Knowledge of database design principles, query optimization, index management, integrity checks, statistics and isolation levels
• Able to handle multiple tasks in a fast-paced environment
• Excellent verbal, written, and interpersonal communication skills
• Ability to evaluate alternative solutions and/or workarounds

Behavioral

Essential / Desired

• Interpersonal skills
• Communication skills
• Creative thinking skills
• Supervising/Leadership skills
• Teamwork Skills
• Influencing skills
• Relationship Building skills
• Decision making skills

H. Incumbent Characteristics

Essential / Desired

• Qualification

  : Bachelor or equivalent degree in computer Science, Information Systems, Engineering

• Experience

  : Min 10 years of experience