Tresphord Chintankwa

ETL Informatica Developer

Contact# 972-***-****

Email: ac5ke5@r.postjobfree.com

PROFESSIONAL SUMMARY

Extracted data from RDBMS and Flat Files, applied logic and loaded to target tables using Informatica Power Center. Applied Performance Optimization techniques and Debugger for Bottlenecks in Target, Source, Mappings and Sessions . Have working knowledge in Agile Methodology(scrum) and Data Warehouse Concepts. An excellent team player with Business Users, Program Managers, Team Leads and other team members maintaning a healthy work environment.

CORE COMPETENCIES

Informatica Power Center 9.6.1

OBIEE 11g

Scrum

Sql

Microsoft Office

Windows 7,8,XP,10

EDUCATIONAL QUALIFICATION

Bachelor of Science In Business Administration, Copperbelt University, Zambia.

PROFESSIONAL EXPERIENCE

HEBERGEONS TECHNOLOGIES March 2015 To Date

Informatica Developer

. +3 years experience using Informatica Power Center 9.6.1

. Worked closely with Business Analysts in understanding Business requirements and helped prepare documents as per user requests

. Developed Informatica Mappings for Extraction, Transformation, and Loading of data into Target Tables.

. Deployed Informatica Client tools including Mapping Designer, Workflow Manager, and Workflow Manager.

. Developed Complex Mappings, Mapplets, Tasks and Workflows using the Client Tools.

. Created and applied Business Logic to Transformations including Filter, Source Qualifier, Expression, Router, Aggregator, Rank, Sorter, Sequence Generator, Joiner, Union, Lookup, Updata Strategy, SCD1 and SCD2.

. Utilised the Source Analyser, Target Designer, Mapping Designer to Import or Create Source and Target definitions as well as create Mappings.

. Created and effectively used Mapping Parameters and Mapping Variables in defining parameters and variables.

. Used Debugger and Performance Optimization techniques by identifying and fixing bugs and Bottlenecks in Target, Source, Mappings and in Session.

.Worked with Frontend Developers to build the Repository using OBIEE 11g Administration tool and involved in the creation of the Physical Layer, Business Model and Mapping layer and Presentation Layer.

. Developed Business Model and Mapping Layer to create Aggregations and Calculation Measures.

. Created Logical Dimensions with Level Based Hierarchies and Logical Dimensions with Parent Child Hierarchies with Drill Down capabilities.

. Tested and validated the OBIEE Repository by checking Consistency, Disabling Cache, Deployment, Query Logging and creating and running the reports in Analytics.

. Implemented Object Level Security and Data Level security for Dashboards and Reports.

.Generated Dashboards, Reports with Slice and Dice or Drill Down capabilities and created various views including Charts, Pivots, Column Filters and Prompts.

Contact this candidate