Amit Tripathi

ETL Developer | Data Analyst

LinkedIn

About

Highly skilled Data Analyst with 3+ years of experience excelling in ETL pipeline development, data integration, and advanced analytics. Proven ability to design and optimize scalable data solutions, reducing processing times by up to 40% and improving data accuracy by 25%. Adept at leveraging SQL, Python, Power BI, and cloud platforms to deliver enterprise-grade reporting and drive data-driven decision-making.

Work Experience

ETL Developer | Data Analyst

Netlink Software Group America Inc

Oct 2022 - Mar 2024

Bhopal, Madhya Pradesh, IN

Spearheaded end-to-end ETL pipeline development and data analysis initiatives for the SiriusXM Enterprise project, enhancing data processing efficiency and reporting accuracy.

  • Led the design and implementation of robust end-to-end ETL pipelines, optimizing workflows to reduce data processing time by 25% and cutting pipeline execution time by 40% through indexing, batch processing, and parallel loading.
  • Enhanced data accuracy by 25% and ensured data integrity for downstream teams by implementing Slowly Changing Dimensions (SCD) and resolving 95% of duplicates, null values, and datatype issues.
  • Designed and deployed automated error-catching routines and data validation flows, reducing pipeline failures by 90% and ensuring 99.9% accuracy of production data outputs.
  • Developed a tiered data archiving strategy that drove 30% storage cost savings and enabled 40% faster dashboard query performance by moving historical data into lower-cost storage.
  • Automated manual reporting workflows using SQL and Pentaho, decreasing monitoring effort by 30% and testing time by 60%, while creating 5+ interactive Power BI dashboards for KPI tracking and operational insights.
  • Partnered with 3+ cross-functional teams to gather requirements, define metrics, and deliver tailored analytics solutions, contributing to data-driven decision-making.
  • Performed root cause analysis (RCA) on 30+ complex data issues, collaborating with QA/Dev teams for User Acceptance Testing (UAT) to ensure high reliability of production data.

ETL Intern

Netlink Software Group America Inc

May 2022 - Sep 2022

Bhopal, Madhya Pradesh, IN

Supported ETL development and data validation efforts for enterprise projects, gaining foundational experience in data processing.

  • Executed ETL processes using Pentaho PDI, contributing to data transformation and loading for enterprise projects.
  • Conducted data validation and testing for enterprise projects, ensuring data quality and reliability for downstream systems.

Education

Agricultural Engineering

AKS University Satna

Aug 2015 - Jul 2019

Satna, Madhya Pradesh, IN

Certificates

SQL Advanced

Hacker Rank

Jan 2022

Google Data Analytics Professional Certificate

Coursera/Google

Jan 2022

Awards

Team Award for Outstanding Performance

Netlink Software Group America Inc

Nov 2022

Awarded as part of a team for exceptional collaboration and achievement on a key project.

Best Performer Award

Netlink Software Group America Inc

Oct 2022

Recognized for outstanding individual performance and contributions to project success.

Languages

Hindi (Native) , English (Fluent)

Skills

ETL Tools

  • Pentaho PDI
  • Informatica

Programming Languages

  • SQL (Advanced)
  • Python (Basics)

Databases

  • PostgreSQL
  • SQL Server
  • MySQL
  • Vertica
  • Snowflake

Cloud Platforms

  • AWS (S3, Redshift)

Data Concepts

  • ETL Development & Testing
  • SCD
  • Data Warehousing
  • OLTP/OLAP
  • Data Migration
  • Data Modeling
  • Metadata Validation

Data Analysis

  • EDA
  • KPI Monitoring
  • Business Metrics
  • Requirement Gathering
  • RCA
  • UAT

Reporting & Visualization

  • Power BI
  • Advanced Excel
  • Excel Dashboards

Other Tools & Methodologies

  • Kubernetes
  • Agile
  • Stakeholder Communication