ETL Developer Resume

SUMMARY

I have 3.6 years of experience in Data Warehousing as an ETL Developer using IBM Info sphere Data stage 8.5, 9.1 and 11.5v.
Good knowledge on Data Warehousing and ETL concepts.
Comprehensive hands on experience on developing Parallel jobs using Data stage Designer and Performance monitoring using Data stage Director.
Actively involved in Development, Performance tuning and Unit testing of Parallel jobs.
Effectively worked with Oracle database.
Good knowledge of SQL and UNIX.
Having knowledge in DWH concepts like Star Schema, Snow Flake Schema, Facts, Dimensions, Fact less Fact, Degenerated Dimension, ODS, Data Mart, SCD, DWH life Cycle etc.
Developed Parallel jobs by using the stages like Join, Lookup, Merge, Funnel, Sort, Copy, Aggregator, Transformer, Modify, Filter, Remove Duplicates and Surrogate Generator etc..
Good Experience in Import/Export Jobs from Development to Production Environment.
Ability to perform independently as well as in team environments
Have always worked for the optimum user satisfaction which has lead to great acknowledgement from the user.
Very disciplined, organized, amicable, self - motivated, proactive, quick learner and a result oriented team player with excellent communication skills

PROFESSIONAL EXPERIENCE

Confidential

ETL Developer

Environment: IBM Info sphere data stage 7.5v/8.5v, Oracle 10g, UNIX and Windows 2003.

Responsibilities:

Enhancing the source and target definitions to in corporate the new fields added in the source and Target.
Enhancing the ETL logic in various transformations like Sort, Lookup, Filter, Aggregator, and Transformer in the development of Data stage jobs.
Used Datastage Director for running and monitoring jobs.
Involved in creating Data Stage jobs for Dimensions and implemented Slowly Changing Dimensions.
Involved in interacting with different source systems like Oracle database and flat files.
Used job parameters and various environmental variables in all the data stage jobs within the project.
Performing unit testing on the jobs developed.

Confidential

ETL Developer

Environment: IBM Web Sphere Data stage 8.5, Oracle,Db2 & Unix

Responsibilities:

Understanding and analyzing the application related documents
Involved in building Enterprise Data warehouse, conforming data from different databases and files to form a single schema using IBM DataStage.
Analyze the source systems for information required in the Data Warehouse.
Developed Data stage jobs by using various stages to load data from various source systems to target databases.
DataStage Designer was utilized for developing mappings using stages, which includes Transformer, Join, Lookup, Merge, Funnel, Filter, Oracle Enterprise Stage, Sequential File, Dataset, Copy, and Modify Stage.
Importing and Exporting DataStage jobs.
Performed unit testing and Preparation of unit test cases.
Worked with FTP connections to store the files in remote server.
Fine tuned DataStage jobs and SQL statements for performance improvement.