We provide IT Staff Augmentation Services!

Sr. Etl Abinitio Developer/ Lead Resume

ChicagO

SUMMARY:

  • Over 8+ years of overall IT experience as a ETL/Data warehouse Developer with extensive project lifecycle Experience in Design, Development, Implementation and testing of various sized applications using ETL Tools.
  • Over 6 years of Abinitio experience in ETL, Data Mapping, Transformation and Loading from Source to Target Databases in a complex, high - volume environment.
  • Designed and deployed well-tuned Ab Initio graphs.
  • Worked on Autosys, creation of JILS for scheduling.
  • Practical experience with various Ab Initio components such as Join, Rollup, Scan, Reformat, Partition by Key, round robin, gather, merge, Dedup sorted etc
  • Extensive experience with EME for version control, impact analysis and dependency analysis.
  • Experience in Scheduling, Production Support and Troubleshooting for various ETL Jobs.
  • Experienced in developing UNIX shell wrapper scripts to run Ab Initio graphs. Practical experience with working on multiple environments like production, development, testing.

TECHNICAL SKILLS:

ETL Tools: Ab Initio (GDE 3.2, Co-Operating System 3.2), EME, Oracle SQL* plus.

Database Tools: Oracle SQL Developer 2010 version 3.1

Tools: Squirrel, Tivoli Workload Scheduler, Altova XML Spy, Putty.

Programming Languages: SQL, UNIX Shell Scripting, SQL*Plus, Oracle SQL, JIL (Autosys).

Operating Systems: Windows 2007, UNIX, LINUX

PROFESSIONAL EXPERIENCE:

Confidential, Chicago

Sr. ETL AbInitio Developer/ Lead

Responsibilities:

  • Worked in onshore-offshore model.
  • Worked as a lead for the offshore/onshore developers to resolve queries and guide in respective processes.
  • Responsible for Design the technical design document and estimates the hours for ETL project.
  • Closely work with business users to gather the requirements and also responsible for creating mapping documents.
  • Developed Complex Ab Initio XFRs to meet the business requirements.
  • Actively participated in ETL code review sessions to get approvals form DEV to QA.
  • Interact with Release Management, Configuration Management, Quality Assurance, Database Modeling Support, other Development teams and Operations
  • Good experience on EME and migrate AbInitio objects to various environments.
  • Developed JIL’s to customize the ETL Ab Initio Graphs at runtime.
  • Responsible for debugging QA, prod batch jobs if any abends on weekly basis.
  • Experienced in represent as ETL contact person for all cross work stream projects for any files consume/creations.
  • Responsible for data requests and pulling the data out of PROD to downstream & source application.
  • Communicated directly with clients to gather information for the various development projects.
  • Understanding the requirement and implementing the transformations using the Data Mapping and Interface Design document.

Environment: AbInitio (GDE 3.2, Co-Operating System 3.2), EME, DB2, SQL 3.1, LINUX, Windows 7.

Confidential, Northbrook

Sr. ETL/Ab Initio Developer

Responsibilities:

  • Implemented various ETL projects in Confidential .
  • Worked in onshore-offshore model.
  • Responsible for Design the technical design document and estimates the hours for ETL projects
  • Closely work with business users to gather the requirements and also responsible for creating mapping documents.
  • Developed Complex Ab Initio XFRs to meet the business requirements.
  • Actively participated in ETL code review sessions to get approvals form DEV to QA.
  • Interact with Release Management, Configuration Management, Quality Assurance, Database Modeling Support, other Development teams and Operations
  • Good experience on EME and migrate Abinitio objects to various environments.
  • Developed shell scripts to customize the ETL Ab Initio Graphs at runtime.
  • Responsible for debugging QA, prod batch jobs if any abends on weekly basis.
  • Involved in modifying the Ab-initio generic graph and wrapper scripts for unloading data from source systems.
  • Experienced in represent as Confidential ETL contact person for all cross work stream projects for any files consume/creations.
  • Responsible for data requests and pulling the data out of PROD to downstream & source application.
  • Communicated directly with clients to gather information for the various development projects.
  • Understanding the requirement and implementing the transformations using the Data Mapping and Interface Design document.

Environment: Abinitio (GDE 3.0.3.1, 3.15, Co-Operating System 3.15), EME, UNIX shell Scripting, DB2, SQL 2008, UNIX, Windows 7.

Confidential

Sr. ETL/Ab Initio Developer

Responsibilities:

  • Involved in Data transfer design and development for legacy data to a newly defined data model for the data warehouse.
  • Involved in meetings to gather requirements from the Business Users.
  • Used Ab Initio data cleansing functions like is valid, is defined, is error, is defined, string substring, string concat and other String, Date, Inquiry and Miscellaneous functions
  • Developed Complex AbInitio XFRs to solves rigorous and meet the business requirements.
  • Developed shell scripts to customize the ETL Ab Initio Graphs at runtime.
  • Automated the Data Loads using UNIX shell scripting for Production, Testing and development environment.
  • Involved in modifying the Ab-initio generic graph and wrapper scripts for unloading data from source systems.
  • Implemented Data Parallelism through graphs, which deals with data, divided into segments and operates on each segment simultaneously through the Ab Initio partition components to segment data.
  • Extensively used ETL to load data using Ab Initio DB components from heterogeneous source systems from DB2, Oracle etc to target DW oracle Database.
  • Involved in scheduling the jobs in Tivoli Workload Scheduler.

Environment: Abinitio (GDE 3.1.0, Co-Operating System 3.1.0), EME, UNIX shell Scripting, UNIX and Windows 7.

Confidential

Sr. ETL/Abinitio Developer

Responsibilities:

  • Developed several partition based Abinitio Graphs for high volume data warehouse.
  • Involved in all phases of the System Development Life Cycle Analysis, amp; Data Modeling.
  • Extensively used Enterprise Meta Environment (EME) for version control.
  • Extensive exposure to Generic graphs for data cleansing, data validation and data transformation.
  • Created Sandbox and edited Sandbox parameters according to repository Extensive exposure to EME.
  • Used AIR commands to do dependency analysis for all ABI objects
  • Involved in Ab Initio Design, Configuration experience in Ab Initio ETL, Data Mapping, Transformation and Loading in complex and high-volume environment and data processing at Terabytes level.
  • Extensively used Partition components and developed graphs using Write Multi-Files, Read Multi-Files, Filter by Expression, Run Program, Join, Sort, Re format.
  • Followed the best design principles, efficiency guidelines and naming standards in designing the graphs
  • Developed shell scripts for Archiving, Data Loading procedures and Validation
  • Involved in writing Unit Test scripts, support documents and implementation plan.
  • Tuned the graphs by creating Lookup files, Memory sort and Max-core parameters for maximum usage of cache memory and enhanced performance.
  • Responsible for cleansing the data from source systems using Ab Initio components such as reformat and filter by expression.
  • Used the sub graphs to increase the clarity of graph and to impose reusable business restrictions.
  • Capacity of designing solutions around Abinitio, with advanced skills in high performance and parallelism in Abinitio.

Environment: Abinitio (GDE 3.0.3.1, Co-Operating System 3.0.3.1), UNIX shell Scripting, Windows 7, DB2, UNIX.

Confidential

Sr. ETL/Ab Initio Developer

Responsibilities:

  • Interacting with business partners to gather requirements
  • Converting the business requirements into list pull specifications.
  • Wrote precise, reusable ETL specifications and patterns to facilitate development of best practices and internal competencies.
  • Used Ab Initio as ETL tool to pull data from source systems, cleanse, transform, and load data into databases.
  • Developed various informatica Graphs for data cleansing using functions like is valid, is defined, is error, string substring, string concat and other string * functions.
  • Designed parameterized generic graphs to pass the values from Wrapper script.
  • Based on business requirements, developed number of Abinitio Graphs using various Components such as Partition by Key, Partition by round robin, reformat, rollup, join, scan, gather,, merge etc.
  • Worked on improving the performance of Ab Initio graphs by using various performance techniques like using lookups (instead of joins), In-Memory Joins to speed up various Abinitio Graphs.
  • Preparing Technical Design and Test Plans.
  • Created various Unit Test Plans and System Test Plans and involved in testing.
  • Worked on scheduling of the Abinitio jobs checking the frequency and the run executions timings.

Environment: Ab Initio (GDE3.1.0), SQL Server 2000, AIX UNIX, Shell Scripts, PL/SQL, Windows 7

Confidential

ETL/Abinitio Developer

Responsibilities:

  • Developed Abinitio Graphs for retrieval of the data from upstream and loading the same to table.
  • Involved in all phases of the System Development Life Cycle Analysis, amp; Data Modeling.
  • Extensively used Enterprise Meta Environment (EME) for version control.
  • Extensive exposure to Generic graphs for data cleansing, data validation and data transformation.
  • Created Sandbox and edited Sandbox parameters according to repository Extensive exposure to EME.
  • Used AIR commands to do dependency analysis for all ABI objects
  • Involved in Ab Initio Design, Configuration experience in Ab Initio ETL, Data Mapping, Transformation and Loading in complex and high-volume environment and data processing at Terabytes level.
  • Extensively used Partition components and developed graphs using Write Multi-Files, Read Multi-Files, Filter by Expression, Run Program, Join, Sort, Re format.
  • Followed the best design principles, efficiency guidelines and naming standards in designing the graphs
  • Developed shell scripts for Archiving, Data Loading procedures and Validation
  • Involved in writing Unit Test scripts, support documents and implementation plan.
  • Tuned the graphs by creating Lookup files, Memory sort and Max-core parameters for maximum usage of cache memory and enhanced performance.
  • Responsible for cleansing the data from source systems using Ab Initio components such as reformat and filter by expression.
  • Used the sub graphs to increase the clarity of graph and to impose reusable business restrictions.
  • To coordinate with Backup team to restore the older files from tape to figure out data anomalies in Production.

Environment: Ab Initio (GDE3.1.0), SQL Server 2000, AIX UNIX, Shell Scripts, PL/SQL, Windows 7

Hire Now