SUMMARY

• Eight (8) years of strong experience in Data Warehousing in the areas of ETL design and development.
• Good acquaintance and understanding of the Software Development Life Cycle, Concepts and Methodologies of design, development and testing, Analysis, Application Design and Development.
• Strong understanding of the principles of Data Warehouse.
• Extensively used ETL methodology for supporting Data Extraction, transformations and load processing.
• Extensive working knowledge in DataStage designer, manager, director and administrator.
• Expertise in development of IBM InfoSphere Datastage Parallel Jobs.
• Experienced with the QualityStage Module.
• Experienced with XML stage for parsing the XML data.
• Experienced in writing shell scripts for multiple tasks to be performed.
• Strong Knowledge in SQL.
• Experienced in writing DDL and DML scripts.
• Experienced in scheduling the jobs using Control - M and Crontab.
• Have a good knowledge on Hadoop/Big Data and Hadoop ecosystems like Hive, Sqoop.
• Have a good knowledge on Python scripting language.
• Experienced to deploy the code to different environments using MKS source and integrity.
• Experienced to write the program specifications for code.
• Experienced to review the code, documents and Unit test cases.
• Experienced to perform unit testing and UIT.
• Experienced to support the SIT and UAT.
• Experienced to resolve the production issues.
• Experienced in migration from IBM InfoSphere Datastage 8.x to 9.1.
• Experienced in monitoring, troubleshooting and performance tuning using Data Stage.
• Experienced in working on Agile methodology.
• Experienced to provide the estimations and prepare the build plan for tasks.
• Have good knowledge in Data warehousing concepts, Teradata, DB2 and oracle RDBMS.
• Experienced in working with Teradata utilities such as BTEQ, FastLoad and FastExport.
• Good at requirement gathering and interaction with the clients.
• Comprehensive problem solving abilities, Good verbal and written communication skills.

TECHNICAL SKILLS

Operating Systems: Windows XP/7, UNIX, Linux

ETL Tools: IBM Ascential Datastage7.5, IBM InfoSphere Datastage 8.1/9.1.

Scripting: UNIX Shell Scripting and Python

Languages: SQL, PL/SQL

Database: DB2 v9.1/9.7, Oracle 9i/10g and Teradata 12/14.

Scheduling Tools: Control-M and Crontab.

Hadoop Ecosystem: Hive, Sqoop.

PROFESSIONAL EXPERIENCE

Confidential, Buffalo, NY

Sr Datastage Developer

Responsibilities:

• Analyzing the requirements and preparing the Design documents based on them.
• Providing the estimations and preparing the build plan.
• Designing and Implementing Date Stage jobs to transfer the data from source to staging area to Data warehouse.
• Involving in extracting the data from different data sources like Oracle, Teradata and flat files.
• Use Quality Stage to validate address fields,date format and Standardization.
• Use XML stage for parsing the XML data.
• Creating shell scripts as per requirements.
• Load/retrive the data into/from HDFS using Bigdata file stage.
• Load the data into HDFS using Hive & Sqoop.
• Export/import the data from/into Teradata tables using FastExport and FastLoad utilities.
• Preparing program Specification documents for the Datastage jobs.
• Working on prepare unit test cases and test data against Unit Test Case specifications.
• Reviewing the code, documents and Unit test cases.
• Performing unit testing and integrating testing.
• Preparing the Control-M documents for Batch scheduling.
• Handling change requests raised by the Client.
• Support to SIT and UAT.
• Prepare the capacity planning documents.
• Code deployed to different environments using MKS integrity and source.
• Involved in resolving the production issues.

Environment: IBM InfoSphere Datastage 9.1, Quality Stage and Control-M 7.x, Shell scripting, Hive, Sqoop, Linux and Windows 7, Teradata 14 and oracle 10g.

Confidential, Buffalo, NY

Sr Datastage Developer

Responsibilities:

• Analyzed the requirements and prepared the Design documents based on them.
• Provided estimations and prepared the build plan.
• Design and Implemented Date Stage jobs to transfer the data from source to staging area to Data warehouse.
• Involved in extracting the data from different data sources like Teradata and flat files.
• Used Quality Stage to validate address fields,date format and Standardization.
• Created shell scripts as per requirements.
• Prepared Program Specification documents for the Datastage jobs.
• Worked on preparing unit test cases and data testing against Unit Test Case specifications.
• Reviewed the code, documentation and Unit test cases.
• Performed unit testing and integrating testing.
• Involved in preparing Control-M documents for Batch scheduling.
• Handled change request raised by the Client.
• Supported to system testing.
• Code deployed to different environments using MKS integrity and source.
• Involved in resolving the production issues.

Environment: IBM InfoSphere Datastage 8.1/9.1, Quality Stage and Control-M 6.x/7.x, Shell scripting, UNIX, Linux and Windows XP/7, Teradata 12

Confidential

Datastage Developer

Responsibilities:

• Analyzed the requirements and prepared the Design documents based on them.
• Involved in extracting the data from different data sources like Oracle, DB2 and flat files.
• Created shell scripts as per requirements.
• Prepared Program Specification documents for the Datastage jobs.
• Worked on preparing unit test cases and data testing against Unit Test Case specifications.
• Reviewed the code, documentation and Unit test cases.
• Performed unit testing and integrating testing.
• Involved in preparing Control-M documents for Batch scheduling.
• Supported to system testing

Environment: IBM InfoSphere Datastage 8.1, Control-M 6.x/7.x, Vision, Shell scripting, UNIX and Windows XP, DB2 9.1/9.7 and Oracle 9i

Confidential

Datastage Developer

Responsibilities:

• Interacting with Client to get the requirements for the project.
• Developing ETL jobs using Data Stage Parallel Extender, supporting all phases of the ETL process such as implementing Source to target mapping.
• Creating Local Containers and Shared Containers to reuse the jobs.
• Automation of source data downloads from different sources and parsing using Shell scripts.
• Preparing unit test cases and unit test results.
• Attending status and review meetings with the team at offshore

Environment: IBM Ascential Datastage 7.5, Crontab, Shell scripting, AIX and Windows XP, Oracle 9i

EDUCATION: Bachelor of Technology in information science and technology, Nagarjuna University, India 2008