Informatica Developer Java

Hridish Iyer

Sr. Software Engineer

Address Middlesex, NJ, 08820

Phone +1-201-***-****

E-mail adwltc@r.postjobfree.com

LinkedIn https://www.linkedin.com/in/hridishiyer/

Results-oriented and innovative Senior Software Engineer with 17 years of experience. Easily communicates complex technical requirements to non-technical stakeholders. Excellent leadership record of leading development teams in enterprise-wide development projects.

Skills

Technical Analysis Database programming

Proficient in Java/Informatica/Python Solutions deployment

Software Development Best practices Performance Tuning

Work History

Apr-2022 - Senior Data Engineer (MadisonLogic)

Develop ETL pipelines using Python

Configure and maintain AWS Glue jobs

Configure and monitor Airflow DAGS

Create AWS batch jobs

Performance tune existing Python Applications using multiprocessing and multi-threading modules.

Performance test / load testing of existing API’s.

Feb 2019 -

Mar 2022

Java /Python Developer

Montefiore Medical Center, New York

Core Java 1.8, Postgres DB, Oracle DB, Spring MVC, Unix shell scripting, Python, Mirth Connect, HL7, SPARQL, RDF, Apache Kafka, Primary objective of this project is to design solution to extract data from different sources File, DB in different formats JSON, CSV and transform data, load it into RDF or generate HL7

Created ETL programs using Spring Framework (Spring Batch) according to techndata into RDF data-store or generated HL7 messages using Mirth Connect.

Used SPQRQL query language to Insert, update, delete and analyze data stored in RDF.

Used Pandas and Data-frames in Python for analyzing data.

Developed Cron job for scheduling the jobs and used shell scripts for pre/post process activities.

Install and Setup Apache Kafaka/ Zookeeper and created Topic to write HL7 message.

Developed Java Client to be called from Mirth Connect to write HL7 into Kafka Topic.

May 2018

- Feb 2019

May 2014

- May 2018

Java /ETL Informatica Developer

Doran Jones, New York, New York

Technology: Informatica 10.2, Core Java 1.8,Servlets, JSP, MS SQL server, Primary objective of this project is to transform and process different format pipe-limited Flat files and generate Pipe delimited flat files.

This is a fast paced development project and I was playing role of Senior ETL developer.

Locally installed Informatica Power Center 10.2 locally.

Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Ware- house Designer, Mapplet Designer and Mapping Designer.

Develop the mappings using needed Transformations in Informatica tool according to technical specifications.

Created complex mappings that involved implementation of Business Logic to load data in to staging area.

Used Informatica reusability at various levels of development.

Developed mappings/sessions using Informatica Power Center 10.2 for data loading.

Developed Java/ J2EE based UI Dashboard for real time monitoring of ETL File processing.

Hence I developed the UI application using Unix shell scripting, Informatica and Java/J2EE to address this issue.

Identified, troubleshot and corrected bugs and bottlenecks.

Java/ETL Informatica Developer

Cognizant Technologies Solutions, Wilmington, DE

Primary objective of this project is to transform and process different format pipe-limited Flat files and generate fixed width flat files.

ETL system receives files from 5 different lines of business (LOB), which ETL process transforms data (vendor and customer data), performs validations and process them into Fixed width flat file, which is then loaded into central repository data- base.

Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment as lead software engineer and managing both offshore and onsite.

Created complex mappings that involved implementation of Business Logic to load data in to staging area.

Used Informatica reusability at various levels of development.

Developed mappings/sessions using Informatica Power Center 9.1 for data loading.

Write shell script for pre-processing of input files, post processing of ETL generated files and for running workflows in unix environment.

Optimizing performance tuning at source, target, mapping and session level.

Nov 2010 -

May 2014

Mar 2007 -

Nov 2010

Jul 2006 -

Jan 2007

Coming up with Design document, performing code review and carrying out build of project.

Java /ETL Informatica Developer

Cognizant Technology Solutions, CTS, New York, New York

Informatica 8.6.1, Core Java 1.5, JDBC, Sybase 12.5, PL/SQL, Stored Packages/Procedures/Functions Triggers, RAD, Worked as application developer and L3 support projects for six major applications for Investment Management group of Major banking client.

Work involved development an support of different Java / Informatica base applications and coordinating with different team members.

Developed database mapping tool which would spot the difference between mapping requirements and the actual Database design in DB.

Developed an Issue tracking portal to be used by all the team members in the network, for tracking and resolving issues in the project efficiently.

Playing the role of developer, over looking and carrying out build of the project.

Playing the role of Change manager, maintaining different versions of code.

Project planning and Coordination as Onsite lead.

Identified, troubleshot and corrected bugs and bottlenecks.

Java developer (Team Lead)

Infosys Technologies, New York, New York

Worked on Application Development, Support and Maintenance projects for three major applications for the Finance and Pricing Portfolio of major pharmaceutical client in New York.

Playing the role of Team Lead, Grooming the team members and assigning task to team members Playing the role of developer, over looking and carrying out build of the project.

Playing the role of Change manager, maintaining different versions of code.

Playing the role of tester,reviewing the testing scenarios, testing the code thoroughly before it is released for User Acceptance testing.

Coming up with Deployment Instruction documents.

Coordinating with different teams to carry out the project successfully.

Trouble shooting, Bug fixes and Impact Analysis.

Java developer

Infosys Technologies, Mysore, India, India

The project was to develop application for 11 states of US for an Major Insurance Client, by understanding the specific business requirements of each state.

Worked on developing specific module of application.

Created the Design Documents, Test case document based on the requirement documents.

Worked in developing a module of the code.

Analyzing/fixing the defects found in the unit testing of the application.

Prepared a book of knowledge on Struts framework which was intended for the use of new joiners into the project, to help them understand about the struts framework.

Participated in performance analysis, design, development and testing.

Education

Jul 2005 -

Jan 2008

Aug 2001 -

Jan 2005

Master of Engineering: Biomedical Engineering

MGM College of Engineering And Technology, Mumbai University - Mumbai

Bachelor of Engineering: Biomedical Engineering

MGM College of Engineering And Technology, Mumbai University - Mumbai

Certifications

Feb 2012 Oracle Certified Professional, Java SE 6 Programmer.

Mar 2021

Dec 2021

Dec 2021

CQI and IRCA Certified ISO/IEC 27001:2013 Information Security Management Systems Lead Auditor

Epic Interconnect Programmer

Epic Chronicles Database Programmer

Awards And Recognition

1.Key Recognition award for excellent contribution in Project delivery in April 2016

2.Cognizant Star award for excellent work for JP Morgan Chase in Nov 2014

3.Cognizant Team Excellence award for excellent work for JP Morgan Chase in May 2011

4.Infosys One the Spot award for excellent work for Pfizer Inc in May 2009.

Contact this candidate