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