ETL Informatica Available resume




  • 9.5 years of IT experience in Data Warehousing implementing Enterprise Data Warehouse (EDW), Data mart and other Business Intelligence Solutions using Informatica Power Center 8.x/9.x, Informatica Cloud and SAP Business Objects 3.x
  • 5.5 years of experience as an ETL expert working at multiple client sites in the United States.
  • Extensive hand-on experience in implementing ETL processes using Informatica Power Center 8.x/9.x for various transactions and loading data from disparate data sources
  • Expertise in complete life cycle of Design, Development, Maintenance and Documentation of various functionalities of Data Warehouses and Data Marts.
  • Experience working on Agile Methodologies, Cloud Computing and implementation of ETL architecture in AWS.
  • Expertise in data warehouse concepts, Kimball methodologies, dimensional & relational data modeling included physical, logical and conceptual to implement data marts and ODS.
  • Strong understanding of Data Warehouse concepts, ETL, OLAP, Star Schema, Snowflake Schema, FACT and Dimensions tables, Slowly Changing Dimension (SCD).
  • Strong hold on Oracle, Netezza and HP Vertica databases.
  • Extensive hands-on Experience in writing UNIX/Linux shell scripts.
  • Expertise in Data Analysis, Data Management & Performing Gap Analysis.

Educational Qualifications:
  • Bachelors of Engineering (Electronics and Telecom), Vishwakarma Institute of Technology, Pune University – June 2006

Business Intelligence

Informatica Power Center 7.x/8.x/9.x, Informatica Cloud, Power Exchange 9.6, Business Objects XI R3.x, Informatica IDQ, SSIS.


TOAD, PLSQL Developer, Aqua Data Studio, WinSCP, SVN, DB Artisan, Squirrel, Putty, Erwin


Oracle 9i/10i/11g HP, Netezza 7.0.2, Vertica *** , SYBASE ASE 14, DB2 10.5, SQL Server


PL/SQL, SHELL, Perl Scripting

Scheduling tool

Autosys, Control M, Redwood


Confidential *** March 2015 to Present

Role: ETL Informatica Architect


See full