Summary
Overview
Work History
Education
Skills
Affiliations
Activities
Personal Information
Assignments Details
Timeline
Generic

Amit Nandkishor Rewatkar

Bangalore

Summary

Data professional with extensive experience at Deutsche Bank Group, specializing in ETL process optimization and SQL development. Demonstrated success in enhancing data quality and performance through effective collaboration with cross-functional teams. Proficient in cloud computing solutions and project management, consistently delivering impactful results in dynamic environments.

Overview

11
11
years of professional experience

Work History

Associate

Deutsche Bank Group
06.2023 - Current
  • Connected to multiple cloud-based operational databases for extracting, transforming, and loading data into the data warehouse for analytics.
  • Investigated production incidents and data inconsistencies while collaborating with development and infrastructure teams for root cause analysis.
  • Optimized ETL processes and SQL queries to enhance performance and resource efficiency.
  • Maintained comprehensive documentation for ETL processes, job dependencies, and support runbooks.
  • Provided regular status updates and incident reports to stakeholders to ensure transparency.
  • Supported ETL code deployments across development, testing, and production environments while coordinating with DevOps teams.
  • Monitored GCP services, including Cloud Storage, BigQuery Data Transfer Service, and Cloud Composer (Airflow).

Assistant Manager

INFOCEPTS TECNOLOGIESPVT LTD
01.2017 - 06.2023
  • Responsible for analysis and Interaction with Client/onsite team in gathering requirements & providing estimation for ETL & DB Activities
  • Extracting data from AWS S3 Bucket and load into AWS RDS database.
  • Prepared custom SQL queries for custom reports to analyze the quality of data
  • Preparation of ETL Mappings to load the data from Source to Target using various transformations.
  • Responsible of monitoring all the ETL Jobs & bug fixing as and when required QA support
  • Responsible to connect to different operational data bases (cloud), extract data, transform data and load data into warehouse for analytical/BI use.
  • Design ETL document including the unit test cases, which will explain the complete design and implementation of the report.

Software Engineer

HANSA SOLUTIONS INDIA PVT LTD
07.2014 - 09.2016
  • Leading a team of 4 members and make them in understanding the application
  • Understanding client’s business requirements and Expectations.
  • Analyzing the requirements and developing the product.
  • Modified the existing Rule Engine framework such that it can handle validations for all products.
  • Verified SQL Scripts and executed on Production server.
  • Creation of SQL queries to provide Operation critical data and reports.
  • Coordinating with various dependent teams to identify issues and to resolve them.
  • Requirements Gathering from Client.

Education

B.E. - Computer Science & Engineering

T.G.P College of Engineering And Technology
07-2014

Skills

  • Informatica Power Centre
    Pentaho ETL tools
    ETL process optimization
    Data modeling
    PL/SQL and SQL development
    Unix operating systems
    SCT and UC4 automation
    MS SQL Server
    Netezza database management
    DBeaver database tool
    ServiceNow platform
    Cloud computing solutions
    JIRA project management
    Oracle database 10g and 11g
    PostgreSQL database management
    Redshift data warehousing

Affiliations

->5+ years of rich experience in ETL technology.

->Experience in Informatica PowerCenter and Pentaho in development and support projects.

->Experience with Informatica and database migration on the cloud.

->Extensive experience in creating the workflows, worklets, mappings, mapplets, reusable transformations, and scheduling the workflows

->Experience with debugging and tuning of ETL processes to improve the overall performance will be preferred

->Experience in ETL connections with AWS Cloud RDS (Oracle RDS and MySQL, Redshift), and S3 Media Bucket SCT, basics of UNIX, and GCP.

->Have hands-on experience in creating data models, extensive knowledge in SQL, Redshift, Netezza, Snowflake Database

->Extensive knowledge in SQL, Redshift, Netezza, Snowflake Database

Activities

Dancing, Traveling, Positive Attitude, Good Leader

Personal Information

  • Father's Name: Nandkishor P. Rewatkar
  • Mother's Name: Shobha N. Rewatkar
  • Date of Birth: 08/13/90
  • Nationality: Indian

Assignments Details

ETL FACTORY (Current Project):

This project involves development and deployment of data integration processes using ETL platform. We as  ETLF  level 3 support engineers provide support to ensure hassle free EOD and intraday processes to populate  targets. Coordination with the teams in case of issues encountered.

CAG (in InfoCepts) 

Changi Airport Group (CAG) is the manager of Singapore Changi Airport, a leading air hub in Asia, and one of the world's most awarded airports.

Web application: IONE (in Hansa Solutions India Pvt Ltd)

 CLIENT  :  Kotak Life Insurance  

Insurance one is an Enterprise Application built using ASP. Net, VB .Net, Windows and web services, WCF services, AJAX controls, and Sync Fusion (third party API – TPA) for web GUI

Timeline

Associate

Deutsche Bank Group
06.2023 - Current

Assistant Manager

INFOCEPTS TECNOLOGIESPVT LTD
01.2017 - 06.2023

Software Engineer

HANSA SOLUTIONS INDIA PVT LTD
07.2014 - 09.2016

B.E. - Computer Science & Engineering

T.G.P College of Engineering And Technology

Similar Profiles

CREATE PROFILE
Amit Nandkishor Rewatkar