Fola Salawu

· Extract data from various sources like flat files, and SQL Server and loaded to the data warehouse.

· Work in Performance tuning for sources, targets, mappings, and SQL queries in the transformations to increase the performance.

· Identify and troubleshoot bottlenecks at various levels like SQL logic, Mappings, and Sessions to enhance the performance.

· Work closely with Business Analysts to Design & Develop SQL Statements, Data Conversions, and Data Cleansing.

· Extract sources from flat-files, Oracle, SQL Server and load them into Oracle using Oracle Warehouse Builder.

· Use SQL tools like Query Analyzer and DB Visualizer to run SQL queries and validate the data.

· Design various mappings for extracting data from various sources involving Flat files, Oracle and SQL Server.

· Extract the source definitions from various relation sources like Oracle, SQL server and from flat files.

· Develop complex SQL queries and Inline views, Materialized views, Global temporary tables for reporting purposes.

· Use SQL-Loader to load data from flat file to Oracle tables, to improve the performance.

· Work with database connections, SQL joins Union, aliases, views, and aggregate conditions.

· Provide document operation and user procedures, when required, and perform supporting training for respective users.

· Use System Procedures to verify data consistency with adherence to defined Data Models.

· Design complex Stored procedures for different applications based on business requirements.

· Involve working on Oracle database, designing and creating tables, relations, constraints, indexes, PL-SQL functions, and procedures.

· Design and developed database objects such as packages, procedures, functions, views, materialized views, indexes and cursors.

· Create various ORACLE database objects like Indexes, stored procedures, Materialized views, synonyms and functions for Data Import/Export.

· Experience in understanding/working through business processes and ETL processes to ensure accurate and consistent delivery of data.

· Analyze and validate complex system requirements and existing business processes and information schemes.

· Review requirements, business processes, and recommendations that relates to proposed solutions.

· Use Data modeling is a method to define and analyze data requirements needed to support the business processes of an organization.

· Involve in Dimension modeling of Data warehouse designed the business process, grain, dimensions and measured facts.

· Generated flat files using Informatica power center.

· Configured Informatica Power Exchange connection and navigator.

· Prepared Technical specification documents for Informatica.

· Developed and maintained complex Informatica mappings.

· Maintained Informatica versions through ClearCase.

· Implemented Informatica loading techniques like Incremental loading (Change Data capture) and slowly Changing Dimensions SCD TYPE II and I.

· Designed and developed a custom database (Tables, Views, Functions, Procedures, and Packages).

· Involved in the preparation of documentation for ETL standards, Procedures and Naming conventions as per ETL standards.

· Performed database tasks such as creating database objects (tables, views, procedures, functions).

· Created several database objects like views, indexes, procedures etc., to resolve the performance issues.

· Interacted with Source system to analyze how various business processes have been tracked across the source tables.

· Worked with business process experts to map integration requirements to ETL code.

· Conducted Business process analysis, task/workflow analysis.

· Translated the business processes/SAS code into Informatica mappings for building the data mart.

· Translated business processes from existing Datastage jobs into Informatica mappings.

· Extracted the source definitions from various relation sources like Oracle, SQL server and from flat files.

· Experience with SQL plus as an interface to databases, to analyze, view and alter data.

· Developed complex SQL queries and Inline views, Materialized views, Global temporary tables for reporting purposes.

· Used SQL-Loader to load data from flat file to Oracle tables, to improve the performance.

· Worked with database connections, SQL joins, Union, aliases, views, aggregate conditions.

· Improved performance of long running batch processes by implementing new mappings and modified existing SQL queries.