SUMMARY:

• 13+years of IT experience in INFORMATICA with full ETL life cycle implementations including analysis, Architect, Design, Development, Testing, Deployment, Post - Production Support/Maintenance and documentation.
• Comprehensive industry experience. Has worked in Telecommunications, Banking and Insurance, Health Care and Retail industries.
• Experienced in Installing, Configuring, Upgrading and Administering Complete Informatica Power Center suit on various versions like 6.x, 7.x, 8.x, 9.x and 10.1 (latest version)
• Experienced in Installing and configuring Repository Service, Metadata Manager Service, Data Analyzer and Web Service Hub with High Availability (HA) installation and configuration on AWS and F5 & Grid option enabled.
• Experienced in Installing, Configuring, Upgrading and Administering Complete Informatica MDM Hub/Process Server /Active VOS /and IDD on various versions like 9.x, 9.7 and 10.2 (latest version).
• Experienced in creating, configuring and registering (Administering) system & Operational ORS's for MDM Hub & Cleanse Server(s) /Process Server(s).
• Experienced in Installing, Configuring, Upgrading and Administering Web Logic & JBoss app servers.
• Performed Extensive Performance tuning on JVM with respect to Web Logic & JBoss and MDM application.
• Experienced in complete end-to-end MDM upgrade from 9.x to9.7 and 10.2 (latest version).
• Experienced in installing & configuring Address Doctor Engine-reference Data on MDM / IDQ/IPC.
• Experienced in creating and configuring Identity Match, Informatica Data Director and other reference data components for Trillium Data Director on MDM Hub & Cleanse Server(s) /Process Server(s).
• Experienced in creating and configuring Java User exits.
• Trouble shooting performance issues and supporting activities on both Web Logic and JBoss app servers.
• Trouble shooting on JAVA & User exits and SIF services and also tuned match/merge process.
• Performed day to day Administration and security audit activities.
• Performed daily health checks on MDM / Web Logic / JBoss applications.
• Performed code deployments to/from higher environments and may more...
• Experienced in integrating Informatica MDM with Informatica Power Center IDQ.
• Experienced in ORS's & Cleanse Server upgrade and code deployments to a higher environment.
• Experienced in Installing, Configuring, Upgrading and Administering Complete Informatica B2B Components.
• Experienced in Installing & Configuring Proactive monitoring PMPC, RTAM and PMR.
• Experienced in Installing & Configuring Data Validation Option (DVO).
• Experienced in upgrading Informatica Power Center across different versions like 8.1 to 8.5, 8.6 to 9.x, 9.x to 9.6 and 8.6 to 9.6 & 10.1 with latest Hot fix etc.,
• Experienced in Installing & Configuring Informatica Cloud Secure Agent& trouble shooting and support.
• Experienced in Installing & Configuring Informatica Lifecycle Management (ILM /TDM) & trouble shooting and support.
• Day to day Informatica environment maintenance and support activities.
• Excellent implementation of data warehouse/data marts using various data warehouse concepts and principals like Change Data Capture, Slowly Changing Dimensions, Normalization/De-normalization (Star and snow-flake Schema Modeling).
• Worked on Slowly Changing Dimensions (SCD) Type 1, 2 and 3 to keep track of historical data.
• Developed Data Warehouse/Data Mart systems, using various RDBMS (Oracle, MS SQL Server, Mainframe file, Teradata and DB2).
• Analyzed, designed and developed Extraction, Transformation and Load (ETL) processes for Data Warehousing and Data Migration, Data Synchronization projects using Informatica Power Center including Designer, Developer Repository Manager, Workflow Manager, Workflow Monitor and Administration Console etc.,
• Profound Experience in Project Environment setup such as Installation, configuration and Administration of Informatica products Client/Server environment.
• Experience in data management activities like data integration, data migration and data Synchronization using heterogeneous source like Oracle/ Exadata 9i/10g/11g/12c, DB2, Flat Files, XML Files, Netezza, Teradata, MS SQL Server 2012/2008/2005 and MS Access 2007/2003.
• Developed Complex mappings from varied transformation logics like Unconnected/Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Union, Update Strategy and more.
• Involved in Informatica ETL Performance tuning, testing and troubleshooting w.r.t Mappings, Sessions and Workflows.
• Experience in implementing complex business rules by creating re-usable transformations, Mapplets, Mappings and Shortcuts.
• Experience using Informatica Power Exchange (Power Connect) for SAP to pull data from SAP R/3.
• Experience using Informatica Change Data Capture (CDC) functionality to pull teh real time data.
• Experience in UNIX shell scripting, Pre-Session, Post-Session UNIX Commands for automation of Informatica job scheduling, backup of repository etc.,
• Experience in exporting and importing (loading) data to/from heterogeneous source systems using Teradata utilities such as BTEQ, Fast Export, Fast Load and Multi Load.
• Extensively worked with SFTP/SSH file transfer and loading using SQL, PL/SQL, SQL *Loader.
• Experience in using teh Informatica command line utilities like pmcmd, pmrepserver, infacmd, infasetup and pmrepagent to execute or control sessions, tasks, workflows and deployment of groups in non-windows environments.
• Experienced in different Project Management Methodologies like Traditional water fall and Agile.
• Proactive in learning new technologies and updating my skills including Strong analytical, verbal, written and interpersonal skills.
• Proven team player with excellent communication and interpersonal skills for meeting teh deadlines.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 10.1, 9.6, 9.1.0,9.0.1, 8.6.1,8.5.1,8.1.1,7.1.x, Power Exchange, IDQ, IDE-(B2B), MDM 10.2, 9.7.1, ILM /TDM Proactive Monitoring, RTAM, Data Validation Option(DVO) and Informatica Cloud

Databases: Exadata Oracle 12c, 11g/10g/9i/8i, MS SQL Server 2008/2005/2000, Teradata, DB2 and MS Access

Operating systems: Windows 7/XP/2003/2000/2008/2012 RT/NT, UNIX-SOLARIS, LINUX and AIX

Language: SQL, PL/SQL, UNIX Shell Scripting, C, C++

Scheduling Tools: Tivoli Maestro, $Universe, Autosys, Crontab and UC4

OLAP/BI Tools: Business Objects XI / 6.5 and Crystal Reports 8 / Cognos.

Web Technologies: XML, Web Logic, JBoss, Amazon AWS and F5

Other Tools: Teradata SQL Assistant, TOAD, Apex Explorer For Salesforce Queries(SOQL), Oracle Gloden gate, Win SCP, Erwin 4.x/3.x, MS Office, MS Visio and MS VSS, Address Doctor and Trillium Data Director

BIG DATA: Informatica BDE / Hadoop Administration

PROFESSIONAL EXPERIENCE

Confidential, Quincy, MA

Sr.Informatica MDM Admin ATLAS Program

Responsibilities:

• Installed, Configured and Upgraded Informatica PowerCenter 9.6.X to 10.1 with latest Hot Fix.
• Installed, Configured and Upgraded Informatica PowerCenter TDM /ILM to 10.1 with all EBF’s.
• Installed and re-configured and upgraded Informatica PowerCenter suite (like IPC, ILM, TDM, IDE and IDQ) on a multi flavored environment (heterogeneous environment) as part of teh upgrade process.
• Installed, configured & Upgraded Master Data Management 9.7.1 (MDM) to 10.1 with latest Hot Fix on Web Logic Application Server on Linux and Windows environments.
• Informatica MDM Code Deployments and environment tuning.
• Applying Hot Fixes (HF's) and Emergency Bug Fixes (EBF's) w.r.t MDM, PowerCenter and PowerCenter Cloud environments.
• Installed and configured Informatica PowerCenter Data Transformation (DT) & Data Exchange (DE).
• Deployed/ Migrated MDM, IDQ & DT Service code to higher environments to till Production & DR.
• Deploying Informatica Code using Deployment Groups (Static & Dynamic), Folder Copy and Export& Import etc.,
• Trouble shooting of Web Services & SAP BW services and Web Logic Server on MDM side.
• Backup & Restore activities including but not limited to Disaster Recovery (DR) activities.
• Daily, Weekly & Monthly etc., Maintenance activities w.r.t Informatica PowerCenter & MDM Environment(s).
• Trouble shooting and supporting Informatica PowerCenter, IDQ, PWX, ILM and MDM Environments.
• Taking help from Informatica vender (GCS) support as we needed.

Confidential, Hoboken, NJ

Sr.Informatica Admi Marshmc Informatica Upgrade

Responsibilities:

• Installing and Upgrading Informatica PowerCenter from 8.6 HF6 to 9.6 with HF3.
• Installed and configured Informatica PowerCenter suite (like IPC, PWX, TDM, IDE and IDQ) on a multi flavored environment (heterogeneous environment). Like Linux and Windows.
• Installed and configured Proactive monitoring PMPC, RTAM and PMR.
• Applying Hot Fixes (HF's) and Emergency Bug Fixes (EBF's) w.r.t MDM, PowerCenter and PowerCenter Cloud.
• Installed and configured Informatica PowerCenter Data Transformation (DT) & Data Exchange (DE).
• Deployed MDM, IDQ & DT Service code to higher environments.
• Deploying Informatica Code using Deployment Groups (Static & Dynamic), Folder Copy and Export& Import.
• Trouble shooting of Web Services & SAP BW services.
• Daily, Weekly & Monthly Maintenance activities w.r.t Informatica PowerCenter Environment.
• Trouble shooting and supporting Informatica PowerCenter Environment.
• Taking help from Informatica vender support as we needed.

Confidential, Quincy, MA

Sr.Informatica MDM AdminCMW Reporting System

Responsibilities:

• Installed and Configured Informatica PowerCenter 9.6.X.
• Installed and Configured Informatica PowerCenter TDM /ILM.
• Installed and configured Informatica PowerCenter suite (like IPC, ILM, TDM, IDE and IDQ) on a multi flavored environment (heterogeneous environment).
• Installed and configured Master Data Management 9.7.1 (MDM) on Web Logic.
• Applying Hot Fixes (HF's) and Emergency Bug Fixes (EBF's) w.r.t MDM, PowerCenter and PowerCenter Cloud.
• Installed and configured Informatica PowerCenter Data Transformation (DT) & Data Exchange (DE).
• Deployed MDM, IDQ & DT Service code to higher environments.
• Deploying Informatica Code using Deployment Groups (Static & Dynamic), Folder Copy and Export & Import.
• Trouble shooting of Web Services & SAP BW services.
• Backup & Restore activities including but not limited to DR activities.
• Daily, Weekly & Monthly Maintenance activities w.r.t Informatica PowerCenter & MDM Environment(s).
• Trouble shooting and supporting Informatica PowerCenter & MDM Environment(s).
• Taking help from Informatica vender (GCS) support as we needed.

Confidential, Springfield, MA

Sr.Informatica AdminMMe-DW Reporting

Responsibilities:

• Multi Domain & Multi Node HA Informatica Environment support and maintenance.
• Installed and configured Informatica PowerCenter suite (like IPC, IDE, IDQ & MDM) on a multi flavored environment (heterogeneous environment).
• Applying Hot Fixes (HF's) and Emergency Bug Fixes (EBF's).
• Installed and configured Informatica PowerCenter Data Transformation (DT) & Data Exchange (DE).
• Deploying DT Service code to higher environments.
• Deploying Informatica Code using Deployment Groups (Static & Dynamic), Folder Copy, Export & Import.
• Added new nodes to teh existing domains.
• Security implementation w.r.t. LDAP & Native authentication.
• Users and User Group access management.
• Creating and managing Application services.
• Creating and Managing Global Objects & its access.
• Trouble shooting of Web Services & SAP BW services.
• Day to day backup and restore repository & Domain activities.
• Configuring & Testing Disaster Recovery (DR) w.r.t PROD Environment.
• Installing, Configuring & Trouble shooting Informatica Cloud Secure Agent.
• Installing, Configuring & Trouble shooting Informatica PMPC, RTAM & PMR.
• Daily, Weekly & Monthly Maintenance activities w.r.t Informatica PowerCenter Environment.
• Trouble shooting and supporting Informatica PowerCenter Environment.
• Taking help from Informatica vender support as we needed.

Confidentia, Richardson, TX

Informatica Admin Sunrise DSR Reporting

Responsibilities:

• Environment setup by Installation and configuration of Informatica suite (IPC, IDE, IDQ & MDM).
• Implemented Hot fixes and EBF’s on top of Informatica Up-gradation.
• Performed Informatica repository management activities like creating folders and assigning required permissions to teh folders.
• Installed and configured teh Data Quality application services w.r.t 8.6 and v9.
• Installed and configured teh content including out-of-teh-box and address validation files w.r.t IDQ.
• Implemented teh Data Director Service for Data quality.
• Adding new users and providing teh required roles and privileges Using Admin Console.
• Created and Managed OS profiles w.r.t IPC suite.
• LADP authentication and configuration.
• Created and configured teh Reporting and Dashboards service for Data Quality application.
• Creating and managing connections and providing teh required access levels Using Repository Manager.
• Regular Monitoring and troubleshooting teh Informatica domain.
• Regular repository backup / recovery activities as part of disaster recovery plan.
• Regular health checkups w.r.t Domain, Node and application services as well as space related activities.
• Provided E2E support for Informatica Environment.
• Initially Implemented full proof of concept (POC) as part of Informatica Up-gradation 8.5 to v9.
• Managed teh Informatica Logs and space related issues.
• Developed Documentation for all teh routines (Mappings, Sessions and Workflows).
• Involved in scheduling teh workflows through Tivoli Maestro Job scheduler using UNIX scripts.
• Played a key role in all teh ETL phases and responsible for production support as well.
• Design, Development and Documentation of teh ETL (Extract, Transformation & Load) strategy to populate teh Data Warehouse from teh various source systems.
• Worked on Informatica 9.0.1/8.6.1 in design and development of complex ETL mappings.
• Implemented partitioning and bulk loads for loading large volumes of data as part of performance tuning.
• Based on teh requirements, used various transformations like Source Qualifier, Normalizer, Expression, Filter, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner and Sequence Generator in teh mapping.
• Developed Mapplets, Worklets and Reusable Transformations for reusability.
• Identified performance bottlenecks and Involved in performance tuning of sources, targets, mappings, transformations and sessions to optimize session performance.
• Identified bugs in existing mappings/workflows by analyzing teh data flow and evaluating transformations.
• Performance tuning by session partitions, dynamic cache memory, and index cache.
• Developed Informatica SCD type-I, Type-II mappings. Extensively used almost all of teh transformations of Informatica including complex lookups, Stored Procedures, Update Strategy, Mapplets and others.
• Implemented update strategies, incremental loads, Data capture and Incremental Aggregation.
• Extensively worked on various Look up Caches like Static, Dynamic, Persistent, and Shared Caches.
• Developed workflow tasks like Email, Event wait, Event Raise, Timer, Command and Decision.
• Used PMCMD command to start, stop and ping server from UNIX and created UNIX SHELL, PERL scripts to automate teh process.
• Created UNIX Shell scripts and called as pre session and post session commands.

Environment: Informatica PowerCenter 9.0.1/8.6.1/8.5, Power Exchange, Oracle10g, Teradata, TOAD 10.1 for Oracle, Oracle Glodengate, DB2, Flat Files, PL/SQL, SAP R3, ERWIN 4.x Data Modeling tool, Windows XP SP3, SunOS, UNIX PERL scripting and Tivoli Maestro.

Confidential, Dallas, TX

Informatica Admin (Lead)Matrix Data Reconciliation (MDR)

Responsibilities:

• Installation and configuration of Informatica PowerCenter v9 as part of Up-gradation 8.6.1 to v9 activities.
• Deployment of Informatica code into ST & production environments.
• Informatica repository management like creating folders and assigning required permissions to teh folders.
• Adding new users and providing teh required roles and privileges under User Management Activities (UMA).
• Creating and managing connections and providing teh required access levels.
• Performance tuning and Log management.
• Regular repository backup / recovery activities as part of disaster recovery plan.
• Analyzed project plan to gather teh business requirements and Prepared Detail Design document from teh requirement specification.
• Design, Development, and Documentation of teh ETL (Extract, Transformation & Load) strategy to populate teh Data Warehouse from teh various source systems.
• Created database objects like tables, views, indexes, triggers, packages and stored procedures (Source Pre load and Target Pre load).
• Worked with teh wide range of sources such as delimited Flat files, MS SQL Server, Oracle databases, XML Files like creating XML Definitions for teh mapping and used XML as source and target.
• Extensively used Informatica Power Center 8.6 to create and manipulate Source definitions, Target definitions, Mappings, Mapplets, Transformations and Re-usable Transformations etc.
• Developed Informatica SCD Type I, Type II, Type III mappings and tuned them for better performance.
• Created Complex mappings to transform teh Business logic using Connected/Unconnected Lookup, Sorter, Aggregator, Update Strategy, Router and Dynamic lookup transformations for populating target tables in an efficient way.
• Used Informatica Debugging techniques to debug teh mappings and used session log files and bad files to trace errors occurred while loading.
• Partitioned teh session to reduce teh load time, involved in Performance Tuning of mappings, transformations and (workflow) sessions to optimize session performance.
• Implemented weekly Error tracking and Correction process using Informatica.
• Used Power Center Workflow Manager to create Workflows, Sessions and also used various tasks like Command, Event wait, Event raise, Email, Timer to run with teh logic embedded in teh mappings.
• Involved in scheduling teh workflows through Crontab and Shell scripts.
• Supported teh Quality assurance team in testing and validating teh Informatica workflows.
• Creating test cases for Unit Test, System, Integration test and UAT to check teh data quality.

Environment: Informatica Power Center v9/8.6.1, Oracle 10g, TOAD, Flat File, XML Files, PL/SQL, Windows XP SP2, Sun Solaris 5.1.0, UNIX scripting, MS SQL Server 2008, Crontab.

Confidential, Richardson, TX

Informatica Admin Enterprise Central Data Warehousing (eCDW)

Responsibilities:

• Analyze business requirements to build a data mart design for various business processes conformed to teh business rules.
• Involved in developing OLAP models like facts, measures and dimensions (Data Models) and drafted teh ETL specifications.
• Designed teh data transfer protocol for various relational and non-relational sources including Flat Files.
• Created Reusable Transformations and Mapplets to use in Multiple Mappings and also worked with Shared Folders andShortcuts.
• Created mappings to load data using various transformations like Source Qualifier, Sorter, Lookup, Expression, router, Joiner, Filter, Update Strategy and Aggregator transformations.
• Created Data Breakpoints and Error Breakpoints for debugging teh mappings.
• Implemented Type 2 Slowly Changing Dimensions (SCD).
• Created Parameter Files and multi-level scheduled workflows.
• Worked with both serial and parallel loading and created re-usable, non-reusable Sessions and Email Tasks for On Success/On Failure mails.
• Worked with Workflow Manager for Creating, Validating, Testing and Running teh Sequential and Concurrent Batches and Sessions.
• Identified teh errors by analyzing teh Session logs and solved them.
• Used pmcmd command to run workflows and developed UNIX Shell Scripts for Pre/Post session commands, deployed using Autosys.
• Identified teh bottleneck for slowly running workflows and tuning of teh SQL Queries in order to improve teh performance Confidential teh both Informatica & database level.
• Involved in Unit Testing, System Integration Testing (SIT) and User Acceptance Testing (UAT).
• Maintenance and Support for Informatica interfaces/projects in production.
• Worked on performance improvement for sales data load and achieved teh exceptional results by reduction of teh load time.
• Created mapping documentation and user guides for ETL processes as part of end user training.
• Active participation in testing Custom, Cross Tab and Drill through Reports for teh client using Business Objects and generated reports using BO tools by querying teh database.

Environment: Informatica Power Center 8.5/8.1.1, Oracle 10g, Teradata, TOAD, Flat Files, XML Files, PL/SQL, UNIX scripting, Business Objects XI/6.5, IBM DB2 Mainframes, Erwin 4.2, Tivoli Maestro.

Confidential, San Jose, CA

Informatica Admin

Responsibilities:

• Performed Informatica repository management activities like creating folders and assigning required permissions to teh folders.
• Adding new users and providing teh required roles and privileges Using Admin Console.
• Creating and managing connections and providing teh required access levels Using Repository Manager.
• Regular repository backup / recovery activities as part of disaster recovery plan.
• Provided E2E support for Informatica Environment.
• Implemented Informatica Up-gradation from 8.1.1 to 8.6.
• Implemented Hot fixes on top of Informatica Up-gradation.
• Managed teh Informatica Logs and space related issues.
• Developed Documentation for all teh routines (Mappings, Sessions and Workflows).
• Involved in full life cycle design and development of Data Warehouse.
• Interacted with Offshore developers, business analysts and data architects to develop a data model.
• Assisted in designing and development of Snow Flake Schema and creating Fact Tables and Dimension Tables for teh Warehouse and Data Marts and Business Intelligence Applications using MS Visio.
• Designed teh Informatica Mapping Technical Specifications on teh basis of Functional Requirements.
• Extensively used Oracle SQL *Loader for transformation and loading of source system data.
• Data Extraction from flat file sources, relational databases, DB2, transforming/validating data by using various Transformations of Informatica, loading into teh data warehouse and flat file targets.
• Created mappings using transformations like Source qualifier, Aggregator, Rank, Filter, Expression, Lookup, Update Strategy, Sequence Generator, Normalizer, Router and Joiner.
• Performed tuning of teh database SQL using Explain plan, SQL Trace and HINTS.
• Development of Shell Scripting for Informatica pre-session, post-session scripts.
• Created and monitored Sessions/Batches using Informatica Server Manager.
• Used pmcmd, command line tool to schedule sessions/batches on $Universe scheduling tool.
• Coded PL/SQL Stored Procedure, functions, packages and database triggers to implement business logic.
• Wrote and maintained Stored Procedure to create reporting data mart.
• Scheduled jobs using $Universe toolset.
• Involved in performance tuning of mappings and sessions.

Environment: Informatica Power Center 8.6/8.1.1, Oracle 10g, SQL *Loader & Teradata on UNIX and Windows XP SP3 with Salesforce real time Integration (SFDC inbound / Outbound) and $Universe.

Confidential, AMSTERDAM, NL

Sr.Informatica Developer

Responsibilities:

• Performed Business Analysis and Requirement Gathering from high-end users and managers.
• Analyzed teh functional specifications provided by teh data architect and created technical specifications documents for all teh mappings.
• Created Fact tables(s), Dimension Tables and Star Schema representation for teh DataMart.
• Created schema objects like indexes, views, stored procedures and sequences.
• Implemented various triggers in PL/SQL to maintain referential integrity.
• Designed and Customized data models for Data Mart supporting data from multiple sources on real time.
• Extensively used PowerCenter to design multiple mappings with embedded business logic.
• Created complex mappings using Connected and Unconnected Lookup, Sorter, Aggregator, Source Qualifier and Router for populating target table in efficient manner.
• Developed Reusable Transformations and Mapplets using Transformation Developer and Mapplet Designer for use in multiple mappings.
• Performed Unit and Integration Testing of Informatica sessions, batches and teh target data.
• Redesign teh mapping to improve teh data quality.
• Performance Tuning of sessions by increasing teh DTM buffer size, configuring single pass reading, optimizing data type conversion, eliminating transformation errors and using pipeline partitioning.
• Used pmrep command line utility to perform basic tasks on teh repository.
• Used pmcmd command line utility to perform basic tasks on teh Informatica server.
• Provided knowledge transfer to teh end users and created extensive documentation on teh design, implementation, daily loads and process flows of teh mappings.

Environment: Informatica Power Center 8.X /7.1.1, Oracle 9i, MS Access 2005, MS SQL Server 2000/2005, UNIX Shell Scripting, TOAD, UC4, SQL, PL/SQL, Business Objects 6.5.

Confidential, COPENHAGE

Informatica Developer

Responsibilities:

• Understanding of teh business requirements and enhancing teh existing data warehouse architectural design for a better performance.
• Involved in High level design (HLD) and Low Level Design (LLD) documents.
• Used utility like SQL * Loader to load bulk data.
• Extracted data from various Sources like Oracle, Excel sheets, XML Files, Flat File, SQL Server and loaded into Teradata.
• Developed reusable transformations and Mapplets.
• Designed various mappings using transformations like Lookup (Connected and Unconnected), Router, Update Strategy, Filter, Sequence Generator, Joiner, Aggregator and Expression transformations.
• Designed complex mappings involving target load order and constraint based loading.
• Configured and ran teh Debugger within teh Mapping Designer to troubleshoot teh mapping before teh normal run of teh workflow.
• Created and fine-tuned Sessions by creating performance details on teh Informatica server for a session and evaluated teh performance details and identified teh reason for slow performance in teh source and teh target databases.
• Migrated Mappings, Sessions and Common Objects from Development to test and to production.
• Involved in import/export of repositories, backing and upgrading teh repository.
• Scheduling and Loading data process and monitoring teh ETL process using Informatica.
• Optimized Informatica mappings for Performance Confidential transformation, mapping and session level.
• Provided Production Support by Running scheduled jobs, diagnose session problems, fix mappings for minor business changes etc.
• Implemented Pushdown Optimization technique of Informatica 8 to optimize session.
• Used pmrep command line utility to perform basic tasks on teh repository.
• Used pmcmd command to run workflows from command line interface.
• Set up batches and sessions to schedule teh loads Confidential teh required frequency.
• Created UNIX Shell Scripts for pre/post session commands for automation of loads using Autosys.
• Actively involved in end user training and support.
• Created Reports using Business Objects.

Environment: Informatica Power Center 7.1/6.2, Oracle 8i, MS Access 2005, UNIX Shell Scripting, TOAD, Erwin 4.0, Autosys, SQL, PL/SQL, Business Objects 5.1.

Confidential

Sr.Informatica Developer DCX - SPOT DW

Responsibilities:

• Performed Business Analysis and Requirement Gathering from high-end users and managers.
• Analyzed teh functional specifications provided by teh data architect and created technical specifications documents for all teh mappings.
• Created Fact tables(s), Dimension Tables and Star Schema representation for teh DataMart.
• Created schema objects like indexes, views, stored procedures and sequences.
• Implemented various triggers in PL/SQL to maintain referential integrity.
• Designed and Customized data models for Data Mart supporting data from multiple sources on real time.
• Extensively used PowerCenter to design multiple mappings with embedded business logic.
• Created complex mappings using Connected and Unconnected Lookup, Sorter, Aggregator, Source Qualifier and Router for populating target table in efficient manner.
• Developed Reusable Transformations and Mapplets using Transformation Developer and Mapplet Designer for use in multiple mappings.
• Performed Unit and Integration Testing of Informatica sessions, batches and teh target data.
• Redesign teh mapping to improve teh data quality.
• Performance Tuning of sessions by increasing teh DTM buffer size, configuring single pass reading, optimizing data type conversion, eliminating transformation errors and using pipeline partitioning.
• Used pmrep command line utility to perform basic tasks on teh repository.
• Used pmcmd command line utility to perform basic tasks on teh Informatica server.
• Provided knowledge transfer to teh end users and created extensive documentation on teh design, implementation, daily loads and process flows of teh mappings.

Environment: Informatica Power Center 8.X /7.1.1, Oracle 9i, MS Access 2005, MS SQL Server 2000/2005, UNIX Shell Scripting, TOAD, UC4, SQL, PL/SQL, Business Objects 6.5.