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
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.
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
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
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
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
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
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.
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