Karthik Deivasigamani
Summary
Senior Data Engineer with more than 10 years of experience in Data Engineering for FMCG Industry. Effective collaborator promoting great problem-solving skills with proven history of efficiency and reliability.
- Successfully managed multiple high-priority tasks simultaneously while maintaining strict deadlines ensuring optimal resource allocation.
- Designed and developed data pipelines, data warehouses and data marts to integrate new data sets from different sources into a data platform
- Collaborated closely with senior management on strategic planning efforts, aligning departmental goals with overarching company objectives.
- Proactively identified areas for improvement, implementing solutions that led to significant cost savings.
- Avid problem solver with keen ability to resolve technical issues, provide solutions for challenging situations and system enhancements.
- Mentored junior team members, contributing to their professional growth and skill development.
- Hands-on experience in Data Lake and Data Integration tools for data warehousing.
- Led a team of 5 members and delivered the modules on time.
Overview
10
10
years of professional experience
4
4
Certification
4
4
years of post-secondary education
Work History
Architect – Data Engineering
PepsiCo Global Business Services India LLP
Nov.2023 - Current
- Collaborated closely with senior management on strategic planning efforts, aligning departmental goals with overarching company objectives.
- Trained 12 newly hired employees within organization and helped with onboarding process.
- Initiated process improvements based on thorough analysis of internal operations data resulting in enhanced productivity levels.
- Conducted thorough root-cause analysis on complex data issues, proposing practical solutions that align with business objectives.
- Reviewed project requests describing database user needs to estimate time and cost required to accomplish projects.
- Participated in strategic planning sessions with stakeholders to assess business needs related to data engineering initiatives.
- Reengineered existing data pipelines to improve performance by identifying bottlenecks and optimizing code accordingly.
Senior Analyst - Data Fabric ETL Developer
PepsiCo Global Business Services India LLP
09.2019 - 10.2023
- Optimized workflow processes to reduce bottlenecks and increase overall effectiveness.
- Established strong relationships with key stakeholders, fostering collaboration and mutual support.
- Designed and developed data ingestion pipelines from on-premises to different layers into ADLS using Azure Data Factory
- Mentored team on standards and processes involved in project.
- Developed reusable data pipelines and reduced the efforts involved.
- Developed custom scripts to automate routine data integration tasks, increasing productivity and reducing manual effort.
- Collaborated with cross-functional teams to identify areas of improvement, leading to increased operational effectiveness.
- Prepared and maintained inventories out of Informatica, Control-M that provides information on end-to-end dataflow.
- Recommended process improvements to continually identify, analyze and fix constraints and challenges.
Senior Business Intelligence Analyst
NTT DATA Services
07.2019 - 09.2019
- Improved collaboration between IT and business stakeholders by serving as a liaison, ensuring seamless communication and alignment of objectives.
- Provided L2 & L3 Support and implemented new changes to the DWH, accompanied by appropriate support documents.
- Interacting with clients on regular basis to discuss day-to-day issues and solutions.
- Involved in data analysis and handling ad-hoc requests by interacting with Users.
- Resolving critical production issues on time with zero escalation.
Data Integration Engineer
Cognizant Technology Solutions
11.2013 - 07.2019
- Develop Informatica Workflows and Teradata BTEQ scripts based on requirement to load tables across different layers.
- Performance tune ETL mappings and Teradata BTEQ scripts.
- Scheduling of jobs in Control-M.
- Migration of BTEQ scripts, Database objects and Schedules across environments.
- Supported UAT and fixed the bugs.
- Production migration of code and hyper care support.
Education
B.Tech - Information Technology
Valliammai Engineering College
Kattankulathur, India Sep.2009 - Apr.2013
Skills
- Data Integration: Informatica Power Center version 104
- Data Lake Technologies: Azure Data Factory, Azure Databricks, ADLS, PySpark
- Databases: Teradata 1720, Oracle, SQL Server
- Scheduling Tools: Control-M, Autosys r113
- Programming Languages: Python, Shell Scripting
- Versioning Tools: Azure DevOps Repos, Star Team
Accomplishments
- Collaborated with team of 20 and coordinated the tasks from offshore and delivered to the Leadership.
- Responsible for maintaining inventories that provided end-to-end data flow.
- Delivered a complex Manufacturing Excellence application within a tight timeline of 6 months with less than 8% UAT issues
- Maintained the DevOps Boards for the project and tracked the progress of the team
- Created multiple shell scripts that helped in automating the data load, data load status and track the issues during data load, etc.
Certification
- Microsoft Certified: Azure Data Engineer Associate (DP-203)
- Microsoft Certified: Azure Data Fundamentals (DP-900)
- Microsoft Certified: Azure Fundamentals (AZ-900)
- Teradata Vantage Certified Associate
Timeline
Architect – Data Engineering
PepsiCo Global Business Services India LLP
Nov.2023 - Current
Senior Analyst - Data Fabric ETL Developer
PepsiCo Global Business Services India LLP
09.2019 - 10.2023
Senior Business Intelligence Analyst
NTT DATA Services
07.2019 - 09.2019
Data Integration Engineer
Cognizant Technology Solutions
11.2013 - 07.2019
B.Tech - Information Technology
Valliammai Engineering College
Sep.2009 - Apr.2013
Similar Profiles
Soumya BastiaSoumya Bastia
Manager-Talent Acquisition (India and AMESA Business) at PepsiCo Global Business Services India LLPManager-Talent Acquisition (India and AMESA Business) at PepsiCo Global Business Services India LLP
Rakshith BhatRakshith Bhat
Manager - HR Transformation Projects at PepsiCo Global Business Services India LLPManager - HR Transformation Projects at PepsiCo Global Business Services India LLP
Satya Sai Pavan TummalaSatya Sai Pavan Tummala
Assistant Manager Sales at PepsiCo Global Business Services India LLPAssistant Manager Sales at PepsiCo Global Business Services India LLP
Animesh NishantAnimesh Nishant
Finance Senior Coodinator at PepsiCo Global Business Services India LLPFinance Senior Coodinator at PepsiCo Global Business Services India LLP
DINESH BHATTDINESH BHATT
Senior Specialist/Data Architect-Data Engineering at LTISenior Specialist/Data Architect-Data Engineering at LTI