Senior Ab Initio developer Resume

SUMMARY:

Having 8.5 years of experience in Data Warehousing applications using Ab Initio and Informatica.
Good understanding of Data warehousing and ETL concepts.
Adept in developing ETL logic using Ab Initio and Informatica.
Knowledge on Talend Open Studio.
Expert in ETL Bug Fixing.
Experience in working with various data sources.
Fairly good understanding of Software Development Life Cycle (SDLC) process.
Good knowledge in SQL and PL/SQL concepts.
Experience in developing UNIX shell scripts.
Expertise in job scheduling using Autosys.
Excellent analytical, problem solving and communication skills.

TECHNICAL SKILLS:

ETL Tools: Ab Initio (Coop sys 3.1/2.15, GDE 3.2/1.15), Informatica 7.1

Database: Oracle 8i/9i/11i/12c, Teradata, DB2v8 and SQL Server 2005

Operating Systems: Windows XP/2000 and UNIX.

Programming Languages: C, C++, Java, PL/SQL

Scheduling Tools: Autosys and CA7

Reporting Tools: Tableau 9.2

PROFESSIONAL EXPERIENCE:

Confidential

Senior Ab Initio developer

Responsibilities:

Confidential

Sr AbInitio Developer

Responsibilities:

Confidential

Sr AbInitio Developer

Responsibilities:

Environment: Ab Initio (GDE 1.15, Co-Op sys 2.15), Sun Solaris-UNIX, Teradata, Oracle 11i and CA7

Confidential

Sr AbInitio Developer

Responsibilities:

Analyze the requirements and come up with the design document representing the same.
Development of new Ab Initio graphs.
Development of plans to define the workflow.
Writing shell scripts.
Developing wrapper scripts to run Ab Initio graphs
Played vital role in identifying the defects and provided concrete solutions.
Preparing and updating checklists, review logs, defect logs and unit test cases.
Involved in unit testing and UAT.
Review and analyze the graphs to improve performance.
Preparing JIL files for job scheduling in Autosys.

Environment: Ab Initio (GDE 1.15, Co-Op sys 2.15), Sun Solaris-UNIX, DB2v8, Autosys

Confidential

Developer

Responsibilities:

Environment: Ab Initio (GDE 1.14, Co-Op sys 2.14), Sun Solaris-UNIX, DB2v8, Autosys

Confidential

Developer

Responsibilities:

Involved in loading data from Source Legacy systems to staging area and then load data into target tables.
Involved in the development of mappings using various transformations like Source Qualifier, Normalizer, Expression, Lookup, Filter, Rank and Joiner and Sequence Generator
Used Mapping parameters while running the sessions
Performance tuning at mapping level and session level
Involved in testing.
Reviewing the code as per the business rules and provide specifications
Involved in fixing up the defects in mappings
Preparing test cases and reviews the test results.

Environment: Informatica Power Center 7.1.3, SQL Server 2005, Windows-XP