PROFESSIONAL SUMMARY * 6+ years of IT experience in Analysis, Design, Development and Deployment of technical solutions to business requirements. * Extensively worked on Data Warehouse Full Life Cycle Projects for Health Care, Financial, Retail and Insurance industries. * 5+ years of Strong Data Warehousing ETL experience using Informatica Power Center 9.5/9.1/8.6/8.1/ (Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer, Informatica Server, Repository Manager) * Experience in all the phases of ETL such as Extraction, Cleaning, Transformation and Loading using Informatica. * Experience in using Oracle 11g for performing ETL functions using stored procedures. * Extensive experience and exposure on several areas of the data warehousing and Business including requirements gathering, data warehouse architecture design, development, quality planning & assurance, data analysis and implementation. Knowledge of Ralph Kimball and Inmon data warehouse approaches. * Basic knowledge with Teradata utilities ( Multiload Fastload, T-PUMP and BTEQ Scripts ). * Excellent understanding of the System Development Life Cycle. Involved in analysis, design, development, testing, implementation, and maintenance of various applications. * Extracted data from various sources ranging from various RDBMS like Oracle, MS SQL Server, DB2, Teradata and and Flat Files to load data into data marts and data warehouse. * Experience in working with Postgres, SQL server for creation of tables, functions views. * Proficiency in working with PL/SQL stored procedures, packages, and triggers. * Actively involved in Performance Tuning, maintaining Staging area, Backup and Recovery process, production support on various platforms. * Performed data quality checks using data quality tools. * Experience with Autosys scheduling . * Experience working with large databases and performance tuning. * Efficient in Optimizing, Debugging and testing SQL queries and stored procedures. * Excellent working knowledge of Shell Scripting and job scheduling on platforms like UNIX. * Able to interact effectively with other members of the Business, Quality Assurance, Users and other teams involved with the System Development Life cycle. * Excellent analytical, functional, design and development skills with excellent communication skills and the ability to interface with the executives and perform independently as well as team environments.

Highlights:

• Scheduling
• Shell Script
• Structured Query Language
• Unix
• AutoSys
• Informatica
• Oracle
• Data Warehouse
• Information Technology
• Test