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.