Summary
Overview
Work History
Education
Skills
Hobbies and Interests
Awards
Timeline
Generic

Jitesh Singh

Pune

Summary

Driven technology consultant with over 11 years of hands-on experience in analyzing, designing, developing, implementing, and testing data pipelines and data models for data warehousing and data integration projects. Proficient in data engineering tools like Informatica PC, Informatica Cloud (IICS), Informatica Big Data (DEI), SQL, NoSQL, and Databricks. Demonstrated expertise in data analysis, requirement analysis, and data mapping for ETL processes, conducting root cause and impact analysis. Possesses a Bachelor's degree in Computer Science with 5 years of experience as a software consultant in the telecommunications domain. Experienced in customer engagements and project management responsibilities, ensuring seamless delivery tailored to client needs.

Overview

11
11
years of professional experience

Work History

Senior Technical Specialist

ILink Digital
08.2022 - Current

Client : Banking (UAE)

  • Lead technical team in delivering complex data engineering solutions.
  • Developed and optimized complex Data pipelines using Informatica BDM/DEI, Databricks Delta Lake, and Azure Synapse, supporting scalable data architectures.
  • Successfully executed projects with SCD Type 2 implementation using Hive as a target and demonstrated proficiency in data modeling and architecture design.
  • Experience in unit testing, data quality testing, and ensured adherence to data integrity standards across multiple execution engines including Databricks, Hive, and native environments.
  • Demonstrated expertise in SQL development and data migration processes, ensuring performance standards during legacy system transitions to modern platforms such as Hive.
  • Experience in automating manual processes, increase scalability and reduce run time using Python and linux scripts.
  • Developed DLT pipelines using python and SQL in Databricks

Consultant

KPMG Global Services
02.2022 - 08.2022

Client: Travel, USA

  • Spearheaded the development of solutions and implementation strategies to address complex data integration challenges in Ivalua, as the Procurement Technical Lead for a leading USA Industrial conglomerate, by collaborating with global teams
  • Achieved Ivalua L1 Foundational certification

Senior Consultant

Deloitte Touche Tohmatsu India
06.2018 - 01.2022

Client : Telecommunication (South Africa)

  • Conducted end-to-end risk analysis and developed revenue analytic controls for fixed line technology (metro ethernet, ADSL, Fibre, Diginet) for a leading Telecommunication company in South Africa
  • Streamlined IFRS-15 implementation and performed monthly impact analysis on revenue recognition
  • Developed revenue mapping and conducted risk analysis.


Client: Electronics (Japan) :

  • Led the agile development of Data Lake and Data ingestion framework using AWS Redshift, S3, and Informatica Cloud (IICS) for a leading Electronics Giant in Japan
  • Developed complex business intelligence rules using ETL
  • Conducted detailed unit testing and produced high-quality documentation
  • Obtained hands-on experience in writing AWS Lambda code in Python
  • Conducted data quality testing to ensure data accuracy and implemented CI/CD pipelines for enhanced delivery.

Application Development Analyst

Accenture
01.2014 - 06.2018

Client: Telecommunication (Norway)

  • Implemented Business Intelligence solution including data migration and data integration for a leading telecommunication operator, including process review and standard operating procedure redesign, using Informatica Power Center and Toad/Oracle SQL
  • Led efforts to maintain data accuracy and quality through thorough analysis, aiding informed decision-making
  • Developed and improved ETL processes using Informatica PowerCenter and Oracle for efficient data handling in the warehouse
  • Collaborated with teams to translate business needs into technical plans, ensuring smooth ETL operations
  • Implemented analytical solutions for a large insurance sector by designing, developing, and implementing a central Data Warehouse system using Informatica Big Data Management, Hive, SQL Server, and Informatica IICS

Education

Bachelor of Technology - Computer Science and Engineering

Maharshi Dayanand University
Rohtak, India
07.2013

Skills

  • Informatica Cloud IICS
  • Informatica DEI/BDM
  • SQL(Oracle, MSSQL Server , Azure Synapse , Delta lake, Hive )
  • Python
  • Apache Airflow
  • Databricks
  • Data integration
  • Data warehouse
  • AWS (s3, Redshift , Lambda functions, EMR)
  • Data modelling
  • End to end data quality testing

Hobbies and Interests

  • Cooking
  • Swimming
  • Science and technology
  • Music

Awards

  • 08/2014, Accenture Stellar Award - Performance, Accenture
  • 03/2018, Accenture Magic Cabinet Award - Performance, Accenture
  • 03/2020, Deloitte Move the Dot Award, Deloitte

Timeline

Senior Technical Specialist

ILink Digital
08.2022 - Current

Consultant

KPMG Global Services
02.2022 - 08.2022

Senior Consultant

Deloitte Touche Tohmatsu India
06.2018 - 01.2022

Application Development Analyst

Accenture
01.2014 - 06.2018

Bachelor of Technology - Computer Science and Engineering

Maharshi Dayanand University
Jitesh Singh