Senior Informatica Analyst Resume

SUMMARY:

Acquired significant Data Warehousing experience with career committed to use of Oracle and various databases.
Extensive use of Informatica for ETL in healthcare, defense, manufacturing and other industries.
Desire to remain in an environment that will continue to challenge and expand my abilities with interest in Big Data, PostgreSQL and Greenplum databases.
Strong oral communication and interpersonal skills for working in both independent and collaborative environments, ability to work with a wide range of personalities and cooperative team leader/member

TECHNICAL SKILLS:

Operating Systems: UNIX (AIX, Sun Solaris), NT platforms

Databases Development and Administration: Oracle Development Teradata, SQL Server, DB2

Tools: ETL Informatica PowerCenter 9, PowerConnect for SAP R/3 and PeopleSoft, Data Stage 8.1

Database Management Query/Load: Oracle SQL*Plus

Teradata: SQL Assistant SQL Server Management Studio

WORK EXPERIENCE:

Confidential

Senior Informatica Analyst

Responsibilities:

Requires use of Security Clearance for Confidential
Use of in depth consultation skills for client interaction
Created needed detailed documentation of data file creation, processing and storage of data feeds for clients.
Informatica Data Steward responsible for data analysis
Development and maintenance of Informatica workflows, Oracle PL/SQL, and Linux shell scripts

Confidential

Data Architect / ETL Engineer

Responsibilities:

Use of Data Analysis and Informatica skills to guide clients with preferred methods of ETL processing required
Data Architect for clients needing analytics support. Use of Oracle and SQL Server on company product platform.
Oracle PL/SQL Developer supporting Product Delivery with client production releases and Product Development creating dynamic SQL using Meta data from Health Care Dataworks Knowledge Edge Data Warehouse.

Confidential

Data Warehousing Consultant

Responsibilities:

Granted secret security clearance for Confidential
Informatica 9.1 ETL developer for Data Warehouse of aircraft inventory, flight, work order, and training data
Creation of complex Informatica reusable mappings and mapplets to use XML sources files for loading into Teradata 14 database using all transformation types (complex lookups, aggregators, XML parser) to process XML data
Used Informatica Pushdown Optimization with Teradata for best practices standard
Wrote performance tuned SQL that was optimized for fastest processing
Designed Informatica mappings, workflows and sessions for efficient performance
Worked closely with Business Object developers to develop metrics for Business Intelligence support

Confidential

Data Warehousing Consultant

Responsibilities:

Created all scripts for creation of database objects (tables, views, indexes, synonyms)
Involved with performance tuning (explain plan, hints) of any Oracle PL/SQL Stored procedures and SQL used
Informatica 8.6 mappings created to load fact tables and type 1 dimensions and type 2 slowly changing dimensions
Created and maintained all database objects (tables, views, indexes, PL/SQL functions and stored procedures)
Wrote validation scripts for use by QA team to compare source and target database data after ETL processing

Confidential

Informatica 8.6 Developer and Data Modeler

Responsibilities:

Worked closely with DB2 developers and Business Analyst to finalize ODS and Dimensional Data models.
Lead Developer - Mentored mainframe developers on use of Informatica 8.6 and Sql Server
Designed reusable mappings, mapplets, sessions, workflows and parameter files to be used as development standards
Position of Public Trust Security Clearance obtained for working with data for Confidential

Confidential

Systems, Data Warehousing Specialist /Business Analyst

Responsibilities:

Performed development with Oracle 10G and Informatica 8.1 in areas of payments and charges, radiology and ER
Utilized strong technical skills including writing AIX Unix Shell Scripts and Oracle SQL scripts for automated data validation
Introduced DBA team to the use of materialized views for faster access to reporting data. Wrote UNIX scripts to connect to Oracle for view creation and daily refresh

Confidential

ETL Informatica 8.1 Developer

Responsibilities:

Data Warehouse developer for the DataHub enterprise 10G Oracle data warehouse of plant systems from SQL Server and Sybase source data
Development of complex Informatica 8.1 mappings using XML sources, targets and Informatica Web Services
Developed PL/SQL Packages, Stored Procedures and functions needed for data loading into the DataHub

Confidential

ETL Informatica Developer

Responsibilities:

Sole Informatica Developer on project. Goal of project was to integrate Confidential of Nashville, TN facility, physician and patient data after acquisition by Confidential, NA.
Use of Informatica Power Center 7.1.3 ETL in 10G Oracle environment
Development of standard and re-usable mappings and mapplets for efficient processing.

Confidential

ETL Informatica Developer

Responsibilities:

Oracle/Informatica Developer to develop interfaces between SAP and PeopleSoft (GL and Administration Systems)
Designed technical specifications for interface development
Informatica Power Center 7.1.3 ETL development and use of Informatica PowerConnect for SAP R/3 and PeopleSoft

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship