SUMMARY

• Experience in using ETL tool extensively IBM InfoSphere/WebSphere DataStage, Ascential DataStage and SSIS. Worked on DataStage client tools like DataStage Designer, DataStage Director and DataStage Administrator.
• Took part in different aspect of a systems development life cycle of different projects including Requirement Gathering, Data Modeling, Development, Production support, Maintenance and Performance tuning.
• Extensively worked on using Datastage Client components like Datastage Designer Administrator, Director and Manager in Data Warehouse ETL development.
• Having a profound knowledge and good understanding in the principles of Data warehousing concepts and also in using Dimensional Modeling, Fact Tables, Dimension Tables, Data Marts, star/snowflake schema modeling.
• Experienced in designing and scheduling sequence, parallel and server jobs using Extracted and worked on data from various data sources such as Oracle, MS - SQL Server, MS - Access, Teradata, DB2, XML and Flat files.
• DataStage Designer and DataStage Director, also implementing UNIX scripts and scheduling tools.
• Having experience in using different types of Stages like Join, Transformer, Aggregator, Merge, Change Capture, Lookup, Sort, Remove Duplicate, Funnel, Filter, Pivot, Shared containers for developing different jobs.
• Wide Knowledge in using PL/SQL to write stored procedures, functions, and triggers.
• Extensive experience in Unit Testing, Functional Testing, System Testing, Integration Testing, Regression Testing, User Acceptance Testing and Performance Testing.
• Used the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions (on an ad hoc or scheduled basis).
• Adept at running Datastage director, viewing job logs, finding errors and fixing them in given time.
• Experience in Production Support, extensively worked on production support issues.
• Imported the required Metadata from heterogeneous sources at the project level.
• Good Knowledge on Business Intelligence Development studio.
• Extensively used BI Integration Services to design ETL process and BI Analysis Services to create cubes.
• Project Management experience with excellent problem-solving, organization and leadership skills.
• Quick learner and adaptive to new and challenging technological environments.

TECHNICAL SKILLS

ETL: IBM Information Server, Data Stage 9.1/8.5/7.5.2, (Administrator, Manager, Designer, Director, Orchestrate, Information Analyzer, Quality Stage)

Operating Systems: IBM AIX 4.3, DG UNIX. Windows XP/Windows 7, Linux

Database: Oracle 11g/10g/9i, Teradata, SQL Server 2005/2008, DB2 on AIX

Languages: Shell Scripts (Bourn), SQL, PL/SQL.XML, Java, C/C++

Scheduling Tools: Tivoli workload Scheduler 8.5.1, Crontab Utility, AutoSys 11.3

Other Tools: Erwin 8.2, HPQC, Microsoft Visio 2007, Microsoft Office 2010

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Sr ETL Consultant

Responsibilities:

• Involved extensively in the data migration team to build the Re-usable Datastage job templates, common parameter sets, common Datastage job containers, SQL extract procedures and common re-usable shell scripts.
• Worked with business analyst to identify, develop business requirements, transform it into technical requirements and responsible for deliverables.
• Implemented Join, Lookup, Aggregates, Filters, Rank and Update Strategy transformations.
• Worked towards optimal performance when using Stages like lookup, join, and merge.
• Extensively worked with DataStage 9.1 V - Designer and Director to load data from source extract files to warehouse.
• Provide the staging solutions for Data validation and Cleansing with PL/SQL and Datastage ETL jobs.
• Created Datastage jobs to load data from sequential files, CSV, Flat files, SQL Server and Oracle.
• Cleansed, Standardize data using Quality stage.
• Developed various jobs using ORA OCI, ODBC, Aggregator, Sequential file stages.
• Designed and developed DataStage jobs for Loading Staging Data from different sources like Oracle, SQL Server DB into Data Warehouse applying business rules which consists data loads, data cleansing, and data massaging.
• Used the Datastage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions
• Created Shared Container to simplify the Datastage Design, and used it as a common job component throughout the project.
• Encompasses Database designing, ETL phases of Data Warehousing. This is achieved with an emphasis on relational data modeling and dimensional data modeling for OLTP and OLAP systems.
• Tuned DataStage jobs for better performance by creating DataStage Lookup files for staging the data and lookups.
• Worked with Metadata Definitions, Import and Export of Datastage jobs using Datastage tools functionality.
• Created Parameters and Parameter sets where ever necessary.
• Scheduled the server jobs using DataStage Director, which are controlled by DataStage engine and also for monitoring and performance statistics of each stage.
• Tuned DataStage jobs for better performance by creating DataStage Hash files for staging the data and lookups.
• Performed functional testing for new release enhancements.
• Participated actively in the team meetings with the developers for bug reviews.
• Developed Shell Scripts to automate file manipulation and data loading procedures.
• Worked with various Partitioning (Round-Robin, Hash fields, Entire, Same, modulus etc.) and Collection (Round-Robin, Ordered and Sorted Merge) techniques.
• Optimized the jobs and routines using various optimization techniques.
• Involved in creating Technical Specification Document (TSD) for the project.
• Performed debugging of some existing jobs using the Director to test and fix the errors.
• Symmetric Multi-Processing processors were used to accommodate partition parallelism.
• Unit tested DataStage Jobs in development including creating the appropriate test data.
• Used Data Stage Director for running and monitoring performance statistics.
• Scheduled existing UNIX shell scripts using crontab.
• Modified UNIX shells according to the latest business requirement.
• Created Master Job Sequencers to control sequence of Jobs using job controls.
• Enhanced the Job Performance by using proper Partitioning methods and analyzing the resources utilized using Job Monitor.

Environment: Information server - Datastage 9.1, SAP ECC, SQL Server, DB2, Oracle 10g, UNIX AIX, Crontab and Windows 7.