ETL Developer Resume

SUMMARY

Having 4+ years of experience in Data warehousing,etl tools like Ab Initio,informatica.
Having 3.2 years of experience in Data warehousing,etl tool like Ab Initio.
Worked 10 months of experience in Data warehousing,etl tool like informatica.
Good knowledge in Star Schema and Snowflake Schema.
Worked wif different data sources like Flat Files and Database like Oracle.
Developed AbInitio Graphs using various Transform components like Join,Rollup,Lookup,Reformat, Filter by Expression, Scan, and partition and de - partition components.
Experience in designing and implementing different types of mappings which includes Aggregator, Expression,lookup,Update,Router,Sequence generator transformations etc,using Informatica.
Proficient in SQL & PL/SQL programming concepts.
Good knowledge in job scheduling tool Autosys.
Soft skills - Good communication and interpersonal skills, Leadership qualities.
Have quickly acquired the additional application skills to complete the job. Interested to explore myself wif new Technologies.

TECHNICAL SKILLS

Data Warehousing (ETL): Ab Initio (GDE 3.0.2 & Co>op 3.0.2 )

Databases: Oracle

Languages: SQL

Operating systems: Windows NT/2000, UNIX.

PROFESSIONAL EXPERIENCE

Confidential

ETL Developer

Responsibilities:

Understanding Mapping Design Document and developed the graphs based on business requirements.
Ab Initio Graphs study and performing modifications during enhancements.
Developed number of Ab-Initio Graphs based on the mapping and business requirements using various Ab-Initio Components.
Involved in doing modifications for the existing graphs.
Worked on improving the performance of Ab-Initio graphs by using Various Ab-Initio performance technique’s like using lookups instead of Join’s etc.
Used Lookups wif Reformat component for fetching matched records based on the downstream process.
Worked on utility commands like m dump,m cp,m mkfs etc.
Used the sub graphs to increase the clarity of graph and to impose reusable business restrictions and tested various graphs for their functionalities.
Worked in a sandbox environment while extensively interacting wif EME to maintain version control on objects.Sandbox features like check in and checkout were used for this purpose.

Confidential

ETL Developer

Responsibilities:

Understand the Business requirement documents.
Prepared Design Specification for Low Level Technical Design Documents.
Extracting Transforming and Loading thedata from Source to Staging and Staging to Target according to the Business requirements.
Developed the transformation graphs based on business requirements.
Used various Ab Initio components of partition,de-partition,database,datasets,transform,FTP and sort to build graphs in GDE.
Participating in daily calls wif the Client and gathering the Requirements and updating the status.
Worked in a sandbox environment while extensively interacting wif EME to maintain version control on objects.Sandbox features like check in and checkout were used for this purpose.
Worked wif de-partition components Gather,Merge which will be used for add the files which is done partition for fast process of data files.
Involved in Unit testing and debugging Ab initio graphs.

Confidential

Responsibilities:

Studied the Technical Documents and developed mappings as per Business Requirements.
Involved in developing mapping document indicating the source tables,columns,data types, transformation required,business rules,target tables,columns and data types.
Worked wif multiple sources such as Relational Databases,Flat files for extraction using Source Qualifier and Joiner.
Extensively used Informatica client tools - Source Analyzer,Mapping designer,Mapplet Designer, Transformation Developer,Workflow Manager and Workflow monitor.
Mappings were built using Transformations like Source Qualifier,Expression,Filter, Look up,Aggregator,Update Strategy,Joiner,Sequence Generator,Sorter and Router.
Resolving any issues in transformations and mappings
Involved in Unit Testing