Abinitio
Prasad Patki
Pune
Summary
I have been associated in a project where we are handling Bank Ops Data. We are supporting to build/maintain any new/existing pipeline, or process that needs to be brought into Snowflake (Data Warehouse) from various Sources (Finacle, Mainframe, etc.) to generate Control/Operational Reports for business to take data-driven decisions.
Overview
3
3
years of professional experience
Work History
Associate Consultant
Capgemini
04.2022 - Current
- Develop and implement scalable data pipelines using Ab Initio (On Prem/Cloud), Snowflake, and Teradata.
- Leverage expertise in Ab Initio GDE components such as Partitioning, De-Partitioning, Datasets, ICFF Components, and Conduct>It to optimize data workflows.
- Utilize PDL, meta-programming, and generic graphs to streamline data processing.
- Work with data from multiple sources, including Oracle, Teradata, Snowflake, Postgres, flat files, JSON, COBOL, and EBCDIC files.
- Automate and optimize Ab Initio processes, implementing improvements for enhanced performance.
- Create Custom Views, Secure Views, and Volatile Tables in Snowflake, with the ability to parse JSON data and use time-travel functionality.
- Maintain and troubleshoot cloud-based data pipelines using AWS EMR, AWS Lambda, AWS CloudWatch, and HashiCorp Vault.
- Use Scala-Spark for cloud reporting pipeline maintenance, and manage source control with GitHub and CI/CD pipelines with Jenkins.
- Create Maestro Job/Stream to automate Ab-Initio jobs.
- Lead and mentor a team of data engineers, providing technical assistance and guiding best practices.
- Collaborate with cross-functional teams to ensure successful project delivery, including creating Source-to-Target documents for DDL creation.
- Implement tuning and debugging strategies for optimal application performance.
Education
Bachelor of Engineering - Computer Engineering
Sinhgad Institue of Technology
Pune, India08.2021
Skills
- Ab Initio
- Snowflake
- Teradata
- Shell Scripting
- Data Warehousing
- Jenkins
- GitHub
- Data Quality
- Data Pipeline
- Agile Methodology
- Problem Resolution
- Decision Making
Accomplishments
1. **Best Performer (2022-2023)**
Recognized for consistently meeting expectations and contributing to team success in key projects.
2. **Pat on the Back**
Awarded for proactive involvement and teamwork, helping drive the success of important initiatives.
3. **Customer Delight**
Honored for delivering excellent support, leading to positive feedback from customers and team members.
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Work Preference
Work Type
Full TimeLocation Preference
On-SiteRemoteHybridImportant To Me
Work-life balanceCareer advancementFlexible work hoursWork from home optionSoftware
Snowflake
Languages
English
Bilingual or Proficient (C2)
Timeline
Associate Consultant
Capgemini
04.2022 - Current
Bachelor of Engineering - Computer Engineering
Sinhgad Institue of Technology