Occupation:Quality Assurance Specialist |
Location:Los Angeles, CA |
Education Level:Bachelor |
Will Relocate:YES |
Description
SUMMARY: * Over 7 years of IT experience in Informatica PowerCenter in all phases of Analysis, Design, Development, Implementation and support of datawarehousing applications. * Experience in the field of Data warehouse using ETL tools such as Informatica Power Center 9.6/8x/7x, PowerMart 9x/8x databases as DB2, Oracle, MS SQL Server and Teradata. * Extensive experience in the implementation of Extraction, Transformation & Loading (ETL) using Informatica Power Center, Teradata, Oracle 11g/10g/9i, MS SQL Server 2008, SSRS and SSAS. * Extensively used various transformations such as Filter, Expression, Update Strategy, Look-up, Sequence, Joiner, Router, Aggregate, and Stored procedure transformation. * Extensively worked in Repository configuration using transformation, creating Mapping, Mapplets, Workflow, Sessions, Worklets, and processing tasks using Designer/ Workflow Manager to move the data from multiple Source system to Targets. * Solid understanding of Data Warehousing concepts and Dimensional modeling (Star schema and Snowflake schema) and Relational Data Modeling and Slowly Changing Dimensions. * Experience in documenting High Level and Low level Design, Source to Target Mapping (STM), Macro and Micro Documents, Unit test plan, Unit test cases and Code Migration Report. * Worked with Business analysts and the DBA for requirements gathering, business analysis, designing and documentation of the data warehouse. * Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers. * Knowledge in Oracle, BTEQ, SQL, PL/SQL, MS Access, MS Excel on UNIX and Windows platforms. * Experience in populating the data warehouse tables using SQL*Loader, MULTILOAD, FASTLOAD, Oracle Packages, Stored procedures, Stored functions. * Knowledge in Data Analyzer tools like Informatica Power Exchange to capture the changed data. * Worked in Agile Methodology for SDLC (Software Development Life Cycle) and utilize Agile scrum meetings for creative work.
Accomplishments
Highlights:
Keywords
