Open To Work
Debadyuti Sardar
Cognizant Worldwide
Edinburgh
4
Certification
18
Years of experience
Experienced Senior Data Engineer with 18 years of expertise designing, developing and supporting enterprise-scale cloud data platforms across the Banking and Insurance sectors. Proven experience delivering scalable ETL/ELT pipelines, modern data platforms and cloud migration solutions using Azure Data Factory, Azure Databricks, PySpark, Delta Lake, Azure DevOps and SQL. Recently expanded expertise through Snowflake University Hands-On Essentials (Data Engineering & Data Science) and Microsoft Learn Power Apps & Dataverse, strengthening capabilities in Snowflake Cortex AI, Cortex Analyst, Secure Data Sharing, RBAC and enterprise application integration. Strong background in Agile delivery, DevOps, stakeholder management and production support.
Work History
5 Years
07.2021 - Current
5 Years
Manager (Senior Data Engineer)
Cognizant Worldwide | United Kingdom
07.2021 - Current
- Working for UK's Leading Specialist Insurer of Commercial and Personal risks, Hiscox Plc.
- Migrated codebase and application, building CI/CD deployment process from Bitbucket and Bamboo to Azure DevOps, enhancing deployment efficiency.
- Used Blob Storage to download ARM Template and overridden environment specific parameters.
- Experience with designing, building, and operating analytics solutions using Azure functionality.
- Resources include SQL Database, Azure Data Factory, Storage Account (Data Lake / Delta Lake), SQL Data Warehouse (Dedicated SQL Pool).
- Developed high performant Azure Data Factory Pipelines.
- Working on Delta Lake, Delta tables in Azure Databricks, using PySpark, PySQL in Databricks to create python notebooks
- Familiar with Databricks Spark Streaming processing using Cloudfiles, Auto Loader, Spark Jobs using Databricks Pipeline
- Processing Change Date Capture with Delta Live tables
- Managed data governance in Azure Databricks.
- Worked flexible hours across various shifts to meet business needs. across night, weekend, and holiday shifts.
- Demonstrated respect and friendliness while assisting team members.
- Quickly learned and adapted to new technology and software applications. Quickly learned and adapted to new technology and software applications.
- Demonstrated leadership skills in managing projects from concept to completion.
- Led design and implementation, engaging with business stakeholders to translate complex requirements into scalable data solutions that meet business needs.
- Resolved operational problems to enhance efficiency and service delivery., improved operations and provided exceptional service.
- Used GitHub for Code management and support various application production release
- Developed Azure Data Fix pipelines to correct production data, ensuring data integrity after code fixes.
2 Years 5 Months
01.2019 - 06.2021
2 Years 5 Months
Senior System Analyst
Cognizant Worldwide | Edinburgh, United Kingdom
01.2019 - 06.2021
- Worked for UK's Largest Mutual Insurer, Royal London Pension & Insurance
- Understand existing client's application process, related to Schemes, Schemes related investments and personal pension investments from SMEs
- Interaction with Development Lead, SMEs and Business Analysts on daily basis
- Gathering Business requirement for validating policy and build transformation logic
- Gathering Business requirement for extract master investment/Individual funds data, Policy level investment extract data and build transformation logic
- Analyze Schemes and investment data as well as policy level data and decide how legacy data can fit into new investment control system as per the new data model
- Perform data volume analysis which will help business to make delivery decisions
- Preparing High Level & Low Level Technical Design Document, ETL process document, Data Reconciliation process document
- Writing PL/SQL Package & Procedure to implement policy validation process, data extract process and the data reconciliations process
- Writing Oracle SQL queries to extract master Schemes, investments and individual funds data as well as policy level investment data using business transformation rules
- Making validation, extract and reconciliation process configurable and dynamic using metadata
- Developing reconciliations dashboard and Migration stages dashboard using
- SQL and Excel to present the ETL situation for taking business decisions
- Preparing unit test case document and unit testing
- Perform performance testing and performance tuning for long running queries using explain plan, AWR reports (supplied by DBA), creating necessary index or dropping unnecessary index or force index whenever required if not using by optimizer
- Deliver the data extract as per the investment control system data model
- Sharing knowledge to the juniors/testers if they have any gap in application/ process understanding
- Check-in codes into server using version control tool.
3 Months
10.2018 - 01.2019
3 Months
Senior System Analyst
Cognizant Worldwide | London, United Kingdom
10.2018 - 01.2019
- Worked for UK's Largest Airline, British Airways
- Responsible for Cost Estimation & resource loading for the implementation based on initial project scope and assumption
- Interacted with IT stakeholders as well as Business stakeholders on daily basis
- Gathered required Business Logic for new allowance from the Business
- Responsible for impact analysis of the existing application to integrate new allowance
- Prepared High Level & Low Level Technical Design Document
- Presented Technical Design Overview to the stakeholders
- Mentoring and providing technical guidance along with business understanding of the project to the new on boarders to facilitate the smooth absorption of the application process and in development of the new allowance
- Writing PL/SQL Package & Procedure to implement the new allowance and make necessary changes to the impacted areas
- Conducting UAT and provide UAT support
- Responsible for preparing Live Implementation Plan.
7 Years
09.2011 - 09.2018
7 Years
Technical Consultant
Cognizant Technologies Solutions | Kolkata, India
09.2011 - 09.2018
- Responsible for creating complex conversion scripts for Extraction
- Transformation and Loading data using PL/SQL for various clients as well as tuning complex PLSQL programs for multiple reputed clients
- Created and developed complex SQL queries and PL/SQL procedures, functions, packages and database triggers
- Performed extensive performance tuning of SQL and PL/SQL scripts
- Created Explain Plan and used Index Hints to tune SQL and PL/SQL Scripts to improve performance
- Designed, Analyzed, Extracted, Transformed and loaded data into Oracle
- Tables using PL/SQL Conversion Scripts for implementing Oracle Data Warehouse from different sources to Oracle tables
- Writing PLSQL codes to facilitate business functions and calculations
- Designed and developed complex Forms and Reports
- Created various control scripts and loaded data into Oracle database from excel using SQL Loader
- Got exposure to work on Informatica & Syncsort ETL tool
- Extensively involved in diagnostics, troubleshooting, analysis and resolution of support issues and defects
- As well as full system development life cycle (SDLC) of multiple Oracle Projects
- Providing Production onsite support / customization, coordinating with client
- Mentoring and providing technical guidance along with business understanding of the project to the new on boarders to facilitate the smooth absorption of the same
- Monitoring every day batch runs and fixing issues if any during the batch run
- Interacted with the UAT teams to address problems and concerns in the areas related to database
- Extensively involved in Unit testing, Integration testing and UAT testing
- Created Technical Documentation and mentored other members in the team
- Prepared and tested Unit Test Cases and documented results.
7 Months
02.2011 - 09.2011
7 Months
Database Consultant
Conacent Consulting Pvt. Ltd. | Kolkata, West Bengal, India
02.2011 - 09.2011
- India Limited & Eveready Industries India :
- Provided support & developed PL/SQL programs to enhance Payroll application process
- Meeting clients, understanding their problems and solving them
- Designed and developed complex Forms and Reports
- Extensively involved in Unit testing, Integration testing and UAT testing
- Created Technical Documentation and completed the assignments well within the time frame.
2 Years 6 Months
08.2008 - 02.2011
2 Years 6 Months
Software Developer
PROTEX COMPUTER PVT LTD | Kolkata, India
08.2008 - 02.2011
- Started working for Bharat Coaking Coal Limited as PL/SQL Developer and responsible for daily Client Interaction and Understanding the Client's Needs and Solving them immediately after a Detailed Analysis of the same by either developing or making necessary modifications in our existing codes, making necessary modifications in Procedures, Functions, Triggers (SQL, PL/SQL) to customize the Software, Developing reports on Oracle 6i Report Builder.
Education
Bachelor of Technology - BTech - Computer Science and Engineering
West Bengal University of Technology | India | 01-2008
Skills
Cloud Data Engineering
Azure Data Factory (ADF)
Azure Databricks
Snowflake
Data Warehousing
ETL / ELT
Data Lake Architecture
Delta Lake
Certification
- Databricks Certified Data Engineer Associate
- Microsoft Certified Azure Data Fundamentals
- Oracle SQL Certified Expert
- Oracle PLSQL Certified Associate
Timeline
Manager (Senior Data Engineer)
Cognizant Worldwide
07.2021 - CurrentRead more
Senior System Analyst
Cognizant Worldwide
01.2019 - 06.2021Read more
Senior System Analyst
Cognizant Worldwide
10.2018 - 01.2019Read more
Technical Consultant
Cognizant Technologies Solutions
09.2011 - 09.2018Read more
Database Consultant
Conacent Consulting Pvt. Ltd.
02.2011 - 09.2011Read more
Software Developer
PROTEX COMPUTER PVT LTD
08.2008 - 02.2011Read more
West Bengal University of Technology - Bachelor of Technology - BTech, Computer Science and Engineering
Read more
ADDITIONAL INFORMATION
- Honors-Awards Star OF The Month & Data Oscar
- Star Of The Week for several weeks in a year
Professional Development
Snowflake University – Hands-On Essentials (2026)
Badge 5 – Data Engineering Workshop
- Completed hands-on training in Snowflake data engineering, including Streams, Tasks, Pipes, MERGE operations and modern ELT workflows.
Badge 6 – Data Science Workshop
- Completed practical training covering Snowflake Cortex AI, Cortex Analyst, prompt engineering, LLM-powered analytics, forecasting and classification.
Power Apps & Microsoft Dataverse
- Completed training covering Canvas Apps, Model-driven Apps, Microsoft Dataverse and Power Platform fundamentals.
TRAINING
- Data Engineering using Databricks on AWS & Azure in Udemy.com
- Azure Data Factory | Data Engineering on Azure & Fabric in Udemy.com