Repository Manager Resume

SUMMARY:

10 years of Strong experience in Complete Software development Life cycle (SDLC) which includes Business Requirements Gathering, System Analysis, Design, Development, and Implementation of Data Warehouse.
8 years experience in Data Warehouse using Informatica Power Center 9.6.1/9.5.1/9.1/8.6/8.5./8.1/7.1/6.1 (Repository Manager, Mapping Designer, Workflow Manager, Mapplet Designer, Transformation Designer, Warehouse Designer, Star & Snowflake Schemas, using ETL tool Informatica on Oracle, SQL Server Databases etc).
Around 4 Years of experience in Netezza Extract Load and Transformation mechanism by taking data from various sources and loading it into Netezza DB using NZSQL and NZLOAD utilities.
Strong experience in installation of Informatica and configuration of Informatica Power Center 9.6.1
Working knowledge of Informatica Power Exchange to support Data Integration requirements.
Experience in using Oracle 12g/10g/9i/8i, Netezza,Teradata, MS SQL Server 2005, MS Access 2007, SQL, PL/SQL.
Good knowledge in interacting with IDQ providing data profiling and analysis making use of Informatica Data Quality (IDQ).
Worked with Dimensional Data warehouses in Star and Snowflake Schemas, Slowly changing dimensions and created slowly growing target mappings, Type1/2/3 dimension mappings.
Proficient in transforming data from various sources (flat files, XML, Oracle) to Data warehouse using ETL tools.
Automated data transfer processes and mail notifications by using FTP Task and send mail task in Transformations.
Experience in Data Migration using SSIS and DTS Services across different databases like Oracle, MS Access and Flat files.
Expert in Report generation using MS SQL Server Reporting Services(SSRS).
Extensively worked on transformations such as Source Qualifier, Joiner, Filter, Router, Expression, Lookup, Aggregator, Sorter, Normalizer, Update Strategy, Sequence Generator and Stored Procedure transformations.
Extensively experience in developing Informatica Mappings / Mapplets using various Transformations for Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse and Creating Workflows with Worklets & Tasks and Scheduling the Workflows.
Extensively involved in Informatica performance issue and Database performance issue, Expertise in error handling, debugging and problem fixing in Informatica.
Experience in design of logical and physical data modeling using E/R studio Expertise in using SQL*LOADER to load Data from external files to Oracle Database.
Extensive experience in writing PL/SQL programming units like Triggers, Procedures, Functions and packages in Unix and windows environment.
Exposure to on - shore and off-shore support activities
Excellent verbal and communication skills, has clear understanding of business procedures and ability to work as an individual or as a part of a team.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.6/ 9.5.1/9.1/8.6/8.5/8.1/7.1/6.1, Informatica Data Analyzer 8.5/8.1, Informatica Power Exchange, IDQ, Data cleansing, OLAP, ROLAP, MOLAP, Autosys, Control M, Star Schema, Snowflake Schema, SSIS,OLTP, SQL*Plus, SQL*Loader

Data Modeling: Erwin 7.2/7.0, Toad, Oracle Designer, PL/SQL Developer 5.1.4.

Databases: Netezza, Postgres SQL, Teradata, Oracle 11g/10g/9i/8i, MS SQL 7.0, SQL Server 2005/2000, MS Access.

Programming: C, C++, SQL, PL/SQL, T-SQL, SQL*Plus, Hadoop, HTML, UNIX Shell Scripting. (AIX)

Reporting Tools: Business Objects XI 3.1/X1 R2,Crystal Reports 2008/XI,Cognos 8.4,SSRS

Environment: UNIX, Windows 2000/2003/XP/Vista.

PROFESSIONAL EXPERIENCE:

Confidential

Repository Manager

Responsibilities:

Expert in Report generation using MS SQL Server Reporting Services(SSRS).
Extensively worked on transformations such as Source Qualifier, Joiner, Filter, Router, Expression, Lookup, Aggregator, Sorter, Normalizer, Update Strategy, Sequence Generator and Stored Procedure transformations.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship