Data Integration Management
Resume:
BHARATH REDDY VOOKANTI
EXPERIENCE SUMMARY:
• Having around 9+ years of IT experience in Administrative, Development, and Support of Data Warehousing and Data Integration solutions using the Informatica and snap logic tool.
• Hands-on knowledge and experience with Informatica Power Centre (PC), Informatica Data Quality (IDQ), Informatica Intelligent Cloud Services (IICS), and Master Data Management (MDM).
• Knowledge and Hands-on Experience in SnapLogic tools such as SnapLogic Designer, Manager and Dashboard.
• Experience in configuring the SnapLogic Ground Plex on AWS EC2 Instances and upgrading to the latest release
• Worked on Adding users to SnapLogic and configuring the groups, Projects and granting privileges and performing code migrations across the environments.
Experience in setting up snap logic connections to both ON-PERM and CLOUD databases such as DB2, Salesforce, Snowflake and S3.
Experience in creating appropriate triggers to invoke snap logic pipelines as necessary in the snap logic’s Elastic Integration Platform.
Built pipelines to move and process B2MML messages that are generated SIEMENS manufacturing automated systems to SAP HANA via JMS Queues by converting them to idoc files.
Experience in Upgrading Informatica Power Center from v961 to 10.2 Versions.
Experience in applying Hot Fixes and Patches to Informatica Platform.
Experience and hands-on knowledge about resolving development and environment-related issues by working with developers and platform vendors
Expertise on Informatica client tools Admin Console, Developer tools, Mapping Designer, Workflow Manager, Repository Manager and Workflow Monitor. Experienced in overall Data Warehouse, Database, ETL and performance tuning.
• Experience in troubleshooting the Session Logs, workflow log files, and debugging the code to fix the Testing issues.
• Experience in analysing and resolving issues using data viewer and mapping logs in IDQ
• Experience in troubleshooting issues in data integration logs, model repository logs, and domain logs in IDQ.
Good understanding of webservices specifically around consuming data from REST and SOAP based HTTP endpoints.
• Experience in working on all IICS admin activities and hands-on experience in performing the migrations from lower environments to upper environments.
• Experience in troubleshooting and fixing cloud tasks by verifying logs from IICS monitor and EC2 instances.
• Hands-on experience in Creating users to MDM HUB and providing tool access by adding them to appropriate roles.
Worked on promoting the code to higher environments and vice versa.
Hands on Experience in Git hub activities and AWS services
• Team player with good interpersonal and problem-solving skills, ability to work in a team and work individually.
Technical Skills:
RDBMS
Oracle 19C/12c, SQL Server 2019/2012, DB2 10.2/9.7 FP1, Sybase 15.x.
ETL Tools
Informatica Power Center 10.x/9.6.1/9.1, IDQ, IICS and Power Exchange, AWS, DEI, Snap Logic.
Operating System
Unix-AIX/Linux/Solaris
Languages
SQL, Shell Scripting, JSON
Modeling Tools
MS Visio.
Other Tools
SQL Plus, Toad, Control-M, WebLogic, JBOSS, SQL Management Studio, AWS, SnapLogic
EDUCATION:
Bachelors in computer science from Jawaharlal Nehru Technological University, INDIA - 2012.
WORK EXPERIENCE:
T. Rowe Price – Owings Mills, MD Jan 2024 – Till now
Informatica MDM and Snaplogic Admin
Responsibilities:
Primary responsibility includes administering & supporting Informatica MDM, PC, DEI, HDInsight application and managing the growth of the database for this application.
Actively worked on stabilizing and hardening the application services by remediating vulnerabilities, bugs, slowness and long pending issues.
Upgraded the Elasticsearch version and changed the architecture of the MDM application for better
Solely implemented new breakfix environment for MDM dev and preprod
Was involved in capacity planning for azure HDI cluster resizing
Auto deployment recommendations is being implemented for PowerCenter application
Standardized Knowledge base, documentation and SOPs for informatica application
Automated the daily health checks reports, SSL certificate expiry tracker, housekeeping of the application and purging of old database
Reduced the cost of azure billing for informatica resource group by reducing the Tshirt size of VM after analyzing the resource usage
Recently upgraded MFT and EDC application and upgrade proposal for PC and MDM is in progress
Quarterly patching or minor upgrades of application. Coordinate with Linux team for their patching cycle
Daily task involves handling incidents, service requests and emergency changes. Coordinating with our offshore team and client for priority issues.
MUNICHRE, New Jersey April 2020 – Dec 2023
ETL Informatica Administrator
Responsibilities:
Participated in meetings with respective teams to gather requirements for project set up.
Provisioned the Users, Groups, Roles, and grant privileges to the users in SnapLogic Manager.
Usage of SnapLogic to build integrations between manufacturing plants and a third – party applications called safety chain.
Actively worked on stabilizing and hardening the application services by remediating vulnerabilities, bugs, slowness and long pending issues.
Created tasks and configuration files needed for pipelines to be able to work in different environments.
Worked on upgrade of SnapLogic to latest versions and validate the complexity of SNAPS related to upgrade.
Created and Consumed SOAP and REST services as HTTP endpoints and routed various calls to do validation of service input and to handle expectations.
Created scheduled, triggered and Ultra- tasks to invoke pipelines and send e-mails about pipeline status.
Involved in monitoring and debugging the pipelines by looking for failures in dashboard.
Responsible for creating the users manually and configuring the LDAP setup for users’ access.
Created folders, Relational and Application connections and configure the ODBC connectivity.
Created test jobs to check the connectivity between the various databases and Informatica applications.
Responsible for the table imports and data map imports across the environments
Responsibility includes administering & supporting Informatica MDM, PC, DEI, HDInsight application and managing the growth of the database for this application.
Responsible for working with Production support and handling long running jobs in Production server.
Monitor and communicate the availability of UNIX and Informatica Environment.
Worked with developers on performing tuning of Informatica Mappings for optimum performance.
Involved in creating Unix Scripts and used PMCMD and PMREP to interact with Informatica Server from command mode.
Upgraded the Elasticsearch version and changed the architecture of the MDM application for better
Solely implemented new breakfix environment for MDM dev and preprod
Responsible for Configuring the Secure Agents in IICS Application after the AWS team releases the new instances.
Worked on migrating the files between the S3 buckets and ec2 instances to local desktop.
Worked on creating the IICS Users and creating the cloud and ON PREM connections.
Worked on troubleshooting and fixing cloud tasks by verifying logs from IICS monitor and EC2 instances.
Environment: Informatica Power Center 10.5/10.2, Power Exchange 10x, IICS, SQL Developer, SnapLogic, Informatica Cloud, UNIX/Linux, DB2 10x, SQL Server 2018.
Innovalan (Ernst & Young), Bowie, MD Aug 2017 – MARCH 2020
Informatica/IDQ Administrator
Responsibilities:
Maintaining Development, Test and Production Repositories using Repository Manager. Also used Repository Manager to maintain the metadata, Security, Backup and Locks.
Worked extensively on transformations like Filter, Router, Aggregator, Lookup, Update Strategy, Stored Procedure, Sequence generator and joiner transformations· Performed Repository and Domain Backup and Restores as needed.
Upgraded Informatica PowerCenter 9.6.0 to 9.6.1 and from 9.6.1 to 10.1
Responsible to work with Informatica support, provide feedback to managers, find a root cause, and take necessary steps to prevent ongoing issues.
Coordinating all code migration efforts between all Dev, UAT, and Production environments.
Performing the Daily activities – Health check of all DEV, UAT, and PROD servers.
Responsible for the Repository and Domain Backup and Restores as needed.
Setup Maintenance Jobs for the start-up, shutdown, backup, purge, Space usage alert.
Responsible for performing the Code Review for Production release.
Hands on experience in deploying the applications after migration of applications and workflows across environments in IDQ.
Responsible for Monitoring the jobs and validating connections from both IDQ Admin console and client tool.
Responsible for updating the AD files and associated reference tables in client tool.
Worked on creating roles for developers and providing access to MDM hub console.
Created ORS health checks in all environments and perform validation of ORS.
Performing the migration of code across environments by promoting and validating ORS after code promotion.
Interact with the network, database, and UNIX administrators to implement Informatica infrastructure and troubleshoot issues.
Coordinating with users to resolve issues in Informatica Jobs and raising SR’s with Informatica Tech Support.
Environment: Informatica PowerCenter 10x/9.6.1, MDM 10x, IDQ 9x, Oracle 11g, SQL Server, ILinux RHEL 6.x/5.x, IBM DB2, SQL Developer, DB2, Sybase.
Q-TECH TECHNICAL SERVICES, UAE. FEB 2014 – MAY 2017
Informatica PC and IDQ.
Responsibilities:
Implemented Hot fixes and EBF’s on top of Informatica Up-gradation.
Performed Informatica repository management activities like creating folders and assigning required permissions to the folders.
Implemented the Data Director Service for Data quality.
Created and configured the Reporting and Dashboards service for Data Quality application.
Created and managed connections and providing the required access levels Using Repository Manager.
Regular Monitoring and troubleshooting the Informatica domain.
Regular repository backup / recovery activities as part of disaster recovery plan.
Provided E2E support for Informatica Environment.
Implemented full proof of concept (POC) as part of Informatica Up-grade.
Managed the Informatica Logs and space related issues.
Identified performance bottlenecks and involved in performance tuning of sources, targets, mappings, transformations, and sessions to optimize session performance.
Identified bugs in existing mappings/workflows by analyzing the data flow and evaluating transformations.
Experience in Installing and configuring MDM HUB software and setting up databases for the Hub store.
Experience with configuring security access manager, resource loading and monitoring operations of MDM HUB.
Implemented update strategies, incremental loads, Data capture and Incremental Aggregation.
Extensively worked on various Look up Caches like Static, Dynamic, Persistent, and Shared Caches.
Created UNIX Shell scripts and called as pre session and post session commands.
Environment: Informatica PowerCenter 9.1/9.5, Power exchange 9.1/9.5, IDQ 9.1/9.5, UNIX Shell Scripting, DB2 8.0, Oracle 10g/11g, SQL Server 2008, TOAD, Linux/Solaris.
Intergraph, Hyderabad, India OCT 2013 – DEC 2014
Informatica Support
Installed and Configured Informatica PowerCenter on Client and Server Machines and Configure Informatica Server and Register Servers.
Worked on Informatica Power Center tool - Source Analyzer, warehouse designer, Mapping Designer, Mapplets, and Reusable Transformations.
Responsible for creating repository users, user groups, giving privileges to the users, granting users with access to the repository folders.
Responsible for maintaining repository backups and their restorations.
Responsible for migrations from Development repository to the QA and Prod repositories.
Managed one-time migration of data with planned outages in the weekend.
Used Informatica Designer designed Mappings that populated the Data into the Dimensions.
Used Workflow Manager, Repository Manager for Creating, Validating, Testing, and running the Batches and Sessions and scheduling them to run at specified time.
Maintained Development, Test and Production Repositories using Repository Manager. Also used Repository Manager to maintain the metadata, Security, Backup and Locks
Worked extensively on transformations like Filter, Router, Aggregator, Lookup, Update Strategy, Stored Procedure, Sequence generator and joiner transformations.
Benchmark testing of Hardware and Informatica PowerCenter mappings to calculate the load times for batch processing and tuning the mappings.
Experience with Production support. Working in Incident tickets and providing 24/7 on-call support.
Environment: Informatica Power Center 8.6.1 Power exchange for Oracle, DB2, UNIX Shell Scripting, DB2 8.0, Oracle 10g, SQL Server 2005, TOAD, Linux/Solaris.
Contact this candidate