We provide IT Staff Augmentation Services!

Informatica Administrator / Lead Developer Resume

Houston, TX

SUMMARY:

  • To work as an Informatica Administrator / Lead Developer and practice my knowledge and past experiences
  • Around 18 years of experience on Informatica - Power Center Administration, Data Warehousing, Data Flow Architecture, Data Analysis, Data Issue Resolution.
  • Working as an Informatica Admin for the past 11 years - Daily tasks such as running repo queries, copying objects using labels from DEV to INT to TEST to PROD Repositories, version control, etc. Creating and managing the DB connections, User Groups, Users (Security), Folder Permissions.
  • Extensively worked on data analysis, ETL data flow, data integration, performance tuning, system testing and documentation
  • Ability to interact with end users, quick learner and team player with excellent communication, analytical and interpersonal skills

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Informatica Administrator / Lead Developer

  • Installation and Configuration of Informatica Products on AWS (PowerCenter 9.6.1/10.1.1, IDQ 9.6.1/10.1.1, MDM 9.7.1/10.1 on Linux Servers)
  • Deploying the etl code from DEV to TEST/PROD.
  • Worked in Informatica mappings to load the Landing and Staging tables
  • Extensively worked on shell scripts on automation (Auto restart of services/servers, Disk space utilization, Informatica Server monitoring and linux file system maintenance and clean-up, infacmd, pmcmd and pmrep operations).
  • Ensure that all support requests are properly approved, documented, and communicated using the Remedy/TFS tool. Documenting common issues and resolution procedures .
  • Escalation of Informatica issues to Informatica Tech Support.
  • Supporting the application project team requests on adhoc basis (Ex: verifying the data source connectivity, coordinating the Outages, disk space issues, Assigning permissions, data loads)

Confidential, Houston, TX

Informatica Administrator / Lead Developer

  • Installed Informatica PowerCenter 9.5 on Linux Servers.
  • Applied Informatica Hotfixes.
  • Deploying the etl code from lower environments to PROD.
  • Maintaining Informatica Repository.
  • Escalation of Informatica issues to Informatica Tech Support.
  • Designed and created complex source to target mappings using various transformations inclusive of but not limited to Aggregator, Lookup, Joiner, Source Qualifier, Expression, Sequence Generator and Router Transformation
  • Implemented effective date range mapping (TYPE II) slowly changing dimension methodology for accessing the full history of well, wellbore and completion information
  • Design mappings involving constraint based loading, target load order
  • Involved in enhancements and maintenance activities of the data warehouse
  • Designed workflow with many sessions with decision, assignment task, event wait and event raise tasks
  • Created post-session and pre-session shell scripts and mail-notifications

Confidential, Houston, TX

Mid-Tier Informatica Administrator

  • Monitoring the Application Services thru Site Scope / NetIQ. Deploy the etl folders from lower environments to PROD.
  • Installed the Informatica 7.1.1/8.1.1 SP 3/8.6.1/9.0/9.5.1 and BO 6.5/XI on the Physical Servers.
  • Installed Informatica Power Exchange 8.5.1 for nergize project for a change data capture project.
  • Applying the EBF patches and Service Packs for Informatica.
  • Prepared the Test Cases and Test Plans for Operational Acceptance Testing using Quality Center to verify how the new project impacts on the Server with existing applications running.
  • Upgraded the Informatica versions from 6.2 to 7.1, 7.1 to 8.1.1. SP3, 8.1.1 SP3 to 8.6, 8.6 to 9.0, 9.0 to 9.5.1
  • Coordination between the Application team and Firewall team to resolve the firewall issues on the application servers for the upstream data loads.
  • Maintaining Informatica Repository and Business Objects Servers.
  • Escalation of Informatica Issues to Informatica Tech Support
  • Supporting the application project team’s requests on adhoc basis.
  • Verifying the data source connectivity, coordinating the Outages, Disk Space issues, Login issues on Citrix.
  • Worked with infrastructure teams to ensure an effective operating environment
  • Defined standards and implemented INFORMATICA best practices.
  • Supported highly available and distributed ETL environment (GRID). Hands on knowledge on Integration Services Architecture and its components such as Load Balancer, DTM processing, Grids, code pages and data movement modes etc.
  • Imparted 24/7 on call support on a monthly rotation basis.
  • Defining the Job Groups, Jobs, Job dependencies on Tidal Enterprise Scheduler
  • Setting the Tidal Job rules and defining schedule dependencies

Confidential, Houston, TX

Sr. Informatica Developer

  • Involved in extracting the data from the flat files
  • Created mappings, mapplets to load the data from base tables into data marts.
  • Worked on Performance issues with the existing mappings to reduce the time and memory usage.
  • Worked on CRC (Cyclic Redundancy Check) Stored procedure to check the uniqueness of a record.
  • Prepared software requirement specifications through interaction with business representatives.
  • Created reusable mapplet transformations to load data from operational data source to Data Warehouse
  • Accessed data from relational tables that are not sources in mapping using Lookup Transformation.
  • Used Sys Admiral Tool (Tidal) Schedules to run the informatica sessions.

Confidential, New London, CT

Sr. Informatica Developer

  • Extracted the data from the Oracle and created mappings to load the data from staging area tables into data marts.
  • Calculated values in a single row by specifying input/output ports before writing to the target using Expression Transformation.
  • Implemented the Error Log tables for all the Dimensions.
  • Created sequential batches to run batch sessions one after the other and concurrent batches to start all the sessions in the batch Confidential once.

Confidential

Informatica Developer

  • Extracted the data from the Oracle Financials (General Ledger) using Informatica Power Connect.
  • Created mappings to load the data from staging area tables into data marts.
  • Created reusable mapplet transformations to load data from General Ledger data source to Data Warehouse.
  • Implemented the Error Log tables for all the dimensions.
  • Created sequential batches to run batch sessions one after the other and concurrent batches to start all the sessions in the batch Confidential once.

Confidential, Stamford, CT

Informatica Developer

  • I was involved in extracting the data from the stage, which is coming from Sybase database and created mappings to load the data from staging area tables into star.
  • Worked on mapplets to calculate the earned ratio, ultimate premiums, reinstatement premiums, adjustment premiums and unearned ratios.
  • Worked on incremental loading for all the dimensions after initial load from stage to star.
  • Worked on TYPE I and TYPE III mappings (Slowly changing dimensions).
  • Worked on data migration from IRIS system to Sybase using informatica 5.1.

Confidential, Greensboro, NC

Informatica Developer

  • Using Power Connect extracted the data from People soft and created mappings to load the data from staging area tables into data marts.
  • Worked on multiple platforms and also did the extraction from UDB/DB2 thru IBM client access driver in to the repository.
  • Used Mapplets to create the ADI (Analytical Data Interface) to capture the slowly changing dimension, which has, type I and type II Strategies.
  • Developed mappings and mapplets for the business components, source adaptors and analytic data interface.
  • Worked with Materialized views to boost the performance on summary tables.

Confidential, CA

Informatica Developer

  • I was involved in extracting the data from the ERP system such as People soft and created mappings to load the data from staging area tables into data marts.
  • Created ADI (Analytic Data Interface) to plug the staging area tables with the data marts.
  • Created Business components (BCS) and Source Adaptors (SA).
  • Used Mapplets to create the ADI to capture the slowly changing dimension, which has, type I and type II strategies.
  • Developed mappings and mapplets for the business components, source adaptors and analytic data interface.
  • Worked on performance issues in INFORMATiCA.

Confidential, CA

Informatica L2 Support

  • I was responsible to solve all the production problems in ODS's for daily as well as weekly loads.
  • I was involved in preparing the documentation for all the ODSs, which includes daily as well as weekly.
  • Generated the reports for the source to target dependencies and involved in EOM load (Month End Process), which has BIG 12 tables.

Hire Now