Profileimage by Ravi Ranjan Software Engineer from Jehanabad

Ravi Ranjan


Last update: 06.09.2022

Software Engineer

Company: Riemen Solution Pvt. Ltd.
Graduation: B.Tech(ECE)
Hourly-/Daily rates: show
Languages: English (Full Professional) | Hindi (Native or Bilingual)




Having strong knowledge and experience in Informatica Power Centre, Tuning, Performance optimization, UNIX shell scripts, Oracle, SQL Server, ETL, Informatica Power Centre 9.x, Database, Oracle11.6.1, MSSQLServer2012, MYSQL, Unix, PuTTy0.60, Unix Shell scripting, Linux, JIRA, Python 3.x, Agile, Middleware, SAP, web Methods, Informatica, shell scripts, SQL, data transfer, bugs, unit testing, code testing, Database Programming.

Project history

06/2017 - 07/2020
Informatica Developer
GPW (Global Prima West)
Title: GPW (Global Prima West)
Client: Target Corporation
Role: Informatica Developer
Team size: 12
Methodology: Agile
Duration- June 2017 - July 2020

GPW Middleware: The GPW Integration Middleware stream deals only with the repointing of
integrations and accommodating changes to existing integrations and persisted data. The overarching
principle of this project is that all integrations and systems are to remain as-is except for changes
required to accommodate SLO conflict resolution, the merger of the SEL and SEU SAP systems and
FICO process changes. There are two streams - web Methods & Informatica.

* Developed ETL programs using Informatica to implement the business requirements.
* Communicated with business customers to discuss the issues and requirements.
* Created shell scripts to fine tune the ETL flow of the Informatica workflows.
* Created shell scripts to perform tasks to minimize the time in Informatica.
* Production Support has been done to resolve the ongoing issues and troubleshoot the problems.

* Performance tuning was done at the functional level. Used relational SQL wherever possible
to minimize the data transfer over the network.
* Effectively used Informatica parameter files for defining mapping variables, workflow
variables and relational connections.
* Used debugger in identifying bugs in existing mappings by analysing data flow,
evaluating transformations.
* Pre and post session assignment variables were used to pass the variable values from one
session to other.
* Designed workflows with many sessions, used informatica scheduler to schedule jobs.
* Performed unit testing at various levels of the ETL and actively involved in team code reviews.
* Identified problems in existing production data and developed solutions to correct them.
* Provided training and support to new team members.
* Conducted code reviews and provided support to tester during code testing for timely fixes
and resolutions.

09/2016 - 06/2017
Software Engineer
Title: Pre-Order Destiny Customers Information
Role: Software Engineer
Team size: 5
Methodology: Waterfall
Duration: September 2016 - June 2017

This request deals with the details of the customer which have pre-order destiny game. This request
which deals with providing the critical information to the customers about who all have pre-order
destiny game.

* Designed the Project architecture.
* Created Low level Design, Database Design and Reporting.
* Monitored the development activity.
* Involved in Database Programming.

Local Availability

Only available for the countries India
Hi Recruiter,

Available to work at any time.


  • Over 3 years of strong experience working as an Informatica Developer.
  • Have extensively worked in developing Informatica mappings for supporting Data Extraction, transformations and loading using Informatica Power Centre.
  • Ability to meet deadlines and handle multiple tasks, flexible in work schedules and possess good communication skills.
  • Experience in the design and building of data model.
  • Strong SQL development skills including writing views, widely usage of analytical functions, Query Tuning and Performance optimization.
  • Created UNIX shell scripts to perform tasks which help to improve performance, to run workflows and controlling the ETL flow.
  • Knowledge to develop SQL with various relational databases like Oracle and SQL Server.
  • Experience in requirement gathering, analysis, design, develop, testing and deploy ETL solutions.
Profileimage by Ravi Ranjan Software Engineer from Jehanabad Software Engineer