We provide IT Staff Augmentation Services!

Informatica Metadata Manager Resume

2.00/5 (Submit Your Rating)

UsA

Hire Now

SUMMARY:

  • More than 7 years of IT Experience in design development, test and maintenance Business Intelligence and database applications using tools and technologies such as Informatica Power Center, Informatica Power Exchange, Informatica Metadata Manager, SQL, PL/SQL,
  • Experience in the Development, Implementation of Database/Data Warehousing /Client/Server /Legacy applications for using Data Extraction, Data Transformation, Data Loading and Data Analysis
  • Involved in major Data warehousing projects as Designer. Has an excellent understanding of Data Warehousing concepts.
  • Extensive experience in ETL design, development and maintenance using SQL, PL/SQL, SQL Loader, Informatica Power Center 7.x/8.x/9.x.
  • Strong work experience in Data Mart life cycle development, performed ETL procedure to load data from different sources into data marts and data warehouse.
  • Involved in data migration and up-gradation to Informatica 9.0 from 8.6.1 and to Informatica 8.6.1 from 8.1.1.
  • Involved in understanding of Business Processes, grain identification, identification of dimensions and measures for OLAP applications.
  • Extensive Data modeling experience using Dimensional Data modeling, Star Schema modeling, Snowflake modeling, and FACTs and Dimensions tables.
  • Experience on basic Informatica administration tasks such as creating folders, users, granting permissions, optimizing Informatica server settings, configuring Informatica repository and installation on the server, etc.
  • Expertise in configuration, performance tuning, installation of Informatica, and in integration of various data sources like Oracle, MS SQL Server, XML, Flat files, COBOL files into the staging area and Design ETL processes that span multiple projects.
  • Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.
  • Adopt at Requirement Analysis, Application Design, Creation of Technical Design and Documentation.
  • Developed ETL Strategies using an ideal mix of Database based Loading Strategies and Informatica.
  • Experienced in Tuning Informatica Mappings to identify and remove processing bottlenecks.
  • Postproduction support, enhancements and performance tuning.
  • Excellent communication, documentation and presentation skills using tools like Visio and PowerPoint.
  • Experience with UNIX and Shell scripts.
  • Experience with job scheduling tools such as Tidal, Autosys, Cron tab, etc.
  • Highly Motivated to take independent responsibility as well as ability to contribute and be a productive team member

Technical Skills:

ETL Tools: Informatica Power Center, Power Exchange 9.1, 8.6, 7.1. Metadata
Databases : Oracle 11g/10g/9i, MS SQL Server 2008/2005/2000, MS Access,IBM DB2,Tera Data V12, Siebel CRM, PeopleSoft
Data Modeling : Data Modeling: Dimensional Data Modeling, Star Join Schema Modeling, Snow Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling.
Environments: UNIX, Windows NT, Windows server 2000/2003
GUI: Visual Basic
Tools : Toad 9.1, Visio, SQL developer, ERWIN
Languages : UNIX shell Script, SQL, PL/SQL

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship