Manager - Backend - India - Tata Teleservices

Description

JOB DESCRIPTION

Responsible for working with key business stakeholders to design and develop ETL layer to meet Data Warehouse requirements for end user reporting, KPI's and analytics capability. Responsibilities will include leading and guiding ETL based design and development

Key Responsibilities

1. Lead and guide in design and development of Informatica/Pentaho based ETL Architecture
2. Architect, Manage, build and quality assure code to ensure fulfillment of business requirement and adhering to ETL architecture and ensure inconsistency, data redundancy and duplication of objects are eliminated
3. Manage partners to handle various layer of Data Warehousing like Database Management, Data Extraction, Transformation and Loading (ETL), Integration for souring the data from various operational systems, Design, build and launch new data models
4. Assess requirements for completeness and accuracy.
5. Determine if requirements are actionable for ETL team.
6. Conduct impact assessment and determine of effort based on requirements.
7. Develop full SDLC project plans to implement ETL solution and identify resource requirements.
8. Experience in agile methodologies
9. Define and manage SLAs for all ETL jobs, reports and analytics and support all existing ETL and data quality processes running in production
10. Build data expertise and own data quality
11. Exercise creativity in the design, development, or improvement of existing processes and driving management of change
12. Manage and implement on-going operations of hosted data solutions including security, user admin, and other administrative requirements

Function
Information Technology

Reporting To
DGM â€' Data Warehouse and ETL

Essential Attributes
Experience in Data Warehouse designing (on-prem and Cloud), Experience in databases like SQL Server, Oracle Cosmos etc. Experience in ETL tools like SSIS etc,

Desired Attributes
Experience in integrating with Sales Force, PowerBI or similar visualization tools, Experience in Jira or ServiceNow or similar tools

Qualification
Graduation in Engineering (preferably in Computer Science

Desired Experience(years)
10+ Years in Developing Data Warehouse solution