Summary
Overview
Work History
Education
Skills
Certification
Languages
Accomplishments
Timeline
Generic

KSHITIJ CHOUDHARY

Bangalore

Summary

Results-driven Software and Data Engineer with 6 years of experience in ETL development, API integration, data migration, and cloud-based solutions for enterprise clients across Healthcare, Life Sciences, and Technology sectors. Proven expertise in Oracle Technologies (PL/SQL, ODI, FDI, OIC), Google Cloud BigQuery, AWS Athena, and Python/Scala backend development. Strong background in data pipeline optimization, report automation, and monitoring dashboards using Wavefront and PROMQL. Adept at leading cross-functional teams, gathering client requirements, and delivering high-performance solutions under strict deadlines. Recognized for fast-track promotions and exceptional client feedback.

Overview

6
6
years of professional experience
1
1
Certification

Work History

Software Developer Engineer 2

Hashedin By Deloitte
Bengaluru
03.2022 - Current
  • Leading the Oracle ETL technical team for the company’s largest client, working extensively with Oracle-driven technologies, including Oracle Data Integrator (ODI), Fusion Data Intelligence (FDI), Oracle Integration Cloud (OIC), SQL, and PL/SQL.
  • Collaborated with cross-functional teams to gather requirements and design scalable solutions for a healthcare product. Successfully implemented Google Authentication (GAuth) API integration using FastAPI, enhancing secure user authentication, and access control.
  • Led a team for a technology-driven client to successfully migrate all reporting and data automation scripts from Oracle PL/SQL to Google Cloud BigQuery. The migrated data was further processed through a data pipeline for cleaning, transformation, optimization, and loading into the target database. Completed the project ahead of the scheduled go-live deadline for the client's applications.
  • Further retained by the same client to lead initiatives focused on performance optimization, and Wavefront metrics creation and scheduling. Spearheaded the migration of the complete codebase from Python to Scala, ensuring improved scalability and performance. Led a team in developing and implementing Wavefront metrics dashboards using PROMQL for advanced monitoring and alerting.
  • Designed and developed ETL packages using SSIS (SQL Server Integration Services) for data manipulation, transformation, and automation as part of a healthcare project for a leading U.S. client. Processed and cleaned large raw datasets, transforming them for use in backend report generation APIs. These SSIS packages directly powered automated report generation and delivery workflows.
  • Implemented a wide range of Life Sciences applications for the company's client, leading the Proof of Concept (POC), and backend implementation of complex, parameterized queries in AWS Athena. Successfully designed and integrated these queries within back-end procedures to support data-driven features and analytics workflows.
  • Worked on API integration and frontend development for a web-based survey system, focusing on customizing and integrating the external Zoom Calendar API to enable seamless scheduling, user interaction, and event management within the application. Including the data insights and analysis for the same product.

Associate Data Engineer

Cognizant Technology Solutions
CHENNAI
06.2019 - 03.2022
  • Promoted from Programmer Analyst Trainee to Associate (two bands above) within the same fiscal year, driven by exceptional client feedback and performance.
  • Worked on Oracle Database and Pipeline Pilot ETL tool, focusing on ETL development, Pipeline Pilot administration, and server management to support data integration and processing workflows.
  • I worked as a Data Analyst for a client project, specializing in database manipulation using PL/SQL. Developed and optimized efficient scripts, resulting in a 60–70% reduction in manual task inflow, and significantly improving process efficiency.
  • Automated analysis protocols and report generation processes for the client's Oracle Database. Enhanced and optimized PL/SQL scripts, leading to a 30% reduction in pre-check time and manual efforts, thereby improving overall operational efficiency.

Intern

Cognizant Technology Solution
CHENNAI
01.2019 - 04.2019
  • Trained in SQL, PL/SQL, and Informatica ETL tools, with a focus on data integration and analytics solutions for the Life Sciences sector.
  • Developed a personal GitHub portfolio web portal to showcase project work and technical skills during interview evaluations for CTS projects.
  • Monitored Informatica ETL jobs, and developed ETL tasks to load flat file data into the database after performing pre-check analysis, ensuring data quality and process accuracy.

Education

B.Tech - Information Technology

Sathyabama Institute Of Science and Technology
Chennai
04.2019

Skills

  • SQL
  • PL/SQL
  • Python
  • scala
  • Informatica ETL
  • SSIS (SQL Server Integration Services)
  • Oracle Data Integrator (ODI)
  • Pipeline Pilot
  • Oracle Integration Cloud (OIC)
  • Fusion Data Intelligence (FDI)
  • Toad for Oracle
  • Google BigQuery
  • AWS Athena
  • Oracle database
  • Google BigQuery
  • SQL-based databases
  • FastAPI
  • Rest API integration
  • Wavefront
  • promql (Prometheus Query Language)
  • Team Leadership
  • Client Communication
  • Requirement Gathering
  • Solution Design
  • Cross-functional Collaboration

Certification

Advanced SQL: SQL Expert Certification

http://ude.my/Uc8294da1-d5ef-4363-8acc-fa14bcbc18e

Oracle Data Integrator 12c certified implementation specialist

https://catalog-education.oracle.com/ords/certview/sharebadge?id=837E3397D6616C60B9D00CD891F9020D4999CA9EF7AFC8B62C58441C996589CA

Languages

Hindi
First Language
English
Advanced (C1)
C1

Accomplishments

  • Received Excellence Award in Hashedin for a Client Migration POD in July 2024.
  • Received the Excellence Award at Hashedin for a client POD in June 2023.
  • Received Back to back 2 promotions in the same Fiscal Year of 2021-2022 in Cognizant.

Timeline

Software Developer Engineer 2

Hashedin By Deloitte
03.2022 - Current

Associate Data Engineer

Cognizant Technology Solutions
06.2019 - 03.2022

Intern

Cognizant Technology Solution
01.2019 - 04.2019

B.Tech - Information Technology

Sathyabama Institute Of Science and Technology

Similar Profiles

CREATE PROFILE
KSHITIJ CHOUDHARY