CHAITALI SENAPATI
Kolkata
Summary
- Over 10 years of proven expertise in data integration, solution design, development, testing, and production support.
- High proficiency in Oracle Data Integrator (ODI 12c) and SQL, with a track record of delivering scalable, high-performance ETL solutions.
- Extensive domain experience across Retail, Insurance, Telecom, and cross-industry projects, enabling data-driven decision-making.
- Prior experience with leading organizations including TCS, IBM India Pvt. Ltd., and Cognizant, collaborating on enterprise-grade solutions aligned with business objectives and technology best practices
Overview
11
11
years of professional experience
1
1
Certification
Work History
Senior Data Integration Engineer
Tata consultancy services
Kolkata, West Bengal
05.2021 - Current
- Contributed to a Banking Data Warehouse Program for Bendigo and Adelaide Bank, covering Liquidity, FCS, and Quantum domains.
- Designed and implemented high-performance ETL processes using ODI 12c, improving data accuracy and reporting.
- Built reconciliation frameworks between Zafin (Pricing & Billing) and Mainframe systems, reducing manual reconciliation efforts.
- Delivered scalable solutions to support regulatory and business reporting requirements.
- Implementation of SDC2 and SCD3.
Data Integration Specialist
Cognizant
Kolkata
12.2018 - 05.2021
- Delivered ODI-based integration for 7-Eleven, migrating from legacy mainframes to Oracle MOM.
- Led requirement gathering, data profiling, and quality checks.
- Designed and developed ODI mappings, packages, and performance-optimized ETL jobs.
- Executed full migration lifecycle across Dev → SIT → UAT → Prod environments.
- Ensured high data quality and timely delivery by collaborating with stakeholders.
BI Developer
IBM India Pvt. Ltd.
Kolkata
11.2017 - 12.2018
- Implemented BI solutions for Indian Oil (EPIC Project), migrating processes from OLTP to OLAP.
- Integrated data from MDM, Siebel, and SAP via middleware to OBIA.
- Designed and developed ODI 11g/12c ETL processes for BI reporting.
- Delivered the Maaden BIAPP project ensuring scalable ETL solutions and accurate reporting.
ETL Developer
EBIW
Kolkata
06.2015 - 11.2017
- Implemented BI and data integration projects for telecom clients (Digicel, CWP Telecom).
- Designed ODI 12c ETL workflows for relational and Big Data platforms.
- Built scalable data integration frameworks supporting 22 markets across 5 hubs.
- Migrated and upgraded ODI Master Repository with minimal downtime.
- Supported SIT/UAT testing, production deployments, and post-migration stability checks.
Education
B. Tech - Information Technology
West Bengal University of Technology
01.2015
Skills
- SQL
- PL/SQL
- ORACLE 11g
- ORACLE 12c
- HIVE
- ODI 11g
- ODI 12c
- EDW Design
- OLTP to OLAP Migration
- Data Reconciliation
- Oracle MOM
- OBIA/BIAPPS
- Big Data (BDA)
Certification
- Oracle Cloud Foundation - Associate
- Oracle Data Integrator 12c
Timeline
Senior Data Integration Engineer
Tata consultancy services
05.2021 - Current
Data Integration Specialist
Cognizant
12.2018 - 05.2021
BI Developer
IBM India Pvt. Ltd.
11.2017 - 12.2018
ETL Developer
EBIW
06.2015 - 11.2017
B. Tech - Information Technology
West Bengal University of Technology