SUMMARY:

• 9+ years of IT experience in different phases of software development life cycle (SDLC).
• Experienced in design, development, administration, maintenance & troubleshooting of Data Warehouse & Data Extraction using Informatica as ETL Tool.
• Solid experience in Informatica Power Center (versions 10/9.x/8.x/7.x) including PowerCenter Repository Manager, Designer, Workflow Manager, Workflow Monitor & Informatica Developer.
• 2 years of experience with Informatica Cloud Services .
• Experienced in providing production support on shared services platform with more than 20 projects per region( Americas, Asia Pacific, EMEA )
• Responsible for 100% uptime of production and non - production systems.
• High availability, GRID, Real Time and Version control features.
• Involved in migration of objects in all phases (DEV, QA and PROD) of project and trained developers to maintain system when in production.
• Proficient in using Informatica command line utilities like infasetup to define, backup & restore domain components, pmcmd to create, schedule and control workflows, tasks, and sessions & pmrep to perform repository backups, creating folders etc.
• Worked with Pre-Session and Post-Session UNIX scripts for automation of ETL jobs using scheduling tools like AutoSys & Control M and Involved in migration/conversion of ETL processes from development to production environment.
• Proficient in UNIX shell scripting.
• Change Management and Change Control experience for maintaining system integrity.
• Technical leadership, mentoring designers, architects, developers and development teams.
• Excellent analytical, problem solving skills and a motivated team player with excellent inter-personal skills and excellent presentation skills.
• Advanced hardware & software troubleshooting skills.

TECHNICAL SKILLS:

Operating systems: UNIX, LINUX, IBM AIX, Windows Server 2012/2008

ETL Tools: Informatica PowerCenter 10.1.1/10.1/10.0/9.6.1/9.5.1/9.1.0/8.6.1/8.1.1, Informatica Data Integration Hub 10.0, Informatica Data Quality 10.1.1/9.6.1, Informatica Power Exchange, B2B Data Exchange

Data Modeling: Kimball’s Methodology, ERWIN 4.1, Star-Schema Modeling, Snowflake Modeling, FACT and Dimension Tables

Databases: Oracle, MS SQL Server, DB2, Netezza, TERADATA, MS Access

Languages: SQL, PL/SQL, UNIX Shell Scripting, XML

DB Tools: SQL*Plus, SQL*Loader, Toad for Oracle 10.5, Toad for Data Analysts 2.1, Aginity Workbench for Netezza

PROFESSIONAL EXPERIENCE:

Sr. Informatica Administrator

Confidential, Chicago - IL

Responsibilities:

• Installed and Configured Informatica PowerCenter 10.1.1, Informatica Data Quality Version 10.1.1 on Windows Server 2012.
• Installed and Configured Salesforce Analytics Wave Connector 10.1.1 for Informatica PowerCenter 10.1.1.
• Upgraded Informatica PowerCenter from version 9.5.1 to 10.1.0.
• Apply EBF’s and Hotfixes to Informatica Servers as needed.
• Code deployments from UAT to PROD, performance analysis, user management, patching and versioning.
• Installed ProActive Monitoring for PowerCenter Operations 3.0 HotFix 1 (PMPC) and RulePoint 6.1 for Informatica PowerCenter for creating alerts about Domain, Repository, Nodes, workflows and session failures.
• Installed, Configured and Administered Informatica Cloud environments .
• Responsible for 100% uptime of Informatica Cloud Service (ICS) and Informatica Cloud Real Time (ICRT).
• Deployed ICS tasks across DEV, UAT & PROD environments and making sure the Tasks, Mappings and Mapping Configuration Tasks are valid post deployments.
• Involved in importing the existing PowerCenter workflows as Informatica Cloud Service tasks by utilizing Informatica Cloud Integration .
• Support monthly patching activities by stopping and re-starting services before and after the patch event.
• Testing the integrity of Informatica Cloud Real Time Processes post monthly patching events and making sure the processes are in published status and working as expected.
• 24X7 On-call production support on a rotation basis.
• Extensively worked with Informatica GCS, R&D and Product Specialist teams for researching and resolving the issues/bugs found during various phases of the product lifecycle.

Informatica Administrator

Confidential, Chicago - IL

Responsibilities:

• Installed and Configured Informatica PowerCenter, Informatica Data Quality & Informatica B2B Data Exchange for Version 10.0 on Windows Server 2012.
• Created & Configured PowerCenter Repository Services, PowerCenter Integration Services, Model Repository Services, Data Integration Services, Content Management Services & Web Services Hub on DEV, QA, UAT & PROD environments.
• Configured High Availability (HA) & GRID for Data Integration Service & PowerCenter Integration Service.
• Configured High Availability for Data Exchange Dashboard & Reports by setting up the load balancer.
• Responsible for stopping and starting Informatica, B2B DX, Data Integration Hub servers and services to support monthly windows patching events.
• Used Informatica Command line utilities like infaservice, infasetup, infacmd, pmrep, pmcmd to perform administrative and maintenance tasks.
• Applied the EBF’s (Emergency Bug Fixes) and Hotfixes for various issues on Informatica server.
• Migrated code across DEV, QA, UAT & PROD.
• Created Relational, ODBC and Application connections in PowerCenter and IDQ to establish connectivity to various databases including but not limited to MS SQL Server, Cassandra, JMS and JNDI.
• Attend standup calls to provide status on various tasks on daily basis.
• Work with DBA & network teams to resolve any databases and connectivity issues.

Informatica Administrator

Confidential, Chicago - IL

Responsibilities:

• Worked as a member of the Enterprise Integration and Data Management team which provided Data Integration solutions to the entire Confidential .
• Installed Informatica PowerCenter 10.0 on Windows server 2012; Created & configured PowerCenter Repository Services, Integration Services, Web Services Hub.
• Installed Informatica 9.6.1 HF3 Big Data Edition for Hadoop on UNIX for DEV, QA & PROD multi node configuration for HA/GRID; Configured Hortonworks and loaded data to Hive, Pig tables .
• Created Model Repository Services, Data Integration Services, Analyst Services, Content Management Services & Reporting Services for Informatica 9.6.1 HF3.
• Deployed Address Doctor files for Address Validation and Content Validation services to implement Address validation and Address Cleansing functionality.
• Assisted with migration of PowerCenter 9.1.0 HF5 to 9.5.1 HF4 on AIX to Linux; Created & configured PowerCenter Repository Services, PowerCenter Integration Services.
• Installed and Configured LDAP authentication for Informatica services.
• Configured Master Node and Backup nodes under High Availability environment with Grids.
• Migrated code across DEV, QA & PROD Repositories.
• Creation and maintenance of Informatica users, groups, roles and privileges.
• Assisted with migrating AutoSys jobs into production and Monitor jobs to ensure successful execution.
• Extensively worked on UNIX shell scripts on automation, monitoring, UNIX file system maintenance and cleanup using Informatica Command line utilities ( pmrep, pmcmd, infacmd ).
• On-board new projects and perform capacity planning to estimate the growth of the project.
• Responsible for problem identification and resolution of failed processes or jobs.
• Interacted with Informatica GCS and CA Unicenter support for raising service requests and worked with them aggressively to get root cause analysis of any failures.
• Assisted customers in troubleshooting issues with their applications in AutoSys and trained the teams to use WCC interface.
• Prepared documentation on a regular basis and created a knowledge repository.
• Provided 24X7 on-call support on a rotation basis.
• Participated in annual DR exercise and successfully tested scenarios to establish connectivity various components in the event of a disaster.

Informatica Administrator

Confidential, Charlotte - NC

Responsibilities:

• I worked as a member of the Wholesale Managed Services team which provides middleware support in a shared infrastructure catering to 50+ projects in both dedicated and shared environments.
• Upgraded Informatica PowerCenter, IDQ & Metadata Manager Version 9.1.0 HF5 to Version 9.6.1 HF1 on RHEL 5.9 & WINDOWS Server 2008 R2 for DEV, SIT, UAT, PROD & BCP/DR servers with multi node HA/Grid environment.
• Installed Informatica PowerCenter 9.5.1 on UNIX; Created & configured PowerCenter Repository Services, PowerCenter Integration Services.
• Assisted with installing ProActive Monitoring 3.0 (PMPC) and RulePoint 5.2 HF3 for Informatica PowerCenter for alerting the production support teams about workflows, session failures.
• Created documents for Knowledge Base on Installation, Upgrade, Configuration, Migration procedures, Best Practices and Naming Standards.
• Deployed code across environments related to Informatica Data Quality.
• Deployed Address Doctor files for Address Validation and Content Validation services related to the Informatica Data Quality projects.
• Helped with installation of PowerCenter clients on developer’s machine and establish connectivity to Informatica repository services.
• Created windows batch scripts to monitor NFS mount points space usage where Informatica shared components for application groups are available.
• Configured Operating System Profiles specific to project requirements and managed user privileges on the profiles.
• Meet with Project Managers and Application team leads on a monthly basis to understand their project growth to proactively perform capacity planning to support/monitor applications on the shared Informatica platform.
• Worked with Informatica Global Support to get the RCA of any server, job, Integration, Repository Service failures and providing various run time statistics for the same.
• Planning and maintaining sufficient memory on application servers across the grid for better ETL Load performance.
• Performance tuning of server and hardware components and applying licenses appropriately per environment.
• Created UNIX shell scripts for backing up the domain and repository services.
• Monitoring server space and cleaning up log files and core files generated by various processes.
• Code migration across DEV, SIT, UAT & Production Repositories.
• Work with Operating System Engineers (OSE) & DBA’s to resolve system issues and bottleneck and troubleshooting issues related to Server/Database/Configuration.
• Analyzed the Change requests (CR) and Work Orders (WO) to ensure proper deployment of code to production environment.
• Partner with other technical and business areas to ensure successful implementation of a stable, scalable environment that supports all projects.
• Support monthly and quarterly patching activities by stopping and re-starting services before and after the patch event.
• 24X7 On-call production support on a rotation basis.
• Supported annual DR/BCP testing activities and assisted application teams to successfully test failover scenarios to be prepared in case of disaster.

Informatica Administrator

Confidential, Baton Rouge - LA

Responsibilities:

• Member of Enterprise Data Services (EDS)/Enterprise Data Warehouse (EDW) team which provides Data Integration capabilities to the entire organization and standardizing IT processes for extracting and transforming data from multiple sources.
• Installed Informatica PowerCenter 9.5.1 on windows and applied latest hotfixes.
• Created and configured PowerCenter Repository Services, PowerCenter Integration Services, Metadata Manager Service, Model Repository Services, Data Integration Services, Analyst Services, Content Management Services, Reporting Services & Web Services Hub Services on Informatica 9.5.1.
• Upgraded existing DEV, QA & Prod environments from version 9.1.0 to Informatica PowerCenter 9.5.1 and configured the Power Center Domain components.
• Implemented PowerCenter High Availability by configuring multiple nodes in domain as gateway nodes, and configuring PowerCenter application services to run on multiple nodes.
• Responsible for ensuring proper application of the licensing files.
• Ensure proper configuration of the pmrep and pmserver components.
• Administer the Informatica repository by creating folders and logins for the group members and assigning necessary privileges.
• Handle user access requests for new developers and ensure the assignment of appropriate security roles and privileges.
• Designed and documented the upgrade process for Informatica PowerCenter tools.
• Involved in regression testing of the new environment with existing ETL code and comparing the performance with the current environment.
• Responsible to migrate ETL Informatica code by using team based versioning.
• Handled PowerCenter User Security migration from Native to LDAP security.
• Created SQL queries to query the Repository DB to find the deviations from Confidential ’s ETL Standards for the objects created by users such as Sources, Targets, Transformations, Log Files, Mappings, Sessions and Workflows.
• Developed batch scripts for maintenance and automation of Informatica PowerCenter process.
• Assisted with the conversion of SSIS package to Informatica.
• Responsible for optimal health of Informatica servers, take necessary steps for better ETL performance including but not limited to server parameters tuning, ETL code issues, optimal design suggestions etc.
• Document processes and train team members within an onsite/offsite resource model.
• Provided 24/7 production support.
• Participated in capacity planning discussions to evaluate the future needs.
• Performed a thorough analysis on Informatica Licensing to assist the Confidential in fully assessing future ROI and meeting the audit and compliance regulations.
• Adhere to HIPAA regulations.
• Responsible to work with Informatica support, provide feedback to managers, find a root cause and take necessary steps to prevent ongoing issues.
• Coordinate with System Analysts, Server team & DBA’s during system outages scheduled for patching & upgrades.
• Attend Change Advisory Board (CAB) meetings to represent team related change activities and to stay informed about changes happening across IT which may affect application.
• Attend weekly incident & problem management meetings to review incidents occurred in the past week and to determine a resolution to the unresolved high priority incidents.

Informatica Administrator

Confidential, Charlotte - NC

Responsibilities:

• Member of Data Integration Center of Capabilities which provided shared services for Data Integration through Data Integration resources, standard practices & common infrastructure to enable repeatable successful Data Integration deployments.
• Installed Informatica Power center 9.1.0 on HP-UNIX and applied latest hot fixes.
• Installed PowerCenter Repository Services, PowerCenter Integration Services, Model Repository Services, Data Integration Services, Analyst Services, Content Management Services, Reporting Services & Web Services Hub Services on Informatica 9.1.0.
• Administered the Informatica repository by creating folders and logins for the group members and assigning necessary privileges.
• Handled user access requests for new developers and ensure the assignment of appropriate security roles and privileges.
• Creating, performing backup and restoring the Informatica Repositories.
• Provide Informatica (PowerCenter and DX) administration support for multiple dedicated environments.
• Responsible for handling the Code Migration requests raised by development teams and cross checking the migrated code in Production with read only access to confirm the successful migration of all objects.
• Performed code review to adhere to Confidential standards and policies.
• Administer and provided support for ETL processes using Power Exchange, Metadata Manager, IDE and IDQ.
• Supported the implementation of Change Data Capture for data updates using Power Exchange.
• Configured PowerExchange Listener & Logger Services on DEV, QA & PROD environments and created shell scripts for capturing the log from PWXCCL*.log
• Created Relational, Application, Queue (MQ), Loader (Teradata Tpump/FastLoader) connections and managed user permissions on these connections on daily basis.
• Configured Operating System Profiles specific to project requirements and managed user privileges on the profiles.
• Added and updated crontab, ODBC and TNS entries on Informatica servers for establishing connectivity to different databases.
• Established connectivity to DB2 database by cataloging the DB2 instance as a Remote Node.
• Created service requests (SR’s) to Informatica to troubleshoot any product related issues/bugs.
• Responsible for resolving issues and Incident Management tickets on priority basis in a timely manner.
• Configure ETL metadata repositories and managed both development and production environment.
• Co-ordinate with production support team for fixing failed tests in the Production Server.
• Responsible for environment failovers to DR.
• Ensured proper configuration of the Power Center Domain components.
• Experienced in Grids, nodes, Repository and Integration services.
• Developed UNIX shell scripts for automation of monitoring Informatica environments.
• Involve in unit testing, systems testing, integrated testing and user acceptance testing.
• Performance tuning, improvement, balancing, usability, automation.
• 24/7 Production Support on a rotation basis.
• Monitored jobs, server space availability and CPU Process.
• Supported the managed file transfers using FTP, SFTP & NDM connect direct and worked with Data transmission support team to troubleshoot issues related to transmission failures.
• Work with System Analysts & DBA’s to resolve server & database related issues.
• Analyzed the Change requests (RFC) and Business Requirement Documents (BRD) and proposed optimal solution to the development/business teams to ensure proper deployment of code to production environment.
• Attend status calls with team members to provide weekly status and update the team of planned upgrades/activities.
• Trained team on Production Support and other necessary documentation.
• Helped programmers to correctly and efficiently design their mappings/programs.
• Involved in Incident, release, and change management.

Informatica Developer

Confidential, Boca Raton - Florida

Responsibilities:

• Extensively used Informatica Power Center 8.6.0 as ETL tool for developing project.
• Used Informatica Data Explorer and Informatica Data Quality for Data Quality Management and Data profiling purposes.
• Used Informatica Data Quality to formulate data conversion and data cleansing rules.
• Performed Data Integration, Data Standardization using IDQ.
• Designed mapping pipeline logic using lookup, Normalizer, aggregator, router, filter, expression, input, output, sequence generator and external procedure Transformations.
• Designed Mapplets, and reusable transformations within the ETL pipeline to embed the business process logic.
• Extensively worked on performance tuning and monitoring of programs, ETL procedures and processes.
• Interacted with the business users to collect Business Functional processes and translated them to ETL specification documents using Velocity Methodology.
• Used ETL debugger extensively to identify the performance bottlenecks within the mappings.
• Used workflow manager to create workflows, sessions, and used various tasks like command task, email task, control task and decision task.
• Prepared the ETL documentation for data conversions.

ETL Developer

Confidential . Dallas - Texas

Responsibilities:

• Developed Informatica development life cycle process documents.
• Worked with business teams to gather the functional requirements and translated them into ETL technical documents.
• Involved in discussions with business analysts and source and target system experts to map requirements to Informatica code.
• Prepared high-level design specification document, Informatica Mapping specification documents for all the Transformations used in the project.
• Imported data from various source (Oracle, Flat file, XML) and transformed and loaded into targets using Informatica.
• Developed Informatica mappings using heterogeneous sources like flat files and different relational databases, Mapplets, Mappings using Power center Designer.
• Developed and Implemented UNIX shell scripts through command task to handle requirements like dropping and building indexes, flat file archiving/dropping process etc.
• Extensively used Informatica debugger to figure out the problems in mappings. Also involved in troubleshooting existing ETL bugs.
• Generated WSDL files and published WebServices for request and response format using Informatica PowerCenter.
• Created client code for accessing WebServices using SOAP UI client and accessing the required WSDL URL.
• Extensively worked in the performance tuning for the mappings and ETL Procedures both at designer and session level.
• At session level tuned the mapping by setting the buffer size, cache size, increasing commit intervals etc.
• Created Incremental data loading logic using mapping variables.
• Implemented constraint based load ordering of target data within the pipeline.
• Implemented aggregation logic using expression transformation with in the pipeline to implement the business logic.
• Designed the Parallel and sequential session Workflows and scheduled the Workflows and Sessions using the Workflow Manager.
• Developed UNIX shell scripts for scheduling workflows by using pmcmd.
• Involved in unit testing, systems testing, integrated testing and user acceptance testing.
• Fixed failed jobs in the Production Server