Data Microsoft Office

Femi Ojuri

667-***-****

*********@*****.***

PROFESSIONAL SUMMARY

Develop Informatica mappings to load the data from various sources using different transformations like source qualifier, connected and unconnected lookup, update Strategy, expression, aggregator, joiner, filter, normalizer, rank and router. Writes and optimize SQL queries using Toad and SQL Server 2008. An excellent team player with business users, program managers, and team leads, architects and other team members maintaining healthy work environment.

CORE COMPETENCIES

Agile, Scrum and Waterfall

Gap Analysis; Requirement Gathering

Microsoft Office

oAccess, Word, Excel,

oPowerPoint, Project, Outlook

SQL Script Generation and SQL Querying

Structured Query Language (SQL)

Microsoft SQL, Oracle, TOAD, MYSQL

Operating Systems- Windows 7, Windows 8, Windows XP

Extraction Transformation and Loading

PROFESSIONAL EXPERIENCE

Remarkable Technology Group (RTG) September 2012 – To Date

Informatica Developer

Used Informatica power center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.

Extensive experience in ETL design, development and maintenance using oracle SQL, PL/SQL, SQL Loader, Informatica power center 9.x

Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.

Involved in extracting data from Flat Files and Relational database into staging area

Mappings, sessions, workflows from Developments to Test and then to UAT

Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a Star Schema

Developed Informatica Mappings using Aggregator, SQL Overrides in Lookups, source filer usage in source qualifiers, and data flow management into multiple target using Router.

Created sessions and extracted data from Various Sources, transformed data according to the requirement and loading into data warehouse.

Used Teradata as a source system.

FEi Systems, Inc. July 2009 – October 2012

Data Analyst

Manipulated, cleaned & processed data using Excel, Access and SQL.

Loaded extracted and conducted data validation of client data.

Analyzed raw data, drawing conclusions & developing recommendations. Writing SQL scripts to manipulate data for dataloads and extracts.

Performed daily system checks. Data entry, data auditing, created data reports & monitored all data for accuracy.

Monitored the automated loading processes to ensure complete and successful data loading.

AWARDS

Teamwork Award, Informatica Developer

Most intuitive Team member, Sales department

Contact this candidate