We provide IT Staff Augmentation Services!

Informatica Power Center Admin/developer Resume

Chicago, IL

SUMMARY:

  • 8+ years of work experience in IT Industry in Analysis, Design, Development and Maintenance of various software applications mainly in Data Warehousing (Informatica Power Center, Power Exchange), Oracle (SQL, PL/SQL), SQL Server, and DB2 and Windows environments in industry verticals like Banking.
  • Work experience in Banking, Financial sectors, Healthcare, Insurance.
  • Worked on Power Exchange deployments and Power Center Deployment migrations using scripts/manual.
  • Worked on Informatica Power center upgrade from 8.x to 9.6.
  • Extensively used ETL tool Informatica which includes components like Power Center, Repository Manager, Designer, Workflow Manager and Workflow Monitor.
  • Developed mapping spreadsheets for (ETL) team with source to target data mapping with physical naming standards, data types, volumetric, domain definitions, and corporate meta - data definitions
  • Worked on different databases like Oracle, Teradata, DB2, Sql server as source systems.
  • Created Mapplets implemented CDC (Change Data Capture for dimensions) common functions, reusable transformations, look-ups for better usability, Data warehousing, Business Intelligence.
  • Worked on setting up Informatica environments, Installation and Configurations, configuring/maintaining ETL metadata repositories and Operational support.

TECHNICAL SKILLS:

Primary Skills: Informatica Power Center 9.6/9.1/9.0/8.1/8.6/8.0, Informatica Repository Manager, Designer, Workflow Manager, Work flow Monitor, Informatica Data Quality, Data Cleansing, Microsoft project plan, Informatica Power Exchange.

Analysis/Design Tools: Visio for Enterprise Architects, TOAD, Embarcadero Rapid, Control-M, Active Batch, HP Service Manager, Remedy.

Languages/ Tools: SQL/PL SQL, SQL Server, Oracle PL/SQL, Microsoft Access.

Systems/Database Platforms: MS SQL Server, DB2, Oracle, Windows 3.x/95/98/2000/XP/Vista, Oracle 7.x-10.x, UNIX, Teradata.

Scheduling Tools: Autosys, Tidal, Active Batch, Control- M.

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Informatica Power Center Admin/Developer

Responsibilities:

  • Created Informatica folders using Informatica Repository manager
  • Created users, groups and integration services in domain using Informatica Power center Admin Console.
  • Carry out Informatica power center deployments from pre prod to production using shell scripts
  • Carry out Informatica power exchange data maps deployments from pre prod to production manually.
  • Involved in installations of Informatica Power center 9.x.
  • Created a GRID in domain using Informatica Admin console.
  • Involved in upgrading Project from 8.x to 9.6 versions.
  • Participated in CAB meeting for root cause analysis during production failure.
  • Worked with Informatica Vendor to resolve P1/P2 issues
  • Supported ON CALL on rotation basis and trouble shoot and resolved system issues/P1/P2 issues
  • Monitored performance of Informatica environments.
  • Acquired knowledge on Big data modules configuration.
  • Responsible for maintaining 22 servers are up for business usage.
  • Managed users/groups, folders and performed code migrations to different environments.
  • Backup/ recovery of Informatica software, repository and configuration
  • Created tickets and worked with Vendor to resolve the issues.
  • Develops, tests, and implements system changes, upgrades, and patches
  • Knowledge on Power Exchange connection creations and all Power Center Connections.

Environment: Informatica Power Center 8.1/8.6/9.1/9.6, Power exchange 5/9.1/9.6, IDQ, Remedy, Secure CRT, Control - M, UNIX, Hive, Oracle, Teradata.

Confidential, Milwaukee, WI

Informatica Admin

Responsibilities:

  • Created Informatica folders, users, profiles and integration services using Informatica Admin Console.
  • Worked/created a service requests to Vendors to resolve the issues.
  • Updated passwords in nodemeta.xml.
  • Updating or applying hot fixes to Informatica.
  • Monitoring Informatica services and jobs in progress and managing user and group access in Informatica.
  • Performance tuning of Informatica server and jobs Backup and restoration of Informatica repository.
  • Worked a request to take backups and migrated the codes.
  • Worked with developers to resolve the performance issues.
  • Conducted one-on-one sessions with business users to gather requirements
  • Analyzed database requirements in detail with the project stakeholders by conducting Joint Requirements Development sessions.
  • By using Repository manager, created deployment groups.
  • Used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings.
  • Resolved the Informatica issues by analyzing the node.log.
  • Restarted the services using scripts.
  • Migrated the code manually from different environments using Repository manager.
  • Hands on experience to work on Onsite and offshore models.
  • Participated to resolve P1/P2 issues.

Environment: Informatica Power Center 9.1.6, SQL Server 2008, Tivoli 8.3, Remedy, UNIX.

Confidential, Brookfield, WI

ETL Informatica developer

Responsibilities:

  • Created source to target matrix (STM) document for offshore development
  • Used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, Logical and Physical Data Models, Data warehousing Solutions
  • Developed Type 2 mapping using Lookup, Expression, Router, Update transformation
  • Created scripts to trigger the Informatica workflows using PMCMD command.
  • Created monthly medical/pharmacy/membership data extracts for downstream system(s)
  • Used Informatica as ETL tool to pull data from different source systems, cleanse, transform, and load data into databases.
  • Created ETL technical design document (TDD) for complex mapping.
  • Prepared deployment plan to migrate ETL mappings, and database code as part of application build process.
  • Conducted code reviews as per company ETL standards.
  • Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator.
  • Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
  • Migrated the code manually from different environments using Repository manager.
  • Hands on experience to work on Onsite and offshore models.
  • Participated to resolve P1/P2 issues.
  • Participate in the rotation of 24/7 support.

Environment: Informatica Power Center 9.0, SQL Server 2008, Tivoli 8.3.HP service manager.

Confidential, Milwaukee, WI

ETL Informatica Lead/Architect

Responsibilities:

  • Participated with developing the Defined ETL Architecture, ETL and coding standards and assisted in their execution.
  • Worked with business and understood the requirements and came up reusable architecture.
  • Designed mapplets, worklets and reusable transformations.
  • Designed restart ability strategy
  • Designed to store Informatica parameters in database.
  • Designed a three layered ETL architecture (Landing zone, staging and DW zone) to populate data for star schema.
  • Designed a process which filtered out the garbage record as per requirements.
  • Delivered a quality product within specified timelines.
  • Participate in the rotation of 24/7 support.
  • Responsible for production issues and data problems.
  • Created weekly project status report for Senior Management.
  • Responsible for unit testing and unit test cases preparation.
  • Responsibility to create documentation/release notes for each release.
  • Perform code Reviews and Internal Quality checks on scripts created by the team

Environment: Informatica Power center 8.X, 9.X, SQL Server 2008, Tivoli 8.3, Autosys, and PVCS.

Confidential

Responsibilities:

  • Requirements gathering, writing of use cases and related analysis artifacts, database modeling, design, XML schema design and construction, stored procedure construction/testing, ETL work, Data Quality, QA, and general data/software architecture consulting
  • Used Informatica as ETL tool, and PL/SQL stored procedures to pull data from source systems/files, cleanse, transform, and load data into databases.
  • Created detailed Data mapping with transformation rules.
  • Developed UNIX shell scripts for scheduling and reconciliation.
  • Participated with developing the Defined Architecture, ETL and coding standards and assisted in their execution.
  • Used Informatica Designer, Data Quality, Data cleansing, Workflow Manager and Repository Manager to create source and target definition, design mappings, Logical and Physical Data Models, Data warehousing Solutions.
  • Managed offshore development & co-ordinate with on-site lead, Project Manager, BA, Testers, DBA, Change Management, Architecture and support team.
  • Delivered a quality product within specified timelines.
  • Successfully implemented Data Mart project
  • Participate in the rotation of 24/7 support.
  • Responsible for production issues and data problems.

Environment: Informatica 7.x, Oracle 10g, UNIX server, Remedy.

Hire Now