Talent.com
This job offer is not available in your country.
Manager - Product and Core Platforms

Manager - Product and Core Platforms

ConfidentialThane
30+ days ago
Job description

A. Position Overview

The Developer will be responsible for designing, developing, and maintaining applications. The ideal candidate should have a deep understanding of application architecture principles and best practices, with experience in cloud-based technologies for migration and integration, query optimization, maintenance of Databases.

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
  • Skills Required

    Ssrs, Postgresql, Product, Teradata, Ms Sql Server, Ssis, Etl

    Create a job alert for this search

    Product Manager • Thane