CAREER GOAL:

Highly Motivated, Solutions Driven with over 8 years of Data Warehousing experience in the areas of ETL design and Development. Involved in complete Software Development life - cycle (SDLC) of various projects, including Requirements gathering, System Designing, Data modeling, and ETL design, development, Production Enhancements, Support and Maintenance. Excellent Interpersonal and communication skills with an ability to remain highly focused and self-assured in fast-paced and high-pressure environments.

EXPERIENCE SUMMARY:

• Having 9+ years of experience both I.T and ITES of which 8 yrs of ETL process using Data Stage 9.1, 8.1, Quality Stage and Pentaho Kettle 5.0.1.
• Extensive ETL tool experience using IBM Infosphere/WebSphere DataStage, Ascential DataStage.
• Worked on DataStage tools like DataStage Designer, DataStage Director and DataStage Administrator.
• Installation of Data stage on windows/Linux server and providing access to all users working on data stage
• Strong understanding of the principles of Data Warehousing using fact tables, dimension tables and star/snowflake schema modeling.
• Worked extensively with Dimensional modeling, Data migration, Data cleansing, ETL Processes for data warehouses.
• Developed parallel jobs using different processing stages like Transformer, Aggregator, Lookup, Join, Sort, Copy, Merge, Funnel, CDC, Change Apply and Filter.
• Used Enterprise Edition/Parallel stages like Datasets, Change Data Capture, Row Generator and many other stages in accomplishing the ETL Coding.
• In Pentaho Kettle Extensively Used transformations like lookups, Join, Filters, Sequence generator, Calculator, JavaScript, Sort, user defined java expression etc.
• Experienced in scheduling Sequence and parallel jobs using DataStage Director, UNIX scripts and Control M scheduling tools.
• Experience in troubleshooting of jobs and addressing production issues like data issues, ENV issues, performance tuning and enhancements.
• Extensive experience in Unit Testing, Functional Testing, System Testing, Integration Testing, Regression Testing, User Acceptance Testing (UAT) and Performance Testing.
• Worked with various databases like Oracle 10g/9i/8i, DB2, SQL Server.
• Worked on Client tools like HP Service Desk, Control M and PVCS Dimensions.
• Documentation in accordance with Company/Client standards and processes.
• Ability to meet deadlines and handle multiple tasks, flexible in work schedules.
• Posse’s good communication and Presentation skills.
• Ability to work under pressure.
• Worked on Agile and Scrum Methodologies.
• Good knowledge about the SDLC.

TECHNICAL SKILLS:

Data Warehousing ETL Tools: Data stage 8.1, 9.1, Pentaho Kettle 5.01,Trained on Informatica

Quality Stage: Information Analyzer, Match stage, Address cleansing.

Databases: Oracle 8i/9i/10g/11g, SQL Server 2008/2012

Languages: PL/SQL, SQL, Unix shell scripting.

Operating Systems: UNIX, Linux, Microsoft 2003/2000/ NT/98/95

Defect tracking Tool: Jira, Quality Center

Change Management tool: MSTFS, Source Tree(Git)

Version Control Tool: SVN

Job scheduling Tool: Control M, Cron job and Windows scheduler

Others: MS Word, Excel, VISIO 2007

CHRONOLOGY OF EXPERIENCE BY CLIENT:

Confidential

Senior Consultant

Environment: Pentaho Kettle, SQL server 2012.

Responsibilities:

• Studying the Source system and Confidential tables.
• Creating the HLD’s and LLD docs based upon the Functional Specification given by the onsite team.
• Extensively Used transformations like lookups, Join, Filters, Sequence generators, Calculator, JavaScript, Sort, user defined java expression etc.
• Involved in Unit Testing, CIT and provided assistance to onsite team in UAT.

Confidential

Senior Software Engineer

Environment: Data stage 8.1, SQL server 2008, UNIX

Responsibilities:

• Analyzed, designed, developed, implemented and maintained Parallel jobs using IBM info sphere Data stage.
• Worked SCDs to populate Type I and Type II slowly changing dimension tables from several operational source files.
• Experienced in PX file stages that include Complex Flat File stage, Dataset stage, and Sequential file stage.
• Implemented Shared container for multiple jobs and Local containers for same job as per requirements.
• Adept knowledge and experience in mapping source to Confidential data using IBM Data Stage 8.x
• Implemented multi-node declaration using configuration files (APT Config file) for performance enhancement.
• Experienced in developing parallel jobs using various Development/debug stages (Peek stage, Head & Tail Stage, Row generator stage, Column generator stage, Sample Stage) and processing stages (Aggregator, Change Capture, Change Apply, Filter, Sort & Merge, Funnel, Remove Duplicate Stage)
• Debug, test and fix the transformation logic applied in the parallel jobs
• Involved in creating UNIX shell scripts for database connectivity and executing queries in parallel job execution.
• Used the ETL Data Stage Director to schedule and running the jobs, testing and debugging its components & monitoring performance statistics.
• Successfully implemented pipeline and partitioning parallelism techniques and ensured load balancing of data.
• Deployed different partitioning methods like Hash by column, Round Robin, Entire, Modulus, and Range for bulk data loading and for performance boost.
• Repartitioned job flow by determining Data Stage PX best available resource consumption.
• Worked on designing and developing the Quality stage.

Confidential

Senior Software Engineer

Environment: Data Stage 8.1, SQL Server 2008, UNIX.

Responsibilities:

• Extensively used Data Stage for extracting, transforming and loading databases from sources including Oracle, DB2 and Flat files.
• Collaborated with EDW team in, High Level design documents for extract, transform, validate and load ETL process data dictionaries, Metadata descriptions, file layouts and flow diagrams.
• Collaborated with EDW team in, Low Level design document for mapping the files from source to Confidential and implementing business logic.
• Generation of Surrogate Keys for the dimensions and fact tables for indexing and faster access of data in Data Warehouse.
• Tuned transformations and jobs for Performance Enhancement.
• Extracted data from flat files and then transformed according to the requirement and Loaded into Confidential tables using various stages like sequential file, Look up, Aggregator, Transformer, Join, Remove Duplicates, Change capture data, Sort, Column generators, Funnel and Oracle Enterprise.
• Created Batches (DS job controls) and Sequences to control set of jobs.
• Collaborated in design testing using HP Quality Center.
• Extensively worked on Job Sequences to Control the Execution of the job flow using various Activities & Triggers (Conditional and Unconditional) like Job Activity, Wait for file, Email Notification, Sequencer, Exception handler activity and Execute Command.
• Developed DS jobs to populate the data into staging and Data Mart.
• Executed jobs through sequencer for better performance and easy maintenance.
• Performed the Unit testing for jobs developed to ensure that it meets the requirements.
• Modified UNIX shell scripts to automate file manipulation and data loading procedures.
• Responsible for daily verification that all scripts, downloads, and file copies were executed as planned, troubleshooting any steps that failed, and providing both immediate and long-term problem resolution.
• Provided technical assistance and support to IT analysts and business community.

Confidential

Environment: Data Stage 7.5.1, DB2, UNIX

Responsibilities:

• Worked on Data Stage Designer, Manager, Administrator and Director.
• Worked with the Business analysts and the DBAs for requirements gathering, analysis, testing, and metrics and project coordination.
• Involved in extracting the data from different data sources like Oracle and flat files.
• Involved in creating and maintaining Sequencer and Batch jobs.
• Creating ETL Job flow design.
• Used ETL to load data into the Oracle warehouse.
• Created various standard/reusable jobs in Data Stage using various active and passive stages like Sort, Lookup, Filter, Join, Transformer, aggregator, Change Capture Data, Sequential file, Datasets.
• Involved in development of Job Sequencing using the Sequencer.
• Used Remove Duplicates stage to remove the duplicates in the data.
• Used designer and director to schedules and monitor jobs and to collect the performance statistics.
• Extensively worked with database objects including tables, views, indexes, schemas, PL/SQL packages, stored procedures, functions, and triggers.
• Creating local and shared containers to facilitate ease and reuse of jobs.
• Implemented the underlying logic for Slowly Changing Dimensions.
• Worked with Developers to troubleshoot and resolve issues in job logic as well as performance.
• Documented ETL validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.

Confidential

Team Member

Environment: Data Stage 7.5.1, DB2, UNIX

Responsibilities:

• Studying the Source system and Confidential tables.
• Creating the HLD’s and LLD docs based upon the Functional Specification given by the onsite team.
• Developing the different types of Jobs using Data stage designer.
• Extensively using stages like DB2, Transformer, Lookup, Joiner, Filter, Funnel, Copy, Remove Duplicate, Sorter, and Aggregator etc.
• Involved in Unit Testing, CIT and provided assistance to onsite team in UAT.Created RFC and W.O using the HPSD Tool.

Confidential

Team member

Environment: Data Stage 7.5.1, DB2, UNIX

Responsibilities:

• Preparing the HLD’s and LLD’s. Developing the different types of Jobs using Data stage Designer.
• Extensively used stages like DB2, Transformer, Lookup, Joiner, Filter, Funnel, Copy, Remove Duplicate and Aggregator
• Involved in Unit Testing, CIT and provided assistance to onsite team in UAT
• Created RFC and W.O using the HPSD Tool. Used Serena Dimensions for Version control.
• Monitored the production flow and provided post implementation results to the Onsite team.