ETL Informatica Available resume

ASHUTOSH N. BADWE

***

[CONTACT]

PROFESSIONAL SSUMARRY:
  • 9.5 years of IT experiencein Data Warehousingimplementing EnterpriseData Warehouse (EDW), Data martand other Business Intelligence Solutions using Informatica Power Center8.x/9.x, Informatica Cloudand SAP Business Objects 3.x
  • 5.5 years of experience as an ETL expertworking at multiple client sites in the United States.
  • Extensive hand-on experience in implementing ETL processes using Informatica Power Center 8.x/9.xfor 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 modelingincluded physical, logical and conceptual to implement data marts and ODS.
  • Strong understanding of Data Warehouse concepts, ETL, OLAP, Star Schema, SnowflakeSchema, 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
Skills:

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.

Tools

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

Database

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

Language

PL/SQL, SHELL, Perl Scripting

Scheduling tool

Autosys, Control M, Redwood

PROFESSIONAL EXPERIENCE:

Confidential *** March 2015 to Present

Role: ETL Informatica Architect

Achievements:

  • Spear-headed project with budget of $1M involving cross functional teams of up to 20 developers, ...

See full