Description
Experience Summary * Around 7 years of Experience as ETL Developer in designing and implementing Data Mart / Data Warehouse applications using INFORMATICA PowerCenter 9.x/8.x / 7.x / 6.x (Designer, Workflow manager, Workflow monitor). * Strong working experience in Investment domain and worked on Bloomberg and Murex data. * Informatica Data Extensive experience in Extraction, Transformation and Loading (ETL) of data from multiple sources. * Designed and developed Complex mappings from various Transformations like Unconnected / Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more, mappings using Stored Procedure's, Normalizer, and Web Services. * Expertise in implementing complex business rules by creating re-usable transformations, and Mappings/Mapplets and Creating Repository, Source, Target Databases. * Well experienced in Performance Tuning of Informatica (sources, mappings, sessions and targets) and Databases, Multi-Threading and parallel processing. * Expertise in PL/SQL development and SQL Query Tuning for better performance. * Experience in Dimensional Data Modeling using Star, Snowflake Schema, Fact & Dimensions tables, Physical & Logical Data Modeling using Erwin. * Proficiency in Data Warehousing techniques for Data Cleansing, Slowing Changing Dimension (type 1, 2 & 3) phenomenon and Surrogate Key assignment. * Extensive working experience in RDBMS like Oracle 11g/10g/9i/8i, MS-SQL Server, Teradata, DB2, SQL, PL/SQL, SQL*Loader. Extensively used Oracle SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers. * Good work experience in Unit testing, Functional, Performance, User Acceptance Testing. * Experience in OLAP Tools Business Objects, Cognos, Microstrategy used for developing Reports. * Experience in UNIX Shell scripting and Job Scheduling on Multiple platforms using Autosys. * Strong knowledge of complete System Software development Life Cycle (SDLC) of Data warehousing, Decision Support System. * Experience in preparing project documents, installation documents. * Ability to meet deadlines and handle pressures coordinating multiple tasks in project environment, excellent communication, interpersonal, analytical skills.
Accomplishments
Highlights:
Keywords
