SUMMARY

• Eight years of hands - on experience in Data warehousing, ETL, and applications using Informatica (PowerCenter/Power Exchange/Data Quality)
• Experience in configuring Informatica 10.x/9.x/8.x server by considering Domains, Nodes, Grids, Repository server, Integration Server, administration console, sources, Clients (Designer, Workflow manager, and workflow monitor).
• Strong experience with PWC HDFS and Hive Connector, Informatica Big Data Edition 9.6.1 HF2
• Experience with Hadoop ecosystem components like HDFS, YARN, Pig, Hive, HBase, Sqoop and Oozie.
• Comprehensive understanding of HDFS architecture, its components and services like job tracker, name node and data node.
• Deployed HBase tables, Hive tables and views, loaded data into them, wrote HiveQL scripts to fetch the data.
• Expertise in importing data from RDBMS to HDFS and exporting data from HDFS into RDBMS using Sqoop.
• Installing, configuring, upgrading Informatica tools like PowerCenter, Power Exchange, Power Exchange Express CDC, Power Analyzer in the Development, Test and production Environments.
• Experienced in Informatica PowerCenter (versions 10.0/9.6/9.5.1/9.5/9.1/9.0.1/8.6/8.1) including Designer, Workflow Manager, Workflow Monitor, Repository Manager and Admin console.
• Hands on Experience in Installing and Configuring Informatica Secure Agent (Informatica cloud).
• Hands on experience on Configuring Metadata Manager Services, Reporting Services, Reporting and Dashboard Services provided by Informatica with use cases.
• Strong experience in administering Informatica Server, Repository services, maintaining repository security, creating directory structures, backup/recovery of Informatica repository, supporting the jobs in production.
• Create and maintaining global & local repositories, users, groups, folders, shared folders, re-usable objects and LDAP Configuration.
• Hands-on experience in configuring PWX CDC for Oracle .cfg files and starting Listener and Logger services.
• Experience in writing Unix shell scripts for executing Informatica Jobs, clearing the alert logs, deleting core files, automation of repository administration by using infasetup, pmcmd, pmrep, infacmd commands in scripts.
• Experience usingInformatica Developer IDQ Big Data Edition.
• Well experience in the maintaining the version repository database by purging the old logs and versions.
• Worked in Informatica B2B Data Transformation
• Experience in Complete life cycle of Design, Development, Documentation and Maintenance of the Data marts and Data warehouse..
• Extensive experience in Tuning and scaling the procedures for better performance by running explain plan and using different approaches like hint and bulk load.
• Worked on Data Modeling, E-R diagrams, Logical, Physical design, Star/Snow flake Schemas using Erwin
• Team player and self-starter, capable of working independently and motivate a team of professional.
• Excellent interpersonal and communication skills, technically competent and result-oriented with strong problem-solving skills.
• Experience on Micro-strategy Administrative daily activities such as project configuration, connection set-up, migration objects.
• Designed and developed ETL Automation using Jenkins, Source tree and Git Hub.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 10.x/9.x./8.x, Informatica B2B, Informatica Data Quality 10.x/9.x, PWX, Informatica Big data edition

Data Modeling: Erwin 4.0/3.5,MS Visio, Oracle designer 2000

DBMS: Oracle 11g/10g/9i, MS SQL Server 2005/2000, Microsoft Access, Excel, Teradata, ODBC

Programming Languages: SQL, PL/SQL, Unix Shell scripting

Operating Systems: UNIX, LINUX, Windows XP/2008/2003/2000/NT/98/95

Other tools: VISIO, ERWIN, TOAD, CITRIX, MicroStrategy, Service Now, UC4, Autosys (Batch Scheduling)

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, Georgia

Sr. Informatica Administrator

Responsibilities:

• Upgraded Informatica PowerCenter and Data Quality from 9.6.1 to 10.1.1 HF1 on Windows Environment.
• Installation and configuration of Informatica Big data edition 10.1.1 HF1 on Linux.
• Applied various EBF’s in Power center and BDM to fix product bugs.
• Installing and Configuring Model repository, Data integration service and Analyst Service in IDQ.
• Configuring LDAP to connect different Data Center.
• Installing and Configuring Metadata Manager and Reporting services for the Data Lineage and Repository Reports respectively.
• Actively resolved all performance issues arising out ofBig Data Hiveloads.
• Parameterized connections to Hadoop within Informatica Developer.
• Developed the standards document for usingInformatica Developer with Hadoop.
• Monitored the operating system response in terms of CPU usage, disk space, swap space and paging by using various UNIX utilities like SAR, vmstat and top.
• Involved in doing error handling, debugging and troubleshooting Sessions using the Session logs, Debugger and Workflow Monitor.
• Setup email alerts notification in BDM to notify users when domain/service goes down.
• Performed Informatica server administration tasks such as stopping/starting Informatica Repository and Server processes, performing code migration from Dev to Test, backup and restoring of Informatica.
• Extensively used Power Center command line utilities such as pmcmd, Pmrep embedded in shell scripts to perform various administrative tasks such as migrations, repository backup scripts, start/stop scripts, statistics collections etc.

Environment: Informatica -Power Center 10.1.1, Informatica Data quality 10.1.1, Informatica BDM 10.1.1, BDE Hive Hadoop Hue Green Plum, Object and Integrity Manager

Confidential, Menomonee Falls, Wisconsin

Sr. Informatica Administrator

Responsibilities:

• Upgrade of Informatica PowerCenter Environment to 10.0 from lower versions (9.1.0 and 9.6.01) and applying patches to the Informatica for fetching session log (EBF).
• Installing and Configuring Model repository, Data integration service and Analyst Service in IDQ.
• Planned and implemented SSL port 389 to 636 a secured standard port in Powercenter and IDQ.
• Configuring LDAP to connect different Data Center.
• Installing and Configuring Metadata Manager and Reporting services for the Data Lineage and Repository Reports respectively.
• Configure ODBC7.0 drivers for various source/target databases connectivity i.e. Oracle, MS SQL Server and IBM DB2.
• Repository administration such as creating repositories, folders, managing groups, users, and security.
• Installation and configuration of Informatica Big data edition.
• Actively resolved all performance issues arising out ofBig Data Hiveloads.
• Parameterized connections to Hadoop within Informatica Developer.
• Developed the standards document for usingInformatica Developer with Hadoop.
• Planned and designed ETL automation using tools such as GitHub, Source-tree, Jenkins using which development team could migrate, create connections, migrate scripts in Informatica PowerCenter themselves.
• Scheduled and executed sessions, sequential and concurrent batches for proper execution of mappings sent notification e-mails using Server Manager.
• Configure Database and ODBC connectivity to various source/target databases of Oracle, SQL Server.
• Hands on MicroStrategy Administrator day to day activities.
• Worked on configuring new projects in MicroStrategy.
• Created packages to deploy from one environment to other using object manager and integrity manager.
• Created various database instances in micro-strategy opening firewall ports.
• Configuring various devices on micro-strategy web such as IPhone, IPad, Android devices.
• Generated various security certificates as per requirement using Venafi.
• Worked on configuring managed file transfer(MFT) nodes and DNI’s to transfer files from one host to other.

Environment: Informatica -PowerCenter 10.0, Power Exchange CDC for Oracle, Data Quality 9.6.0, Oracle 11g, IBM DB2, Reports and Dashboard services, BDE Hive Hadoop Hue Green Plum, JIRA, MicroStrategy Developer, Object and Integrity Manager, Venafi, MFT, Jenkins, GitHub, Service Now.

Confidential, El Segundo, California

Sr. Informatica Administrator

Responsibilities:

• Up gradation Informatica PowerCenter Environment to 9.6.0 from lower version and applying patches to the Informatica for fetching session log.
• Installing Informatica in HA mode and Configuring GRID on the Integration services.
• Installing and Configuring Metadata Manager and Reporting services for the Data Lineage and Repository Reports Respectively.
• Migration Informatica from Data Center to Different Data Center.
• Hands on knowledge on Integration Services Architecture and its components such as Load Balancer, DTM processing, Grids, code pages and data movement modes etc.
• Have good knowledge on Installation and Configuration of PowerCenter connect for LDAP.
• Extensively used PowerCenter command line utilities such as pmcmd, Pmrep embedded in shell scripts to perform various administrative tasks such as migrations, repository backup scripts, start/stop scripts, statistics collections etc.
• Actively resolved Informatica/Big Data limitations in Informatica Developer.
• Actively used Hue to accessBeehive HCatalog File Browser and Ambarion Hadoop.
• Have done Informatica big data setup and created connections as required by project team.
• Configuring Reporting and Dashboard Services and Jasper soft iReporting.
• Performed installation/configuration of Informatica B2B Data Transformation Studio
• Setup ofB2B Environmentfor the processing ofHIPAA, SWIFT, HL 7 and EDI-X12type of files
• Created documents for basic how-to for Data Transformation Studio.
• Performed installation/configuration of Proactive Monitoring. Created code review rules (governance/operations) in rule-point of proactive monitoring.
• Designed and developed sophisticated workflows and data transformations involving Informatica B2B components DX Data Exchange and DT Data Transformation.
• Enabling Web Services Hub and Configuring JMS Connections to inbound and outbound of XML Messages.
• Creating Informatica server administration automation scripts using UNIX shell scripting.
• Analysis of current Informatica environment and identification of errors and recommended on where best practices can be used.

Environment: Informatica - PowerCenter 9.6.0/9.1.0, Power Exchange CDC for Oracle, Jasper soft iReport, Actuate 7.0, Reports and Dashboard services, IDQ, Web Services Hub, Oracle 10g, UNIX Shell Script, AutoSys, Unix/Linux, UC4 Scheduling tool

Confidential, Denver, CO

Informatica Administrator

Responsibilities:

• Installed Informatica PowerCenter, Power exchange version 9.6.0/9.5.1 in HA mode and configuring GRID on the Integration services
• Installed Informatica B2B Data Transformation and Configured the HIPAA 5010 DT Libraries.
• Configured HIPAA Validation for Data Transformation Libraries.
• Installing and Configuring Metadata Manager and Reporting services for the Data Lineage and Repository Reports respectively.
• Installing Power Exchange CDC for Oracle and Configuring dbmover.cfg and pwxccl.cfg files, Starting Listener and Logger on the Informatica servers on nohup mode.
• Configure ODBC7.0 drivers for various source/target databases connectivity i.e. Oracle, MS SQL Server and IBM DB2.
• Installing and Configuring MRS, DIS and Analyst Services for Data Quality services
• Design, develop and test ETL processes using Informatica PowerCenter to bring in all needed data sources for the organization.
• Analyze business requirements, technical specification, source repositories and physical data models for ETL mapping and process flow.
• Experience in the integration of various data sources such asOracle, DB2, XML Files and Flat files.
• Worked on Outbound and Inbound Process of EDI Files (Electronic Data Interchange)
• Configured Informatica Data Quality Address Doctor USA Address Validation.
• Extensively worked on Informatica Performance tuning to find potential bottlenecks in the Source, Informatica and Target systems.
• Monitored the operating system response in terms of CPU usage, disk space, swap space and paging by using various UNIX utilities like SAR, vmstat and top.
• Analyze business requirements, technical specification, source repositories and physical data models for ETL mapping and process flow.
• Worked extensively with different Caches such as Index cache, Data cache, Lookup cache (Static, Dynamic and Persistence) and Join cache while developing the Mappings.
• Creating Informatica server administration automation scripts using UNIX shell scripting.
• Repository administration such as creating repositories, folders, managing groups, users, and security.
• Scheduled and executed sessions, sequential and concurrent batches for proper execution of mappings sent notification e-mails using Server Manager.
• Involved in designing the frame work for ETL automation and working over production failures.
• Involved in doing error handling, debugging and troubleshooting Sessions using the Session logs, Debugger and Workflow Monitor.

Environment: Informatica - Powercenter 9.6.0/9.5.1, B2B DT, IDQ, Power Exchange CDC for Oracle, Data Quality, Oracle 11g, MS SQL Server, IBM DB2, Reports and Dashboard services.

Confidential, Phoenix, AZ

Informatica Administrator/Lead

Responsibilities:

• Installing, configuring, up gradation and administration of various versions of Informatica tools such as PowerCenter, Power Analyzer and Power Exchange.
• Installing PowerExchange CDC for Oracle and Configuring dbmover.cfg and pwccl.cfg files, Starting Listener and Logger on the Informatica servers on nohup mode.
• Configure Database and ODBC connectivity to various source/target databases of Oracle, Sql Server.
• Enabling Web Services Hub and Configuring JMS Connections to inbound and outbound of XML Messages.
• Analyze business requirements, technical specification, source repositories and physical data models for ETL mapping and process flow.
• Worked extensively with different Caches such as Index cache, Data cache, Lookup cache (Static, Dynamic and Persistence) and Join cache while developing the Mappings.
• Creating Informatica server administration automation scripts using UNIX shell scripting.
• Repository administration such as creating repositories, folders, managing groups, users, and security.
• Scheduled and executed sessions, sequential and concurrent batches for proper execution of mappings, sent notification e-mails using Server Manager.
• Extensively used PowerCenter command line utilities such as pmcmd, Pmrep embedded in shell scripts to perform various administrative tasks such as migrations, repository backup scripts, start/stop scripts, statistics collections etc.
• Designing automation of ETL jobs using Informatica batches and Pre-Session and Post-Session UNIX scripts using Korn shell scripting in VI editor.
• Performed Informatica server administration tasks such as stopping/starting Informatica Repository and Server processes, performing code migration from Dev to Test, backup and restoring of Informatica.
• Involved in automating a manual regression process by writing UNIX shell scripts, which are generally used when the source files are not received from the upstream systems

Environment: Informatica - PowerCenter 9.0.1/8.1/8.6, Power Exchange CDC for Oracle, Sonic - MQ JMS Services, Web Services Hub, Oracle 10g, UNIX Shell Script, AutoSys, Business Objects, Erwin, Windows XP, Unix, UC4 Scheduling tool.

Confidential, Sacramento, CA

Informatica Administrator/Developer

Responsibilities:

• Installed and Configured the Informatica PowerCenter and connected with each database in Data Warehouse using ODBC network layer.
• Migrating the code between various environments like CUT (Development), ETE (Testing), DR (Production Mirror) and Production.
• Developed the Informatica mappings using various transformations, Sessions and Workflows. SQL Server was the target database, Source database is a combination of Flat files, Oracle tables, People Soft, Excel files, CSV files etc.
• Upgrading from Informatica 7.x to 8.x, adding support patches and bug fix patches.
• Informatica environment administration. Creating users and groups, configuring profiles and privileges. Configured folders and folder security. Configured shared folders for re-usable objects
• Developed Shell and Perl scripts to FTP files, parallelize tasks, send email notifications, implement archive strategies and purge old data.
• Designed template documents, which were used by the developers, during the migration of the ETL code to QA and Production environments.
• Written UNIX Shell scripts to automate the process of analyzing, gathering statistical data, clearing the alert logs, trace dump files and setting cron jobs for all.
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
• Setting of Error Logic for streamlining and automating the data loads for cleansing and trapping incorrect data on staging servers and then loading it to the Oracle data warehouse
• Wrote Shell scripts for removal of Core and Log file after specified interval of time.
• Maintained Code Check-In/Check-Out procedures and assisted in managing code release in all environments.
• Involved in doing error handling, debugging and troubleshooting Sessions using the Session logs, Debugger and Workflow Monitor.

Environment: Informatica - PowerCenter 7.1/8.1, Oracle 10g, SQL Server, AutoSys, Erwin4.0, Windows XP, UNIX

Confidential

Informatica Developer

Responsibilities:

• Extensively involved in the Analysis, design and Modelling.
• Extensively used Joins, Triggers, Stored Procedures and Functions in interaction with backend database using PL/SQL.
• Used Informatica Repository Manager to maintain all the repositories of various applications.
• Developed mappings using several transformations such as Filter Transformations, Joiner Transformations, Rank Transformations, Sequence Generator Transformations, Stored Procedure Transformations and Expression Transformations in Informatica.
• Design and Development of pre-session, post-session routines and batch execution routines using Informatica Server to run Informatica sessions.
• Designed multi-dimensional Star schema, Generated the database scripts, E-R diagrams using ERWIN.
• Participated with the Data Architect in the dimensional modeling of the Market Quality Data warehouse
• Creating Oracle Packages and Stored Procedures, Functions, Triggers.
• Starting Sessions and Batches and make Event based scheduling using Informatica PowerCenter Server Manager. Developed Documentation and Process Flow for mappings and sessions.
• Using Informatica Power Connect for Siebel to extract and integrate customer relationship management (CRM) data stored in Siebel.
• Created new business requests by developing Informatica mappings and PL/SQL code.
• Worked with the Business Objects reporting team in creating simple reports and provide appropriate data to meet the reporting requirements
• Written Shell scripts for the daily maintenance operation of the Database like backup procedures, checking the space allocations and table space analysis
• Checked and tuned the performance of application

Environment: Informatica-PowerCenter, Oracle 8.x, PL/SQL, Business Objects, UNIX Shell Script, Windows NT/2000, HP UNIX.