6 years of design engineering and 9 years of extensive experience in complete Software development life cycle (SDLC) including strong background in data ETL, development and implementation of various data warehouses/data marts. Extensive experience as ETL Developer in technologies and methods using Informatica Power Center and Pentaho. Extensively worked on Dimensional modeling (Star/Snowflake), Data migration, Slowly Changing Dimensions, Data cleansing and Data Staging of operational sources using ETL processes and providing data mining features for data warehouses. Experience in integration of various Operational Data Source (ODS) with Multiple Relational Databases like Oracle & SQL Server, DB2 and Worked on integrating data from flat files like fixed width and delimited. Knowledge of AWS and IICS (Cloud) tools and services. Actively involved in Performance SQL Tuning, ETL tuning and Error handling.•Experience in implementing the complex business rules by creating transformations, re-usable transformations (Expression, Aggregator, Filter, Connected and Unconnected Lookup’s, Router, Rank, Joiner, Update Strategy), and developing complex Mapplets. Experience in Data Modeling (Logical and Physical Design for distributed databases, Reverse-engineering and Forward-engineering using Erwin). Involved in the designing and building Pentaho ETL for Cognos analytics. Excellent knowledge of studying the data dependencies using Metadata stored in the Pentaho/Informatica Repository and preparing batches for the existing sessions for scheduling of multiple sessions. Proficient in understanding business processes/requirements and translating them into technical requirements. Excellent communication skills to clearly communicate with client and internal team. Experience in building Oracle Data Warehouse from different OLTP systems. Strong experience with MS SQL, PL/SQL, T-SQL, Stored Procedures, Packages, and Triggers. Extensive experience with Change Data Capture (CDC). Experience in shell scripting to run ETL mappings and file handling. Experience with various Databases includes Oracle 12c, 11g, 10g, SQL Server 2005/2014. Developed Test Scripts, Test Cases, SQL QA scripts to perform Unit testing, System Testing and Load testing. Seamlessly migrated the Code from Development to Testing, UAT and Production.Experience with various domain areas such as Health Care, Oil and gas, Finance, Supply Chain and Manufacturing.