Pratik Ojha
Data Engineer
Bengaluru
Summary
Results-driven Azure Data Engineer with a strong background at Accenture, specializing in ETL development and data pipeline design. Proven ability to enhance data integrity and optimize performance, leveraging skills in RDBMS and collaboration. Adept at delivering high-quality solutions while maintaining a focus on continuous improvement and automation.
Overview
4
4
years of professional experience
2
2
Languages
Work History
Azure Data Engineer
Accenture
08.2023 - Current
- Have a Good understanding about spark architecture including spark core, spark SQL and spark components.
- Collaborate on ETL (Extract, Transform, Load) tasks, maintaining data integrity through Data Factory.
- Deliver data quality following Software Development Life Cycle(SDLC)
- Provide On-call support for prod critical issues.
Data Engineer
Accenture
04.2022 - 07.2023
- Optimized data processing by implementing efficient ETL pipelines .
- Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity .
- Have followed Agile Methodology - SCRUM and deliver quality work following software development cycle.
- .Fine-tuned query performance and optimized database structures for faster, more accurate data retrieval and reporting.
Data Engineer Intern
Accenture
11.2021 - 03.2022
- Increased automation in reporting processes by designing dynamic dashboards using visualization tools like Tableau .
- Worked on efficient runtime for a query using SQL window functions.
- Basic understanding about Spark concepts
- Worked on managed and external table using Hive.
Education
Bachelor of Engineering in Information Science -
Dr. Ambedkar Institute Of Techonology
Bengaluru, India 04.2001 -
Skills
ETL development
Projects
Designed and Implemented Data Pipeline using Azure PaaS:
- Created pipeline using ADF architecture(linked services, datasets and activities) and worked on data flows.
- Design and develop Shopping spark application using spark and Spark SQL for data transformation and aggregation for different file formats.
- Improved runtime efficient by using concepts of broadcast and accumulators.
- Develop a banking spark application using pivot concept.
Worked on design changes for existing datastage jobs and linux scipts
- Utilised the Transformer and join processing stages to make data accurate visible in a dataset using IBM Infosphere Datastage.
- Worked with different processing stages to improve process efficiency.
- Implemented scripts for converting file permissons automatically and send a reminder about spaces if it reaches threshold value.
Awards
FY23 Ace Award, Accenture : Received award for superlative performance in context of managing physical events.
FY23 Pinnacle Award, Accenture : Received award for delivering depolyment on time and automating some jobs for batch processing
Timeline
Azure Data Engineer
Accenture
08.2023 - Current
Data Engineer
Accenture
04.2022 - 07.2023
Data Engineer Intern
Accenture
11.2021 - 03.2022
Bachelor of Engineering in Information Science -
Dr. Ambedkar Institute Of Techonology
04.2001 -
Similar Profiles
Amanjot Kaur LambaAmanjot Kaur Lamba
Workday Integration Consultant at AccentureWorkday Integration Consultant at Accenture
Sumit PatilSumit Patil
SAP Security and GRC Consultant at AccentureSAP Security and GRC Consultant at Accenture
Sajal BhardwajSajal Bhardwaj
People Advisor Analyst, HRBP at AccenturePeople Advisor Analyst, HRBP at Accenture
Priyanka GhoshPriyanka Ghosh
Instructional Design Analyst at AccentureInstructional Design Analyst at Accenture
Ayushi SharmaAyushi Sharma
Emerging Architect at Shell India Markets Pvt LtdEmerging Architect at Shell India Markets Pvt Ltd