We provide IT Staff Augmentation Services!

Informatica Specialist Resume

4.00/5 (Submit Your Rating)

Windsor, CT

SUMMARY:

  • Informatica Certified Specialist with 9 years of total IT (Informatica, Oracle Apps) experience in which 7+ years on Powercenter 9.5.1/9.1/8.6.1 Design/Development/Administration) and 2 years on Oracle Applications 11i /R12(Development/Design).
  • Highly Skilled in designing Data Models and preparing HLD and LLD for Informatica Developments.
  • Expertise in Installation of Informatica Powercenter Server and maintenance.
  • Expertise in Informatica Administration and Repository Management.
  • Deployed Informatica 9.5.1 in Dev, Test and Prod environments in US for one of the biggest financial services Client.
  • Production (UK) Informatica Administrator for almost 2 years and was part of Go Live team for 2 trusts.
  • Responsible for all activities related to the development, implementation, administration and support of ETL processes
  • Development of Complex Mappings, Mapplets, Worklets and Workflows.
  • Capable of working independently and as well as part of a team.
  • Good Exposure in Healthcare Modules.
  • Familiar with Modules like Order Management, Oracle Purchasing, Oracle Payables, Oracle Inventory. Bill of Materials, Projects.
  • Experience in development of Conversions, Oracle Reports, XML Reports, Excel Reports and Discoverer Reports in Oracle Applications environment.
  • Configuring AOL setup in 11i, like creating users, assigning responsibilities, registering Executables, Concurrent programs, assigning in Request Groups.
  • Good Communication skills in interacting with clients.
  • Travelled to UK for 1 year 6 months on Work permit and 2 months on Business Visa for Confidential project.

TECHNICAL SKILLS:

DW Tool: Informatica Powercenter 9.5.1 / 9.1 /8.6

ERP Tool: Oracle Applications 11i (11.5.9)/R12

ERP Modules: INV,PO,OM, AP, BOM,WIPDatabase, MSSQL Server,DB2 UDB,Oracle 9i/11G, Netezza

Languages: SQL, PL/SQL, C,COBOL,ASP

Tools: TOAD, SQL *Plus, SQL *Loader, FTP, Discoverer 4i,XML Publisher

GUI Tools: MSTR, Hyperion, SAP BO, Developer 2000 (Forms 6i and Reports 6i)

OS: UNIX(RHEL),MS - Dos, Windows Series

PROFESSIONAL EXPERIENCE:

Confidential, Windsor, CT

Informatica Specialist

Responsibilities:

  • Managed Informatica Infrastructure Team.
  • Handled Informatica Administration for 3 different portfolios.
  • Maintained 8 repositories across different portfolios.
  • Automated outages with Unix Scripts.
  • Deployment of Code to various environments
  • Performance tuning on long running jobs
  • Created Unix scripts for Automated backups
  • Created Unix scripts for Automated user maintenance in Test and Prod environments
  • Created Unix scripts to Automate Jobs based on file and data availability in SAN and DB.

Confidential, Phoenix

Informatica Specialist

Responsibilities:

  • Deployed and Upgraded from Informatica 8.6.1 to Informatica 9.5.1 in Development, Test and Production environments on Unix Platforms.
  • Setup Grid environment in Test and Production.
  • Repository Management.
  • Deployment of Code to various environments
  • Performance tuning on long running jobs
  • Created Unix scripts for Automated backups
  • Created Unix scripts for Automated user maintenance in Test and Prod environments
  • Created Unix scripts to Automate Jobs based on file and data availability in SAN and DB.
  • Received Client appreciations for Successful Deployment of Informatica Powercenter.
  • Received Best faculty award for training 6 batches on Informatica Powercenter 9.5.1
  • Improve the Overall documentation of the CIQR process as a card replacement transaction subject area.
  • In corporate CIQR into the new WSDW infrastructure strategy (Data Warehouse/Data Mart).
  • Moving existing Cognos 7.4 reports/cubes which are required to Microstrategy solution used by WSDW
  • Moving existing ETL processes which are required to Informatica solution used by WSDW
  • Preparation of Design Documents
  • Creation of LDM and PDM based on Design
  • Developed mappings to migrate data to DW and DM
  • Loaded historical data to DW and DM
  • Received on the Spot Award for successfully completing the CIQR project on time and without any Issues.

Confidential

Informatica Specialist

Responsibilities:

  • Informatica Server Administration.
  • Installation and Maintenance of Informatica Server
  • Design and Development of Informatica based extract and transformation solution as part of the overall Confidential Migration solution.
  • Design and development of Trust based solution and dependency model to the core solution.
  • Development of theInformaticaMappings, lookups, reusable components, Sessions, Work Flows etc. as per the design documents/communication
  • Development-Production Delivery model development and carrying out regular development build uplifts & Functional Area Design/Requirement changes.
  • Verification and validation of the internal ETL Loading tool (LDMS, Blob Tool).
  • Involved in reviewing the Test Cases written by the peers
  • Onsite Coordination with Offshore team.

Confidential

Informatica Specialist

Responsibilities:

  • PO Supplier Conversion.
  • BOM Routings Conversion.
  • Confidential WIP Traveler Report. (XML with Barcodes)
  • NAFTA Certificate in XML
  • CIP Analysis XML Report
  • Confidential Project Material Breakdown Summary Report
  • Projects WBA Custom Form.
  • PO INA Outbound Interface

Confidential

Informatica Specialist

Responsibilities:

  • Created Mappings, Mapplets and Workflows.
  • Used various Transformations like Lookups, Filter, Data-Masking, SQL, Unconnected Lookups, Router, Union, Rank, Sequence, Joiner, SQ, Expression, Agrregation etc.
  • Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email, command and pre/post SQL
  • Fixed invalid Mapping's, tested Stored Procedures and Functions, Unit Testing of Informatica Sessions, Workflows.

Confidential

Informatica Specialist

Responsibilities:

  • Customized Confidential Cost Analysis Report.
  • Customized Costing Reports.(Excel format)
  • Zero Cost Script Main Weekly SCCR
  • Zero Cost Script Clean up Monthly Zero Cost Validation
  • Item Cost Analysis by Level Weekly Cost Update
  • Item Cost Comparison Monthly Item Cost Archiving
  • Created Custom Auto invoice Exception Report.
  • Customized various existing Reports.
  • Created PL/SQL Packages and Procedures
  • Supporting Production Issues.
  • Developed Customized Forms in Costing(Received E-Award for Form Development)
  • Monthly ADP Taxware uploads.
  • Awarded E Award for Excellence in Technical Skills
  • Received Training on Hyperion Reporting(IR,FR,WA)

Confidential

Customization and Production Support

Responsibilities:

  • Created the PO Summary Report which is Export friendly.
  • Created Cost Value Comparison Report.(Excel format)
  • Created Items not in BOM Report(XML Format)
  • Customized various existing Reports.
  • Upgraded various reports into XML.
  • Created PL/SQL Packages and Procedure
  • Supporting Production Issues.

We'd love your feedback!