Description
Summary: * Experience in data modeling, data warehouse, ETL design development, Ralph Kimball models with Star/Snowflake Schema Designs with analysis-definition, database design, testing, and implementation and Quality process. * Extensively worked on Informatica 6.x/7.x/8.x/9. x. * Involved in the full development lifecycle from requirements gathering through development and support using Informatica Power Center, Repository Manager, Designer, Server Manager, Workflow Manager, and Workflow Monitor. * Experience in designing/developing complex mapping using transformations like Unconnected and Connected Lookup, Router, Filter, Expression, Aggregator and HTTP transformation. * Involved in writing various UNIX shell scripts for writing automated scripts for scheduled queue process and PMCMD commands. * Strong analytical and conceptual knowledge in database design and development using Oracle [ ] SQL, PL/SQL, Developer/2000 and Unix Shell Scripting. * Experience in writing Unix scripts, Perl scripts for the business needs. * Extensively worked on Data Extraction, Transformation, and Loading with RDBMS, Flat files and datasets. Extensively worked with SQL, UNIX Shell Scripting, Perl Scripting & Performance tuning to improve performance. * Involved in a role as an Informatica Administrator in upgrading the repository database and giving permission to various groups of users and testers. * Experience in integration of various data sources definitions like Oracle, DB2 UDB, Flat Files, Netezza, SAP, XML and XSDs. * Installation and configuration of Informatica servers and client environments. * Experience in writing, testing, and implementation of the cursors, procedures, and functions at database level using PL/SQL and DB2. * Familiar with Erwin 4.X and Sybase Power Designer 11 as data modeling tools. * Interacted and well managed various offshore teams. * Gathered requirements for data extraction & data base queries utilizing Terradata, SQL and MS Access queries. * Excellent communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high adaptability to new technologies and tools. * Had experience as worked in Agile environment.
Accomplishments
Highlights:
Keywords
