Resume

Sign in

Data Manager

Location:
Rockland, Massachusetts, United States
Posted:
January 30, 2018

Contact this candidate

Resume:

E-mail: ac39el@r.postjobfree.com

Summary:

**+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. Have 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 principles 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 the 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 the 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 the deadlines.

Education:

Bachelor of Technology (B.Tech-2002).

Technical Skills:

Below is a list of important software & hardware products, tools and methods that I have worked with

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 Golden 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 Memberships / Certifications:

Professional Society / Certification

Member Since / Date Certified

Informatica PowerCenter 7x/8.x/9.x

October 2007 / November, 2009/ June, 2012

Data Science - Massachusetts Institute of Technology (MIT)

July, 2017

Trainings Attended:

Functional Knowledge Transfer about BASEL-II Management Information System

Trainings Conducted:

Functional Knowledge Transfer and Training about Cisco to the new team members

Introduction to ETL concepts (Extraction Transformation & Loading) and Basic Administration to the up and down stream system members.

Work Experience:

The details of the various Projects that I have handled are listed here in chronological order.

Client: CWM, Quincy, MA, USA Dec 2015 – Till Today Role: Sr.Informatica MDM Admin ATLAS Program

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 the 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.

Client: Marsh & McLennan, Hoboken, NJ, USA Aug 2015 –Dec 2015

Role: Sr.Informatica Admin Marshmc Informatica Upgrade

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.

Client: CWM, Quincy, MA, USA Nov 2014 - Aug 2015

Role: Sr.Informatica MDM Admin CMW Reporting System

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.

Client: MassMutual, Springfield, MA, USA Sep 2013 - Nov 2014

Role: Sr.Informatica Admin MMe-DW Reporting

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 the 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.

Client: AT & T, Richardson, TX, USA Mar 2012 - Sep 2013

Role: Informatica Admin Sunrise DSR Reporting

The project is to build an Application data warehouse by taking heterogeneous sources like flat files, Mainframes, oracle and transforming the data according to the specifications and loading in to the financial data warehouse (eCDW) which will be very useful to Business Intelligence people to query the data from data warehouse for reports and analysis of the business in future.

As an Informatica Admin:

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 the folders.

Installed and configured the Data Quality application services w.r.t 8.6 and v9.

Installed and configured the content including out-of-the-box and address validation files w.r.t IDQ.

Implemented the Data Director Service for Data quality.

Adding new users and providing the required roles and privileges Using Admin Console.

Created and Managed OS profiles w.r.t IPC suite.

LADP authentication and configuration.

Created and configured the Reporting and Dashboards service for Data Quality application.

Creating and managing connections and providing the required access levels Using Repository Manager.

Regular Monitoring and troubleshooting the 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 the Informatica Logs and space related issues.

Developed Documentation for all the routines (Mappings, Sessions and Workflows).

Involved in scheduling the workflows through Tivoli Maestro Job scheduler using UNIX scripts.

Played a key role in all the ETL phases and responsible for production support as well.

Other Responsibilities:

Design, Development and Documentation of the ETL (Extract, Transformation & Load) strategy to populate the Data Warehouse from the 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 the requirements, used various transformations like Source Qualifier, Normalizer, Expression, Filter, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner and Sequence Generator in the 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 the 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 the 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 the 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 Goldengate, DB2, Flat Files, PL/SQL, SAP R3, ERWIN 4.x Data Modeling tool, Windows XP SP3, SunOS, UNIX PERL scripting and Tivoli Maestro.

Client: Frontier Communications, Dallas, TX, USA Apr 2011 – Mar 2012

Role: Informatica Admin (Lead) Matrix Data Reconciliation (MDR)

As an Informatica Admin:

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 the folders.

Adding new users and providing the required roles and privileges under User Management Activities (UMA).

Creating and managing connections and providing the required access levels.

Performance tuning and Log management.

Regular repository backup / recovery activities as part of disaster recovery plan.

Other Responsibilities:

Analyzed project plan to gather the business requirements and Prepared Detail Design document from the requirement specification.

Design, Development, and Documentation of the ETL (Extract, Transformation & Load) strategy to populate the Data Warehouse from the various source systems.

Created database objects like tables, views, indexes, triggers, packages and stored procedures (Source Pre load and Target Pre load).

Worked with the wide range of sources such as delimited Flat files, MS SQL Server, Oracle databases, XML Files like creating XML Definitions for the 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 the 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 the mappings and used session log files and bad files to trace errors occurred while loading.

Partitioned the session to reduce the 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 the logic embedded in the mappings.

Involved in scheduling the workflows through Crontab and Shell scripts.

Supported the Quality assurance team in testing and validating the Informatica workflows.

Creating test cases for Unit Test, System, Integration test and UAT to check the 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.

Client: AT & T, Richardson, TX, USA Aug 2010 – Mar 2011

Role: Informatica Admin Enterprise Central Data Warehousing (eCDW)

As an Informatica Admin:

Performed Informatica repository management activities like creating folders and assigning required permissions to the folders.

Adding new users and providing the required roles and privileges Using Admin Console.

Creating and managing connections and providing the required access levels Using Repository Manager.

Regular repository backup / recovery activities as part of disaster recovery plan.

Involved in performance tuning activities

Provided E2E support for Informatica Environment.

Implemented Informatica Up-gradation from 8.1.1 to 8.5.

Implemented Hot fixes on top of Informatica Up-gradation.

Managed the Informatica Logs and space related issues.

Developed Documentation for all the routines (Mappings, Sessions and Workflows).

Involved in scheduling the workflows through Tivoli Maestro Job scheduler using UNIX scripts.

Responsibilities:

Analyze business requirements to build a data mart design for various business processes conformed to the business rules.

Involved in developing OLAP models like facts, measures and dimensions (Data Models) and drafted the ETL specifications.

Designed the 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 the 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 the Sequential and Concurrent Batches and Sessions.

Identified the errors by analyzing the 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 the bottleneck for slowly running workflows and tuning of the SQL Queries in order to improve the performance at the 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 the exceptional results by reduction of the 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 the client using Business Objects and generated reports using BO tools by querying the 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.

Client: Cisco Systems, San Jose, CA, USA Feb 2009 – Aug 2010

Role: Informatica Admin Channels and Distribution System

As an Informatica Admin:

Performed Informatica repository management activities like creating folders and assigning required permissions to the folders.

Adding new users and providing the required roles and privileges Using Admin Console.

Creating and managing connections and providing the 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 the Informatica Logs and space related issues.

Developed Documentation for all the routines (Mappings, Sessions and Workflows).

Involved in scheduling the workflows through $Universe Job scheduler using UNIX scripts.

Responsibilities:

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 the Warehouse and Data Marts and Business Intelligence Applications using MS Visio.

Designed the Informatica Mapping Technical Specifications on the 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 the 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 the 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.

Client: ABN AMRO, AMSTERDAM, NL Aug 2007 – Jan 2009

Title: Sr.Informatica Developer BUEU BASEL II Management Information System

Responsibilities:

Performed Business Analysis and Requirement Gathering from high-end users and managers.

Analyzed the functional specifications provided by the data architect and created technical specifications documents for all the mappings.

Created Fact tables(s), Dimension Tables and Star Schema representation for the 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 the target data.

Redesign the mapping to improve the data quality.

Performance Tuning of sessions by increasing the 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 the repository.

Used pmcmd command line utility to perform basic tasks on the Informatica server.

Provided knowledge transfer to the end users and created extensive documentation on the design, implementation, daily loads and process flows of the 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.

Client: AP Moller, COPENHAGEN, UK Jan 2007 – Aug 2007

Title: Informatica Developer

Responsibilities:

Understanding of the business requirements and enhancing the 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 the Debugger within the Mapping Designer to troubleshoot the mapping before the normal run of the workflow.

Created and fine-tuned Sessions by creating performance details on the Informatica server for a session and evaluated the performance details and identified the reason for slow performance in the source and the target databases.

Migrated Mappings, Sessions and Common Objects from Development to test and to production.

Involved in import/export of repositories, backing and upgrading the repository.

Scheduling and Loading data process and monitoring the ETL process using Informatica.

Optimized Informatica mappings for Performance at 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 the repository.

Used pmcmd command to run workflows from command line interface.

Set up batches and sessions to schedule the loads at the 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



Contact this candidate