Managing Daily Data Extracting function, transforming according to the business logics, and load to relevant target databases. This process should be handled with high Accuracy. Monitoring of this process need to maintain with agreed SLAs with BUs by providing on time data availability.
Troubleshooting and recovering on Daily ETLs and provide root cause analysis. Daily Revenue assurance activities on BI.
Coordinates with source owners and business owners for resolving issues and escalate/liaise with relevant venders/partners for technical support.
ETL (Extracting Transforming and loading) implementation on new source system integrations, should have to make proper and accurate dimensional model by studying end user analysis/report requirements.
Maintain Detail level records and maintain summaries on Data warehouse.
Manage change requests in existing Big data related ETLs and in summary and analytical tables .
Suggesting new technologies and tools to optimize the Extract, transform, Loading operations.
Gather requirements from user divisions for new data feeds and liase with stake holders to complete integration and design summary tables.
Understand user requirement, source data and develop and validate data extraction logics
Coordinate with OS Team to get relevant os upgrades
System maintenance, time to time VA scans, , storage management and security risk management/assessments , on all BI systems.
Should have to responsible on up and running (availability) status on all BI and ETL (Extracting Transforming and loading ) Layer.
Cloud platform security maintenance (In terms of data security, role based access control
Participate and contribute to relevant events
Monitor the correct adherence to data management practices and policies
Research on industry best practices and work with internal / external parties on RnD tasks
Provide required details of new integrations to the Data dictionary
