Prakhar Tayal Email and Phone Number
Professionally, I am a seasoned Data Engineer with a strong foundation in designing and implementing robust data solutions. My expertise lies in the entire data lifecycle, from extracting raw data to transforming it into meaningful insights for informed decision-making. With a primary focus on SQL, I possess advanced skills in data manipulation, querying, and database management. My proficiency extends to Azure Data Pipelines, Azure Synapse, and Azure Databricks, allowing me to orchestrate seamless data workflows, optimize data warehousing, and perform advanced data transformations effectively.I have hands-on experience in designing and deploying efficient data pipelines using Azure Data Pipelines, which enables me to construct, schedule, and manage data workflows effortlessly. My expertise extends to Azure Synapse, where I architect scalable data warehousing solutions, optimizing query performance and facilitating collaborative analytics. Azure Databricks is a cornerstone of my skill set, enabling advanced data transformations using SQL or Python and streamlining the refining process for standardized, enriched data ready for consumption in Azure SQL and downstream applications.In addition to technical proficiency, I bring a client-centric approach to my work. My ability to engage in effective client interactions, understand their requirements, and communicate technical concepts in a clear and comprehensible manner has been a key factor in project success. I am dedicated to ensuring that the solutions I deliver not only meet but exceed client expectations.As a continuous learner, I actively seek opportunities to expand my skill set and stay at the forefront of advancements in data engineering. My commitment to quality, efficiency, and results-driven outcomes has been a consistent theme throughout my professional journey.In summary, my professional identity is defined by a multifaceted skill set that combines technical expertise, analytical acumen, effective communication, and a collaborative mindset. I am passionate about leveraging data to drive organizational success, and I am enthusiastic about contributing my skills and experience to meet the evolving challenges and opportunities in the realm of data engineering.Skills :Data EngineeringETL ArchitectureData Warehousing OptimizationAzure Cloud ServicesSQL and NoSQL,Big Data Processing with Azure DatabricksBig DataData Analysis and VisualizationJava
Deloitte
View- Website:
- deloitte.com
- Employees:
- 295722
-
ConsultantDeloitte Sep 2024 - PresentBengaluru, Karnataka, India
-
Technology AnalystInfosys Apr 2024 - Sep 2024Bengaluru, Karnataka, India•Orchestrated the migration from an on-premises Oracle database to Azure Synapse Analytics using Azure Data Lake Storage and Azure Databricks ,demonstrating adept Data Engineering skills.•Designed, developed, and deployed ETL solutions utilizing Microsoft Synapse and Data Factory to extract, transform, and load data from various sources to the data warehouse.•Designed and implemented a real-time data pipeline to process semi-structured data by integrating 150 million raw records from 10+ data sources using Databricks and Azure Data Factory,, showcasing Data Engineering proficiency and leveraging SQL/Python for streamlined transformations.•Actively contributed to the end-to-end design, development, and deployment of multiple enhancements and business initiatives, all while adhering to the Agile DevOps delivery process.•Led a dynamic team of 10+ professionals, fostering collaboration and empowering them to deliver excellence in Data Engineering tasks.•Played a crucial role in sprint planning, backlog grooming, and ensuring the successful creation and closure of sprints, employing Python scripts for automating repetitive tasks and enhancing team productivity.• Working with clients and solution architects closely on project requirements and providing solution to existing underlying issues. -
Senior System EngineerInfosys Oct 2022 - Jul 2024Bengaluru, Karnataka, India1. Designed and implemented a data pipeline using Azure Data Factory to process structured data by integrating raw records from various data sources. 2. Built pipelines to efficiently copy data from source to destination within Azure Data Factory.3. Engineering Spark application within Databricks notebook, utilizing PySpark and Delta Lake tables for data extraction, transformation, and aggregation across various file formats, facilitating streamlined data analysis. 4. Developed notebooks from scratch in Azure Databricks using PySpark and SQL with full/incremental load capabilities as per business requirement. 5. Strategically employed Incremental Load methodology in Azure Data Factory to seamlessly integrate new data files/records, ensuring up-to-date data processing. 6. Used Logic Apps to build custom emails which are sent on completion/failure of pipeline. 7. Collaborated with business stakeholders to understand requirements and deliver data solutions.8. Implemented CI/CD pipelines within Azure DevOps to enhance team productivity.9. Developed Triggers to automate the ETL jobs running by scheduling them.
-
System EngineerInfosys Jul 2021 - Oct 2022Bangalore Urban, Karnataka, IndiaData Engineer in a leading Australian telecommunications company (Telstra), where I played a crucial role in data warehousing projects. My responsibilities encompassed writing and optimizing complex SQL queries, managing Oracle databases, extract-transforming-loading of data , monitoring etc.•Led the ETL development for data warehousing projects, ensuring the creation of scalable and efficient data solutions.•Integrated Java Spring Boot applications with Oracle databases, optimizing data retrieval and storage processes for enhanced performance.•Wrote and optimized intricate SQL queries to extract, transform, and analyze data, ensuring streamlined and high-performance data operations.•Managed Oracle databases throughout the data lifecycle, from receiving raw data to creating and optimizing tables, guaranteeing data integrity.•Established direct connections with clients, fostering clear communication channels and gaining insights into their data needs for successful project outcomes.Analyzing the requirements to prepare Design Documents, Build, Unit Testing, Integration Testing, Deployment, Continuous Integration, Source Code version management, Production Support and Maintenance, Client Management.
-
InternInfosys Feb 2021 - May 2021Mysore, Karnataka, IndiaTrained and honed as a full-stack Java Developer. Notably, I've developed an E-commerce Flight Booking and Management application, seamlessly merging technology and user experience with the following functionalities:Customer-Focused Features:1. Developed and implemented a user-friendly authentication system allowing customers to seamlessly Login/Signup for flight booking.2. Created a dynamic interface enabling customers to view detailed flight information, including arrival/departure time, duration, and price.3. Implemented a secure booking system, allowing customers to book, cancel, and view their flight tickets effortlessly.4. Enabled customers to download boarding passes for their bookings, enhancing the travel experience.5. Implemented a feature-rich flight booking history section for customers to track their past reservations.6. Incorporated a feedback system, allowing customers to share their experiences and suggestions.Admin Management Capabilities:1. Designed an intuitive admin interface empowering administrators to efficiently add and delete flight details.2. Implemented functionality for admins to re-schedule flight details, ensuring flexibility in operations.3. Developed a system for admins to track the total number of passengers boarding for a particular flight, streamlining logistics.4. Created a feature allowing admins to view the flight order history of a specific passenger, enhancing overall management.
-
MentorProgate Jul 2020 - Dec 2020Mentoring students and helping them in clarifying there doubts, conducting competition to make the learning excitement for all. -
Data Analyst InternVerificient Technologies Apr 2020 - Oct 2020Pune, Maharashtra, IndiaThe primary responsibility of this role is to meticulously analyze and filter out violations, errors, and fraudulent activities within the recorded sessions of online exams undergoing machine learning (ML) processing. The task involves a detailed examination of online exam sessions, ensuring the detection and identification of any irregularities or breaches in the assessment process. By leveraging machine learning algorithms, the goal is to enhance the overall quality and integrity of the data generated during these examinations. The role plays a pivotal part in producing accurate and insightful data reports, contributing to the maintenance of a secure and trustworthy online examination environment. This position requires a keen eye for detail, a deep understanding of machine learning techniques, and a commitment to ensuring the highest standards of data quality and integrity in the context of online education assessments. -
Campus AmbassadorWave Jan 2020 - Feb 2020During my internship at Popshot as a Sales Intern, my primary focus was on promoting the brand and acquiring new customers through digital marketing channels. However, the role extended beyond just customer acquisition; it emphasized the critical aspect of customer retention and gathering valuable insights from them. This comprehensive approach aimed to not only bring in new customers but also to understand their needs and preferences. By actively engaging with customers, I contributed to the redesign of products and services, aligning them more closely with customer requirements. This experience honed my skills not only in sales and digital marketing but also in the strategic aspect of product and service enhancement based on customer feedback and insights. -
Actions On GoogleGoogle Developers Sep 2019 - Dec 2019VUI DevelopmentI made a QUIZ on GOOGLE ASSISTANT on general tech knowledge in two languages English and Hindi.On achieving "Global Pin", Google rewarded me with a Google T-shirt and a Google Home.
Prakhar Tayal Education Details
-
Computer Science And Engineering With Specialization In Ai&Ml -
Maharaja Agarsain Public School - IndiaSchool
Frequently Asked Questions about Prakhar Tayal
What company does Prakhar Tayal work for?
Prakhar Tayal works for Deloitte
What is Prakhar Tayal's role at the current company?
Prakhar Tayal's current role is AI & Data Engineer at Deloitte | Data Warehousing | ETL | Azure Databricks | Big Data.
What schools did Prakhar Tayal attend?
Prakhar Tayal attended Galgotias University, Udacity, Maharaja Agarsain Public School - India.
Who are Prakhar Tayal's colleagues?
Prakhar Tayal's colleagues are Nikolaos Nikoletopoulos, Ravikumar Vemula, Josefa Gallego, Yuan Hao Li, Stav Chen, Zachary Bruno, Mallory Girvin.
Not the Prakhar Tayal you were looking for?
-
-
-
Prakhar Tayal
Indore -
Prakhar Tayal
Raipur
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial