We provide IT Staff Augmentation Services!

Senior Informatica Analyst Resume

2.00/5 (Submit Your Rating)

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'd love your feedback!