Summary
Overview
Work History
Education
Skills
Certification
Secondary Skills
Primary Skills
Timeline
Generic
Ami Gorakhiya

Ami Gorakhiya

Summary

Experienced Data Engineer adept at designing, developing, and maintaining data pipelines using Informatica PowerCenter to ensure smooth data flow across systems. Proficient in Teradata database management, including performance tuning, data modeling, and optimization techniques for large-scale data processing.

Overview

6
6
years of professional experience
1
1
Certification

Work History

Data Engineer - Data Migration

Eclinicalworks
11.2022 - 01.2024
  • Worked on Patient Related Data/Medication Related Data/Claims related Data for ETL processes.
  • Client communication for getting system access to extract data from various healthcare database backups, flat-files and reports.
  • Extensive Database Schema Analysis to find required data for migration.
  • Determined vivid relations between data across the database generating crosswalk tables.
  • Calls with Client & Project manager to create a data evaluation plan by negotiating client requirements and expectations.
  • Migrated data into eCW Database using custom Utilities, considering business requirements specified under DEP (Data Evaluation Plan).
  • Provided technical support on external requests received from clients till migration is done and they are successfully live.
  • Accompanied Project manager to get scope of project from Client by understanding and discussing their usage and requirements.

SENIOR ETL DEVELOPER & PROJECT SUPPORT

TATA CONSULTANCY SERVICES
03.2019 - 05.2022
  • Knowledge of complex asset and customer data migration.
  • Experience in legacy data migration with diverse data sources.
  • Familiarity with working in Oracle and MySQL databases.
  • Experience in preparing technical documentation for deliverables.
  • Ability to prepare and report project performance metrics and KPIs.
  • Prior experience in managing data, data quality, and data-related projects.
  • Effective verbal and written communication skills for team collaboration and coordination.
  • ServiceNow application and data management.

ETL DEVELOPER

TATA CONSULTANCY SERVICES
11.2018 - 02.2019
  • Create ETL mapping to sync data between data sources
  • Create production turnover documents and migration
  • Attend technology design meetings and recommend security and data improvements and will be empowered to work on those prioritized changes
  • Provide inputs to develop project plans
  • Self-motivated with critical attention to details, deadlines and reporting.

ETL DEVELOPER

TATA CONSULTANCY SERVICES
11.2017 - 11.2018
  • Understand data requirements and transform data in required format as per the business rules using tools like Teradata, Informatica, Cronacle
  • Work with IT team to follow full development life cycle with other technical operations
  • Work with other team members in establishing and sharing design and development techniques of ETL processes.
  • Increased data accuracy by implementing thorough validation checks and error-handling mechanisms.
  • Supported various ad hoc requests from end-users by delivering accurate datasets as per their requirements.

Education

BCA (Bachelor in Computer Application) -

Saurashtra University
03.2016

HSC -

Dholakiya School
04.2013

SSC -

Dholakiya School
05.2011

Skills

  • Data Modeling
  • Data curating
  • ETL development
  • Data Warehousing

Certification

  • On the spot Award - TATA Consultancy Services | April -2019
  • Service & Commitment Award - TATA Consultancy Services | March 2020

Secondary Skills

Others: SVN, Wincp, Unix, Putty, ServiceNow, GitHub, SQL

Primary Skills

  • ETL: Teradata 16.x, Informatica 10.x, Redwood Cronacle (Job Scheduler)
  • DBMS: Teradata, Oracle
  • RDBMS: SQL Server Management Studio(SSMS)
  • Management Skills: Scrum Management, Agile Methodology, Communication Skills, Team Management, Ability to handle client and stakeholders

Timeline

Data Engineer - Data Migration

Eclinicalworks
11.2022 - 01.2024

SENIOR ETL DEVELOPER & PROJECT SUPPORT

TATA CONSULTANCY SERVICES
03.2019 - 05.2022

ETL DEVELOPER

TATA CONSULTANCY SERVICES
11.2018 - 02.2019

ETL DEVELOPER

TATA CONSULTANCY SERVICES
11.2017 - 11.2018

BCA (Bachelor in Computer Application) -

Saurashtra University

HSC -

Dholakiya School

SSC -

Dholakiya School

Similar Profiles

CREATE PROFILE
Ami Gorakhiya