Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Aniruddha Bose

ETL Developer | Informatica Cloud (IICS) | Data Integration Specialist
Kolkata

Summary

Results-driven Informatica and IICS/ETL Developer with 9 years of extensive experience in data integration, migration, and application support across diverse sectors, including banking, healthcare, and IT. Expertise in IICS (CDI, CAI, CDQ, MDM), PowerCenter, SQL, and cloud platforms such as Azure and AWS, with a strong focus on PowerCenter-to-IICS migration and compliance-driven ETL pipelines. Demonstrated proficiency in financial process intelligence (R2R, O2C, P2P) ensures seamless project execution and strict adherence to industry standards. Recognized for delivering client-focused solutions with zero escalations.

Overview

9
9
years of professional experience
2
2
Certifications

Work History

Senior IICS Developer / Team Lead

Tata Consultancy Services (TCS)
12.2022 - Current
  • Designed and deployed IICS CDI pipelines for migration and data integration projects.
  • Developed real-time Salesforce–Oracle integrations using CAI to enable faster reporting.
  • Implemented Cloud Data Quality (CDQ) rules for customer and financial data cleansing.
  • Partnered with architects to establish best practices in reusable mappings and error handling.
  • Led a team of six developers, assigning tasks, reviewing deliverables, and ensuring on-time delivery.
  • Mentored junior developers, and conducted knowledge transfer sessions for IICS.

ETL/Data Analyst

PwC SDC
10.2021 - 11.2022
  • Built financial process intelligence (R2R, O2C, P2P) models using SQL and SnapLogic.
  • Enhanced ETL pipelines to deliver actionable insights for finance stakeholders.
  • Conducted data validation and defect analysis, ensuring 99% accuracy post-deployment.
  • Collaborated with cross-functional teams to improve pipeline efficiency and governance.
  • Recognized for timely and quality delivery of client projects across multiple engagements.

ETL Developer

IBM India Pvt. Ltd.
08.2016 - 10.2021
  • Developed end-to-end ETL workflows in PowerCenter/IICS for Johnson & Johnson’s compliance reporting.
  • Migrated PowerCenter jobs to IICS, improving performance and reusability.
  • Authored FRS, URS, TDD, ECC documentation to meet regulatory and audit requirements.
  • Handled production support, defect analysis, and data validation with zero escalations.
  • Awards: IBM Spark Award (2020), Best Graduate Hire, Manager’s Choice Award.

Education

B.Tech - Information Technology

Kalyani Government Engineering College
Kalyani , West Bengal
08-2016

Skills

  • ETL & Cloud: Informatica IICS (CDI, CAI, CDQ, MDM), PowerCenter, SnapLogic
  • Databases: Oracle, Teradata, SQL Server
  • Cloud Platforms: Azure (ADLS, Synapse), AWS (S3, Redshift)
  • Scripting & Tools: SQL, PL/SQL, Unix, Query Surge, Control-M, JIRA, ServiceNow
  • Methodologies: Agile/Scrum, Data Quality, Data Governance, Documentation (FRS, URS, TDD, ECC)

Certification

Microsoft Azure Fundamentals (AZ-900)

Timeline

Senior IICS Developer / Team Lead

Tata Consultancy Services (TCS)
12.2022 - Current

ETL/Data Analyst

PwC SDC
10.2021 - 11.2022

ETL Developer

IBM India Pvt. Ltd.
08.2016 - 10.2021

B.Tech - Information Technology

Kalyani Government Engineering College

Similar Profiles

CREATE PROFILE
Aniruddha BoseETL Developer | Informatica Cloud (IICS) | Data Integration Specialist