Summary
Overview
Work History
Education
Skills
Websites
Languages
Timeline
Generic

Saikat Kanjilal

Kolkata

Summary

Dynamic Technical Lead with strengths in ETL Development and Data Integration. Delivers robust data solutions that enhance operational efficiency and drive informed decision-making. Cultivates high-performing teams through strategic leadership and agile methodologies.

Overview

10
10
years of professional experience

Work History

Technical Lead

Cognizant Technology Solutions
Kolkata
11.2025 - Current

Project: Legacy to Cloud Data Migration & Modernization.

Client: A leading US-based banking and financial services organization.

Description:

Led the migration and modernization of critical banking data from legacy systems to a cloud-native data platform using Informatica Intelligent Data Management Cloud (IDMC) and Snowflake.

Key Responsibilities & Contributions:

  • Served as Technical Lead, driving end-to-end migration strategy, solution design, and implementation.
  • Designed and developed robust ETL/ELT pipelines using IDMC for ingesting and transforming large-scale banking datasets into Snowflake.
  • Implemented optimized data models in Snowflake (staging, core, and presentation layers) to support analytics and reporting use cases.
  • Ensured data integrity, reconciliation, and validation between legacy and cloud systems, minimizing data discrepancies.
  • Tuned ETL workflows and Snowflake queries to achieve performance optimization and cost efficiency.
  • Collaborated with business stakeholders, data analysts, QA teams, and DevOps for seamless delivery.
  • Managed production support, performed root cause analysis (RCA), and implemented fixes for pipeline failures.
  • Mentored team members, conducted code reviews, and ensured adherence to development standards.

Senior Associate

Cognizant Technology Solutions
Kolkata
12.2022 - 10.2025
  • Worked across multiple data integration and warehousing projects in the banking domain, delivering ETL solutions using Informatica and SQL.
  • Developed and maintained ETL workflows for data extraction, transformation, and loading from legacy systems to data warehouses.
  • Performed data analysis, mapping, and transformation logic implementation based on business requirements.
  • Ensured data quality, validation, and reconciliation during data processing.
  • Optimized existing ETL jobs to improve performance and reduce execution time.
  • Provided production support, incident resolution, and root cause analysis (RCA).

Senior Software Engineer

Legato Health Technologies
Hyderabad
04.2022 - 11.2022
  • Worked on data integration and ETL development projects using Informatica and SQL.
  • Assisted in development and maintenance of ETL workflows for data extraction, transformation, and loading.
  • Performed data validation, basic transformations, and unit testing of ETL jobs.

Software Engineer

Legato Health Technologies
Hyderabad
09.2019 - 03.2022
  • Supported senior team members in requirement analysis and issue resolution.
  • Gained hands-on experience in data warehousing concepts, SQL querying, and production support activities.

Programmer Analyst

Cognizant Technology Solutions
Kolkata
04.2017 - 09.2019
  • Assisted in unit testing, debugging, and issue resolution for ETL processes.
  • Developed basic ETL workflows, performed data transformations, and supported data loading activities.

Programmer Analyst Trainee

Cognizant Technology Solutions
Kolkata
05.2016 - 04.2017
  • Started career working on data integration and ETL development using Informatica and SQL.
  • Gained foundational knowledge of data warehousing concepts and production support processes.

Education

Bachelor of Engineering - Electrical and Electronics Engineering

Regent Education and Research Foundation
Kolkata, WB
01-2023

Skills

  • ETL Development: Extensive experience creating ETL workflows using Informatica PowerCentre and IICS
  • Data Cleansing/Quality: Familiar with Informatica Data Quality (IDQ) for data cleansing, and data rules as per client requirements
  • Data Modelling: Familiar with data modelling concepts and SDLC model
  • Snowflake architecture
  • Technical leadership
  • Agile methodologies
  • Team performance management
  • People management

Languages

English
Proficient
C2
Hindi
Proficient
C2
Bengali
Proficient
C2

Timeline

Technical Lead

Cognizant Technology Solutions
11.2025 - Current

Senior Associate

Cognizant Technology Solutions
12.2022 - 10.2025

Senior Software Engineer

Legato Health Technologies
04.2022 - 11.2022

Software Engineer

Legato Health Technologies
09.2019 - 03.2022

Programmer Analyst

Cognizant Technology Solutions
04.2017 - 09.2019

Programmer Analyst Trainee

Cognizant Technology Solutions
05.2016 - 04.2017

Bachelor of Engineering - Electrical and Electronics Engineering

Regent Education and Research Foundation
Saikat Kanjilal