Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Timeline
Generic

Pranjal Borhade

Pune

Summary

Results-driven ETL Developer with a proven track record at Teradata India Pvt Ltd, enhancing project efficiency and system performance through expert SQL optimization and effective cross-functional collaboration. Spearheaded data migration initiatives, achieving significant improvements in data integrity and processing speed, while fostering a culture of continuous learning and innovation.

Overview

6
6
years of professional experience
1
1
Certification

Work History

ETL Developer

Teradata India Pvt Ltd
Navi Mumbai
01.2021 - Current
  • Collaborated with cross-functional teams to analyze business requirements and translate them into technical solutions, yielding a 10% increase in project efficiency.
  • Utilized Teradata utilities such as TPT, FastLoad, MultiLoad, TPump, and FastExport to optimize data processing, leading to a 25% reduction in processing time.
  • Spearheaded the design and implementation of Teradata database objects, ensuring efficient data storage and retrieval through tables, views, and functions.
  • Designed and carried out superior practices for Teradata DBMS and development, driving a 15% increase in team productivity.
  • Conducted performance tuning activities to enhance ETL processing time, resulting in a remarkable 50% improvement in overall system performance.
  • Engineered a series of potent transformations, including Router, Joiner, Expression, Lookup, Sequence generator, and Normalizer, to optimize data workflows and elevate processing efficiency by 30%.
  • Configured and optimized Informatica Cloud connectors, yielding a 20% improvement in data extraction and loading speed.
  • Applied SCD Type 2 mapping and parameterized mappings, enhancing reusability and scalability by 40%.
  • Executed thorough unit testing and integration testing for Informatica Cloud components, ensuring a 99% success rate in deployment.
  • Monitored and optimized Teradata system performance using Teradata Viewpoint for real-time insights and attained 30% improvement in query performance by crafting and refining Teradata SQL queries, stored procedures, and macros.

Application Operations II

Teradata India Pvt Ltd
Navi Mumbai
02.2020 - 12.2020
  • Supervised and managed ETL jobs and workflows, guaranteeing 99% data integrity and accuracy.
  • Promptly resolved data extraction, transformation, and loading issues, achieving a 20% reduction in resolution time.
  • Implemented workload management strategies using Teradata Active System Management (TASM), prioritizing critical queries and improving resource allocation for enhanced system efficiency and throughput.

ETL Developer

Teradata India Pvt Ltd
Navi Mumbai
01.2019 - 01.2020
  • Participated in end-to-end data migration project, converting legacy ETL processes from Teradata to Informatica PowerCenter.
  • Designed and developed scalable ETL workflows and mappings to support the seamless transition of large datasets.
  • Analysed existing Teradata scripts and logic to map transformation rules and implement them in Informatica.
  • Collaborated with data architects, QA teams and business analysts to ensure data integrity, performance optimization, and successful cutover.
  • Conducted unit testing, performance tuning, and assisted in resolving data quality issues post migration.

Education

Bachelor of Engineering - Information Technology

Mumbai University
Ramrao Adik Institute Of Technology
06-2018

Diploma - Information Technology

Mumbai University
Bharati Vidyapeeth Institute Of Technology
05.2015

Skills

  • Data engineering
  • Data migration
  • SQL optimization
  • Workload management
  • Analytical thinking
  • Problem solving
  • Data quality
  • Teradata utilities
  • ETL development
  • Performance tuning
  • Informatica Cloud
  • Data integration
  • Cross-functional collaboration
  • Team collaboration
  • Effective communication
  • ETL modeling
  • Data warehousing management
  • Error handling
  • Database design
  • Informatica Development
  • Teradata database management
  • Agile Methodologies
  • Batch processing
  • Data integration
  • Data warehousing
  • Version control (Git)
  • Scripting languages
  • SQL development
  • Data modeling
  • Data cleansing
  • Data mapping
  • Teradata
  • Informatica IICS & PowerCenter
  • JAMS Scheduler
  • JIRA
  • Tableau
  • Jenkins
  • Control-M
  • SQL
  • Python

Accomplishments

  • GDC Spot Award 2024
  • GDC Spot Award 2023
  • 2022 GDC India Champion of the Year Award
  • Employee of the quarter 2020

Certification

  • Teradata Vantage Certified Developer
  • Teradata Vantage Certified Professional
  • Teradata Vantage Cloudlake Associate Certified
  • Teradata Vantage 2.3 Associate Certified
  • Teradata Vantage Administration Certified

Timeline

ETL Developer

Teradata India Pvt Ltd
01.2021 - Current

Application Operations II

Teradata India Pvt Ltd
02.2020 - 12.2020

ETL Developer

Teradata India Pvt Ltd
01.2019 - 01.2020

Bachelor of Engineering - Information Technology

Mumbai University

Diploma - Information Technology

Mumbai University

Similar Profiles

CREATE PROFILE
Pranjal Borhade