We provide IT Staff Augmentation Services!

Sr. Informatica Administrator Resume

SUMMARY:

  • Over 15 years of IT experience in the System Analysis, Design, Development, Implementation, Testing and Reporting for Data Warehousing.
  • 15 years of experience in ETL processes using Informatica Power Center for multiple database source environments to Data Warehouse/Data Mart in Windows environments.
  • Experience in Relational and Dimensional modeling.
  • Dimensional modeling using star and snowflake schemas and implemented Slowly Changing Dimensions.
  • SQL Server 2016, Oracle 12c, DB2, OLTP, OLAP, Data Reports, Erwin
  • Worked on UNIX shell scripts used in scheduling Informatica pre/post session operations, database administrations and database connections.
  • Worked with PMCMD to interact with Informatica server from command mode and execute the shell scripts.
  • Expertise in creating mapplets and reusable transformations using Informatica.
  • Tidal scheduler for scheduling Informatica jobs.
  • Self - Starter and comfortable in high intensity and challenging work environment.
  • Extensive experience in financial, banking, telecom, healthcare & pharmaceutical industries.

SKILL:

Informatica Tools: Informatica Power Center 10.2/9.6.1/9.1, Metadata manager 10.1, B2B Data Exchange, B2B Data Transformation, Power Exchange, MDM, Data Quality (IDQ), Data Masking and Informatica Cloud.

Scripting: Unix Shell Scripting (Korn shell, Bourne Shell).

Databases: SQL Server 2016, Oracle 12c, Teradata, IMS(Mainframe),DB2

Operating Systems: Windows 2012, Sun Solaris 11, HP-UX, Confidential -AIX.

OOD ER studio: Scheduling Tools Autosys, CA WorkStation (ESP), Informatica Scheduler, Tidal

Methodologies: Waterfall, Agile

Version Control: Subversion

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Informatica Administrator

Responsibilities:

  • Install and upgrade Informatica PowerCenter to 10.2 HF1
  • Install and upgrade Informatica PowerExchange to 10.2 HF1
  • Install Informatica Cloud Secure Agent for IICS
  • Install IDQ and MDM 10.2 HubStore, HubServer, Hub Console and Process server
  • Use IICS to connect to Salesforce and AWS and run jobs on Informatica Cloud
  • Configured Informatica PowerCenter, IDQ and MDM to run on Multi-node architecture for High availability.
  • Folder migrations from PowerCenter 9.6 to 10.2
  • Mentor Informatica developers and Administrators.
  • Use Repository Manager for managing Deployment groups and code migration
  • Created Informatica Queries to query Informatica Metadata.
  • Migrate param files, source files and target files as needed.
  • Create Standards documents to help developers have a road map of coding standards.
  • Assigning security and permissions to the developers using Informatica Admin Console.
  • Implement Velocity document as suggested by Informatica.
  • Help developers tune their workflows and sessions for better performance.
  • Create the paper work to buy the software and hardware required for 10.2 and Cloud implementation.

Environment: Informatica Power Center 10.2, MDM, Informatica Cloud, Windows 2012 R2, Exadata, Solaris 11, SQL Server 2016, Oracle 12c, Metadata Manager, Web services, Korn Shell

Confidential, IL

Sr. Informatica Administrator

Responsibilities:

  • Install Informatica PowerCenter 9.6.1 and then upgraded it to PowerCenter 10.1
  • Folder migrations from PowerCenter 9.5 to 9.6
  • Install MDM 10.1 HubStore, HubServer, Hub Console and Process server
  • Install MDMExecuteBatch to run MDM jobs using shell scripts.
  • Use Repository Manager for managing Deployment groups.
  • Created Informatica Queries to query Informatica Metadata.
  • Informatica Code migration from PowerCenter 9.5 to PowerCenter 9.6
  • Migrate param files, source files and target files as needed.
  • Creating Standards documents to help developers have a road map of coding standards.
  • Assigning security to the developers using Informatica Admin Console.
  • Starting and stopping services and server when required.
  • Implement Velocity document as suggested by Informatica.
  • Help developers tune their workflows and sessions for better performance.
  • Create the paper work to buy the software and hardware required for 961 implementation.

Environment: Informatica Power Center 10.1/9.6, MDM,UDB DB2,Unix AIX, SQL Server 2008, Oracle 11g, Metadata Manager, MS Access, ER Studio, Web services, Data Masking, Data Profiling and Data Quality (IDQ).

Confidential, GA

Sr. Informatica Developer/Administrator

Responsibilities:

  • Install Informatica PowerCenter 9.6.1
  • Repository upgrade from PowerCenter 9.1 to PowerCenter 9.6.1
  • Installed and Implemented Informatica Cloud.
  • Built reusable Informatica Cloud mappings to load data from SalesForce into SAP .
  • Assigning security to the developers using Informatica Admin Console.
  • Responsible for translating business requirements into Technical documents.
  • Used ER studio for Data Modeling target database.
  • Worked on both Dimensional model databases and Relational model databases.
  • Extensively used Informatica to load data into Oracle 11g database using CDC real time and Batch workflows.
  • Used Data Profiling to understand the source system data and develop rules.
  • Wrote shell scripts to cleanse source data before loading it through Informatica.
  • Created Informatica Mappings, Sessions, Workflows and scheduled it through Shell Scripts.
  • Created relational connections and ODBC Connections for sources and targets.
  • Implemented Oracle Partitioning for Yearly data.
  • Created Materialized views to get local copy of Remote data. Used DBLinks.
  • Use Repository Manager for managing Deployment groups.
  • Informatica Code migration from PowerCenter 8.6.1 to PowerCenter 8.6.1 and 9.1
  • Migrate param files, source files and target files as needed.
  • Creating Standards documents to help developers have a road map of coding standards.
  • Help developers tune their workflows and sessions for better performance.

Environment: Informatica Power Center 9.6.1,Unix AIX, Putty, Crontab, Oracle 11g, Metadata Manager, MS Access, ER Studio, Web services, Data Profiling and Data Quality.

Confidential, IL

Sr. Informatica Administrator

Responsibilities:

  • Install Informatica PowerCenter 9.1 and then upgraded it to PowerCenter 9.5
  • Folder migrations from PowerCenter 8.6.1 to PowerCenter 9.1 and then to 9.5
  • Mentor Informatica developers and Administrators.
  • Manage Security and permissions using Admin Console.
  • Use Repository Manager for managing Deployment groups.
  • Created Informatica Queries to query Informatica Metadata.
  • Informatica Code migration from PowerCenter 8.6.1 to PowerCenter 8.6.1 and 9.5
  • Migrate param files, source files and target files as needed.
  • Creating Standards documents to help developers have a road map of coding standards.
  • Assigning security to the developers using Informatica Admin Console.
  • Starting and stopping services and server when required.
  • Implement Velocity document as suggested by Informatica.
  • Help developers tune their workflows and sessions for better performance.
  • Create the paper work to buy the software and hardware required for 901 implementation.

Environment: Informatica Power Center 9.5/9.1/8.1,UDB DB2,Unix AIX, SQL Server 2008/2005, Oracle 11g, Metadata Manager, MS Access, ER Studio, Web services, Data Masking, Data Profiling and Data Quality.

Confidential, CT

Sr. Informatica Administrator

Responsibilities:

  • Responsible for creating, adding Repository using Repository Manger.
  • Installed Informatica Power Center 8.6.1 on Development and Production Windows Environments.
  • Used to create the relational connections and ODBC Connectivity’s for sources and targets schemas.
  • Helped developers create and configure Workflows, Worklets, and Sessions tasks to transport the data to target using Informatica Workflow Manager.
  • Also created various tasks such as command task, email task, Decision task, timer tasks,
  • Responsible for migrating code.
  • Responsible for enforcing standards.
  • Developing proof of concept for new projects.

Environment: Informatica Power Center 9.0/8.6/8.1,UDB DB2,Unix AIX, SQL Server 2008/2005, Oracle 11g, Metadata Manager, MS Access, ER Studio, Web services, Data Masking, Data Profiling and Data Quality

Confidential, NE

Sr. Informatica Developer /Administrator

Responsibilities:

  • Extensively used Informatica to load data from Flat Files, Mainframes and SQL Server.
  • Worked with Source Analyzer, Warehouse Designer, Transformation designer, Mapping designer and Workflow Manager
  • Extracted data from Mainframes IMS databases and VSAM files using Power Exchange.
  • Used XML as sources and Target in Informatica mappings.
  • Extensively used Triggers, Stored Procedures and Functions.
  • Used transformations such as the source qualifier, aggregators, connected & unconnected lookups, filters, sorter, stored procedures, router & sequence generator.
  • Development of pre-session, post-session routines and batch execution routines using Informatica Server to run Informatica sessions.
  • Checked and tuned the performance of application.
  • Developed data Mappings between source systems and warehouse components.
  • Created and defined DDL’s for the tables at staging area.
  • Documented user requirements, translated requirements into system solutions

Environment: Informatica Power Center 8.6/8.1/7.2, SQL Server 2005/2000, Metadata Manager, MS Access, ER Studio, Microsoft Reporting services, Web services, Data Masking, Data Explorer and Data Quality

Confidential

ETL Developer

Responsibilities:

  • Created mappings using the transformations like Source qualifier, Aggregator, Expression, lookup, Router, Filter, Update Strategy, Joiner, and Stored procedure transformations
  • Created reusable transformations and Mapplets and used them in complex mappings.
  • Maintain Development, Test and Production Repositories using Repository Manager.
  • Wrote shell scripts and PMCMD to interact with Informatica server from command mode.
  • Extensively worked on views, stored procedures, triggers and sql queries and defined DDL’s for loading the data before feeding the flat files.
  • Migrated mappings from Development to Testing to Production.
  • Created various documents such as Source-To-Target data mapping document, Backroom Services Document, Unit Test Cases and Data Migration Document.

Environment: Informatica Power Center 7.2, SQL Server 2005, Oracle 9i, ER Studio, Microsoft Reporting services, Web services provider.

Hire Now