Rohit Jaiswal

adpb5r@r.postjobfree.com Mob No: 855-***-****/866*******

Professional Profile

●Total IT Experience 8 years and working as Technical Lead in HCL.

●Experience in of ETL tools and Application Technical support and handling project scenarios.

●Experience in Informatica Administrator,Application/Product support using Informatica PowerCenter, DataQuality, Dataexchange, Managed File Transfer, EDC/EDP,AXON, BDM,TDM,CDC,MDM.

●Experience with Kerberos/SSL configuration.

●Experince on Hadoop Cluster, Spark and Blaze job run.

●Experince in working Datawarehouse and DataManagment.

●Experience in debugging mappings for defects and analysis.

●Work Experince on Oracle, Sales Force, SQL and Teradata DB’s and PL SQL.

●Work Experience in UNIX/Linux Commands and Scripting.

●Worked on reporting and dashboard creation using tools reporting tools like Tableau.

●Proficient in identifying, analyzing and solving problems, bugs.

●Experience in working with multiple clients and geographically distributed teams.

●Open to learn and adapt to other BI technologies and roles.

●Excellent Team player with positive attitude and good communication skills.

●Proficient in data modelling techniques like ER diagrams, data flow diagram on Data Analysis.

Summary

Proven IT Specialist with experience in reputed fortune 500 MNC as well as in operations leveraging expertise in organization, data analysis, and problem solving to provide exceptional user support and assistance in resolving conflict. Experience includes managing sensitive materials and providing after-hours support for clients.

Certifications and Achievements

●Informatica Administrator Certification with 80%.

●Awarded 5 time with Customer Satisfaction.

Skills

ETL Tools

Informatica Power Center 10.4, 10.2, 9.6,9.1, 8.1, IDQ, TDM, EDC,AXON, BDM, MFT, Data Exchange, PWX

Database

Oracle, SQL Server, Teradata, IBM D2, Sales Force, MySQL

Reporting Tools

Tableau

Scripting language

Unix shell scripting

Other tools

Autosys, Control-M, Jira, SharePoint, Service now, Azure cloud service

Work History

HCL September 2020- present

Technical Lead

Project1

Duration: September 2020 to present

Project: MunichRe

Company: HCL

Client: HSB, MunichRe, American Modern Insurance Group.

Description: As part of this project we had to build Datawarehouse, ETL Setup environment like DEV,UAT,PreProd and Production environment for various companies under MunichRe group like Hartford Steam Boiler Inspection and Insurance Company (HSB), Ergo Group, American Modern Insurance Group Inc etc. Traditionally these subsidiary companies of MunichRe groups had individual VM(Operating system),database, User/Group permission with no interlink between them, so challenge was faced while Installation, upgrade, migrate various ETL products containing data from multiple companies. So as part of Administrator, development of Datawarehouse from scratch was taken up

Technologies: Informatica 10.4,9.6,9.1, Powercenter, Dataquality,EDC/EDP,AXON, TDM, DataExchange, MFT,MDM, BDM, Data Quality, MS sql server, Oracle,PostgreSQl

Role: Informatica consultant

Responsibilities:

•Understand a defect by going through the specifications present in ServiceNow.

•Perform Admin task on all Production environment of various ETL Products

•Development of Informatica mappings and workflows to fulfill the business requirements.

•Unit testing the Informatica mappings with sample data.

•Providing support to the testing team in validation of the business rules.

•Suggesting in performance improvement techniques to the team.

Informatica Business Solution:

Senor Technical Support Engineer May 2014 – September 2020

Responsibilities:

End to End cloud Solution AWS.

Provided 24/7 on-call support for production.

Implement and Support Application/Product development, test, quality assurance and Production environments including object migrations.

Install/Upgrade Informatica ETL software, Administer Services and provide Application support for Clients from different Domains.

Responsible for reproducing the issue at Lab environment and Collaborating with R&D team for Bugs/CR/Patch through Jira.

Perform troubleshooting analysis and resolution of critical applications on UNIX, AIX, SOLARIS, LINUX,WINDOWS.

Perform Active Directory/LDAP configuration and have knowledge on SSO,HTTPS, DSN, OSI,TCP/IP,DHCP.

Communicate workarounds to be followed to L1 and L2 till the issue gets resolve. Raising issues to development team and working with them closely for permanent fix.

Provide ETL Performance tuning and Production Support

Responsible for reproducing the issue at Lab environment and collaborating with R&D team for Handling mission critical customer from all over the globe and supporting them over call, video call or emails.

Write Knowledge Base Articles. Contribute to Documentation.

Java based application level troubleshooting like Jstack/Thread dump analysis. Also, Working on OS level Stack like PSTACK, PMSTACK, STRACE

Onsite Travel: Have traveled to Austin (City in Texas) on Business visa for PowerCenter Production support, go-live support and its related activities and discussions with Users

Educational Qualification

Name of Course

University/Board

Year of Passing

Aggregate of Marks

B.E (CSE)

RGTU

2013

72.50%

HSC

M.P Board

2011

76.67%

SSC

M.P Board

2010

65.69%

Personal Details

Name : Rohit Jaiswal

Email : adpb5r@r.postjobfree.com

Date of Birth : 15 FEB 1990

Personal Interests : Travelling, Trekking, Certified Fitness consultant and painting.

Contact this candidate