We provide IT Staff Augmentation Services!

Senior Informatica Developer Resume

TECHNICAL SKILLS:

Databases: MS SQL, Oracle (Oracle Streams), SQL Server200/2005 Sybase, DB2, Terradata,Netezza

Programming Languages: C, Java, SQL, and PL/SQL

Operating Systems: Windows, Sun Solaris, HPUX, AIX and Linux

J2EE Application Servers: WebSphere and JBoss

Software: Microsoft Office, Informatica Power Center, Informatica B2B,DAC, Talend,SSIS

EXPERIENCE:

Senior Informatica Developer

Confidential

Responsibilities:

  • Help develop a robust GDW to extend OBIA complete with history keeping, full and incremental load capabilities
  • Identified repeatable patterns used for the project as well as other engagements
  • Used Talend to develop an access report system out of OBIA
  • Produced an MDM POC using Talend MDM suite for internal purposes
  • Examined Talend ESB as part of the MDM POC to integrate data

Owner and Developer

Confidential

Responsibilities:

  • Leveraged patterns developed in previous projects to create functional DW for the client
  • Lead a team of 4 junior developers
  • Act as the Informatica as well as the general architecture SME to resolve issues/alter patterns to fit new needs

Consultant

Confidential

Responsibilities:

  • Played a critical role as the Informatica B2B Data Transformation tool SME. The Data Transformation tool was used to consume XML files off a messaging queue and convert data for loading into relational targets. Set up a repeatable process of integrating B2B DT tool with Power Center. Mentored junior level team members on operation of the process.
  • Worked as an integration Designer for a data migration effort. Participated in requirements gathering as well as ETL design. Provided Power Center expertise in ETL process design.

Senior Associate

Confidential

Responsibilities:

  • Parse incoming EBCIDIC data and load into intermediary XML files
  • Apply business transformations within B2B
  • Produce XML outputs from B2b to be consumed by Power Center
  • Use the Unstructured Data Transformation to call the B2B Service from within a Power Center Mapping
  • Use the relational hierarchy to import the B2B output
  • Apply additional business transformations within Power Center
  • Produce flat file outputs from Power Center for loading into DB2
  • Load data into DB2 for testing
  • Load data into DB2 tables to ensure relational integrity holds
  • Set default values for fields where necessary to ensure proper data load
  • Use Power Center 8.6 and later upgraded to 9.0

Senior Application Developer

Confidential

Responsibilities:

  • Developed HL7 compliant XML documents
  • Develop projects to handle XML inputs using Informatica’s B2B tool
  • Map elements into HL7 compliant XML
  • Work with QA group to alter existing projects to fit new requirements

Senior Database Developer

Confidential

Responsibilities:

  • Participate in ODS design reviews sessions.
  • Provided input during group reviews of newly designed ODS databases before development started
  • Analyze source data in order to assist in optimal design of the databases
  • Perform post development analysis looking for possible improvements to design
  • Develop and test ETL processes using Informatica’s Power Center
  • Develop mappings from source to target documents using various standards
  • Create sessions and workflows with appropriate dependency considerations
  • Perform unit tests on individual mappings as well as integration tests on workflows
  • Document mappings and test results
  • Develop workflows into various environments
  • Deploy workflows between Development, QA and Production environments using deployment groups
  • Schedule and monitor workflow runs
  • Analyze reject records and deploy fixes to mappings

ETL Developer

Confidential

Responsibilities:

  • Provide project - specific support for all facets of the ETL process.
  • Assist with the necessary data analysis before source-to-target map design
  • Develop, test, and maintain source-to-target Informatica mappings
  • Support the data movement processes during the application development life-cycle
  • Conduct performance tuning of the ETL process
  • Analyze ETL workflows to identify critical sessions
  • Perform source and target tuning of sessions to improve performance
  • Participate in production on-call support rotation schedule for ETL processing
  • Provide fixes to ensure ETL batch completion in case of interruptions
  • Follow up on issues and suggest and perform permanent fixes for identified problems
  • Perform testing and validation for implemented fixes

Certified Systems Analyst

Confidential

Responsibilities:

  • Interpreted C code and UNIX scripts into Informatica process
  • Consolidated fragmented code into a workflow
  • Retrofitted and improved on process to meet new client needs
  • Identified opportunities for parallel processing to cut down on run time
  • Retargeted data from DB2 to Terradata at client’s request
  • Installed, configured and deployed Informatica Power Analyzer and Metadata Reporter with JBoss on a Windows environment
  • Installed, configured and deployed Informatica Power Analyzer and Metadata Reporter with WebSphere on a UNIX environment.
  • Altered Power Center Metadata Reporter to fit client’s needs
  • Development support for implementing a data warehouse at Barclays Investments
  • Developed types one and two dimension table mappings for data warehouse
  • Interpreted and developed documentations for complex mappings produced for project

Hire Now