Post Job Free

Resume

Sign in

Informatica Developer, DB2 SQL, Unix Shell Scripting

Location:
Chennai, TN, India
Posted:
November 30, 2017

Contact this candidate

Resume:

Arun Noble V

Email:ac3jdd@r.postjobfree.com, Phone: 995-***-****

Career Summary

Software Developer with a background that spans 3 years and 6 Months of Information Technology experience in the field of development for insurance applications.

Extensive work experience in Insurance Domain with Informatica, Federated Data Warehouse, UNIX/LINUX, DB2 as the technical base.

Having work experience in Informatica administration and automated the Informatica admin works using Unix Shell Scripting.

Having experience in Mainframe auto flow code to create the application job flow diagram/chart.

Scheduling and prioritizing the jobs using Control-M scheduler. Technical Skills:

Tools:Informatica10.1(Power Center & Power Exchange), Control-M,HPSM

Scripting language: Unix shell scripting, Mainframe(JCL,COBOL,PL1,DB2), C

/C++ and Java

Relational Databases: DB2 & Oracle

Scheduler: Control- m Automation v9.0

Educational Qualification:

Bachelor of Engineering from Adhiparasakthi College of Engineering, Vellore with 76%.

HSC and SSLC from Sri Ganesar Higher Secondary School, Thoothukudi with 80%.

Work Experience:

Company: HTC Global Services (February 2014 – TILL DATE) Designation: Software Development Engineer

Project -Informatica 2nd level support

Duration : May 2014 – August 2015

Industry : Insurance

Client : State Farm Insurance, USA

Environment : Informatica Admin and UNIX

Role : Production Support

Team Size : 12

Project Details: Initial Support for all Informatica related applications. Roles and Responsibilities:

Developed a UNIX script to automate the Informatica manual work(Folder setup, Access Maintenance, Connection object setup and maintaining catalog entries)

Developed a UNIX utility for parameter file updating for Informatica tool in organizational level.

Prepared a test case for daily maintenances UNIX script and tested it.

Setting up the environment for new application in Informatica.

Maintaining access to the Informatica repository based on HP service manager request.

Server monitoring, File system check based on HP service manager automated incident.

Prepared monthly HP service manager reports for management purpose.

Analysis the job logs and troubleshoots the production Informatica and UNIX jobs.

Prepared the auto flow diagram using Mainframe auto flow code to schedule the application jobs in production.

Handling production issues based on priority

Scheduling and prioritizing the jobs using Control-M. Project - Sales and Compensation (Agency Awards)

Duration : September 2015 – till date

Industry : Insurance

Client : State Farm Insurance, USA

Environment : Informatica and UNIX

Role : Developer

Team Size : 9

Project Details: The objectives of the project is analysis the agent & Sales Leader business and assign a rank/level to each agent based on their performance and maintaining a book of business for each agent. Roles and Responsibilities:

Requirement gathering and analysis

Prepared a high-level design and low-level design document.

Developed ETL Informatica code, pmcmd scripts and UNIX scripts to analyze the data.

Preparing a Knowledge item for all components and making an entry in WIKI page & lotus notes.

Developed a flow dependencies diagram (Auto flow Chart) using Mainframe Auto flow code.

Preparing Unit test cases, system test cases & performing integration testing.

Providing support and services for this project. Project - Agency Travel Compensation (Agency Awards) Duration : May 2016 – till date

Industry : Insurance

Client : State Farm Insurance, USA

Environment : Informatica and UNIX

Role : Developer

Team Size : 9

Project Details: The objective of the project is giving the compensation trip to every agent based on their level in book of business.

Roles and Responsibilities:

Requirement gathering and analysis

Prepared a high-level design and low-level design document.

Developed ETL Informatica code, pmcmd scripts and UNIX scripts to analyze the data.

Preparing a Knowledge item for all components and making an entry in WIKI page & lotus notes.

Developed a flow dependencies diagram (Auto flow Chart) using Mainframe Auto flow code.

Preparing Unit test cases, system test cases & performing integration testing.

Providing support and services for this project. DECLARATION

I hereby state that all the above furnished information is true and correct to the best of my knowledge and belief.

Place: Chennai Arun Noble V



Contact this candidate