I have over 15 years of experience in software development. Experienced in life cycle development including requirements gathering, analysis, design, development, testing, deployment to production and post - production support in ORACLE ERP APPLICATIONS, INFORMATICA 9.5(ETL) DATA WAREHOUSING, HADOOP DEVELOPMENT FOR BIG DATA SOLUTIONS.

Involved in Extracting, loading Data from Hive to Load an RDBMS using Sqoop.

Extensive data validation using HIVE and also written Hive UDFs

Involved in creating Hive tables loading with data and writing hive queries which will run internally in map reduce way.

Worked on exporting the same to SQLServer, which further will be used for generating business reports.

Worked in tuning HiveQL and Pig scripts to improve performance

Good experience in troubleshooting performance issues and tuning Hadoop cluster.

Load flat files from Hdfs file path to local informatica ( ETL ) file system directories. From here loaded as Source file into Informatica Power Center for transformations and loading processed data into final destination database for further decision making process.

Moved all log/text files generated by various products into HDFS location. Created External Hive Table on top of parsed data.

Worked on different phases of Data Warehouse development lifecycle from Mappings to extracting data from various sources to tables and flat files. Created Re-Usable objects like Maplets & Re-usable transformations for business logic.

Worked on Transformations, such as Rank transformations, Expressions, Aggregator and Sequence

Experienced in working with complex mappings using expressions, routers, lookups, aggregators, filters. Worked on updates and joiners in Informatica, session partition, cache memory, connected lookups and unconnected lookups.

Systems messages are sent to different retails stores throughout the country using to Oracle Advanced Queuing Technology.

Using UTL FILE utility of Oracle to extract data as a flat file and send it directly to the server. Involved in Performance Tuning, profiling and monitoring of SQL Via Explain Plan, Confidential and SQL Trace .

Written shell scripts to automate SQL Loader process to load data into the tables. Used SQL Profiler to monitor the server performance, debug T-SQL for slow running queries

JavaScript Requires
Sorry this site will not function properly without the use of scripts.
The scripts are safe and will not harm your computer in anyway.
Adjust your settings to allow scripts for this site and reload the site.