SUMMARY

• Over 12+ years of dynamic career reflecting pioneering experience in the field of Information Technology as a Informatica ETL Developer and Administrator in Data Warehousing and Client/Server technologies, with strong understanding in Administration.
• Excellent INFORMATICA SYSTEM ARCHITECTURE and ADMINISTRATION CAPABILITIES.
• Installed configured and maintained INFORMATICA SOFTWARE in support of BUSINESS PROCESSING REQUIREMENTS.
• Performs SOFTWARE INSTALLATIONS, UPGRADES and APPLYING bug fixes to Informatica software packages in AIX, Solaris, and Red Hat Linux.
• Expertise in Informatica issue resolution, debugging and performance tuning.
• Extensive Hands - on experience in INFORMATICA POWERCENTER (8.x/9.x/10.x) ADMINISTRATION and PRODUCTION SUPPORT.
• Extensive Hands-on experience in Informatica Intelligent Cloud Services (IICS) Administration.
• Configuration of security domains and Scheduling Synchronization of the users/group with LDAP directory service, if you use LDAP security Domain.
• Worked on setup of Informatica Disaster Recovery Environment.
• Worked on configuration of Power Exchange, Informatica B2B.
• Worked on configuration of Informatica TDM and masking the databases for avoiding PII data in lower regions.
• Worked on Development and Production support environments on INFORMATICA POWERCENTER
• Having experience scheduling jobs using Control-M / AutoSys/CA WLA
• Having experience in leading a team of people (Onsite and offshore) during the Project life cycle.
• Proficient in UNIX Shell Scripting.
• Limited experience with Informatica products suites EDC 10.4.0, Axon 7.0
• Experience in Writing technical documentation and procedures.
• Strong experience in installation of Informatica on UNIX, Migration of repositories, and up-gradation of repositories.
• Good experience in maintaining Oracle, ODBC connections and installing and maintaining various new database connectivity software and Informatica plugins for respective software.
• Closely worked with the DBA in creating tables, migrating tables to different environments and obtaining permissions on various tables, actively worked with Unix teams and Sys admins in rolling out the updates and hot fixes.
• Exposure to Multiple Database Amazon Redshift, Netezza, SQL server, Oracle.
• Involved in Presales support - RFP support, Solution architecture Design.

TECHNICAL SKILLS

ETL Tools: Informatica PC 8.x/9.x/10.x, Amazon Web Services, Data Quality, B2B, IDQ, Power Exchange, Informatica TDM,IICS

Databases: SQL server, Oracle. DB2, Netezza, Redshift Database

Operating System: UNIX (Solaris, HP-UX, AIX), Windows server 2012

PROFESSIONAL EXPERIENCE

Confidential, Boston MA

Sr. Informatica Admin & TDM Architect

Responsibilities:

• Involved in capacity management of servers and storage.
• Upgraded Informatica from version 9.6.1 and 10.2.0(Migrated to Microsoft Azure)
• Configuration of Informatica Intelligent Cloud Services (IICS) and handled deployments and SAML configurations.
• Worked on the Critical issues and got it resolved with Informatica.
• Solving problems, long running jobs, investigate failures and application support.
• Performing day to day administrative activities such as Deployment, involvement in production issues.
• Monitoring and tuning ETL repository and system for performance improvements
• Handled Multiple Outages in our environment and have coordinated the activities with various teams involved in the Outage.
• Involved as Test Data Management Architect -Design and manage TDM framework using Informatica TDM and Power Center
• Interact with Business, SMEs, Application Managers, DBAs to understand the system constraints.
• Capture and analyze masking requirement from business perspective.
• Perform PHI/PII analysis, data profiling, masking rule creation, execution & trouble shooting.
• Create masking framework for different file formats such as flat, CSV, XML, EDI etc. as per business need.

Confidential, New York NY

Sr. Informatica Administrator

Responsibilities:

• Involved as Informatica Administration - Installation & Configuration of Informatica Products like PowerCenter and Data Quality.
• Test the Informatica installation for different components of Advanced Edition like Dry run to check the stability of the installation and connectivity test to check different data sources connectivity.
• Configuration of LDAP, Informatica services and upgrading the code from existing version. Automation of regular tasks through Unix Scripting.
• Configure, Update Operating System Profiles.
• Involved in development activities.
• PGP/GPG /SSH key Generation and Implementation.
• Worked on configuration of Informatica B2B DT.
• Support the existing Production, QA and Development environments.
• Configuration of redshift and S3 connectors.
• File system maintenance for utilization of the storage.
• Power Exchange installation and configuration.
• Worked on setup of Informatica Disaster Recovery Environment.

Confidential

TDM Architect/Support Lead

Responsibilities:

• Implement Gold Copy architecture and create reusable data cubes for non-production refreshes.
• Design and manage TDM framework using OneTDM, Informatica TDM and Power Center
• Interact with Business, SMEs, Application Managers, DBAs to understand the system constraints.
• Capture and analyze masking requirement from business perspective.
• Perform PHI/PII analysis, data profiling, masking rule creation, execution & trouble shooting.
• Create masking framework for different file formats such as flat, CSV, XML, EDI etc. as per business need.
• Project management activities such as scope evaluation, estimation, resource and project planning, work prioritization, monitoring, project status reporting
• Have profound knowledge in Test Data Management Tools like Informatica ILM TDM Informatica -10.1, Data Masking, Archival and Test Data Management
• Strong Architectural concepts, database skills, Object Oriented Programming, and development knowledge
• Involved on End-to-End Test Data Management process by using the tool One TDM.
• Developing shell scripts, SQL queries as per client requirements
• Organizing scrum calls on daily basis and solving technical and process-oriented queries to the offshore team.
• Upgrade Existing environments to Latest Software releases

Confidential

Sr. Informatica Administrator

Responsibilities:

• Support the existing Production, QA and Development environments.
• Installation of Informatica 9.6 /V10.1 on UNIX servers.
• Configuration of LDAP, Informatica services and upgrading the code from existing version.
• Automation of regular tasks through Unix Scripting.
• Establish the standards and best practices.
• Support all Informatica related issues faced by development team and provide resolutions to the users.
• Configure, Update Operating System Profiles.
• Setup of Power Exchange for SQL Server CDC.
• Support Informatica Platform during off-hours and weekends.
• Setup of Informatica Archiving.

Confidential

Lead Informatica Administrator

Responsibilities:

• Work with the Infrastructure Team to Procure the Hardware, Storage.
• Work with the DBA’ Confidential for Creation of Database Instance, Oracle Client Installs.
• Install PowerCenter 8.1.1 SP5 for the 7 Repositories in Development, QA & Production.
• Import the Repository Dumps received from Confidential TSG Environment and Unix File system Exports.
• Install the DB2 Client and Teradata ODBC Drivers, Appworx V6 Agents for Informatica.
• Install Power Exchange Client for Informatica on Informatica Servers to connect SAP.
• Ensuring 24x5 production support and reporting various production issues encountered to customer on daily basis.
• Planning the schedules for maintenance of applications and servers.
• SSH key Generation and Implementation.
• Generation and Implementation of PGP/GPG Encryption for the files containing confidential data fields.
• Providing Incident Management, Problem Management, Root Cause Analysis and Corrective Action for the issues occurred in the environment.
• Hotfix/EBF Installations on the server.
• Design/Code Reviews before moving the code to production environment.
• Setup and Configuration of Informatica Disaster Recovery Environment.

Confidential

Lead Informatica Developer and Administrator

Responsibilities:

• Designed the Mapping Technical Specifications on the basis of Functional Requirements.
• Created ETL mappings using Informatica Power Center to move Data from multiple sources like Flat files, Oracle, SAP and Web Services into a common target area such as Staging, Data Warehouse and Data Marts.
• Tested the Informatica mappings with manual testing and assisted QA team.
• Developed different mappings by using different Transformations like Aggregator, Lookup, Expression, update Strategy, Joiner, Router etc to load the data into staging tables and then to target. Aggregator, Lookup, Expression, update Strategy, Joiner, Router, processes, test cases, and error control routines Sequence generator etc transformations in the mappings.
• Creating shared folders, user groups, Individual users and assigning privileges to them to enforce security authorizations on accessing the repository objects.
• Coordinating and assisting the developers while moving objects across folders and repositories and assisting them during production moves.
• Used Pmrep and Pmcmd command line modes to issue instructions to Informatica Server and Informatica repository server for scheduling and managing the ETL jobs and other repository management and maintenance activities.
• Created as well as worked on existing UNIX shell scripts and used session, mapping variables as and when required.

Confidential

Informatica Developer

Responsibilities:

• Involved in Analysis and High-Level Design as well as Low Level Design.
• Designing of Mapping Technical Specifications on the basis of Functional Requirements.
• Created reusable transformations, mappings, mapplets, workflows, worklets, and database connections using Mapping Designer and Workflow Manager.
• Testing the mappings to ensure that data is loaded as per ETL Specification.
• Involved in creating test cases, test scripts and test data for testing the Informatica mappings and workflows.
• Worked on using the Informatica command line utilities like pmrep, pmcmd and infacmd to control workflows, creation of deployment groups, sessions and tasks in Linux.
• Informatica Vendor Engagement for Issues.
• Handling the production build process moving or copying workflows, mappings and different repository objects from one folder to other folder and from repository to other local repositories.
• Analysis and Fixing the Bugs, which arose in the Due Course of the project.
• Scheduling and running the jobs from AppWorx Scheduler.