Amitava Ghosh
Kolkata
Summary
Dynamic Senior Consultant with HCL Technologies, specializing in ETL workflows and data engineering. Expert in Informatica Powercenter and IICS, I optimized data pipelines, enhancing efficiency . Adept at incident management and stakeholder collaboration, I ensure seamless operations while fostering team knowledge transfer and support.
Overview
12
12
years of professional experience
1
1
Certification
Work History
Senior Consultant – Data Engineering
HCL Technologies
12.2022 - Current
- Developed and enhanced ETL workflows using Informatica PowerCenter and Informatica Intelligent Cloud Services (IICS), including Cloud Data Integration (CDI) for cloud-based data processing.
- Built and deployed end-to-end data ingestion pipelines integrating multiple data sources such as FTP Flat file, JSON, Tabular structured data, XML, AWS S3, and AWS Redshift.
- Implemented Change Data Capture (CDC) for real-time updates using both Informatica PowerCenter and IICS Both.
- Implemented Concurrent data load in Informatica PowerCenter and Dynamic mapping in IICS for multiple source and target definition.
- Conducted performance tuning for large-scale data pipelines and optimized IICS jobs for efficiency.
- Analysed data in SQL Server, AWS Redshift, Atheena S3 and Snowflake data base in case of any data discrepancies or new data pipeline implementation as a part of data analysis.
- Create Universe, data source query, new report, marge report, Edit report, Schedule report in SAP BO.
- Support IBM TM1 for supply chain, create SKUs, dimensions in TM1 development environment. Implement data source through ETL into TM1.
- Provided on-call production support for critical incidents (P1) in ETL and the Marketing Analytics domain.
- Authored process documentation and conducted knowledge transfer (KT) sessions for new team members.
System Engineer – Data Warehousing
Tata Consultancy Services
06.2015 - 12.2022
- Designed, developed, and maintained Informatica workflows, transformations, and Slowly Changing Dimensions (SCDs).
- Performed root cause analysis for batch failures and optimized performance for recurring processes.
- Led incident and problem management activities ensuring SLA compliance for a BFSI domain client.
- Prepared SDS, SRS, rollback scripts, and handled emergency change requests.
- Coordinated with stakeholders to ensure smooth deployment and service restoration.
- Managed incident lifecycle in ServiceNow for telecom operations.
- Raised, tracked, and resolved P1, P2, and P3 incidents within SLA.
- Conducted quality audits of incident management deliverables to maintain high operational standards.
- Acted as the primary escalation point for critical operational issues.
Network Officer
ShoMuk Engineering Consultancy (Vodafone)
04.2014 - 06.2015
- Oversaw network operations ensuring maximum service availability.
- Maintained operational records and conducted regular safety and compliance audits.
- Coordinated maintenance activities and resolved field issues to minimize downtime.
Education
B.Tech - ECE
WBUT (MAKAUT)
01.2013
Diploma - ETCE
WBSCTE
01.2010
Higher Secondary -
WBCHSE
01.2006
Secondary -
WBSE
01.2004
Skills
- ETL Tools
- Informatica Intelligent Cloud Services (IICS)
- Informatica PowerCenter 9x/10x
- AWS GLUE
- Databases
- Oracle
- MySQL
- SQL Server
- AWS Redshift
- Snowflake
- Cloud & BI
- AWS S3
- SAP BO
- IBM TM1
- Scripting
- UNIX Shell
- SQL Query
- PL SQL
- Terraform
- Tools
- JIRA
- Service Now
- Autosys
- Tidal
- WinSCP
- Putty
- DBeaver
- SQL Server Management Studio
- Toad
- GitHub
- Visual Studio Code
- Management
- Incident & Quality Management
- ITIL
- ITSM
Certification
• Microsoft Certified: Azure Data Fundamentals (DP-900)
• Adobe Business Practitioner Expert
• Lean Six Sigma Green Belt – TCS Internal
• IICS DNA – HCLTech Internal
• Generative AI and Prompt Engineering L2 – HCLTech Internal
• Adobe Business Practitioner Expert
• Lean Six Sigma Green Belt – TCS Internal
• IICS DNA – HCLTech Internal
• Generative AI and Prompt Engineering L2 – HCLTech Internal
Business Domain
- Telecom
- BFSI
- Retail
Awards Recognition
- Multiple ‘On the Spot’ Awards – TCS (2020-2022)
- Best Team Awards – TCS
- Service & Commitment Awards – TCS
- Star of the Month – TCS
- Tech-a-lavya Performance Award – Vodafone Project
Languages
- Hindi
- Bengali
- English
- Hindi
- Bengali
Core Competencies
Informatica Intelligent Cloud Services (IICS), Informatica PowerCenter 9.x/10.x, AWS GLUE, Oracle, MySQL, SQL Server, AWS Redshift, Snowflake, AWS S3, Redshift, SAP BO, IBM TM1, Snowflake, UNIX Shell, SQL Query, PL SQL, Terraform, JIRA, Service Now, Autosys, Tidal, WinSCP, Putty, DBeaver, SQL Server Management Studio, Toad, GitHub, Visual Studio Code, Incident & Quality Management, ITIL, ITSM
Personal Information
- Hobbies: Music
- Date of Birth: 02/17/89
- Nationality: Indian
Timeline
Senior Consultant – Data Engineering
HCL Technologies
12.2022 - Current
System Engineer – Data Warehousing
Tata Consultancy Services
06.2015 - 12.2022
Network Officer
ShoMuk Engineering Consultancy (Vodafone)
04.2014 - 06.2015
B.Tech - ECE
WBUT (MAKAUT)
Diploma - ETCE
WBSCTE
Higher Secondary -
WBCHSE
Secondary -
WBSE