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
