SUMMARY

• Having 9 years of total experience as ETL Lead with hands on experience in Datastage and Database (Oracle/DB2).
• Involving in full life cycle development including requirement gathering, analysis, design, development, testing, implementation, maintenance and documentation of Data warehousing models using ETL tools.
• Responsible for Technical System Design, Development, Testing, Code Review, Code migration, Supporting System testing, Job scheduling, Offshore Coordination, prepared source to target mapping.
• Expertise on Datastage tools like Datastage Designer, Director and Manager.
• Proficient in Data analysis, Data modeling, Database design and Data migration.
• Expertise in design and development using ETL methodology for data extraction from various sources like Oracle/DB2 and flat files Extraction Transformation and Loading using corporate - Wide-ETL Data Stage.
• Experienced in customer facing role and customer management.
• Experienced in onshore/offshore project execution
• Experienced in techno functional role
• Experience of ETL Migration from 7.5 to 8.5 Version.
• Excellent knowledge of studying the data dependencies using Metadata of DataStage and preparing job sequences for the existing jobs to facilitate scheduling of multiple jobs.
• Developing DataStage jobs using star schema and snowflake schema modeling and conversant with Data Warehouse concepts like fact tables and dimension tables.
• Experience in designing Sequences, Exception handling and have used various stages like exception handler, sequencer, terminator stage.
• Good knowledge on Performance Enhancement and Trouble Shooting of DataStage jobs.
• Performance tuning of Parallel Jobs.
• Good knowledge of Pl/SQL queries, stored procedures and functions.
• Good Knowledge of Control-M scheduling tool.
• Experience in working on operating systems like UNIX and Windows.
• Experience in writing UNIX shell scripts and scheduling them.
• Experienced in executing projects in Waterfall and Agile software development methodologies.
• Supported analysts by administering and configuring HIVE, running Pig and Hive queries.
• Basic Knowledge of Informatica ETL and Talend.
• Participated in discussions with the Project Manager, Business Analysts and with other Team members.
• Very good capabilities in understanding the Business Process Functionality leading to gaining excellent Telecom domain, Banking domain and Insurance Domain knowledge.
• Ability & highly keen on to learn, grasp and deliver both individually & as a proactive team member.
• An effective communicator with exceptional relationship management skills with the ability to relate to people at any level of business and management and significant experience working with steering committees and other project managers.

TECHNICAL SKILLS

ETL Tool: Ascential DataStage Enterprise Edition 11.3,9.1.2,8.7/8.5/7.5

Database: Oracle 11i/9i/8i/8.0/7.0, SQL Server 2000, DB2 UDB 8.0, MS Access 2003

Language: SQL, PL/SQL, Shell Script, C/C++, XML

Tools: & Utilities: TOAD 8.0, Win SQL, MS Office 2003, Command Center/Control Center DB2 Client, MKS, ControlM, Autosys

Operating Systems: IBM UNIX AIX 4.2, Solaris SunOS5.9, Lenux, Windows 2000/NT/XP/Vista

PROFESSIONAL EXPERIENCE

Confidential, Phoenix AZ

Lead ETL Datastage Developer

Responsibilities:

• Worked as Onsite-Offshore Data stage solution developer.
• Experience in integrating data with different source systems (DB's, fixed width and flat files) and target databases (Oracle. Db2 and SQL Server).
• Strong experience on IBM DataStage (11.3, 9.1.2/8.7/8.5/8.1/8.0/7.5 ), Grid/Cluster environments, SQL, PL/SQL, shell scripting.
• Migration of ETL projects to IBM information Server 11.3/8.7/8.5/8.0/8.0.1 on different servers.
• Performed Debugging, Migration, Troubleshooting and performance Tuning.
• Proficient in Data analysis, Data modeling, Database design and Data migration.
• Worked extensively on different types of stages for developing batch/real time jobs.
• Good in planning, estimation, monitoring and coordinating with offshore.
• Proficiency in data warehousing techniques Slowly Changing Dimension, surrogate key assignment and change data capture.
• Supported enterprise DATA processes including Business Glossary Definitions, Metadata Definitions and Data Lineage during the Software Development Lifecycle.
• Responsible for data Reconciliation, outlier management, source to target mapping documentation
• Experience in data warehousing architecture, data marts, data integration, and data modeling.
• Experience in data extraction and processing, using Hive, Pig, Sqoop, Impala, HBase.
• Good experience in performance tuning and bottle neck trouble shooting of ETL jobs.
• Experience in designing Data Marts and Data Warehouse using Star Schema and Snowflake Schema.
• Experience in using of Quality Stage / Information Analyzer for data quality standardization and cleansing the data.
• Good experience in production support, trouble shooting and supporting SIT and UAT.
• Developed micro designed, Unit test documents.

Environment: IBM InfoSphere Information Server 8.7 DataStage, Parallel Extender, Oracle 11g, DB2 Client Putty, WinSql, Sql Server 2008 Management Studio

Confidential, Cincinnati OH

Lead ETL Datastage Developer

Responsibilities:

• Experience in full life cycle system development requirements gathering, elicitation and business usecase development, solution development, user acceptance testing and production rollout.
• Leading the offshore team in the ETL process and Metadata Management.
• Documenting the movement of DATA between systems (the rules and transformation logic) using the Data Lineage capabilities in E/R Studio.
• Experience in working by loading data from multiple sources directly into HDFS
• Worked on performance tuning and enhancement of DataStage job transformations.
• ETL Designer, onsite coordinator and reviewer.
• Extensively used DataStage Designer, DataStage Director for developing jobs and to view log files for execution errors.
• Provided the release notes and assisted DataStage Admins during the production installation.
• Excellent in technical documentation, including root cause analysis, release document for production.
• Have been instrumental in several successful production release during the move to production from the test environment and have been successful in solving the critical issues that happens during the production releases.
• Extensive experience in Scheduling the DataStage jobs using ControlM Scheduling tools
• Extensive experience in Unit Testing, Functional Testing, System Testing and Integration Testing.
• Business and partnership development, recruitment and supervision of staff, product definition, market identification and management of projects and staff.

Environment: IBM InfoSphere Information Server 8.7 DataStage, Parallel Extender, Oracle 11g, DB2 Client Putty, WinSql, Sql Server 2008 Management Studio, MKS, ControlM.

Confidential

Senior Datastage Developer

Responsibilities:

• Involved in development phase meetings for Business Analysis and Requirements Gathering.
• Created and reviewed the conceptual model for the ETL with business users.
• Developed DataStage ETL jobs for extracting data from multiple sources.
• Analyzed the given source Dimensions and target Fact table structures to develop Surrogate Key tables referencing required dimensions.
• Developed various jobs using ODBC, Hashed file, Aggregator, Sequential file, Transformer stages, lookup, merge, join stages.
• Developed Parallel jobs using Stages which includes Join, Transformer, Sort, Merge, Filter and Lookup.
• Used Shared Containers and created reusable components for local and shared use in the ETL process.
• Imported and exported Repositories across DataStage projects.
• Experience in working on developing oracle PL/SQL to write queries, stored procedures, oracle functions, packages and triggers.
• Use Control-M to schedule jobs by defining the required parameters and monitor the flow of jobs.
• Involved in migrating from datastage 7.5 to 8.5 Version.
• Analyzed data with discrepancies through Error files and Log files further data processing and cleansing.
• Used DataStage Director Runtime engine to schedule and execute developed jobs and job sequences, and use Log events to monitor job progress and performance.
• Participated in weekly status meetings, and conducting internal and external reviews as well as
• Formal walkthroughs among various teams and documenting the proceedings.

Environment: IBM InfoSphere Information Server 8.5 DataStage, Parallel Extender, Oracle 8/9i, DB2, MSSQL Server 2000, UNIX, Windows NT, DB2, ControlM, MKS, Putty

Confidential

Systems Engineer/ETL Datastage Developer

Responsibilities:

• Hands on experience in Transforming Business specific rules into functional Specs.
• Frequent work the Data Integration Architect to create ETL standards, High level and Low level design document.
• Responsible for Production Support and involved in On-Call for Data Integration Applications.
• Experience in Integration of various sources like SQL Server, Oracle, DB2UDB, My-Access.
• Good knowledge in writing shell scripts to automate file manipulation and data loading procedure.
• Involved in System study, Analysis and Project Planning.
• Hands on experience in tuning the Datastage Jobs, identify and resolve, performance tuning,
• Bottlenecks in various levels like source and target jobs.
• Strong experience in designing Parallel, Server Jobs, Job Sequencers and Batch Jobs in Datastage.
• Development and support experience with control M Scheduling tool.
• Frequent usage of different Stages like Look up, Join, Surrogate Key, debugging stages, pivot, remove duplicate etc.
• Involved in writing SQL Queries.
• Frequently Used Star Team version Control for exporting and importing of Jobs using the Datastage tool.
• Tuning of SQL-Statements, stored procedures.
• Involved Unit testing and deployment of the application.
• Transferring Old Data from Legacy system to Application Database.
• Training the users, support and maintenance of the application.
• Discussions with client for bug fixing and customization of application.

Environment: Datastage 7.5/8.1,Oracle 10g/11g, SQL, PL/SQL, shell, UNIX, Windows NT, DB2, QC, putty