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.