Umar Qureshi Email & Phone Number

10 + Years of experience in Information Technology and ETL, applications using Informatica (Power center). Implemented data warehousing methodologies for Extraction, Transformation and Loading using Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor, Repository Server Administration Console. Extensively worked on ETL Informatica Transformations effectively including – Source Qualifier, Connected - Unconnected Lookup, Filter, Expression, Router, Normalizer, Joiner, Update, Rank, Aggregator, Stored Procedure, Sorter and Sequence Generator and created complex mappings. Strong experience in designing and developing Business Intelligence solutions in Data Warehousing/Decision Support Systems using Informatica Power Center 10.2/9.6/9.1/8.6/8.1.Good Experience in developing Unix Shell Scripts for automation of ETL process.Worked on Exception Handling Mappings for Data Quality, Data Profiling, Data Cleansing, Data Validation.Implemented Slowly Changing Dimensions Type 1 and Type 2, methodology for accessing the full history of accounts and transaction information. Involved in understanding requirements and in modeling activities of the attributes identified from different source systems like Oracle, SQL and Flat files. Expertise in implementing complex business rules by creating re-usable transformations, Mapplets, Mappings, Mapping, Session and Workflow Variables. Experienced in Performance of Mapping Optimizations in Informatica. Experienced in using the Oracle SQL* Loader feature for loading the data from Flat Files to Data Base tables for Bulk Loading.Good experience in using SQL, PL/SQL, Indexes, Functions, Procedures, Triggers and Cursors.Excellent Team Player, self-motivated with good communications skills.Used Control-M for Job scheduling.

Listed skills include Management Consulting, Change Management, Innovation Management, Business Strategy, and 16 others.

• 

  University Of Sindh

  Computer Science