Sindhuri Golla

*** ******** **, *** ******, CA, UNITED STATES

PHONE EMAIL SOCIALS

510-***-**** adl5p1@r.postjobfree.com https://www.linkedin.com/in/sindhuri-golla-3887a31a5

SUMMARY

* ***** ** experience with IT experience in Data warehousing, Business Intelligence, Expertise in Installing and Managing Informatica PowerCenter, Metadata Manager, Data Explorer and Data Quality. Strong knowledge in Informatica Administration including upgradation, Configuration, maintenance and troubleshooting. Strong experience in installation of Informatica on UNIX, Windows servers & AWS Ec2, Migration of repositories, and up gradation of repositories. Also Involved in the full development lifecycle from requirements gathering through development and support using Informatica Power Center, Repository Manager, Designer, Server Manager, Workflow Manager, and Workflow Monitor. Involved in a role as an Informatica Administrator in upgrading the repository database and giving permission to various groups of users and testers. Experience in debugging and performance tuning of sources, targets, mappings and sessions. Collaborated onsite teams, interacted and well managed various offshore teams. Excellent communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high adaptability to new technologies and tools. Strong Team working spirit, communication and relationship management skills.

EXPERIENCE

T-Mobile.

San Diego, CA // Senior Informatica Administrator // 04/2020 – present

Manages all Informatica environments, configurations, user access, PowerCenter, WHUB, EHUB, installs new software and patches and applies necessary configuration changes. Responsible for reliability and performance of the Informatica software.

Informatica Administrator with very strong professional background in Data warehouse domain and industry experience in the software engineering, processes and methodologies. Responsible for the design, installation, upgrade, hotfixes, Power exchange, creation, documentation, trouble shooting and enhancement of ETL processes. Solid understanding of data and ETL technologies, as well as experience in administering Custom ETL development

Installed and configured Informatica Power Center 10.x.

Gathering the requirements for the Informatica Power Center Install on Servers.

Day to day administration activities like user creation, folder creation, configuring DB connections etc.

Constantly looking whether the infrastructure is readily available for developers and support team members to perform their tasks.

Capacity planning and on-going monitoring.

Proactively increase capacity as needed.

Exported and imported Informatica objects like Mapplets, Mappings, Sessions, Worklets & Workflows.

Administrated of Repository services and Integration services on Nodes.

Created unix shell scripting to automate backup repositories

Automated the process for workflow migraitons from one instance to other instance.

Enabled server level monitoring alerts

Migrated from onprem to aws ec2.

Kohls – E- commerce’s

Milpitas, CA // Sr Informatica Administrator // 07/2015 – 03/2020

This project is to facilitate any environment or platform related & data related requirements and challenges in Merchandise space. Integrate test data provisioning & encryption/masking solution with CICD build pipeline in Jenkins. Provide solution to any existing data issue & database performance related issues for applications to run smooth with the underlying data.

Install, configure and maintain Data Integration tool suits, software (Informatica PowerCenter) environments to meet development requirements.

Perform daily operations to support ETL development including import definition, creating folders, and resolving migration issues. Applying hotfix & version upgrade from 9.1 to 10.1.

Create folder, connection string for developer and Setup best practice for developer.

Automate repository content migration from one repository to another. and Manage repository content for better performance.

Performance tuning & code review.

User management, high availability, LDAP configuration

Publish data health checkup report to stake holders and Wrote Custom Transformation in Informatica to integrate Kohl’s data protection software Protegrity

Configure Informatica to read/write data from Cassandra

Write PL/SQL block to export/import schema and/or table in Oracle using data pump API

Checked data refresh script in Git and build the core through Jenkins. The Jenkins job is integrated with DevOps CICD pipeline to automate test data refresh or generate test data automatically.

Developed Rest API to automate test data creation, clean up, user sign-up & sign-in.

Participate in capacity planning and coordination with IT infrastructure engineers.

Keeps up to date on vendor license agreements and maintain license inventory

Work with application teams to fulfill database tasks (creating databases, accounts, tables, etc.)

Creation and configuration of integration services to run on the Grid

Backup and restore of domain and Repository services

Brocade

San Jose, CA // Informatica Administrator // 08/2013 – 07/2015

Brocade provides innovative network solutions that help the world’s leading organizations transition smoothly to a virtualized world where applications and information can reside anywhere. The prime responsibility of our team is to build customer database hub (CDH) means party-customer account information using web services such as SOAP. We are loading data from different sources to staging area by cleansing data to do this we are using Address Doctor services and Duns Numbers from Duns and Bradstreet (DNB). After getting data as per business requirement from DNB and Address Doctor we are loading data to the warehouse.

EBS (Enterprise Business Solutions) this integrated with Oracle R2 and like the POS Source systems are SFDC, EBS, POS and PRM.

Setting up and configuring enterprise Informatica Implementation with PowerCenter 8.X (8.6 and further preferable) on UNIX and Oracle 10g and greater

Extensively work in installing/configuring Power Exchange

Installation and configuration on a multi-server environment and securing Cognos10 BI.

Administering, deploying and maintaining Models, reports, and cubes to all environments.

Set up required permissions in the Cognos Portals for the User group for security purposes.

Create and maintain the software migration process, coordinator and implement improvements to the migration process.

Closely work with Informatica Corp for product issues, licensing and understanding product roadmaps

Maintaining security through effective management of users/groups

Working with off sure (India) team.

Extensively worked in Implementation of patches and upgrades.

Implementation of maintenance activities like Power downs / Reboots etc

Extensively worked in automation of deployments to Production from Test environment

Coordinating with internal clients / storage /UNIX / DBA teams to resolve issues

Performing an implementation and rollout of Informatica Metadata Manager

Providing technical support for the Informatica environment

SKILLS

ETL : Informatica PowerCenter (8.1/8.5/8.6.1/9.0/9.1/10.1), Informatica Power Exchange.

Languages : SQL, PL/SQL, SQL*Plus, XML, UNIX Shell Scripting, Perl, C, C++, COBOL, JAVA

Data base : ORACLE, AS/400, MS SQL Server 2000/2005/DTS Packages, Teradata, Sybase, DB2 UDB, TOAD

BI Tools OLAP : Business Objects, Crystal reports.

Data Modeling : Erwin3.5.5/3.5.2/4.0, Visio 2008

Operating Systems : AIX, Sun-Solaris, HP-Unix, NT, LINUX. MS-DOS 6.1, WINDOWS 95/98/XP.

Office Tools : OFFICE, Excel, MS Project, Visio, Power point, Word Perfect, Corel draw, Lotus Notes.

Networks : Windows NT, Windows 2000, Novell

Other Skills and Tools : MQ Series, TOAD, SQL Loader, Autosys and Web tools: HTML, DHTML, XML, XSD

EDUCATION

Graduation - master’s in computer science. – 3.7 GPA

Under Graduation - Information Technology and Computer Science - 79%

Contact this candidate