Summary
Overview
Work History
Education
Skills
Awards
Certification
Timeline
Generic

Krishnendu Bose

Bengaluru

Summary

Highly skilled professional with 9 years of hands-on experience in analyzing, developing and designing solutions(ETL, Data Warehouse) in OLTP technologies using star and snowflake dimensional modelling. Hands-on exposure with Informatica Cloud(IICS)/ETL. Self-motivated team performer with experience as Informatica Lead/Informatica Cloud(IICS) Developer. Willing to contribute to the success of my organization with sheer commitment and fully utilizing my skills and knowledge in a position offering continuous growth and development.

Overview

10
10
years of professional experience
1
1
Certification

Work History

Technical Lead

Bahwan Cybertek
08.2024 - Current
  • Led end-to-end design and development of data integration solutions using Informatica IICS CDI, integrating data across multiple cloud and on-premise systems.
  • Acted as a Technical Lead, mentoring junior developers, reviewing code and designs, and setting best practices for development and deployment.
  • Managed full project lifecycle, including planning, resource allocation, stakeholder communication, and delivery tracking.
  • Designed and implemented scalable applications for data extraction and analysis.
  • Created proofs of concept for innovative new solutions.

Senior Associate

PwC India
09.2021 - 08.2024
  • Lead a Workday Data Migration Project, managing a team of 8 to migrate the data from SAP Legacy system to Workday, resulting in successful overall data load and increase the load percentage to 97% using Cloud Data Integration (IICS CDI).
  • Responsible for interaction with business partners to identify/understand the business requirements, design specifications and expectations
  • Identify ETL specifications based on the business requirements and creating ETL Mapping Documents, high level documentation for product owners and data managers
  • Responsible for leading a Data Migration Project, managed a team of 6 to migrate the business data from Teradata to Snowflake, resulting in successful technical and business go-live using Cloud Data Integration (IICS CDI)
  • Have experience in migrating the data from Legacy system to Workday using SAP connector
  • Involved in capacity planning, product planning, sprint planning and release planning
  • Managed code reviews and ensure that all solutions and processes are aligned to architectural/requirement specifications, SLAs and standards
  • Extensively worked on Hierarchy Builder, Hierarchy Parser, Web Service transformation
  • Involved in support/maintenance for the production systems by providing detailed Incident Reports with Root-cause analysis, Temporary and Permanent solution to the issues
  • Provide resolution to an extensive range of complicated ETL-related problems, proactively and as issues surface
  • Provided leadership and direction to project team by understanding business processes, gathering requirements, identifying potential usability issues, managing scope, and ensuring the deliverables were maintained at all times
  • Responsible for leading a Data Migration Project, managed a team of 6 to migrate the business data from Teradata to Snowflake, resulting in successful technical and business go-live
  • Managed code reviews and ensure that all solutions and processes are aligned to architectural/requirement specifications, SLAs and standards
  • Managed team and assign tasks, review/validate code and help them to fix the critical issues in testing and development
  • Responsible for interaction with business partners to identify/understand the business requirements, design specifications and expectations
  • Identify ETL specifications based on the business requirements and creating ETL Mapping Documents, high level documentation for product owners and data managers
  • Designed and build IICS mappings to extract the data from SAP systems, Flat Files like csv and excel and loaded the data SQL Server for generating XML files as per the business need
  • Involved in capacity planning, product planning, sprint planning and release planning

Information Technology Analyst(ITA)

Tata Consultancy Services
06.2015 - 09.2021
  • Collaborate with Business analysts, architects and developers to plan, design, develop, test and deploy solution in all the environments
  • Prepared technical specifications and resolution documents for job monitoring and issue resolving across all the environments
  • Developed and enhanced complex Informatica mappings, sessions, workflows with optimization
  • Managed team and assign tasks, review/validate code and help them to fix the critical issues in testing and development
  • Provided solutions to production failures and ETL/DB performance enhancement
  • Worked as a delivery coordinator for preparing the project timeline plan
  • Trained the business users on understanding the ETL process to support their own applications, shared the knowledge to resolve data issues
  • Interacted with business, cross functional team on day to day basis for critical timeline requirements and any system issues
  • Implemented Informatica transformations like joiner, aggregator, Connected and Unconnected lookups, Router, Update Strategy, Expression etc
  • Developed and enhanced complex Informatica mappings, sessions, workflows with optimization
  • Managed team and assign tasks, review/validate code and help them to fix the critical issues in testing and development
  • Provided solutions to production failures and ETL/DB performance enhancement
  • Worked as a delivery coordinator for preparing the project timeline plan
  • Trained the business users on understanding the ETL process to support their own applications, shared the knowledge to resolve data issues
  • Interacted with business, cross functional team on day to day basis for critical timeline requirements and any system issues
  • Prepared technical specifications and resolution documents for job monitoring and issue resolving across all the environments

Education

Bachelor of Technology - Computer Science and Engineering

Techno India Saltlake(TISL)
06.2015

High School - Science

Haryana Vidya Mandir
04.2011

High School - Science

Haryana Vidya Mandir
04.2009

Skills

  • Informatica Intelligent Cloud Services(IICS)
  • Informatica PowerCenter 961
  • MS SQL Server
  • Oracle 10g
  • Snowflake

Awards

  • On The Spot Award, 01/01/21
  • Above and Beyond Award, 11/01/22

Certification

  • Microsoft Certified, Azure Data Fundamentals - Microsoft.

Timeline

Technical Lead

Bahwan Cybertek
08.2024 - Current

Senior Associate

PwC India
09.2021 - 08.2024

Information Technology Analyst(ITA)

Tata Consultancy Services
06.2015 - 09.2021

High School - Science

Haryana Vidya Mandir

High School - Science

Haryana Vidya Mandir

Bachelor of Technology - Computer Science and Engineering

Techno India Saltlake(TISL)
Krishnendu Bose