We provide IT Staff Augmentation Services!

Informatica Admin Resume

3.00/5 (Submit Your Rating)

New Carrollton, MD

SUMMARY

  • Over 14 Years of experience in Design, Coding, Administration, Development & Implementation of Data Warehouse/Data Marts
  • Over 11 Years of experience as a Sr. Data Warehousing Analyst with ETL tool like Informatica and PL/SQL programming.
  • Over 10 Year of experience in Informatica Administration and have installed and upgraded various versions.
  • Good Expertise in establishing ETL environments according to project requirements.
  • Advance Knowledge and excellent concepts in ETL, Data warehousing and DataMart.
  • Extensive knowledge in Informatica ETL Tools (Admin Console, PowerCenter, Repository Server, Informatica Server, Repository Admin Console, Repository Manager, Designer, Workflow Manager and Workflow Monitor).
  • Worked Extensively on Informatica Designer Client Tool (Source Analyzer, Data warehousing designer, Mapping Designer, Mapplet and Transformations).
  • Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, and Sequence Generator
  • Extensive Knowledge in conversion of Corporate Data Model into Data Warehouse using Star or Snowflake schema.
  • Involved in the extraction process to get the data from Oracle sources, Flat files etc.
  • Expertise in implementing an efficient migration process to move ETL objects from development to test and production environments using Informatica deployment groups, Import/Export option.
  • Proficient in interaction with the business users. Pioneered load strategies of loading staging area and data marts. Dealt with SCD Type1/Type2 loads.
  • Emphasized on Performance of Mapping Optimizations in Informatica.
  • Very strong skills in writing SQL Queries and Procedures for development and testing Business applications.
  • Efficient in working on remote systems using FTP and hands on experience in modifying and uploading the files to the remote systems.
  • Extensive knowledge in scheduling the jobs using Autosys.
  • Excellent Communication and Interpersonal skills.
  • Proven problem solving, Self - starter and worked individually as well as adapting rapid changes in team environments and priorities.
  • Demonstrated ability in Grasping New Concepts (both Technical & Business) and utilize as needed.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 10.5.1/10.4.1/10.2.0 /9.6.1/9.1.0 , Informatica Power Exchange/Data Validation Option

Data Modelling: Erwin

Programming: SQL, PL/SQL, UNIX Shell Scripting

RDBMS: Oracle 12.2, SQL Server, DB2, PostgreSQL

GUI: DB Visualizer, SQL Navigator, TOAD

Operating Systems: Windows NT/2000/XP, Linux, UNIX AIX/Solaris

PROFESSIONAL EXPERIENCE

Confidential, New Carrollton, MD

Informatica Admin

Responsibilities:

  • Installed and configured various Informatica versions on Informatica ICC.
  • Installed various Informatica Emergency Bug Fixes.
  • Used Informatica OS Profile concepts with Informatica ICC to manage multiple projects under same domain.
  • Worked on creating the various packages for Power Exchange Greenplum.
  • Worked on creating the various packages in Drive for Emergency Bug Fixes to do deployment in various environments.
  • Worked on Key tabs and Database maintenances.
  • Created and configured various objects within Informatica Admin Console using GUI and Informatica command line references.
  • Extensive experience on Informatica Admin Console configuration for on boarding new projects and manage existing projects on Informatica Platform.
  • Worked on restoring multiple files for Emergency Bug Fixes, DVO and Power Exchange.
  • Worked on creating multiple change requests in KISAM.
  • Worked on updating the scripts for various Informatica Emergency Bug fixes.
  • Gave knowledge transfer to team members on how to stage in BigFix console.
  • Gave knowledge transfer to team members on installing Emergency Bug Fixes

Environment: Informatica Power Center 10.5.1/10.4.1/10.2.0 , Oracle 12, Flat files, Sun Solaris, Linux.

Confidential, Camp Hill, PA

Informatica Admin/Sr. Informatica Developer

Responsibilities:

  • Worked with the business along with the analysts to gather the requirements and provided numerous solutions based on the requirements.
  • Installed and configured various Informatica versions on Informatica ICC.
  • Installed various Informatica Emergency Bug Fixes.
  • Created and configured various objects within Informatica Admin Console using GUI and Informatica command line references
  • Extensive experience on Informatica Admin Console configuration for on boarding new projects and manage existing projects on Informatica Platform
  • Used Informatica OS Profile concepts with Informatica ICC to manage multiple projects under same domain
  • Worked with enterprise architect to implement Informatica Solutions at various clients
  • Implemented various shell scripts to automate Informatica processes like backup repository on daily bases, repository restore process etc.
  • Responsible for weekly status / triage meetings & preparing the Weekly Status Report (WSR) and showing progress and efforts to the Manager.
  • Helped projects with their code migration processes with different Informatica environments
  • Manage multiple Informatica Products like PowerCenter, DVO, DT within organizations
  • Modified existing/Developed new complex Informatica PowerCenter Mappings to extract and pull the data according to the guidelines provided by the business users from different sources like Flat files, Oracle, SQL Server and populate the data into Oracle Target Systems.
  • Created Mappings using Mapping Designer to load the data from various sources, using different transformations like Source Qualifier, Expression, Lookup (Connected and Unconnected), Aggregator, Update Strategy, Joiner, Filter, and Sorter transformations.
  • Developed mappings/Reusable Objects/Transformation/mapplets/user defined functions by using mapping designer, transformation developer and mapplet designer in Informatica Power center.
  • Used Debugger within the Mapping Designer to test thedata flowbetweensource and targetand to troubleshoot the invalid mappings.
  • Involved in writing procedures, functions in PL/SQL and also involved in Performance Tuning of SQL Queries, Sources, Targets and sessions by identifying and rectifying performance bottlenecks.
  • Involved in using Autosys as a scheduling tool to schedule the jobs. Designed and created Autosys Jill jobs to schedule the workflows and the procedures.
  • Involved in Unit testing, System testing and UAT to check data consistency.
  • Assisted testing team for their System Integration Testing.
  • Prepared all documents necessary for knowledge transfer such as ETL strategy, ETL development standards, ETL processes.

Environment: Informatica Power Center 9.6.1, Oracle 11g, SQL Server 2008, dB Visualizer 9.0.6, PL/SQL, Flat files, Sun Solaris, Windows 8.

Confidential, Richmond, VA

Jr Informatica Admin/Sr. Informatica Developer

Responsibilities:

  • Worked with the business along with the analysts to gather the requirements and provided numerous solutions based on the requirements.
  • Managed Informatica Admin Console for various admin tasks.
  • Created Custom Roles assign them to various services.
  • Created various services, security domain connections within Informatica Admin Console
  • Added custom properties, environment variables with various services
  • Worked on updating gateway node whenever required based on password changes.
  • Helped projects to triage their failures/issues on regular bases.
  • Involved in development of Logical and Physical data models which caters the business needs.
  • Involved in hitting the various performance issues. Optimized the mappings, targets, sources and sessions wherever applicable to improve the performance.
  • Used Debugger to debug the mappings and to troubleshoot the information.
  • Used Session parameters, mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
  • Involved in using and enhancing the existing PL/SQL functions, procedures and packages. Developed new PL/SQL procedures and table functions to populate the data in the tables and implemented the business rules and transformations.
  • Performed performance tuning using Explain Plan, Hints, bitmap and b-tree indexes, materialized Views and table partitioning.
  • Involved in Optimizing and Performance tuning logic on targets, sources, mappings, and sessions to increase the efficiency of sessions.
  • Migrated mappings, sessions and workflows from Development to testing and then to Production Environments.
  • Improving workflow performance by shifting filters as close as possible to the source and selecting tables with fewer rows as the master during joins. Loaded the data from flat files, excel files to Oracle tables after creating external tables.
  • Scheduled Informatica Jobs through Autosys scheduling tool.
  • Involved in the production support during the vital stages of loading the data in to the Data warehouse.
  • Responsible for monitoring loads and tackled performance challenges whenever issues are observed during the production load.

Environment: Informatica Power Center 9.1.0, Oracle 11g, dB Visualizer 9.0.6, SQL Navigator 5.5.4, PL/SQL, Flat files, LINUX, Windows XP Professional.

Confidential, Thousand Oaks, CA

Sr. Informatica Developer

Responsibilities:

  • Involved in development of Logical and Physical data models which caters the business needs.
  • Installed and configured Informatica Power Center and Informatica Client tools.
  • Developed complex mappings using Informatica Power Center Designer to transform and load the data from various source systems like Flat files, Oracle, SQL Server and loading to Oracle target database.
  • Extensively used various types of transformations such as Expression, Normalizer, Joiner, Update Strategy, Lookup (Connected and Unconnected) to load the data.
  • Devised extensive PL/SQL Stored Procedures & Triggers to populate the base tables on daily basis and implementing business rules and transformations.
  • Performed Mapping Optimizations to ensure maximum Efficiency.
  • Implemented complex mapping such as Slowly Changing Dimensions (Type 2) using Flag.
  • Designed and developed several mapplets and worklets for reusability.
  • Designed and Developed pre-session, post-session routines for Informatica sessions to drop and recreate indexes and key constraints for Bulk Loading.
  • Involved in Unit Testing, User Acceptance Testing (UAT) to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
  • Used Debugger to debug the mappings and to troubleshoot the information.
  • Monitor, schedule, and troubleshoot batches and sessions for weekly and daily extracts from various data sources across all platforms to the Target database.
  • Involved in Production Support during the vital stages of loading the Data Warehouse.
  • Written PL/SQL procedures for processing business logic in the database.

Environment: Informatica Power Center 8.6.1, Erwin r7, Oracle 10g, SQL Server 2000, PL/SQL, Flat files, TOAD, UNIX, Windows NT.

Confidential

Informatica Developer

Responsibilities:

  • Prepared documentation including requirement specification.
  • Involved in designing Data Mart model with Erwin using Snowflake Schema methodology.
  • Created Sessions and batches to extract the data.
  • Involved in the creation of jobs using workflow manager to validate schedule run and monitor the jobs.
  • Involved in designing the procedures for getting the data from all systems to Data Warehousing system.
  • Extensively used Informatica to load data from different sources like Flat files, COBOL to oracle.
  • Information is stored in table definitions in the repository and is entered using the Repository Manager.
  • Used the Power Center Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
  • Assisted warehouse designer while designing the models.
  • Wrote Unix Shell Scripts to automate the process.
  • Built Informatica mappings and mapplets to extract data into data warehouse.
  • Preparation of technical specification for the development of Informatica Extraction, Transformation and Loading (ETL) mappings to load data into various tables and defining ETL standards.
  • Used aggregate, expression, lookup, update strategy, router, and rank transformation.
  • Developed joiner transformation, normalizer for extracting data from multiple sources.
  • Designed and Development of pre-session, post-session routines and batch execution routines using Informatica Server to run Informatica sessions.
  • Used Informatica Server Manager to create, schedule, monitor and send the messages in case of process failures.
  • Involved in Performance Tuning of sources, targets, mappings, and sessions.

Environment: Informatica Power center 7.1.1, Windows NT, Oracle 8i, COBOL, SQL, PL/SQL, SQL* Loader, Erwin 3.5.

We'd love your feedback!