amit Rajput


Last update: 28.05.2019

ETL Consultant

Company: Tata Consultatncy services
Graduation: Bachelour of enginerring (Information Technology)
Hourly-/Daily rates: show
Languages: English (Full Professional)


Extract Transform Load (ETL) Data Warehousing Workflows Analytical Thinking Banking Services Relational Databases Functional Design Problem Solving Oracle Applications Project Management Life Cycle + 7 more keywords


• Over all 5+ years of experience in Data warehousing by using Informatica.
• ETL Concepts to load data from different sources into data warehouse using Informatica Power Center.
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Update Strategy, Aggregator, Sorter and Sequence Generator.
• Extensively worked with Slowly Changing Dimensions
• Efficacy in relational database systems like Oracle.
• Good understanding Data Warehousing Concepts such as Star Schema and Dimension Table
• Designing and developing Workflows, Sessions and other tasks using Work flow manager tools.
• Involved in functional study of the application.
• Running the jobs/Workflows for ETL process.
• Prepared and run sql queries to verify Dimensional and Fact tables data.
• Verified column mapping between source and target
A leader with strong analytical, logical and problem-solving skills
• Well acquainted with Software Development Life Cycle.
• Good knowledge in all areas of a project lifecycle like analysis, design, coding, testing and documentation.
• Reviewing the functional specifications and Requirements documents.
• Have domain knowledge in Banking and Retail market.

Project history

Project Title  :           Sea Bird Data Warehouse.
Client              :         Sea Bird Shipping Agency   
Environment :           Informatica,Sybase, Pl/Sql, Shell script, Oracle 10g
Designation :            Consultant
Domain        : Logistic
Duration      : Mar 2017 to till date
Description  :    SeaBIRd Data warehouse and BI solution. SeaBIRd is to become single source of information for all the reports that are used across different functional areas.
Responsibilities: Design, develop, analyze and implement Oracle, ETL.
  • Assist team members with questions and decision making
  • Write implementation, instructions and integration tests for applications
  • Develop database procedures and packages
  • Optimize the existing jobs using SQL/PL-SQL tuning methodologies
  • Business Requirements gathering and analysis provided by the client, preparation of functional specifications and design documents.
  • Prepared technical specifications for the development of Informatica (ETL) mappings to load data into various target tables and defining ETL standards.
  • Created Informatica mappings, sessions and workflows to load the data.
  • Created relational tables at the data base level for ODS and staging area.
  •  Involved in source to target count testing, source to target data testing, data mapping or transformation testing, data complete testing using minus query.
  •  Involved in functional study of the application.
  •  Running the jobs/Workflows for ETL process.
  •  Prepared and ran sql queries to verify Dimensional and Fact tab les.
  •  Verified column mapping between source and target

Local Availability

Only available in these countries: India
Currently I am living in baneglure india , I can travel anywhere on demand
Profileimage by amit Rajput ETL Consultant from ETL Consultant