Sign in

Abinitio ETL Developer Project

Madikonda, Telangana, India
1000000Abinitio ETL
May 02, 2019

Contact this candidate


Pratibha Rawat

ETL Developer Mobile: 91-830*******


Experience summary

* ***** ** ***** ********** in Data Warehousing technology.

Around 3.8 years of experience in Ab-Initio in the areas of development and implementation of

business systems and brief exposure to Teradata, Bigsql,UNIX and Mainframe technologies.

Good exposure to plan and execute all phases of software life cycle starting with requirement

study, analysis, design, development, testing and implementation.

Good exposure to generic graphs which handle the CDC and data level validation.

Good working experience with all the components in Ab-Initio GDE, successfully developed and

tested Ab-Initio graphs and deployed in production.

Responsible for scheduling the jobs and monitoring using Control-M as a scheduler.


● Bachelor of Technology from Uttarakhand Technical University,Dun (68.2%).

● Intermediate from SGRR public school Dehradun (72.2%,CBSE Board)

● High School from Bal Bharti School,Uttarakhand (68.4%,CBSE Board).

Skill Set

Operating Systems : Windows, UNIX.

ETL Tools : Ab-Initio, Control-M

Technology : Data Warehousing, Mainframe.

Tools and Utilities : Ab-Initio Co>op version3.2.5,Unix

Databases : DB2, Mssql, Oracle and Teradata.

Domain : Banking and Financial Services.

Work Experience Summary

Name of the Company Designation Duration

Cognizant Technology Solutions Programmer Analyst Feb 2014 – April 2017


Capgemini India Pvt Ltd Associate Consultant June 2017-Till Date

Relevant Project Experience

Project#1: Client (KeyBank)

Role : Ab-Initio Developer

Client : Key Bank, USA

Tools/Environment : Ab-Initio (GDE–3.2.5 & Co-ops 3.2.5), UNIX, SQL

Duration : Feb’15 – April’17

Project Description

EDP (Enterprise Data Programming): Project aims to incorporate the Data Factory Model and

maintained in the Harmonization Layer as files in a standardized form. These files act as the source

for several downstream applications internal and external to Key Bank.


Developed some new mapping, workflow as per requirement to load those offline items to stage

table and worked on some existing mappings as it was an Upgrade project.

● Unit Prepared and Verified test case to validate data correctly populated till reporting layer.

● Involved in creating, building and promoting PARM jobs in the Mainframe region for scheduling



Project#2: Client (Barclays)

Role : Ab-Initio Developer

Client : Barclays, UK

Tools/Environment : Ab-Initio (GDE–3.2.7 GDE version), UNIX, SQL,Teradata.

Duration : June’17 – Aug’18

Project Description

Split the Bank, Merge Customer, Tactical solution

● Split the Bank:As part of this project, rewrite Banking and Debit Falcon for accounts, Plastic

cards and Customer details to CS source files instead of TCV files. I have enhanced the

process to pass markers using source files. Added newly monthly process to delete the

redundant profiles of account and cards from Falcon.

Developed ETL code to full extract the all active customer and cards.

● Tactical solution :In Tactical Solution project, delivering of FML rule analytics ad rule

authorizing data from FML into BIW1.0 via ETL. In order to deliver the central store data to

enable Fraud Analytics to define and verify the Machine Learning business rules.


● To load the data into Teradata, validate header and trailer of a file and send only

detailed records to the next flow and load for further analysis, also send the files to

SSCA Falcon team via connect direct.

● Handing project till production and involving in all process to make project GO Live.

● Unit testing, Table structure creation, file transfer connectivity setup.

Project#3: Client (Discover Financial Services)

Role : Ab-Initio Developer

Client : Discover Financial Services, US

Tools/Environment : Ab-Initio (GDE–3.2.7 GDE version), UNIX, SQL,Teradata.

Duration : Oct’18 – Mar’19

Project Description

Migration of Abinitio code from AIX server to Linux Server.


● U s i n g ET L t o o l Ab I n i t i o a n d SQL L o a d e r f o r da t a

m i g r a t i o n t o En t e r p r i s e Da t a Wa r e h o u s e .

● Responsible to checkout the code from AIX server to LINUX server for testing and

compatibility check.

● Tested the AIX implemented Abinitio code in LINUX server, and done minor code

changes for better execution in prod environment.

● Promoted the updated code to LINUX prod server, supported the code in UAT and

production server for the first successful run.

● Responsible for handing abends and failures while execution in UAT and PROD, Also

provided the quick resolution and fixed the issues.

● As a scheduling tool TWS is being used for monitoring and job scheduling.

Internal Only

Personal Details

Father’s Name : Mr. G.P Rawat

● Date of Birth 28thJuly, 1990


Nationality : Indian

Languages Known : English, Hindi

Marital Status : Single

Current Address : Narsingi, Hyderabad

Pan Card : BQCPR3109L

Contact this candidate