SUMMARY:

• 11+ years of overall IT experience.
• Very good exposure to the Agile and waterfall based software development, Integration architecture.
• Very strong exposure indifferent ETL concepts and integration approaches
• Expert in providing complete ETL solutions for data integration projects in domains - Funds, Shares etc.
• Currently learning Hadoop administration which is internally deployed by Informatica EDC.
• Solid experience on Informatica New Applications - IDQ, Axon, EDC and integration of them.
• End to End setup and configuration of Manta Flow(Lineage Tool)
• Good Leadership and Management experience
• Good Team building, Collaborative, Positive environment creative skills.
• Very effective Listening skills, positive attitude and solid white board presentation skills.BE|2009
• Major: Electronics and ComputersAdministration
• Very strong experience in administrating complex, enterprise Informatica Environments.
• Migrated over ~100 projects from one version to another version of Informatica with near-to-zero issues.
• Very strong in analyzing and adapting to the Eco system such as schedulers, Unix/Linux systems, Databases
• Solid experience in installation of Enterprise Informatica environments with efficient planning and execution.
• Generated Data domain discovery reports for data warehouse to help in identifying the columns for masking
• Very strong experience in setting up IDQ environment for profiling needs.
• Good experience in configuring the IDQ to use Hadoop cluster as resource to run the jobs.
• Administered Informatica environments on versions 7x, 8x, 9x, 10x.
• Lean thinking and Customer centric approach practices in Informatica administration area.
• Managed Informatica environments on OS platforms - Linux and Windows 2008/2012.
• Solid experience in creating “Self-Service” environments of Informatica.
• Configuring and on-boarding multiple database on to Manta and liverage the Lineage capability of Informatica EDC with help of Manta and Informatica EDC Integration.Architecture
• Road Mapping and Future State Design, Solution Design of the ETL projects
• Process design and alignment of building clocks for Data Ops flow.
• Solid experience in capacity planning of the ETL environment.
• Solid experience in designing the DR environment for Informatica.
• Expert knowledge on Enterprise Integration patterns.
• Very good experience in designing and Architect of implementing the out of Box solutions.
• Good exposure to enforcing ETL best practices and design patterns.
• Sound Knowledge on security implementation on ETL environments - SSO/LDAP.Infrastructure management and administration
• Solid experience in proper configuration of the Power Center Domain components.
• Informatica - Setting up the Data Explorer environment and Enterprise discovery for the organization by setting up data domains etc.
• Experience in nodes, Repository services, Integration services, and Reporting Services and SAP BW services.
• Experience in Create, backup, restore for Informatica Repositories.
• Maintain all necessary updates and/or patches for the ETL environments
• Worked on Typical Transformations like Web Service Consumer, Java Transformations
• Setup the Secure Agent Server for Informatica Cloud.
• Handled user access / security role requests for new developers and projects
• Coordinate deployments that include Informatica deployments as well as probably Unix Shell Script and Database DDL deployments
• Write Repository Queries in support of developments and Production statistics
• Ensures proper compliance of the licensing files.
• Creating Folders and manages user and user group access to objects based on LDAP settings.
• Performed Upgrading Informatica Power center Version 7.X to Informatica Power center 8.X, PowerCenter 9.X., PowerCenter 10.X
• Setup the Environment (Installation/Security/LDAP) for Informatica 10.2 Data Quality for Invesco.
• Setup the Environment (Installation/Security/LDAP) for Informatica 10.2 Enterprise Data Catalog Environments (Dev, QA and PROD) and upgrade to Latest version of 10.4.0.2Version.
• Setup the Environment (Installation/Security/LDAP) for Informatica Axon 5.x Environments(Dev, QA and PROD) and upgrade to the latest version of Axon 7.x
• Expert in creating and publishing the wiki with all documents in place
• Expert in creating “self-service” environments where customers/users empowered with many activities without admin dependency.Maintenance, OUTAGE, Error Handling & COMMUNICATION:
• Good Experience in setting up and policies and procedures for Informatica environment
• Solid experience in rolling out the new policies and procedures with CAP(change acceleration process) methodology to user community and ensure to minimize the impact.
• Good experience in creating communication templates to send global communications for outages/environment updates etc.
• Involving Testing, Debugging, Validation and Performance Tuning of data warehouse, help develop optimum solutions for data warehouse deliverables.
• Creates and maintains all databases required for development, testing, and production usage.
• Ensure the Unix/Linux systems and database systems are with latest security/DB patches.
• Analyze Change request (CR) as per requests from development teams
• Responsible for investigation, characterization, and communication of build and release problems; implementing corrective and preventive actions. Resolved the issues BMC Remedy Tickets on Priority basis.
• As per Change requests (CR) migration of objects in all phases (DEV, QA and PRD) of project and trained developers to maintain system when in production.
• Ability to perform root cause analysis, performance monitoring and application related issues
• Involving Testing, Debugging, Validation and Performance Tuning of data warehouse, help develop optimum solutions for data warehouse deliverables.
• Creating SR to Informatica Inc- related to any Power center product issues.
• Starting/Stopping Informatica services
• Stake holder Communication Management, Vendor Management.
• Coached junior administrators in the team
• Managed Informatica Upgrade projects with proper planning and execution.
• 6+ years of exposure to ETL Administration.
• 3+ years of experience in ETL code development.
• 3+ years of experience in creating metadata manager lineage jobs
• 3+ years of experience in creating and analyzing data using IDE/DQ tools
• Currently learning Hadoop Administration and Architecture.

TECHNICAL SKILLS

Domain: - Finance/Investment banking, Consumer.

Architecture Framework: - TOGAF

ETL: - Informatica 7x,8x,9x,10x.,IDQ. Informatica Metadata Manager

Big Data: Hadoop 2.6

Data Governance: - Informatica Enterprise Data Catalog, Informatica Axon

Business tools: Informatica Business Glossary

Schedulers: - Crontab, Autosys, Control M

Database: - Oracle, Sqlserver

Scripting: - Bash/Kron.

Data Modelling: Erwin, Power Designer

Ticketing Tools: BMC, Service Now

Auditing Exposure: SOX.

PROFESSIONAL EXPERIENCE:

Deputy Manager

Confidential

Responsibilities:

• Installation and Configuration Informatica EDC, Axon and IDQ
• Upgrade of Axon and EDC Environments
• Setting up security and Groups in Informatica Environments
• Demand Management
• Helping in setting up the DG Framework and implementation.
• Defining Custom DataDomains and use them in catalog to enrich Metadata.
• Automation of Scanner run’s in EDC
• Building report for Data Quality and Scanners status using PowerBI\Tableau.

Adv Data Governance Analyst

Confidential

Responsibilities:

• Setup Scanners\Resources in EDC
• Setup Encryption for DB's while data on move by installing Security s on both Informatica Server and DB Hosting servers
• Setup a new dedicated samba share for DataGovernance Team and mount it on EDC Servers from which the files are scanned to EDC.
• Setup Custom linage job in EDC and show the lineage of how the data is being populated from different zones (Source, landing, confirmed and Organized zones) for Data Lake.
• Schedule DQ Rules of a DataSet in Axon to run in IDQ and get the scores updated in Axon.
• Setup Axon users and assign necessary Role.
• Provided end to end solution and implemented for GDPR using Axon.
• Creating of Data Domain rules and leveraging the Auto Glossary and Data Domain propagation in Informatica EDC by teaching ML of Informatica.
• Automatic onboarding of Datasets to Axon using the Advanced features of Axon 7.0
• Scripting in Python to Automate the Lineage Scanner, Scanners Report from EDC using REST API
• Design and develop the Internal Exception Management system which gives the real time Data quality and showing up the scores in Axon.

Senior Lead Informatica administrator

Confidential

Responsibilities:

• Responsible for the Uptime and availability of the Mission critical production environment.
• Responsible for providing support to the developers/production support as in needed.
• Implemented Informatica AXON, EDC and IDQ solutions in Invesco and architected and collaborated with user community and helped them to be familiarize with the tools and “how to” of the different tasks
• Well managed the work load with balance of initiatives and Day to Day operations, and created capacity to take over support of other BI tools in Analytics space.
• Lead Informatica upgrade project from 9x to 10x version with near to zero post production issues.
• Implemented best practices like Wiki creation, Unified communication DL for users etc.
• Resolved critical performance issues of the ETL jobs by proposing best practices of ETL code
• Implemented proactive monitoring on the errors getting logged in the system
• Implemented a custom data model and ETL flows to load operation metrics like source success rows, sources, targets etc
• Configured the IDQ environment for organization data profiling needs.

Application managment Analyst

Confidential

Responsibilities:

• Responsible managing critical environments of Informatica
• Analysis of existing policies and procedures across the environment and seek the opportunities for the innovation.
• Responsible to automate existing manual activity - User creation/Folder creation.
• Created dashboard for cache disk usage, memory usage for all Informatica servers.
• Handled the change management for all the applications.
• Partnered with Storage team in creating the reports for IOPS for all BI related Infrastructure to debug any issues with storage.
• Provided end to end picture for all the loads in production environment with all other parameters like cache/memory usage etc.
• Created Wiki for the Informatica space with all the standard procedures etc.
• Responsible for initializing the new services - Informatica Data Quality and Metadata manager for business and provide necessary KT for developers.
• Responsible for all the documentation and ensured the seamless transition between Users/fellow admins on the new process/polices