Mandar Tribhuwan

Designing and implementing data models and schemas to support analytical and operational requirements.

• Developing and optimizing ETL processes to cleanse, transform, and aggregate data from multiple sources.
• Implementing data quality checks and validation processes to ensure accuracy, completeness, and consistency of data.
• Monitoring and optimizing performance of data pipelines and systems to handle increasing volumes of data.
• Creating new CDC Connectors for Production database.
• Doing Tasks for Database Center of Excellence (DB-COE) Troubleshooting and monitoring Debezium Connectors.
• Performing DBA tasks. (User management, Database management)
• Taking Full Load of Production and UAT Creating and monitoring Kafka Topics.
• Implemented data migration processes, ensuring data accuracy and integrity during transitions.

Projects :

IDFC Duration : (10/2022 - 10/2023)

• Implemented Debezium, powerful open-source change data capture (CDC) tool, on Kafka to enable real-time data synchronization between source database (Oracle) and target database (Aerospike)
• Successfully captured and streamed database changes, ensuring reliable and efficient replication process.
• Leveraged Kafka ecosystem to handle data events efficiently.
• Enabled organization to maintain up-to-date data in Aerospike, facilitating responsive, data-driven applications.
• Implemented alerting mechanisms in Grafana to notify stakeholders of critical events or deviations from predefined thresholds.

Airtel (SKYVAULT) Duration : (10/2023 - 05/2024)

• Telecom sector related project which is based on AB-INITIO.
• Implemented ETL where text messages are handled by SMPP.
• Regularly interacting and troubleshooting client queries using Data Visualization tools as ( Kibana , Grafana , Oracle SQL Developer & AB-INITIO graphs ).

Airtel DARTS Duration : (05/2024 - Current)

• DARTS - Digital Analytics in Real Time, analyzed data from various sources such as calling related data, SMS, 5G Data, Broadband data, etc.
• Reprocessed data through AB-INTIO jobs and loaded same into HADOOP using KAFKA.
• Used various data Visualization tools like Grafana, Microsoft Power-BI.