Summary
Overview
Work History
Education
Skills
Languages
Timeline
Generic

Nitin Ranjan Ojha

Texas,TX

Summary

Data Engineer with 7+ years of expertise in designing and implementing advanced ETL pipelines and automation solutions. Proficient in AWS, Python, and data analytics, with a proven track record of enhancing system performance and reducing manual tasks through innovative approaches. Committed to leveraging skills in data engineering and analytics to drive business intelligence and operational efficiency.

Overview

8
8
years of professional experience

Work History

Senior Data Engineer

Hitachi Digital Services
11.2022 - Current

DATA ENGINEER

  • Designed and implemented end-to-end ETL pipelines using AWS Glue and coalesce, enabling seamless data extraction, transformation, and loading. Orchestrated these workflows using Apache Airflow to ensure efficient and reliable scheduling, monitoring, and execution of data processes across multiple environments.
  • Collaborated closely on the design and implementation of Data Vault modeling, ensuring scalable and flexible data architecture to support business intelligence and analytics initiatives.
  • Proactively addressed and resolved production issues in real-time, troubleshooting and providing effective solutions to ensure minimal downtime and maintain system performance.
  • Streamlined and automated processes to accelerate deliverables, improving efficiency and reducing turnaround time for faster and more reliable outcomes.

PLATFORM ENGINEER

  • Collaborated on cross-functional teams to drive platform improvements and deliver business value.
  • Evaluated new technologies for potential adoption into the platform ecosystem, ensuring a cutting-edge tech stack.
  • Taking initiative to improve the ecosystem by introducing custom solutions for CI/CD deployments ,AWS glue ,Airflow ,Snowflake etc
  • Setting up the deployments using CI/CD for any existing applications .
  • Continuous support on the application run time issues .
  • Resolving all kind of risk and compliance issues related to the organization .
  • Tracking all the vulnerabilities and resolving them on an organization level.

Software Engineer

Mphasis
05.2021 - 11.2022
  • Implemented robust code improvements, resulting in significant performance gains. Led debugging efforts, resolving complex issues and ensuring seamless product delivery.
  • Designed and developed automation tools using Python and PySpark to perform data validation operations across multiple databases and file formats. Collaborated closely with clients to gather requirements and implement tailored automation solutions in alignment with their specific needs.
  • Fostered strong team relationships, facilitating knowledge sharing and mentoring junior developers. Contributed to agile development processes, improving sprint productivity.
  • Pioneered new approaches to software architecture, streamlining development workflows. Introduced automation tools, reducing manual tasks and increasing overall efficiency.

Senior Team Member

Tata Motors Pvt LTD
09.2019 - 05.2021
  • Developed and implemented Python scripts to automate the transformation and loading processes within the existing system, while gaining hands-on experience in data analysis utilizing business intelligence (BI) tools.
  • Managed the extraction and integration of data from diverse sources, while reviewing and recommending improvements to data models. Ensured adherence to data modeling standards and best practices during the design and implementation phases.

Associate Consultant

Saama Technologies Pvt LTD
08.2017 - 09.2019
  • Contributed to the development of ETL processes using Informatica, facilitating data extraction, transformation, and loading from multiple sources.
  • Collaborated on enhancements based on client requirements, while optimizing SQL queries to improve performance and efficiency.

Education

B.E. - Computer Engineering

D.y. Patil Coe, Akurdi Affiliated To University of Pune
Pune,India
05.2016

Skills

  • ETL
  • Data Engineering
  • Data Warehousing
  • Python
  • PySpark
  • Data Modelling
  • Data Analytics
  • Business Intelligence
  • Dashboard Management
  • Data Profiling
  • Data Cleansing
  • Apache Airflow
  • Google BigQuery
  • AWS S3
  • AWS Lambda
  • AWS Glue
  • Snowflake
  • Coalesce
  • Oracle
  • Teradata
  • Hive
  • GCP
  • AWS
  • GIT
  • Informatica
  • Azure Devops
  • Liquibase
  • CI/CD

Languages

English
Hindi
Marathi

Timeline

Senior Data Engineer

Hitachi Digital Services
11.2022 - Current

Software Engineer

Mphasis
05.2021 - 11.2022

Senior Team Member

Tata Motors Pvt LTD
09.2019 - 05.2021

Associate Consultant

Saama Technologies Pvt LTD
08.2017 - 09.2019

B.E. - Computer Engineering

D.y. Patil Coe, Akurdi Affiliated To University of Pune
Nitin Ranjan Ojha