5 years of experience in data warehousing and business Intelligence in various domains like Finance, Banking, Insurance, Retail, and Healthcare. Extensive experience in ETL development using Informatica Power Center
shell, unix, shell script, oracle 11g, oracle, analysis, informatica, testing, etl, system testing, unit testing, control m, unix shell, database
offshore, automation, oracle, sql development, informatica, server, router, real time, unit testing, bloomberg, performance tuning, strategy, perl, shell, software, shell script, portfolio management, stored procedures, testing, reports, file systems, design, linux, management, triggers, pl sql, dat
Involved in unit testing, system testing, UAT, performance tuning, and UNIX shell scripts, Oracle 11g, Teradata, DB2, SQL developer.
Developed ETL jobs using Informatica to load data from flat files to database tables. The data was extracted from flat files, DB2, and loaded into the target table.
Created and deployed the workflows using Control-M and UNIX script for data analysis. Also, used the same to run the jobs.
Created shell scripts to automate the process of loading data into the staging tables. Also, used the same to load the data from the flat files.
Extensively used various transformations like source Qualifier, Joiner, Expression, Lookup, Filter, update strategy, Sequence Generator, Sorter, and router.
Wrote shell scripts to automate the process of loading the data into the staging tables. The data is loaded into the target table.
Saint Peter's University
Design and development of ETL process using Informatica Power Center, PL/SQL, Netezza, Oracle, and SQR, monitoring and tuning the performance of Informatica mappings.
Developed ETL jobs using Informatica Power Center 9.5.1. The data stage was used for extracting, transforming, loading, integrating, and loading data into Netezza tables.
Worked with Netezza and DB2, SQL, PL/SQL, UNIX shell scripts, and used Teradata for monitoring and performance tuning.
Involved in ETL process for loading data from Netezza to Greenplum. Used Informatica Power Center for extraction, transformation and loading of data and also for file storage and error handling.
Worked with ETL team to implement the data warehousing process and implemented the Informatica Power Center for planning and scheduling.
Extensively worked on ETL process using Informatica Power Center for extracting, transforming, loading and storing data from flat file and transformed IT to the target systems.