ETL (Abinitio) Developer Resume

SUMMARY:

Profoundly talented and resourceful Abinito (ETL) developer with more than 4 years of experience in preparation of detailed design, development of Abinito graphs, unit testing, Analysis, Maintenance and implementation activities for various complex BFSI projects.
Proven track record of successfully delivered many defect free project releases.
Well known with the concept, design and development of Data Marts, Data Warehouse using Star Schema and Snowflake Schema in implementing Decision Support System.
Strong Data warehousing experience using Ab Initio 2.13/2.14/2.15, Unix Shell scripting, Teradata
Technically worked extensively on Teradata utilities like Fast Load, Multi Load, Fast Export, TPump and BTEQ.
Have worked in RUMBA BI MF application for executing ETL jobs from OPCZ scheduler.
Exceptionally organized with great ability to work on multiple projects at once.
Exceptional flexibility and ability to work independently and in a team.
Worked under extremely tight deadlines with successful delivery of the project.
Exposed to coordinating with several external teams as part of my current onsite assignment in Mexico.

TECHNICAL SKILLS:

Operating Systems: Unix, Linux.

Languages: Unix Shell Script, SQL.

Database Skills: Teradata

Database Tools: Teradata SQL Assistant

Version Control Tools: Abinitio EME

ETL Tools: Abinitio - 2.14 and 3 versions, RUMBA BI MF appln, SSH-Tectia Client

PROFESSIONAL EXPERIENCE:

Confidential

ETL (Abinitio) Developer

Responsibilities:

Responsible for requirements gathering, project formalization, project scoping.
Design reviews and walkthrough of all technical deliverables.
Set up NDM connectivity between the new systems and US DWH system.
Interacted with different source systems to get a clear idea about the data level changes and identified the impacts at DWH end.
Involved in creation of detailed level document and designed the jobs.
Worked with end-users to collect business requirements, functional and reporting design specifications
Developed a lot of UNIX shell scripts to perform various tasks
Worked on improving the performance of Abinito graphs by using Various Abinito performance techniques like using lookups (instead of joins), In-Memory Joins, In - Memory sorts and rollups to speed up various Abinitio Graphs
Created standard check scripts for automatic standard check in test region.
Involved in code review for performance improvement in job execution time.
Fixed the defects raised by the QA team during testing with in the time.
Involved in preparation of unit test plans and unit testing.
Supported SIT/UAT testing process.

Confidential

ETL (Abinitio) Developer

Responsibilities:

Identified the Impacts to the existing system based on the new requirement and the provided LOE for development efforts
Researched the difference in functionality between the versions and provided an alternative solution.
Performed Testing activities under various environments
Participated in Weekly and Monthly Review Meetings
Contributed largely in the performance tuning of ETL
Analysis of the specifications provided by the clients, Preparation of Design Docs, Test Case, and Implementation documents.
Involved in Creation of Schedule sheet by analyzing the interdependencies across applications and jobs
Actively involved in gathering the feedback from the users to develop strategies to further tweak the system to achieve better results

Confidential

ETL (Abinitio) Developer

Responsibilities:

Actively participated in architecting the new application and prepared the DLD.
Worked in all the database operations using Teradata.
Impact analysis for any changes or new implementation on production
Prepared and executed Unit and Integration test cases.
Created Ab Initio Reusable graphs
Developed Wrapper scripts for executing the Abinitio Jobs.
Coordinate and Communicate with the Onsite.
Given code walk through/ induction on the project to other team members
Created a Production support document and documented the Test case work book, High level Design and Detail Design documents
Involved in review of design and code
Involved in SIT/UAT support to fix code issues.
Involved in Post Implementation support.

Confidential

ETL - (Abinitio) Developer

Responsibilities:

Was involved in the design and implementation of various enhancements.
Worked with end-users to collect business requirements
Used Ab Initio graphs to load data into the Teradata database.
Developed parameter sets for the Ab Initio graphs to run a graph with different inputs.
Involved in preparation of ETL design documents.
Created ETL activity graphs through Ab Initio & Teradata Utilities .
Involved in System test plan creation based on the requirement and design document.
Involved in preparation of unit test plans and unit testing.
Migrating and deploying the ETL code in QA and UAT environments.