Creating DataStage jobs by extensively using ETL methodologies, including SCD Type 1, Type 2 to extract, transform and load data.
Create jobs to extract data from different data sources into Oracle database.
Developing complex DataStage jobs according to the business requirements and mapping documents.
Designing DataStage sequences to specify Job execution order.
Usig Director to run jobs, test/debug its components and monitor executable versions.
Involved in Code Migration from one environment to another environment (dev, test, prod).
Experience working with Hierarchical Stage, XML & JSON would be a plus.
Oracle Database/SQL
Created and executed SQL queries to fetch data from database to validate and compare results.
Developed and wrote various SQL queries, Joins, Procedures to fetch complex data.
Resolved the performance issues while extracting & loading data into Oracle database tables.
Performed SQL Load & Partition operations using Bulk Load Method in Oracle Connector Stage for High Volume data.
Experienced with SQL performance tuning techniques. Incorporated SQL tuning recommendations for data retrieval by using indexing strategy and using hints.
Performed tuning of SQL queries for faster extraction of data and being able to troubleshoot the long running sessions.
UNIX/Linux
Performed Unit testing of DataStage Jobs using Unix Shell Scripting to ensure that it meets the requirements.
Used UNIX scripts to execute DataStage jobs and DataStage Director for scheduling, executing and monitoring jobs.
Created Unix Shell scripts for validating the files and moving the files across environments.
Involved in writing UNIX scripts and calling them through Routine activity in the sequence.
Data Warehouse
Involved in implementing star schema Logical/Physical/Dimensional data modeling.
Performed Design, Development, Testing, and Maintenance of Data warehouse tables including enhancements.
Developed source/target mappings of data from applications into the Data Warehouse environment.
Experienced in developing test plans used in validation of Data Warehouse solutions.
Implemented SCD Type 1 and SCD Type 2 methodologies to track historical changes in Data Warehouse.