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
2025.11 - 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
2022.12 - 2025.10
  • 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
2022.04 - 2022.11
  • 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
2019.09 - 2022.03
  • 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
2017.04 - 2019.09
  • 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
2016.05 - 2017.04
  • 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
2023-01

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
2025.11 - Current

Senior Associate

Cognizant Technology Solutions
2022.12 - 2025.10

Senior Software Engineer

Legato Health Technologies
2022.04 - 2022.11

Software Engineer

Legato Health Technologies
2019.09 - 2022.03

Programmer Analyst

Cognizant Technology Solutions
2017.04 - 2019.09

Programmer Analyst Trainee

Cognizant Technology Solutions
2016.05 - 2017.04

Bachelor of Engineering - Electrical and Electronics Engineering

Regent Education and Research Foundation
Saikat Kanjilal