SUMMARY:

• Having 11 years 4 months of experience in Information technology industry with experience in requirements gathering, design, data analysis, development, testing and implementation of client server applications. Expertise in top Integration tools such as DataStage 11.5, 8.7, 8.1 and 7.5.1.
• My experience includes interfacing with clients directly on daily basis.
• Experience in Data Extraction, Transformation and Loading (ETL) processes using DataStage (DataStage11.5x and DataStage8.7x).
• As a Tech lead work with customer to understand the requirements, analyze and work with onshore and offshore teams and implement on - time deliveries.
• Experience in creating DDL scripts for Operational Data Store and ETL Source to Target mapping documents.
• Expertise in writing Teradata SQL, Oracle SQL, Stored Procedures and performance tuning of Teradata queries
• Experience in designing, coding, testing and deploying ETL data stage.
• Prepared best practice and checklist document for Modeling and Teradata Database Design
• Job scheduling experience in Tivoli and Autosys. Automate the ETL process through Unix scripts.
• Efficiently used Dynamic and Static partition of Teradata.
• Designed the advanced features of Teradata temporal & Bi-Temporal features to handle the historical tables and also involved in sizing the database.
• Co-coordinating Offshore modeling and ETL team
• Projects are implemented in agile. Rally is the tool used for agile tracking.
• Attended classroom training on Hortonworks Hadoop, Pig, Hive, Hbase, Kilo and Nifi
• Completed AWS accreditation courses.
• Implementing projects using Agile methodology.
• Profound Knowledge of RTL Methodology (SAP Migration), SAP loading/extraction methods (IDOC, BAPI, ABAP).
• Basic knowledge of SAP transactions and SAP LSMW loads.
• Analysis, Design, Architecture, Development, and Implementation of Data warehousing solutions (EDW, BI).

TECHNICAL SKILLS:

Operating Systems: Windows NT/200x Server and Unix (AIX).

ETL Tools: IBM DataStage 11.5,8.7, 8.1, 7.5 and Informatica 7.5

RDBMS: Teradata

Other Tools / Technologies: Teradata SQL Assistant, SAP, IBM Infosphere products, IBM Data Studio

TERADATA - Tools & Utilities: Teradata BTEQ, FastLoad, MultiLoad, TPump, FastExport, SQL Assistant, Teradata Manager

PROJECT EXPERIENCE:

Confidential

Environment: IBM DataStage 11.5, IBM AIX, UCD, GitHub, Teradata.

Team Lead, ETL Developer

Responsibilities:

• Gathering information and providing team members with all the necessary information for development.
• Assist in issue resolution by acting as a mediator between clients and the development team.
• Used Agile methodology in delivering the project.
• Validate the results and work for production implementation.
• Working with business and users to establish the strategy for Master Data Management for Reliability Project to merge data from both Confidential and US Airways. This will be the single source for both the systems.
• Realtime data integration with data warehouse.
• Developing Datastage jobs using MQ stage for Real time data to load into Teradata database.
• Extelsivelly used XML stage for parsing JSON and XML Messages.
• Data profiling and analysis and create ETL High Level Design
• Develop the ETL jobs using Websphere Datastage, BTEQ, FastLoad, MultiLoad and FastExport, UNIX shell scripts.

Confidential

Environment: IBM DataStage 8.7, IBM AIX, SAP.

Team Lead, ETL Developer

Responsibilities:

• Gathering information and providing team members with all the necessary information for development.
• Assist in issue resolution by acting as a mediator between clients and the development team.
• Develop DataStage jobs to load data from several legacy systems to SAP.
• Automate the migration process using RTL methodology and load data in SAP using IDOC’s, BAPI and LSMW load.

Confidential

Environment: IBM DataStage 8.1, IBM AIX, Teradata.

Team Member, ETL Developer

Responsibilities:

• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into SAP.
• Developed jobs using stages ODBC, Sequential Files, Filter, Funnel, Remove duplicate Stage, Transformer, TD connector etc.
• Import and export of repositories across projects.
• Worked in system testing.
• Tuning DataStage transformations and jobs to enhance their performance.
• Creation of jobs sequences.

Confidential

Environment: IBM DataStage 7.5, IBM AIX, Mainframes, SAP BW, SAP R/3.

Team Member, ETL Architect/Developer

Responsibilities:

• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the DWH.
• Developed jobs using stages ODBC, Link Partitioner, Aggregator, Transformer, Link Collector, and Hash File etc.
• Import and export of repositories across projects.
• Writing routines for Error Correction and inserting default values for specific errors.
• Troubleshooting the designed jobs using the Data stage Debugger.
• Tuning DataStage transformations and jobs to enhance their performance.
• Creation of jobs sequences.
• Creation of job schedules to automate ETL process by scheduling in TWS (Tiwoli Work Shop).
• Co-Ordination with maintainence team after moving the project to production.

Confidential

Environment: IBM DataStage 7.5, IBM AIX, Mainframes, SAP BW, SAP R/3.

Team Member, ETL Architect/Developer

Responsibilities:

• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the DWH.
• Developed jobs using stages ODBC, Dataset, Remove Duplicate stage, Lookup, Join, Funnel, Sequential File, Sort, Aggregate, SAP IDOC, Cange Capture Stage and SAP.
• Import and export of repositories across projects.
• Troubleshooting the designed jobs using the Data stage Debugger.
• Tuning DataStage transformations and jobs to enhance their performance.
• Creation of jobs sequences.
• Creation of job schedules to automate ETL process by scheduling in TWS (Tiwoli Work Shop).

Confidential

Environment: IBM DataStage 7.5, IBM AIX, Mainframes, SAP BW, SAP R/3.

Team Member, ETL Architect/Developer

Responsibilities:

• Gather requirements from Confidential Business Users
• Develop the DataStage Jobs according to the requirements and standards
• Unit Testing of DataStage Jobs
• Integration Testing of Whole Flow
• Report Status to the Management Team