DataStage Designer Resume

SUMMARY

Over 8 years of experience in analysis, design, modeling, development, implementation and testing of Data modeling, Data warehouse Design, Development and Testing using ETL and Data Migration life cycle using IBM WebSphere DataStage 9.x, 8.x/7.x (DataStage Designer, Data Stage Manager, DataStage Director and DataStage Debugger)
Efficient in all phases of the development lifecycle, coherent with Data Cleansing, Data Conversion, Performance Tuning and System Testing.
Expertise in building Operational Data Store (ODS), Data Marts, OLTP/OLAP System Study, E - R modeling. Involved in Designing Dimensional Model (Star schema and Snowflake schema), Decision Support Systems (DSS) using Multi Dimensional Model (Kimball and Inmon), Fact and Dimensional Tables, Slowly Changing Dimensions. Worked with CDC (Change Data Capture).
Experience in analyzing the data generated by the business process, defining the granularity, source to target mapping of the data elements, creating Indexes and Aggregate tables for the data warehouse design and development.
Great expertise in designing, developing, testing and also in migrating DataStage jobs from Development System to Test System and eventually to Production System for Operational Data Store and Data Warehouse.
Excellent experience in using Stages like Complex Flat File, Dataset, Copy, File set, Oracle Enterprise, Join, Sequencer, Aggregator, Merge, Filter, Transformer, Lookup, Funnel, Compress, Stored Procedure, DB2 load, etc.,
Efficient in incorporation of various data sources such as Oracle, MS SQL Server, and DB2, Sybase, XML and Flat files into the staging area.
Worked with most of the parallel stages applying different partitioning techniques.
Expertises in UNIX shell scripting.
Developed Test Scripts, Test Cases, and SQL QA Scripts to perform Unit Testing, System Testing and Load Testing. Migrated Code from Development to Testing, UAT and Production.
Involved in Performance Fine Tuning of ETL programs. Tuned DataStage and Stored procedures Code.
Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels.

TECHNICAL SKILLS

ETL: IBM InfoSphere DataStage 8.5, 9.1, 11.3 (DataStage Designer, Manager, Director and Administrator)

Databases: Netezza 7.x, DB2 9.x, Oracle 11g/10g/9i, Microsoft SQL Server 2000, 2005, TeraData V6, R13, Sybase, SQL, PL/SQL

Programming/Others: UNIX Shell Scripting, SQL, PL/SQL, SQL*Plus 3.3/8.0

Schedulers: Autosys, Maestro and Cron

Data Modeling Tools: Erwin 7.x, 4.x

Operating Systems: Solaris 2.x/8, Linux 7.1/7.2/8, IBM-AIX, HP UX, SCO-UNIX, Windows 2000 Server/Advanced Server, Windows 95/98/2000/XP, OS/390

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship