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 IndiaStakeholders Internal : TDA-BSG and all other TATA AIA internal departmentsExternal : PartnersD. Key Result Areas
Implement and Optimize Operational dataMaintain Master Data ManagementPrepare and Organize for Big DataIntegral Part of BI initiativesDesign and implement database in accordance to end users information needs and viewsDefine and implement database schemas and normalizationDevelop, implement, and optimize stored procedures and functions using T-SQLReview and interpret ongoing business report requirementsDevelop procedures and scripts for data migrationProvide data management support to usersEnsure performance, security, and availability of databasesPrepare documentations and specifications for database design, coding, and testingHandle common database procedures such as upgrade, backup, recovery, migration, etc.Profile server resource usage, and optimize and tweak as necessaryCollaborate with other team members and stakeholdersAnalyse existing SQL queries for performance improvementsPerform tests and evaluations regularly to ensure data security, privacy, and integrityResolve database-related issues and provide solutions in a timely mannerStay updated with recent technological advancements and industry trends in database developmentComplex query understandingFollows all required company policies and practices relating to the System Development Life Cycle.Technical Tools :
Databases : MS SQL Server, TeradataBI Tools : SSIS, SSRS, ETLGood to have : PostgreSQLE. 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, ETLGood to have : PostgreSQLKnowledge of JSON and PostgreSQL support for JSONPostGIS proficiency and grasp of core geospatial conceptsAbility to efficiently write database code without compromising data quality, privacy or securityKnowledge of database design principles, query optimization, index management, integrity checks, statistics and isolation levelsAble to handle multiple tasks in a fast-paced environmentExcellent verbal, written, and interpersonal communication skillsAbility to evaluate alternative solutions and / or workaroundsBehavioral
Essential / Desired
Interpersonal skillsCommunication skillsCreative thinking skillsSupervising / Leadership skillsTeamwork SkillsInfluencing skillsRelationship Building skillsDecision making skillsH. Incumbent Characteristics
Essential / Desired
Qualification : Bachelor or equivalent degree in computer Science, Information Systems, EngineeringExperience : Min 10 years of experienceSkills Required
Ssrs, Postgresql, Product, Teradata, Ms Sql Server, Ssis, Etl