IBM DataStage Developer/Administrator Resume

SUMMARY:

A self - organized and motivated seasoned professional with more than 6.7 years of experience in the ETL Development and infrastructure Implementation for diversified domain. An insightful experience in IBM DataStage, Informatica, Tableau and Cognos.

SKILL:

IBM DataStage 11.5 IBM Cognos

PL/SQL Oracle

IBM DB2 SQL server

Data warehousing PowerShell

Informatica SVN

EXPERIENCE:

IBM DataStage Developer/Administrator

Confidential

Responsibilities:

Designed and Developed Data stage Jobs to Extract data from heterogeneous sources, Applied transform logics to extracted data and Loaded into Data Warehouse Databases.
Created DataStage jobs using different stages like Transformer, Aggregator, Sort, Join, Merge, Lookup, Data Set, Funnel, Remove Duplicates, Copy, Modify, Filter, Change Data Capture, Change Apply, Sample, Surrogate Key, Column Generator, Row Generator, Etc.
Extensively worked with sequential file, dataset, file set and look up file set stages.
Developed complex store procedures using input/output parameters, cursors, views, triggers and complex queries using temp tables and joins.
Maintained Data Warehouse by loading dimensions and facts as part of project.
Also worked for different enhancements in FACT tables.
Developed Test Plan that included the scope of the release, entrance and exit criteria and overall test strategy.
Created detailed Test Cases and Test sets and executed them manually

IBM DataStage Developer

Confidential

Responsibilities:

Provided assistance for definition, structuring and documentation of data sources as per requirements.
Assisted in designing and development of complex ETL structures for transformation of data sources into data warehouses.
Designed codes for data access along with stored procedures and current SQL queries.
Conducted reviews of database designs and system integration issues for further improvements.
Resolved troubleshooting problems relating to ETL applications and data issues.
Implemented procedures for validation, reconciliation of metadata and error handling in ETL processes.
Analyzed database designs and system integration processes to make suggestions for further enhancement.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship