Summary
Overview
Work History
Education
Skills
Websites
Personal Information
Timeline
Generic

Aditya Sharma

Roanoke

Summary

Accomplished Data Architect at Wipro Technologies with expertise in IICS and ETL architecture. Spearheaded the migration to Python-based ETL solutions, enhancing data integration efficiency. Proficient in BigQuery and Google Cloud, complemented by strong analytical skills, driving impactful data solutions across diverse platforms.

Overview

13
13
years of professional experience

Work History

Data Architect

Wipro Technologies
Southlake
12.2021 - Current
  • Designed reusable ETL pipelines for data capture and loading into Cloud Data Warehouse.
  • Led migration initiative from Talend to IDMC and Python-based ETL solutions.
  • Automated data extraction from Rabbit MQ, Mongo DB, Oracle, SQL Server, APIs, and S3 buckets using Python.
  • Developed a durable key solution to mitigate PII exposure in ETL processes.
  • Implemented process integrity checks for audit compliance on all cloud ingestion jobs.
  • Created reusable IICS solutions for migrating legacy jobs from Sqoop and Data Proc.
  • Automated generic ETL code development for ingesting data into Big Data and Teradata, utilized across Data Warehouse and Reporting Teams.
  • Supported multi-platform on-premises to GCP cloud migration and maintained curation jobs as per business requirements.

Technicial Lead

Wipro Limited
Westlake
04.2019 - 11.2021
  • Designed and automated reusable ETL pipelines for data ingestion into HDFS with Talend.
  • Developed generic pipelines for data extraction from MongoDB, Teradata, Oracle, SQL Server, flat files, AWS S3, Salesforce API, Splunk, and RabbitMQ.
  • Created parameter-driven reusable objects on Talend ETL tool, reducing development time by sixty percent.
  • Utilized big data tools such as Spark SQL, Sqoop, TDCH, Hive, HDFS, and MapR-DB.
  • Maintained curation jobs to populate Hive tables as slowly changing dimensions.
  • Acted as subject matter expert for multi-platform upgrades involving Teradata, Talend, and MapR.
  • Participated in Agile sprints with two-week iterations to optimize project delivery.
  • Collaborated in onsite-offshore model with daily communication to ensure operational alignment.

Technical Lead

Wipro Technologies
Pune
01.2018 - 04.2019
  • Led team of ETL developers to deliver pipelines in Informatica and Talend per client standards.
  • Trained junior team members, enhancing overall team competency.
  • Automated IA for Informatica jobs using repository queries to improve efficiency.
  • Developed complex data curation pipelines for storage in DWH to facilitate reporting.

Senior Software Engineer

Wipro Limited
Kuwait City, Kuwait
01.2016 - 12.2017
  • Delivered data warehouse modifications to support billing system transitions to single rating engine.
  • Collaborated with telecom domain client to enhance data warehouse functionality.
  • Gathered customer requirements, submitted proposals, and secured approval for project estimates.
  • Designed ETL processes and developed jobs using Informatica PowerCenter.
  • Executed integration testing and obtained user acceptance testing sign-off.

Senior Software Engineer

Wipro Limited
Budapest
05.2015 - 12.2015
  • Coordinated onsite activities for complex data migration project at Telecom client location.
  • Led billing migration track, gaining expertise in Amdocs billing systems and data storage methods.
  • Enhanced SQL-based tool for bill-to-bill testing pre- and post-data migration.
  • Worked with different system matter experts in the telecom domain to define the strategy for enabling the data relationship between legacy master records.

Project Engineer

Wipro Limited
Pune
10.2012 - 05.2015
  • Created ETL pipelines using Informatica PowerCenter to optimize data flow.
  • Acquired expertise in integrating complex datasets from legacy CRM and billing systems.
  • Executed performance tuning through pushdown optimization, partitioning, and parallelism on Informatica.
  • Migrated complex datasets to next-generation CRM and provisioning systems.
  • Gained experience in securities and telecom domains for data warehouse initiatives and data migration factory.
  • Utilized SQL hints and indexes to enhance query performance.
  • Streamlined data migration processes to ensure efficiency and accuracy.
  • Collaborated with diverse teams to address intricate data integration challenges.
  • Automated reconciliation testing between the legacy and new billing systems

Education

Bachelor of Engineering - Computer Science

Chitkara University
Baddi, Himachal Pradesh
07-2012

Skills

  • IICS and ETL architecture
  • Data integration and analysis
  • BigQuery and Google Cloud
  • Python for ETL processes
  • Analytical and problem-solving skills
  • PowerCenter and Talend Studio
  • Big data technologies
  • Teradata and SQL Server
  • Hadoop ecosystem management
  • Hive and Spark processing
  • SQL and Sqoop usage
  • Near real-time data ingestion

Personal Information

Title: Data Architect , Cloud Data Engineer

Timeline

Data Architect

Wipro Technologies
12.2021 - Current

Technicial Lead

Wipro Limited
04.2019 - 11.2021

Technical Lead

Wipro Technologies
01.2018 - 04.2019

Senior Software Engineer

Wipro Limited
01.2016 - 12.2017

Senior Software Engineer

Wipro Limited
05.2015 - 12.2015

Project Engineer

Wipro Limited
10.2012 - 05.2015

Bachelor of Engineering - Computer Science

Chitkara University

Similar Profiles

CREATE PROFILE
Aditya Sharma