Summary
Overview
Work History
Education
Skills
Certification
Awards
Timeline
Generic

Amit Kumar Sinha

Data Modeler | ETL Developer
Bengaluru

Summary

Experienced Data Modeler & ETL Developer with over 7 years in data management, including 3+ years focused on data modeling and architecture. Proven expertise in OLTP/OLAP systems, relational and dimensional modeling, and data analysis. Proficient in Data Modelling, SQL Server, SSIS, data warehousing, ETL processes, data transformation, and performance optimization, Data Vault concepts, and leading modeling tools like ER/Studio. Strong problem-solving skills and ability to work collaboratively in a fast-paced environment. Demonstrated ability to handle large datasets, automate data workflows, and deliver high-quality results.

Overview

7
7
years of professional experience
2
2
Certifications
3
3
Languages

Work History

Application Development Senior Analyst

Accenture India Pvt. Ltd.
04.2021 - Current
  • Led the design of conceptual, logical, and physical data models to support enterprise data warehouse solutions.
  • Implemented Data Vault methodology for scalable and auditable architecture across multiple domains.
  • Worked with business stakeholders to translate reporting and analytics needs into robust data structures.
  • Maintained data models using ER Studio, Draw.io, ensuring consistency with enterprise data standards.
  • Conducted data profiling and analysis in SQL to validate data quality and structure.
  • Collaborated with data governance team to define metadata standards and data dictionary.
  • Designed, developed, and optimized ETL processes using SSIS for data migration and transformation across various platforms.
  • Worked closely with the data architecture team to implement scalable and high-performing ETL workflows for the data warehouse.
  • Created complex T-SQL queries and stored procedures for data extraction, transformation, and loading (ETL) processes.
  • Collaborated with business analysts to understand data requirements and create solutions for reporting and analytics.
  • Tuned SSIS packages and optimized SQL queries for improved performance, reducing ETL job run times.
  • Worked at client location in nearshore (Argentina) for 2 years leading the development team.

Programmer Analyst

Cognizant Technology Solutions
07.2018 - 04.2021
  • Participated in database normalization and schema optimization initiatives.
  • Built dimensional data models supporting OLAP cubes and business intelligence platforms.
  • Developed ETL processes using SQL Server Integration Services (SSIS) to extract, transform, and load data from various sources (e.g., flat files, databases, APIs).
  • Implemented data transformations and aggregation logic using SSIS Data Flow components (e.g., Lookup, Merge Join, Conditional Split).
  • Performed performance tuning of SSIS packages and SQL queries, optimizing data load times and system resources.
  • Supported data migration projects, including data mapping, transformation logic, and data validation.
  • Maintained and updated SSIS packages for continuous improvement and automation of ETL processes.
  • Collaborated with cross-functional teams to define data requirements and develop solutions to support business intelligence initiatives.

Education

Bachelor of Technology (B.Tech) -

SRM University
05.2018

Skills

Data Modelling

ETL

SQL

Data Warehousing

T-SQL

undefined

Certification

Azure Data Fundamentals (DP 900), Microsoft

Awards

  • ACE Award - Received in Both Individual and Group Category, Accenture,
  • Rising Star Pinnacle Award - For creating extraordinary value within a short time since joining the team,
  • Accenture, Rocking Rookie Award - Recognized as Entry Level Trainee for Outstanding Performance under CDB Applause,
  • Cognizant, Outstanding Performance Award - CDB AI&A Rewards & Recognition Program, Cognizant

Timeline

Application Development Senior Analyst

Accenture India Pvt. Ltd.
04.2021 - Current

Programmer Analyst

Cognizant Technology Solutions
07.2018 - 04.2021

Bachelor of Technology (B.Tech) -

SRM University

Similar Profiles

CREATE PROFILE
Amit Kumar SinhaData Modeler | ETL Developer