SUMMARY

• 8 Years of IT experience with in depth knowledge in design, development, enhancement of Informatica batches, Data Conversion/Acquisition of large pharmacy and Business Intelligence applications in Health Care and strong development skills to work through entire SDLC methodologies.
• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels and work as a part of team as well as independently.
• Extensive hands on preparing batch architecture for OLTP and ODS system.
• Logical/Physical data modeling - Creation of ER diagram, table partitioning, indexes and query tuning for large volume database.
• Experience in oracle database migration from 10g to 11g and making system in Active- Active mode for batch and oracle database.
• Design and development of sessions, command, email, control and timer tasks and connections and workflows using Informatica Workflow Manager
• Expertise in using Informatica Power Center for large data conversion and Acquisition.
• ETL development experience using Oracle 10g/11g/Flat Files/XML files and Informatica (Source Analyzer; Confidential Designer; Transformation Developer; Mapping Designer; Mappings; Transformations such as Source Qualifier, Aggregator, Sorter, Joiner, Rank, Router, Filter, Expression, Unconnected Lookups, Connected Lookups, Update Strategy, and Sequence Generator, XML parser, Normalizer, SQL transformation, store procedure and Active & Passive transformations, Reusable Transformations etc; Workflow Manager; Workflows, Sessions, Reusable Sessions, command, email, control and timer tasks etc; Workflow Monitor, Parameter Files, Variables).
• Extensively worked on ILM Informatica Transformations for data masking using Key masking, substitution masking, random masking, Social Security numbers, Credit card numbers, Phone numbers and Email addresses etc.
• Good experience of designing/developing slowly changing dimensions like SCD type-1, type-2 and type-3 to maintain the transactional data and historical data
• Performance tuning in Informatica batches by optimizing Sources, Targets, Mappings and Sessions and good experience of using partitioning and parallel processing. SQL query tuning expert.
• Expert in Enterprise job scheduling in production according to system utilization using control-M.
• Good Experience in working with UNIX Shell Scripts to automate Informatica workflows, data processing, FTP, Secure FTP, SCP etc.
• Expertise in using Informatica admin console to manage domain, nodes, repository, integration services, Informatica Repository Manager to managing User, folders, User Connections, Locks etc and importing and exporting workflows using Informatica Repository Manager and automated shell scripts
• Good experience of Informatica code Upgradation of Informatica Repository and Users from Informatica8.1.1 to Informatica 9.1 and from Informatica9.1 to Informatica 9.6
• Expertise in Team Track and Quality center tool used for defect and CR tracking throughout the SDLC life cycle.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.1/8.6.1/8.1.1 , Data masking and IDQ(Data Quality)

Databases: Oracle 11g/10g, OLTP and ODS

Languages: SQL and PL/ SQL and Unix Shell scripting.

Operating systems: Windows XP/Window 2007, UNIX (AIX 6/5.3/4.2)

Scheduling Tools: Control-M 8.0/7.0/6.2

Other Tools: TOAD, WinSCP, Putty, SVN subversion, Mercury Quality Centre, Team Track, Microsoft Office and Visio

PROFESSIONAL EXPERIENCE

Confidential, Woonsocket, Rhode Island

Informatica Batch Designer and Technical Lead

Responsibilities:

• Follow software development life cycle (SDLC) methodologies to understand business requirement, design, development and testing.
• Interact with client/Business Analyst to understand business requirement to prepare good design.
• Create batch architecture document, design document and data map for ETL rules that is scalable for application high volume data.
• Design ETL Informatica batch framework to synchronize data from production to test environment as per pharmacy store.
• Design ETL Informatica batch framework for data masking using Key masking, substitution masking, random masking, Social Security numbers, Credit card numbers, Phone numbers and Email addresses etc.
• Design ETL Informatica batch framework for acquiring data from different pharmacy or to convert other pharmacy to Confidential .
• Logical/Physical data modeling - Creating of ER diagram, table partitioning, indexes and query tuning for large volume database.
• Utilization of performance tuning concepts to optimize Sources, Targets, Mappings and Sessions and using partitioning and parallel processing to make batch scalable to process large amount of data.
• Performance tuning by optimizing SQL queries in source qualifiers using index and partitioning.
• Utilization of Confidential Initiate tool for patient and prescriber search and de-duplication to improve search.
• Design of various Active & Passive transformations, reusable transformations, mappings and Mapplets and sessions using Informatica.
• Design Informatica Power center batch architecture to extract transformation and load data from different sources like oracle, flat files and XML files to send to third parties.
• Design ETL Informatica Transformations including - Source Qualifier, Connected - Unconnected Lookup, Filter, Expression, Router, Joiner, Rank, Aggregator, Sorter and Sequence Generator, XML parser, Normalizer, SQL transformation, store procedure, update strategy and transaction control transformation and created complex mappings.
• Design architecture for slowly changing dimensions like SCD type-1, type-2 and type-3 to maintain the transactional data and historical data for the need of business process using Informatica applications.
• Identifying, researching, and analyzing production issues in order to develop solutions and help development team.
• Designing Stored Procedures, packages, triggers, cursors, tables, and views and other SQL.
• Scheduling of batch job in production according to system utilization using control-M.
• Experienced in data migration from one server / location to different server environments using FTP, Secure FTP, SCP methodologies and good experience in working with UNIX Shell Scripts for automatically running sessions, aborting sessions, creating parameter files and running batch jobs.

Confidential

Sr. Informatica Batch Developer/Designer

Responsibilities:

• Follow SDLC methodologies to understand business requirement, design, development and testing.
• Interact with client to understand business requirement to prepare good design.
• Worked with Business Analysis team to understand requirements and created design document.
• Create batch design and data map for ETL rules that is scalable for application high volume data.
• Preparing ETL architecture to process high volume data in OLTP.
• Design of various Active & Passive transformations, reusable transformations, mappings and mapplets using Informatica Mapping Designer.
• Design of sessions, command, email, control and timer tasks and connections and workflows using Informatica Workflow Manager
• Design/Develop Informatica Mappings, Mapplets, Sessions, Workflows and Worklets for data loads from different sources like Oracle, Flat files, XML data with various data formats.
• Use Informatica Power center for data extraction, transformation and loading from desperate data sources like oracle, flat files and XML files and load the data into different targets like oracle and flat file etc.
• Design/Develop ETL Informatica Transformations including - Source Qualifier, Connected - Unconnected Lookup, Filter, Expression, Router, Joiner, Rank, Aggregator, Sorter and Sequence Generator, XML parser, Normalizer, SQL transformation, store procedure, update strategy and transaction control transformation and created complex mappings.
• Interacting with offshore development team to explain design.
• Design architecture for slowly changing dimensions like SCD type-1, type-2 and type-3 to maintain the transactional data and historical data for the need of business process using Informatica applications.
• Performance tuning in Informatica batches by optimizing Sources, Targets, Mappings and Sessions and using partitioning and parallel processing.
• Performance tuning by optimizing SQL queries in source qualifiers using index and partitioning.
• Logical/Physical data modeling - Creating of ER diagram, table partitioning, indexes and query tuning for large volume database.
• Scheduling of batch job in production according to system utilization using control-M.
• Experienced in data migration from one server / location to different server environments using FTP, Secure FTP, SCP methodologies and good experience in working with UNIX Shell Scripts for automatically running sessions, aborting sessions, creating parameter files and running batch jobs
• Identifying, researching, and analyzing the issues in order to develop solutions and assist production support team.

Confidential

Informatica Administrator

Responsibilities:

• Identifying, researching, and analyzing the issues to assist with data analysis to improve operation.
• Proving performance tuning suggestions in Informatica batches by optimizing Sources, Targets, Mappings and Sessions and using partitioning and parallel processing.
• Proving Scheduling of batch job in production according to system utilization using control-M.
• Expertise in using Informatica admin console to manage domain, nodes, repository, integration services and logs
• Upgradation of Informatica Repository and Users from Informatica8.1.1 to Informatica9.1.1.
• Repository code page conversion to support multi lingual character sets.
• Used Informatica Repository Manager to managing User, folders, User Connections, Locks and other repository related tasks.
• Good hands on in Importing and exporting workflows using Informatica Repository Manager and automated shell scripts.
• Expertise to set up new environment for different environment like development, system testing and UAT for batches.

Confidential

Sr. Informatica Batch Developer

Responsibilities:

• Development of various Active & Passive transformations, reusable transformations, mappings and mapplets using Informatica Mapping Designer.
• Development of sessions, command, email, control and timer tasks and connections and workflows using Informatica Workflow Manager
• Development Informatica Mappings, Mapplets, Sessions, Workflows and Worklets for data loads from different sources like Oracle, Flat files, XML data with various data formats.
• Develop ETL Informatica Transformations including - Source Qualifier, Connected - Unconnected Lookup, Filter, Expression, Router, Joiner, Rank, Aggregator, Sorter and Sequence Generator, XML parser, Normalizer, SQL transformation, store procedure, update strategy and transaction control transformation and created complex mappings.
• Performance tuning in Informatica batches by optimizing Sources, Targets, Mappings and Sessions.
• Extensively used database partitioning (key range, hash and list), indexing and parallel processing data in Informatica sessions.
• Performance tuning by optimizing SQL queries in source qualifiers using index and partitioning.
• Scheduling of batch job in production according to system utilization using control-M.
• Optimize UNIX Shell Scripts to reduce execution timing of data processing.

Confidential

Informatica Batch Developer

Responsibilities:

• Development of various Active & Passive transformations, reusable transformations, mappings and mapplets using Informatica Mapping Designer.
• Development of sessions, command, email, control and timer tasks and connections and workflows using Informatica Workflow Manager
• Development of Informatica Mappings, Mapplets, Sessions, Workflows and Worklets for data loads from different sources like Oracle, Flat files, XML data with various data formats.
• Use Informatica Power center for data extraction, transformation and loading (ETL) from desperate data sources like oracle, flat files and XML files and load the data into different targets like oracle and flat file etc.
• Extract data from xml files and loaded into OLTP, ODS and Flat file using XML Source Qualifier, XML Parser Transformations.
• Develop ETL Informatica Transformations including - Source Qualifier, Connected - Unconnected Lookup, Filter, Expression, Router, Joiner, Rank, Aggregator, Sorter and Sequence Generator, XML parser, Normalizer, SQL transformation, store procedure, update strategy and transaction control transformation and created complex mappings.
• Creation of UTR and UTS for ETL testing and shell scripting.
• Scheduling of batch job in production according to system utilization using control-M.
• Create process follow for UNIX Shell Scripts for automatically running sessions, aborting sessions, creating parameter files and running batch jobs.
• Experienced in data migration from one server / location to different server environments using FTP, Secure FTP, SCP methodologies.

Confidential

Informatica Batch Developer

Responsibilities:

• Development of various Active & Passive transformations, reusable transformations, mappings and mapplets using Informatica Mapping Designer.
• Development of sessions, command, email, control and timer tasks and connections and workflows using Informatica Workflow Manager
• Development Informatica Mappings, Mapplets, Sessions, Workflows and Worklets for data loads from different sources like Oracle, Flat files, XML data with various data formats.
• Use Informatica Power center for data extraction, transformation and loading (ETL) from desperate data sources like oracle, flat files and XML files and load the data into different targets like oracle and flat file etc.
• Extract data from xml files and loaded into OLTP, ODS and Flat file using XML Source Qualifier, XML Parser Transformations.
• Develop ETL Informatica Transformations including - Source Qualifier, Connected - Unconnected Lookup, Filter, Expression, Router, Joiner, Rank, Aggregator, Sorter and Sequence Generator, XML parser, Normalizer, SQL transformation, store procedure, update strategy and transaction control transformation and created complex mappings.
• Creation of UTR and UTS for ETL testing and shell scripting.
• Scheduling of batch job in production according to system utilization using control-M.
• Create process follow for UNIX Shell Scripts for automatically running sessions, aborting sessions, creating parameter files and running batch jobs.