Post Job Free


Sign in

Etl Developer Software Engineer

Saint Charles, MO
September 27, 2023

Contact this candidate



Email: PH: +1-636-***-****

ETL Developer

Professional Summary

ETL developer with 6.8 years of work experience in Ab initio- Conduct IT, Oracle, PDL, Teradata, UNIX, Data Analysis and Shell Scripting.

Worked with Wipro Ltd. For 2.7 years as Senior Software Engineer.

Worked with Tata Consultancy Services Ltd. for 4.2 years.

About 6.5 years plus of thorough affair with Data warehousing platform.

Knowledge on ETL tools like IBM Data Stage and Informatica.

Worked on advanced concept of Meta-Hub to create data lineage in ETL tool Abinitio.

Experience in data extraction from heterogeneous sources using Abinitio.

Experience in creating High Level Design and Detailed Design in the Design phase.

Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements.

Solid understanding of OLAP concepts and challenges with large data sets.

Strong experience in designing and developing complex mappings from varied transformation logic

like lookups, Reformat, Rollup, Join, Scan, Merge, Filter By Expression..

Strong knowledge of Entity-Relationship concept, Facts, and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snowflake Schema).

Experienced in Client handling also. Taking requirements and doing analysis for the same.

Experienced in fixing the job (Unix, Ab-initio) related issues

Expertise in SQL Programming & SQL Tuning in Teradata.

Good experience in Teradata utilities: BTEQ, TPTload, Multiload, Fastload, Fastexport.

Good understanding of Hadoop architecture and various components such as HDFS, YARN and MapReduce programming paradigm.

Wrote Ad - hoc queries for analyzing the data using HIVE QL.

Experience in analyzing data using HiveQL, HBase and custom MapReduce programs. Have worked on Spark Framework, Hadoop ecosystem. Loaded files to Hive and HDFS from Abinitio.

Experience in Creation of Test Cases taking into consideration the actual business requirements and also preparation of Technical Specifications for solutions.

A strong team player, collaborating well with the team to solve problems and actively incorporating input from various sources by working with others on a global basis.

Strong analytical and problem-solving skills with clear communication to make business decisions.

Committed to learn new skills & has the ability to work under pressure.

Professional Experience

ETL Developer

Wipro Limited, Gurugram, India May2017 to Jan 2020

Roles &Responsibilities:

Worked closely with data modelers, business analysts and BI developers to understand requirements,

to develop the ETL processes using Abinitio.

Involved in level 2 and level 3 production support processes for resolution of ETL related issues in production.

Ensures issues are identified, tracked, reported on and resolved in a timely manner.

Provides oversight of other ETL development activities and unit testing all objects and processes and performs find-tuning and UAT issue resolution.

Extensive experience in application integration using tools like Abinitio.

Data Migration using Data loader & SQL Server.

Written Pre and Post Session SQL commands to drop and recreate the indexes on data warehouse

Developed complex Informatica mappings using Lookup, Join, and Scan and

Rollup for populating target tables in an efficient manner.

Identified and fixed the Bottle Necks and tuned the Graph and SQL for improving


Assists in enforcement of project deadlines and schedules.

Possesses understanding in the areas of application programming, snowflake schema database and system design.

Identifies critical issues with ease.

Exhibits confidence and an extensive knowledge of emerging industry practices when solving

business problems.

Takes input from the supervisor and appropriately and accurately applies comments/feedback.

Seeks and participates in development opportunities above and beyond training.

Environment: Ab-initio, Express-it, Hive, Hadoop, Meta-hub, Control center, workflow management tools.

ETL Developer

Tata Consultancy Services, Noida March 2013 to May 2017

Roles & Responsibilities:

Analyzed the functional specs provided by the data architect and created technical specs documents

for all the mappings.

Parsing high-level design spec to simple ETL coding and mapping standards.

Developed and tested Current Process Modifications in Data Warehouse based on Change Requests

from Users.

Developed ETL process for new product alignment process and territory management changes.

Designed & Developed Informatica mappings, creating sessions and workflows for Data Loads. Used

Transformations like Join, Reformat, Rollup, Scan, Lookups.

Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process.

Maintained the batch processes using Unix Shell Scripts.

Developed unit test strategy and involved in coordinating the full cycle system testing effort with the

help of QA and project management team

Involved in Monthly and Weekly Production Process Support for Warehouse and DataMart with

Customer, Rx and DDD data from IMS Health and NDC.

Responsible for Migrating the Ab-initio Processes from development to Test and production environment.

Move data from/to HDFS and create tables on top of them.

Hive is used on top of Beeline for faster and better performance.

Sqoop is used to move large datasets (history) to HDFS.

Extensively worked on developing continuous Change Data (CDC) using Ab-initio

Tuned both ETL process as well as Databases.

Tuned the mappings and ETL procedures both at mapping and session level for better performance.

Load the data from heterogenous source system into Netezza table.

Involved in level 2 and level 3 production support processes for resolution of ETL related issues in production.

Supported team members in critical ETL processes

Environment: Ab-initio GDE, ESP scheduling tool, UNIX, PL/SQL, Teradata, Viewpoint, Datastage, Oracle, Netezza

Educational Qualification:



B.Tech Computer Science



Anand Engineering College (affiliated to Gautam Buddh Technical University,Lucknow) in 2012 Aggregate Percentage 76.5%

Contact this candidate