Ranjabati Roy
Kolkata
Summary
Skilled IT professional with 4 years of a hands-on developer/designer experience as well as experience working with industry’s popular Data Quality and IICS services. Skilled in IPC, SQL and Unix Shell Scripting, with a solid background in designing and optimizing data integration and ETL processes. Experienced in developing dashboards to monitor SLAs and KPIs, ensuring accurate data and stable system performance. Seeking to contribute technical expertise and analytical skills to support effective and reliable business solutions.
Overview
4
4
years of professional experience
Work History
Associate, Data Integration Specialist
Cognizant Technology Solutions
11.2021 - Current
- Designed, developed, and maintained Informatica cloud data integration processes using the appropriate data load technique, including Push-Down Optimization for performance optimization.
- Developed and implemented complex SQL scripts for the creation and management of database tables, incorporating pre-SQL and post-SQL queries to optimize data processing.
- Developed and managed ETL workflows and data mappings, utilizing Informatica Intelligent Cloud Services (IICS) and Informatica PowerCenter (IPC), to ensure seamless data integration across multiple environments.
- Collaborated with IT Quality Assurance (QA) teams to create UAT test plans, design test cases, and manage the testing project schedule.
- Analyzed data warehouse architecture, normalized/de-normalized, star schemas and snowflakes, slowly changing dimensions, dimensional surrogate key handling, exception data processing, troubleshooting, and recommending improvements and alternative methodologies.
Education
B.Tech - Electrical Engineering
RCC Institute of Information Technology
Kolkata07-2021
Higher Secondary Certificate -
South Point High School
KolkataSkills
- ETL tools
- Informatica Intelligent Cloud Services (IICS)
- Informatica PowerCenter (IPC)
- SQL
- Basics of Unix shell scripting
- Data tools
- Microsoft Excel
- CyberArk
- WinSCP
- Soft skills
- Problem solving
- Analytical thinking
- Effective communicator
- Project management
Languages
- English
- Bengali
- Hindi
Personal Information
Date of Birth: 11/26/96
Disclaimer
I hereby affirm that the information provided above is accurate and true to the best of my knowledge and belief.
Ranjabati Roy
Timeline
Associate, Data Integration Specialist
Cognizant Technology Solutions
11.2021 - Current
B.Tech - Electrical Engineering
RCC Institute of Information Technology
Higher Secondary Certificate -
South Point High School