Consulting Informatica Engineer Resume Profile

Leverages comprehensive technical acumen, problem-solving skills, and expertise in database construction, data flow, and Informatica administration to provide companies with exceptional data storage options. Skilled at providing automation and testing, protecting data integrity, and designing highly reliable systems using Agile methodologies.

Key Areas of Strength:

More than 35 years of IT experience with a focus on Insurance and Banking industry including designing, developing, implementing and supporting major Data Warehouse projects.
Expertise in developing standard and re-usable mappings using various transformations like expression aggregator, joiner, source qualifier, lookup and router.
Designed complex Mappings and have expertise in performance tuning slowly-changing Dimensions
Experience in performance tuning of Informatica mappings and Database Oracle Design DBA .
Expert knowledge of Data warehousing concepts and Dimensional modeling Star schema .
Technical Skills Summary
Oracle 11g R2 HA Informatica v9.1 Grid AIX UNIX Linux TOAD Navigator Business Objects
Oracle Reports MySQL SQL Server Oracle RDB/VMS Informix ERStudio Erwin
SQL PL/SQL DDL scripting COBOL Visio IBM, Sun, and HP Alpha Platforms

Professional Overview

Confidential

Consulting Informatica Engineer

Providing consulting ETL services, with a proven track record of successfully implementations of IT projects using Informatica for ODS, DW, ETL Loads for various industries such Banking and Insurance.
Informatica Administration - UNIX, LINUX
Data Modeling and Architecture Embarcadero, Erwin
Consulting - ETL Mapping Services
Upgrade to 9.1 from Previous Versions of Informatica
ETL Loads PL/SQL, SQL

Confidential

Senior Software Engineer

Delivered design and development of Informatica 9.1 ETL mappings to support initial load, refresh, and on-going updates of a new Oracle corporate data warehouse in a HA Grid environment also provided Oracle/MySQL database administration and design based on Agile methodologies.
Reviewed requirements specifications for business rules related to the data warehouse defined technical specifications for the ETL process and headed related systems tests of the data mart.
Developed Informatica mappings to load data from different sources to the staging area and organize the data into store tables delivered mappings to load data mart dimensions and fact tables.
Designed and led unit testing of sessions, worklets, and workflows to scheduling new mappings.

Confidential

Consultant Data Warehouse Development

Assigned to design, document, and code hundreds of Oracle PL/SQL scripts and procedures in order to perform a data migration from the SAGs Alpha-based member eligibility, claims, and account receivable systems to an Oracle 9i/10g data warehouse provided complex data migration and scripting, PL/SQL packages, and SQL Load control files.
Assembled design requirements documentation and metadata for 22 new dimensions and 8 new fact tables delivered DDL scripts to create tables and needed indexes.
Coded and tested numerous functions and procedures to facilitate table loading.
Provided 11 materialized views of the member eligibility aggregated to demographic tables, claims, and AR facts.

Confidential

Consultant Data Warehouse Development

Contracted to drive development and testing of 125 ETL mappings and 40 worklets to transfer data from a customer system to an Oracle 9i database for a key strategic client project involved source and target databases on a Sun UNIX server and a warehouse comprised of two fact tables and 40 dimensions requiring external and internal loading.
Created 100 mappings between source and target using Power Center v6.2 Designer and used Informatica to import data from Oracle for all sources and targets.
Delivered 40 worklets and 40 workflows to empower alpha testing procedures.
Generated fact, dimension, and support tables using TOAD and DDL scripting.
Utilized single sources and multiple targets as well as detached lookups.

Confidential

Senior Programmer Analyst/Oracle Database Administration

Served as senior technical lead programmer on a corporate-wide consolidation project to centralize and replace four company database business systems with one Oracle-based organizational data store and star schema data mart.
Built the corporate data warehouse by using Informatica v6.1 to extract, transform, and load existing data.
Automated data extraction from Oracle and DB2 databases and used SQL and PL/SQL embedded COBOL programs to build the new data warehouse tuned data warehouses using SQL Lab Vision/Quest Central.
Wrote hundreds of DCL scripts to create tables, views, and indexes in the data warehouses.
Designed and developed PL/SQL procedures for summarizing and aggregating fact tables.
Employed SQL Loader for bulk loading once the data warehouse was complete.
Supported company RBD-based statement of operation system with new development and maintenance.

Confidential

Senior Programmer Analyst/Senior Systems Manager

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship