SUMMARY:

• 9 years of experience in Analysis, Design, Coding, Testing and Production support in Enterprise Data Warehouse and Data Migration. Currently working as a Senior ETL Developer, specialized in IBM Infosphere Datastage V 11.5/ 9.1/8.1/8.0.1 . Migrated data from various legacy systems using DataStage tool as an intermediate layer. And have been a part of the development and support team till the application is launched.
• Extensive experience resolving technical issues using DataStage tool.
• Specializes in data analysis, data mapping, data conversion, data integration, business analysis, functional design, Technical design and different aspects of data/information management.
• Worked with Infrastructure team as a Admin for Datastage and Informatica software.
• Expertise in all the phases of Software Development Life cycle (SDLC) using different methodologies like Agile, Waterfall, Scrum.
• Extensive experience interacting with cross - functional, global teams and communicating project information to multiple levels in an organization.
• Handles complex systems, project integration, and technical designs. Possesses design, plan, and team coordination expertise.
• Expertise in loading data to Hadoop hive tables from flat files.
• Works directly with clients and management to resolve conflicts and issues that may arise. Has worked extensively with SQL, including performing query optimizations. Possesses strong mentoring ability. Has ETL Design/Implementation experience. Quick learner, detail oriented and quality conscious. Industries/areas worked in include: Retail, Banking and Insurance.
• Strong background with ETL Design and coding for Data loading, Data cleansing, Data Validation and Data Integration for enterprise data migration systems.
• Document processes necessary to maintain and expand the ETL processes to support future needs.
• Design and Build common re-usable ETL components to define audit processes and capture DQ exceptions, Job monitoring and ETL logging processes.
• Create ETL processes to ensure data integrity (error handling) and document appropriate procedures.
• Write System test cases and perform system and integration testing.
• Experience in writing UNIX scripts, Basic routines and Control-M scheduling.
• Experience in implementing the complex business rules by creating re-usable jobs, shell scripts transformations.
• Expert knowledge of performance tuning source, mapping, target and sessions
• Created Schemas (Star and Snow Flake) to fit reporting, query and business requirements
• Knowledge of full life cycle development in Data Warehousing
• Experience in DataStage jobs specification documentation preparation

TECHNICAL SKILLS:

ETL Tools: DataStage V 9.1/8.1/8.0.1 , Informatica 9.6.1

Languages: SQL, UNIX Shell Script, Hive Query Language

Databases: Oracle 9i/10g (10.2.0.4)/11g, Apache Hive, Netezza, UDB DB2, SQL Server

Other Tools /Web Scheduling Tool: Red Point Interaction v4.3, Control: M, Remedy, Oracle SQL Developer V 2.1, Squirrel SQL Client, PUTTY 0.6, WinSCP 4.2.5

Operating systems: AIX Unix, Windows 98/2000/XP/7

Methodologies: Dimension Modeling, ER Modeling, Star Schema, Snow Flake Schema.

WORK EXPERIENCE:

Confidential, Phoenix, AZ

Sr Lead Datastage developer

Responsibilities:

• Worked in the design, development, testing and implementation of Data Stage ETL programs in version 8.7
• Worked in Agile Environment. Good experience with Scrum process overview.
• Created Source to target mapping documents, gathered data requirements from business and modified the existing mapping documents and respective Data Model changes.
• Extensively used Red Point Interaction campaiging tool to integrate the data with Netezza Datamart to create Campaigns.
• Designed and developed DataStage parallel jobs and performed data loads.
• Extensively used the transforms of DataStage for several types of transformations.
• Proficiently handled Parallel Extender for creating jobs for the stages like Aggregator, Transformer, sort, merge, join, lookup, remove duplicate, filter and Change Capture.
• Used purge process for the staging area fact and dimension tables using combination of DataStage jobs and Unix scripts

Environment: IBM DataStage 8.7 Netezza, PUTTY 0.6, WinSCP 4.2.5, Red Point Interactions, Control M

Confidential, San Antonio, TX

Lead Datastage developer

Responsibilities:

• Leading a 3 member ETL developer team, provide them job level requirements and review he components.
• Worked in the design, development, testing and implementation of Data Stage ETL programs in version 9.1.
• Worked in Agile Environment. Good experience with Scrum process overview.
• Created Source to target mapping documents, gathered data requirements from business and modified the existing mapping documents and respective Data Model changes.
• Generated Star Schema, Facts and dimensions for developing Data Mart in the Data Warehouse.
• Designed and developed DataStage parallel jobs and performed data loads.
• Extensively used the transforms of DataStage for various types of transformations.
• Proficiently handled Parallel Extender for creating jobs for the stages like Aggregator, Transformer, sort, merge, join, lookup, remove duplicate, filter and Change Capture.
• Used purge process for the staging area fact and dimension tables using combination of DataStage jobs and Unix scripts
• Created Hive tables and loaded the files to hive tables in Hadoop environment.
• Involved in tuning DataStage jobs for better performance.

Confidential, San Antonio, TX

DataStage Lead Developer

Responsibilities:

• Worked in the design, development, testing and implementation of Data Stage ETL programs in version 9.1.
• Worked in Agile Environment. Good experience with Scrum process overview.
• Created Source to target mapping documents, gathered data requirements from business and modified the existing mapping documents and respective Data Model changes.
• Leading a 3 member etl developer team, provide them job level requirements and review he components.
• Generated Star Schema, Facts and dimensions for developing Data Mart in the Data Warehouse.
• Designed and developed DataStage parallel jobs and performed data loads.
• Extensively used the transforms of DataStage for various types of transformations.
• Proficiently handled Parallel Extender for creating jobs for the stages like Aggregator, Transformer, sort, merge, join, lookup, remove duplicate, filter and Change Capture.
• Used purge process for the staging area fact and dimension tables using combination of DataStage jobs and Unix scripts
• Created Hive tables and loaded the files to hive tables in Hadoop environment.
• Involved in tuning DataStage jobs for better performance.

Environment: IBM DataStage 9.1, Informatica 9.6.1, Netezza, Oracle SQL Developer, PUTTY 0.6, WinSCP 4.2.5

Confidential, San Antonio, TX

DataStage and Informatica Admin

Responsibilities:

• Process Informatica and Datastage application access requests from ETL developers.
• Migrated Informatica mapping, sessions and workflows from development to test and production environments using Informatica PowerCenter Repository Manager.
• Performed Informatica and Datastage weekly maintenance activities like bouncing the application in the operating system.
• Executed commands to turn off/on the Datastage services such as ResMon App, EngMon App.
• Coordinated with Linux midrange team to perform server bounce once in a month.
• Migrated several Datastage projects from Datastage 8.1 to 9.1 versions.
• Set up the projects with all environment variables, required database connections. Created ODBC connections based on ETL developers request.
• Performed Code walkthrough of new ETL jobs developed to check for the basic ETL standards like partitioning, usage of parameters etc.
• Created an automated script to process user access requests.

Environment: IBM Infosphere Information server 8.1/9.1, Informatica 8.6/9.6, Windows 7, SQL Server 2005, Putty, WinSCP.

Confidential, San Antonio, TX

DataStage Developer

Responsibilities:

• Preparing technical design/specification for data extraction, Transformation and Loading and Data Cleansing.
• Used DataStage Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into Data Warehouse database
• Created Jobs in ETL tool DataStage to populate the data files with lookup values. Used Sequential File stage, ODBC Stage and Transformer stage. Used XML Stage to parse the incoming data from XML’s to output columns.
• Responsible for creating extract queries from different databases.
• Created Hive tables and loaded the files to hive tables in Hadoop environment.
• Wrote DataStage jobs using DataStage Designer and DataStage Manager and in-depth experience in dealing with different stages (Ftp, Merge, Sort, Aggregator, Lookup)
• Responsible for creating DS job run scripts and scheduling them in control M.
• Performed Import and Export of DataStage components and table definitions using DataStage Manager
• Worked on database connections, SQL joins, views, aggregate conditions, parsing of objects and hierarchies
• Worked on production issues and user acceptance issues pertaining to data from source to target

Environment: IBM DataStage 9.1/8.1/8.0.1 , Netezza, Oracle SQL Developer, PUTTY 0.6, WinSCP 4.2.5, UDB DB2

Confidential

DataStage and Informatica Support Lead

Responsibilities:

• Maintenance of Data Warehouse, User Rights, Data Mining, Reporting, QC of Data.
• Experience in using various tuning techniques to improve performance in Mappings, Sessions, Workflows, Datastage parallel jobs and sequences.
• Debugged, maintained existing codes by SQL Query Tuning.
• Analyzed and designed source code ETL overview documentation for Enterprise. Data Warehouse
• Collaborated with database administrators, application developers, and business users in order to ensure business requirements meet expected results.
• Regular monitoring of Control M jobs to resolve jobs failures and keep Return to Service (RTS) times low.

Environment: IBM DataStage 8.1/9.1, Informatica 9.1/9.6.1, Oracle 11g, AIX, DB2 UDB, Oracle Developer, Control-M

Confidential

Datastage Developer

Responsibilities:

• Requirement analysis and gathering to provide technical and architectural support to the team.
• Involved in design of ETL jobs and created ETL design documents.
• Created Datastage paralled jobs involving stages like transformer, join, lookup, sort, filter.
• Involved in code migration from development to test and production environments.
• Primarily involved in job design, technical reviews and troubleshooting of jobs.
• Involved in scheduling and tracking, effort estimation.

Environment: IBM DataStage 8.0.1, Oracle 11g, AIX, DataStage Version Control, Oracle Developer, Control-M, Remedy.