Abinitio Consultant Resume
0/5 (Submit Your Rating)
Charlotte, NC
SUMMARY
- Having 8+ years of experience in Information Technology with special emphasis on Design, Development and implementation of Data Warehousing in banking domain.
- Extensive experience in all the phases of the Data warehouse life cycle involving Design, Development, Analysis, Testing and migration in the various areas of Data warehousing.
- Good working knowledge of Data Warehousing techniques and Concepts experience with ETL processes.
- Hands on experience in Creating Ab initio Graphs, Plans, Pset’s, Autosys scheduling tool.
- Extensively worked on AbInitio (ETL Tool) and good experience Transform components, Partition components and Departition components.
- Experience in various Ab Initio parallelism techniques and implemented Ab Initio Graphs using Data parallelism.
- Good Hands on M Commands and AIR commands in Ab Initio.
- Experience and expertise on SQL and UNIX Commands.
- Experience in configuring and monitoring jobs in Autosys scheduling tool.
- Demonstrated ability to complete multiple assignments simultaneously and maintain high standards of client organizations.
- Very strong mix of academic and professional experience in the related area, demonstrated through the implementation of successful projects and diverse roles.
- A self - starter, team player, worked on fast-faced development environments committed to the deliverables and all my experience include Agile SDLC.
TECHNICAL SKILLS
Operating Systems: UNIX, WIN-9X,WIN-XP
Languages: SQL, Shell Scripting
Databases: ORACLE 10g.,SqlServer2005,2008,DB2
Tools: & Utilities: Ab Initio GDE - 3.0.2, 3.1.5.3,3.2.6,Autosys
Domain Knowledge: Banking
PROFESSIONAL EXPERIENCE
Confidential, Charlotte, NC
Technology/Software: AbInitio, Unix, Oracle
Abinitio Consultant
Responsibilities:
- Interacting with the client to understand the requirements. Analyzing requirements.
- Involved in Creation of design document (HLD & LLD) based on the Business requirement.
- Involved in Design of various graphs using AbInitio.
- Design, develop and Unit Test Ab Initio graphs using GDE for Extraction, Transformation and Loading of data from source to target.
- Created Ab Initio graphs, utilizing Rollup, Join, Sort, Replicate, Partition components to speed up the ETL process.
- Modifying the existing graphs to fix the problem request.
- Documenting the failures and their solutions for future use.
- Performed unit testing.
Confidential
Technology/Software: AbInitio, Oracle, Unix
Senior Abinitio Developer
Responsibilities:
- Interacting with the client to understand the requirements. Analyzing requirements.
- Worked on new enhancements for the change request coming from Business
- Involved in Design of various graphs using AbInitio
- Modifying the existing graphs to fix the problem requests
- Involved in post deployment activities
Confidential
Technology/Software: AbInitio, Oracle, Unix.
ETL developer
Responsibilities:
- Interacting with the client to understand the requirements. Analyzing requirements.
- Developed Low Level Design Documents based on the Business requirement.
- Extensively used various components like Input, Output (Table/File), Filter by expression, Rollup, Sort with in groups, Dedup sort, Reformat and Join.
- Read Excel component is extensively used to convert all tabs in excel to .CSV
- Created Framework like AbInitio Job Audit Capture.
- Improve the performance of AbInitio graphs by using various AbInitio performance techniques.