Professional Summary

• Over 7 years of experience in Data warehousing in the areas of ETL design and development. Proficient in all the stages of Software Development life-cycle including System Analysis, Design, Development, Implementation, Production Support and Maintenance. Ability to work effectively and efficiently in a team and individually with excellent interpersonal technical and communicational skills.
• Extensive ETL tool experience using IBM Infosphere/Websphere Datastage, Ascential Datastage and SSIS. Worked on Datastage client tools like Datastage Designer, Datastage Director and Datastage Administrator.
• Good Knowledge about the principles of DW like Data marts, OLTP, OLAP, Dimensional Modeling, fact tables, dimension tables and star/snowflake schema modeling.
• Excellent in using highly scalable parallel processing infrastructure using parallel jobs with multi-node configuration files.
• Experienced in scheduling sequence, parallel and server jobs using DataStage Director, UNIX scripts and scheduling tools.
• Designed and developed parallel jobs, server and sequence jobs using Datastage Designer.
• Experience in using different types of stages like Transformer, Aggregator, Merge, Join, Lookup, Sort, Remove duplicate, Funnel, Filter, Pivot, Shared containers for developing jobs.
• Worked and extracted data from various data sources such as Oracle, MS-SQL Server, MS- Access, Teradata, DB2, XML and Flat files.
• 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.
• Created local and shared containers to facilitate ease and reuse of jobs.
• Proven track record in addressing production issues like performance tuning, enhancement, data, environment and memory issues.
• Knowledge in using Erwin as leading Data modeling tool for logical LDM and physical data model PDM .
• Knowledge in Reporting Tool such as Cognos.
• 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 .
• Experience in Production Support, extensively worked on production support issues and resolved them using session logs, workflow logs, and used e-mail task for capturing issues via e-mail along with the session logs.
• Strong administration skills on Data stage and WebSphere.
• Good Knowledge on Business Intelligence Development studio.
• Extensively used BI Integration Services to design ETL process and BI Analysis Services to create cubes.
• Connect to R3 systems and developed jobs to extract data from R3 systems and Info cubes.
• Worked with SAP ABAP and IDOC stages to extract data from R/3 Systems.
• Written Multi Dimensional Queries to analyze the data.
• Quick learner and adaptive to new and challenging technological environments.
• Project Management experience with excellent problem-solving, organization and leadership skills.

Technical Skills

Professional Experience

Confidential

ETL Developer

Responsibilities:

• Worked in Supply Chain management for Developing Data stage jobs.
• Created SQL Stored procedures and queries and used in the parallel jobs.
• Used Data Stage Designer to develop various jobs to extract, transform, integrate and load data into data warehouse database.
• Responsible for requirements gathering, source-to-target mapping, process flow diagrams, and documentation for Data stage project.
• Used Lookup transformations to manipulate the information.
• Used SQL Developer to created SQL Scripts to load the History and compare the data in different environments.
• Worked with OBIEE testing team to analyze and debug the SQL generated to fix the errors.
• 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.
• Extensively worked with CDC stage to capture the change records.
• Also worked on Developing Data stage Server jobs. Used Data Stage manager to export the jobs
• Provided Support during the implementation of the project.

Environment: IBM Info sphere Data Stage 9.1, Ascential Data Stage 7.5.1 Enterprise Edition Designer, Manager, Director , Oracle, UNIX, Autosys Scheduling Tool, SQL Developer.

Confidential

Sr. ETL Developer

Responsibilities:

• Designed ETL jobs using IBM Infosphere DataStage 8.5 Extract, Transform and load the data into Netezza staging, ODS and EDW.
• Created SQL views and queries and used in the parallel jobs.
• Created jobs to load data from AS400 to Netezza.
• Interacted with TCS offshore Team on Daily basis.
• Responsible for generation of DDL statements which are executed for database creation.
• Responsible for data analysis, requirements gathering, source-to-target mapping, process flow diagrams, and documentation
• Used the Director to schedule running the job, testing and debugging its components, and monitoring.
• 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.
• Designed jobs using different parallel job stages such as Join, Merge, Lookup, Filter, Dataset, Lookup File Set, Remove Duplicates, Change Data Capture, Switch, Modify and Aggregator.
• Provided Support during the implementation of the project.
• Extensively used Tableau to generate the reports for business users.

Environment: IBM Info sphere DataStage 8.5, Netezza, UNIX, SQLServer, Tableau

Confidential

Sr. ETL Developer

Responsibilities:

• Designed ETL jobs using IBM Infosphere DataStage 8.1 and IBM Infosphere DataStage 8.7 to Extract, Transform and load the data into staging, ODS and EDW.
• Managed Accenture Offshore Team and provided Technical support needed.
• Participated in Code Review and provided support during Implementation.
• Worked closely with the ETL Lead, Solution Architect, Data Modeller, Business Analysts to understand business requirements, providing expert knowledge and solutions on Data Warehousing, ensuring delivery of business needs in a timely cost-effective manner
• Responsible for data analysis, requirements gathering, source-to-target mapping, process flow diagrams, and documentation.
• Responsible for generation of DDL statements which are executed for database creation.
• Designed parallel jobs using stages such as Join, Merge, Lookup, Remove Duplicates, Copy, Filter, Funnel, Dataset, Lookup, Pivot, and Sort, Surrogate key Generator, Change Data Capture CDC , Modify, Row Generator and Aggregator.
• Worked on pipeline and partitioning parallelism techniques and ensured load balancing of data.
• Deployed different partitioning methods like Hash by field, Round Robin, Entire, Modulus, and Range for bulk data loading.
• Implemented various shared containers for Re-using the business functionality.
• Worked within a team to populate Type I and Type II slowly changing dimension tables from several operational source files
• Created UNIX shell scripts for File Transfer and File validation during parallel job execution.
• Used the ETL Data Stage Director to schedule running the solution, testing and debugging its components monitor the resulting executable versions.
• Experienced in using SQL Loader and import utility in TOAD to populate dataset in the data warehouse tables.
• Created Shared Containers for Re-using the Business functionality.
• Scheduled jobs using Autosys scheduler and CA7 utility based on the requirements and monitored the production processes closely for any possible errors.
• Constantly in touch with the Business Line to verify the requirements and create the mapping documents .
• Provided Level III Support to debug any technical issues and fixed them.
• Extensive experience as a Datastage Administrator.
• Extensively worked on the enhancements for the existing projects.

Environment: IBM Info sphere DataStage 8.1, Oracle 11g, UNIX, Oracle, DB2, Flat files, XML files, Autosys, TOAD 9.6.

Confidential

Role: Datastage Administrator/ Developer

Responsibilities:

• Used DataStage Designer to develop various jobs to extract, transform, integrate and load data into data warehouse database.
• Managed Netezza queries by performance tuning and techniques such as CBT and Collocation.
• Performed Installation and migration of IBM Websphere Datastage Enterprise Edition/PX on UNIX platforms.
• Developed several transformations in the process of building Data warehouse database.
• Worked on retrieving data from different legacy systems such as Oracle, DB2.
• Used Lookup transformations to manipulate the information.
• Interacted with User Groups/Corporate Testing Groups/Business people.
• Developed shell scripts to automate file manipulation and data loading.
• Involved in Performance Tuning of Parallel Jobs using Performance Statistics.
• Extensively worked with database objects including tables, views, indexes, schemas, stored procedures, functions, and triggers.
• Used the Director to schedule running the job, testing and debugging its components, and monitoring.
• Used Autosys to schedule jobs.
• Involved in Unit Testing of the jobs.
• Created Shell scripts for scheduling various Batch jobs.
• Ran jobs using Parallel Extender for splitting bulk data into subsets and dynamically distribute to all available nodes to achieve best job performance
• Used QualityStage to ensure consistency, removing data anomalies and spelling errors of the source.
• Created Data Model using ERwin from data sources and defined the dimensions, levels and measures in the model.
• Actively participated in the Team meetings to gather the business requirements and developing the Specifications Unit Test Cases
• Used SQL Loader, Bulk Loader, and DB2 Auto Loader for dealing with bulk data loading to the database
• Used Tivoli Workload Scheduler for running Datastage jobs.

Environment: IBM Info sphere DataStage 8.5, oracle 11g, TWS, UNIX, IBM AIX, Oracle, DB2, Flat files, Sequential files, TWS.

Confidential

ETL Datastage Developer

Responsibilities:

• Provided Technical support to the team as the ETL developer. Addressed best practices and productivity enhancing issues.
• Worked on designing and developing the Quality stage.
• Assisted in understanding the infrastructure requirements at offshore including sizing played key role in smooth operation of development environment.
• Loaded data into load, staging and lookup tables. Staging area was implemented using flat files.
• Created jobs in DataStage to import data from heterogeneous data sources like Oracle 9i, Text files and SQL Server.
• Generation of Surrogate IDs for the dimensions in the fact table for indexed and faster access of data in server jobs.
• 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.
• Dicing and Slicing of the input data for the Business feedback. Testing of the system.
• Designing Data masking techniques to mask sensitive information when working with offshore
• Assisted Mapping team to transform the business requirements into ETL specific mapping rules.
• Enhanced various complex jobs for performance tuning.
• Responsible for version controlling and promoting code to higher environments.
• Worked on Teradata optimization and performance tuning.
• Performed Unit Testing, System Integration Testing and User acceptance testing
• Involved in ongoing production support and process improvements. Ran the DataStage jobs through third party schedulers

Environment: IBM WebSphere Datastage, IBM AIX 5, IBM DB2 8.0, Oracle 10g, MS Visio, MS Project, MS Office Suite, Teradata, Windows XP, Flat Files, SQL Developer, Unix Shell Scripting

Confidential

Role: ETL Developer

Responsibilities:

• Involved in the analysis, data modeling, detailed system design, development and technical documentation
• Designed an ETL process using Business Intelligence Integrated Services to Extract, Tranform and Load from .csv files to SQL server Database.
• Used SSAS to build cubes and analyze the data by MDX querying.
• Maintained a separate Database for each department.
• Used Star schema to design the ETL process.
• Used multiple connection managers for source and destinations.
• Used IBM Web sphere DataStage 7.5.1 to extract data from the individual department databases and used transformations to load into an Oracle Warehouse.
• Deployed different partitioning methods like Hash by field, Entire, Modulus, and Range for bulk data loading.
• Used Type II slowly changing dimension tables from several operational source files.
• Defined Measures and Measure Groups, Dimension Relationships and key Performance Indicators.
• Written Multi Dimensional Queries to analyze the data.
• Participated in the development and maintenance of a Date Warehouse / Data Mart Routine Load Schedule.
• Worked with heterogeneous sources including relational sources and flat files
• Used the Director to schedule running the job, testing and debugging its components, and monitoring.

Environment: IBM Web sphere DataStage 7.5.1, IBM AIX 5, Oracle 9i, MS Visio, MS Project, SQL Server Management Studio, Business Intelligence Integration Services and Analysis Services.

Confidential

Role: ETL Developer

Responsibilities:

• Extracted data from various sources Flat Files, SQL server and loaded into a Corporate Data warehouse.
• Implemented various strategies for Slowly Changing Dimensions using Server/PX jobs using the Frame Work approach.
• Designed jobs using different parallel job stages such as Join, Merge, Lookup, Filter, Dataset, Lookup File Set, Remove Duplicates, Change Data Capture, Switch, Modify and Aggregator.
• Involved in developing Designer- Server and PX jobs for Extracting, Cleansing, Transforming, and Integrating/Loading Data into Corporate Data Warehouse CDW .
• Developed Job Sequencers with restart capability for the designed jobs using Job Activity, Exec Command, E-Mail Notification Activities and Triggers.
• Extensively designed, developed and implemented Parallel Extender jobs using Parallel Processing Pipeline and partition parallelism techniques to improve job performance while working with bulk data sources.
• Extensively used Director to Monitor and check the run statistics of the Jobs and to clear the job logs, job resources.
• Extensively used - Manager to Export/import components.

Environment: Ascential DataStage 7.5.1 Enterprise Edition Designer, Manager, Director , Oracle, ERwin , SQL Analyzer, SQL Server, Parallel Extender, AS400. Windows 2000