Singarao Katta

Data warehouse specialist

ac1v64@r.postjobfree.com

+1-512-***-****

SUMMARY

Over 8 years of enterprise level technical experience in Server Development, troubleshooting, support and maintenance of UNIX servers.

CERTIFICATIONS

Oracle Sun certified for Solaris 10.

Six Sigma Green Belt Certified.

ITIL Certified

Agile Certified

EDUCATION

Bachelor of Degree

ANU University, India

Apr 2005

SKILLS

Technologies UNIX, Veritas NetBackup Cognos BI/TM1, Informatica9.x and 10.x, HVR.

Operating system Oracle Solaris, Linux, Windows.

Desktop Operating Systems Windows 8, windows 7, Vista, XP

Platform/Hardware Redhot Linux, Oracle hardware. HP Ux, AIX

Software MS Office, Visual Studio, Oracle/SQL Developer, SQL Server Engine

Tools Informatica, Cognos 8.4, Cognos 10.2/TM1, HVR, Sesame RJ, Putty, MDM

EXPERIENCE

ETL Informatica Administrator Nov 2015 – Till Date

HP I, TX, United States

Tata Consultancy Services Ltd

Responsibilities

• Managing Power Center 9.x and 10.1 instances.

• Working under 24/7 support.

• Involved and did the upgrade of Informatica.

• Worked on Migration of Informatica from one OS to another OS.

• Good Exposer at Windows OS to troubleshoot the Informatica Issues.

• Strong at Unix to do anything for Informatica perspective.

• Repository migration from lower version to higher version and also worked on migration from one platform to another.

• Clubbing the repositories together to minimize the license cost.

• Performing the server health check.

• Working on Configure the IDQ services on Informatica.

• Working on to configure and install the power exchange.

• Working on provide the connection info to user to use the developer tool.

• Expert in UNIX shell script.

• Good team coordination and used to bring all required teams to resolve the issue .

• Strong at CDC mechanism to support the PWX.

• Working on Informatica upgrades by applying the hotfixes.

• Exposer on applying the EBF’s as part of bugfix.

• Very proactive to work on issues to resolve with in SLA.

• I am very strong to create the automation processes like deletion of labels as well DG’s and inactive users and their respective folder and folder refresh and domain backup and domain repo scripts.

• Perform the Troubleshooting steps on Informatica service issues.

• Configuring and implementing the GPG keys for Data encryption process.

• User issues while performing the action on Informatica.

• Good Exposer in executing the SQL queries to troubleshoot the issues

• Working on apply the pwx connector to connect to MSDCRM and Salesforce..etc..

• Coordinate with Informatica vendor to get the product level information.

• Well explorer to execute the changes on production systems.

• Working on cleanup of directories on priority

• Configuring and Implementing the ssh keys for establish the connection between source and target and vise versa.

• Working on Informatica Analyst.

• Supporting the sap bw services and IMM services from Informatica.

• Good Knowledge on HVR (High Volume Real-time Replication tool).

• Coordinated with UNIX and Database Administrators.

• Configured web services on dev instance.

• Carried out root-cause analysis and solution development.

• Handled users, groups and folders.

• Corresponded with end users to resolve issues.

• Extensively worked on Informatica Mappings/Session/Workflows to load data from Oracle to TD and vice versa.

• Extensively worked on UNIX shell scripts on automation (Auto restart of Proftpd).

• Automation of domain backup, Repository backup, Deletion of UN used ETL folders and Inactive users.

• Implemented the new protocol for sftp users (Proftpd)

• Creation and maintenance of Informatica users and privileges.

• Extensively worked on UNIX Shell scripts to launch jobs and to execute Job Control Table Process.

• Worked on Informatica Templates to standardize the HP process and maintain consistency across different teams.

• Worked on SQL queries to query the Repository DB to find the deviations from Company’s ETL Standards for the objects created by users such as Sources, Targets, Transformations, Log Files, Mappings, Sessions and Workflows.

• Working on sftp issues.

• Worked on different phases of Data Warehouse development lifecycle from designing, development, testing and implementation.

• Strong interpersonal & organizational skills.

• Responsible to manage Development, QA and Production Environments for Informatica.

• Working on Data analyzer and Informatica analyst services.

• Strong at troubleshoot the backend level issues.

• Strong at Informatica server and client installations.

• Creation of odbc connections and relations connections.

Areas/Applications

• Area

- Requirement Analysis

- Module design

- Development

- Documentation

- Implementation

- Support and Maintenance

- Onsite-Offshore Co-ordination

ETL Informatica Administrator Apr 2009 – Oct 2015

GE Corporate, Fairfield, CT, United States

Tata Consultancy Services Ltd

Responsibilities

• Managing Power Center 9.x and 10.1 instances.

• Involved and did the upgrade of Informatica.

• Supporting the sap bw services and IMM services from Informatica.

• Good Knowledge on HVR (High Volume Real-time Replication tool).

• Coordinated with UNIX and Database Administrators.

• Configured web services on dev instance.

• Carried out root-cause analysis and solution development.

• Handled users, groups and folders.

• Corresponded with end users to resolve issues.

• Extensively worked on Informatica Mappings/Session/Workflows to load data from Oracle to TD and vice versa.

• Extensively worked on UNIX shell scripts on automation (Auto restart of Proftpd).

• Automation of domain backup, Repository backup, Deletion of UN used ETL folders and Inactive users.

• Configuring and implementing the GPG keys for Data encryption process.

• Configuring and Implementing the ssh keys for establish the connection between source and target and vise versa.

• Working on Informatica Analyst.

• Implemented the new protocol for sftp users (Proftpd)

• Creation and maintenance of Informatica users and privileges.

• Extensively worked on UNIX Shell scripts to launch jobs and to execute Job Control Table Process.

• Strong at troubleshoot the backend level issues.

• I am very strong to create the automation processes like deletion of labels as well DG’s and inactive users and their respective folder and folder refresh and domain backup and domain repo scripts.

• Worked on Migration of Informatica from one OS to another OS.

• Good Exposer at Windows OS to troubleshoot the Informatica Issues.

• Strong at Unix to do anything for Informatica perspective.

• Repository migration from lower version to higher version and also worked on migration from one platform to another.

• Strong at Informatica server and client installations.

• Creation of odbc connections and relations connections.

• Worked on Informatica Templates to standardize the GE process and maintain consistency across different teams.

• Worked on SQL queries to query the Repository DB to find the deviations from Company’s ETL Standards for the objects created by users such as Sources, Targets, Transformations, Log Files, Mappings, Sessions and Workflows.

• Working on sftp issues.

• Worked on different phases of Data Warehouse development lifecycle from designing, development, testing and implementation.

• Strong interpersonal & organizational skills.

• Responsible to manage Development, QA and Production Environments for Informatica.

• Working on Data analyzer and Informatica analyst services.

Contact this candidate