Datastage developer Resume

SUMMARY

A Dynamic IT professional with 7+ years of work experience in Data Analysis, design and development of ETL applications.
Actively involved in the Complete Project Life Cycle from user requirements, Analysis, Design, Development and implementation.
Good understanding of Relational Database Management Systems like Data warehousing concepts, Relational Database Management Systems and Dimensional modeling (Star schema and Snowflake schema).
Strong working experience on Data Warehousing applications, directly responsible for the Extraction, Transformation and Loading (ETL) of data from multiple sources into Data Warehouse.
Extensive knowledge in handling slowly changing dimensions.
Experience in Data warehouse development, ETL (DataStage), ETL testing, Data Stage implementations and support.
Extensive hands - on using DataStage client components, DataStage Director, DataStage Manager (prior to 8x release), DataStage Designer.
Familiar with new enhancements in the IBM Web sphere DataStage - Multiple Job Compile, Surrogate key generator Stage, Job Report, Message handler options.
Expertise in Data Mirror with Datastage 8.1/7.5 using change data captures stage.
Developed efficient mappings for data extraction/transformation/loading (ETL) from different sources to a target data warehouse.
Proficient in all phases of the development lifecycle, coherent with Performance Tuning, Unit Testing, experience in design and implementation of Server and Parallel jobs including Job Sequencers.
Strong interpersonal, written and verbal communication skills. Highly organized, detail-oriented professional with strong technical skills.
Effective Interpersonal skills to co-ordinate and participate in a team environment and achieve organizational goals.

TECHNICAL SKILLS

ETL: IBM Data Stage PX/EE 8.1,Ascential/7.5.x, Manager, Designer, Director, Parallel Extender, MetaStage, Quality stages, Information Analyzer.

Dimensional Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling.

RDBMS: Oracle 10g/9i, IBM DB2 UDB 8.0/7.0, MS SQL Server 2005/2000, Teradata 12, ODBC, MS Access.

Operating Systems: Windows XP/NT/2000/VISTA, UNIX (Sun Solaris, Linux, HP-UX, AIX)

Programming Languages: C, C++, SQL, PL/SQL, HTML.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship