Saikat Kanjilal

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.

• 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).

• 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.

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

• Assisted in unit testing, debugging, and issue resolution for ETL processes.
• Developed basic ETL workflows, performed data transformations, and supported data loading activities.

• Started career working on data integration and ETL development using Informatica and SQL.
• Gained foundational knowledge of data warehousing concepts and production support processes.