Summary
Overview
Work History
Education
Skills
Certification
Languages
Timeline
Generic

Prasad Joshi

Pune

Summary

Dynamic Data Engineering Lead with extensive experience at Cognizant Technology Solutions, specializing in Snowflake, Databricks and cloud services. Proven track record in optimizing ETL processes and leading cross-functional teams. Adept at project management and fostering stakeholder relationships, driving successful data solutions that enhance business growth and operational efficiency.

Overview

15
15
years of professional experience
1
1
Certification

Work History

Data Engineering Lead

Cognizant Technology Solutions (Client - Novartis)
Pune
05.2024 - Current
  • Developed and maintained ETL processes with Databricks and Snowflake for enhanced data processing reliability.
  • Designed scalable solutions for large datasets within cloud environments to support business growth.
  • Conducted troubleshooting sessions to identify root causes of issues in data processing pipelines.
  • Documented standards, guidelines, and best practices for data engineering operations to ensure consistency.
  • Built large-scale distributed systems for transforming, storing, cleaning, and validating diverse datasets.
  • Created automated tests for validating changes to existing ETL jobs prior to production deployment.
  • Reviewed code from team members to uphold quality standards across projects.
  • Led data engineering projects focused on optimizing data pipelines and workflows.

Data Engineer

Cognizant (Client - Tele2)
Stockholm
09.2023 - 04.2024
  • Designed and developed data models and warehouses using Snowflake.
  • Created and maintained database objects, including tables, views, and stored procedures.
  • Optimized ETL processes for efficient data loading into Snowflake.
  • Implemented data flows in Apache NiFi to extract data from EDW server and Oracle DB.
  • Developed data pipelines in Airflow to facilitate data transfers to Snowflake.
  • Crafted stored procedures and UDFs in Snowflake for seamless data transformations.
  • Collaborated with stakeholders to gather requirements and devise data solutions.
  • Monitored daily data loads and resolved data quality issues.

ETL Test Automation Lead

Cognizant (Client - Deutsche Telekom)
Bonn
06.2016 - 08.2023
  • Implemented end-to-end ETL test automation framework across multiple data warehouses within BI landscape.
  • Led multisite team of ETL and test automation engineers from offshore and onsite in Germany.
  • Conducted discussions, demos, and show-and-tell sessions with customers and subject matter experts.
  • Gathered functional requirements and translated them into business scenarios and test cases.
  • Designed comprehensive ETL testing strategy for on-premise to cloud DWH migration using Snowflake on AWS.
  • Developed initial data integration and validation pipelines in GitLab and Jenkins, facilitating DevOps journey.
  • Architected overall test automation framework for both on-premise and cloud DWH solutions.

ETL Test Lead

Cognizant (Client - Deutsche Telekom)
Pune
06.2014 - 06.2016
  • Conducted requirement gathering based on functional specifications to inform test planning.
  • Estimated testing efforts and identified test scenarios from specifications.
  • Logged and executed test cases in JIRA to track progress.
  • Prepared and analyzed test data for comprehensive validation.
  • Executed Informatica workflows, UNIX shell scripts, and stored procedures.
  • Validated business rules applied to test data to ensure accuracy.
  • Debugged code failures to enhance software reliability.
  • Developed test completion and defect reports while reporting status to clients daily and weekly.

ETL Test Lead

Infosys (Client - HSBC)
Pune
11.2013 - 06.2014
  • Preparation of automated SQL test scripts using design specs and mapping rule documents
  • Execute SQL Scripts
  • Debug the code/failures
  • Report testing included exception and reconciliation reports, primary key, null not null data validation & business testing
  • Test case and test data Preparation
  • Logging defects in QC
  • Used RTC for tracking issues/defects, requirements
  • Work in coordination with BA's & Dev Team to understand, fetch & test data correctly
  • Prepared overall test approach & test case documents

Sr ETL Test Engineer

Tech Mahindra (Client- British Telecom)
Pune
06.2010 - 11.2013
  • Executed ODI jobs and stored procedures efficiently.
  • Validated transformation rules on extracted data for accuracy.
  • Debugged code and addressed failures during migration process.
  • Reviewed generated load files according to transformation rules prior to loading.
  • Executed UNIX shell scripts to automate processes.
  • Participated in program and design calls with designers to ensure alignment.
  • Identified test scenarios based on specifications for comprehensive coverage.
  • Prepared and analyzed test data to support testing phases.

Education

B.E. - ELECTRONICS & TELECOMMUNICATIONS

SGBAU Amravati University
Yavatmal
01.2009

Skills

  • SQL and Snowflake
  • PySpark and Databricks
  • Data orchestration with Airflow
  • Apache NiFi integration
  • Python programming
  • Cloud services: AWS, Azure, and GCP
  • Version control with Bitbucket
  • Test automation with Robot Framework and TOSCA DI
  • Unix operating system
  • Data migration and warehousing
  • Testing methodologies
  • Project management and estimation techniques
  • Customer relationship management

Certification

  • Snowflake SnoPro Core
  • Azure Data Engineer - Associate
  • AWS Certified Solutions Architect - Associate

Languages

Marathi
First Language
English
Advanced (C1)
C1
German
Elementary (A2)
A2

Timeline

Data Engineering Lead

Cognizant Technology Solutions (Client - Novartis)
05.2024 - Current

Data Engineer

Cognizant (Client - Tele2)
09.2023 - 04.2024

ETL Test Automation Lead

Cognizant (Client - Deutsche Telekom)
06.2016 - 08.2023

ETL Test Lead

Cognizant (Client - Deutsche Telekom)
06.2014 - 06.2016

ETL Test Lead

Infosys (Client - HSBC)
11.2013 - 06.2014

Sr ETL Test Engineer

Tech Mahindra (Client- British Telecom)
06.2010 - 11.2013

B.E. - ELECTRONICS & TELECOMMUNICATIONS

SGBAU Amravati University

Similar Profiles

CREATE PROFILE
Prasad Joshi