We provide IT Staff Augmentation Services!

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.

Hire Now