Uploaded File
add photo
Ramkumar
ramkumar.mail2008@gmail.com
7754 Lucerne Drive
Middleburg Heights, OH 44130
Senior Informatica Developer
13 years experience W2
0
Recommendations
Average rating
81
Profile views
Summary

  • I am a Senior Informatica Developer having an experience of 8 Years in banking domain.
  • I am actively looking for Informatica Developer positions and open to relocate anywhere in USA.
  • I am holding H1B visa valid until Sep 2018.

Experience
Informatica Developer
Banking/Financial
Jun 2008 - present
  • 8 years of IT professional experience in Analysis, Design, Modeling, Development, Testing Implementation and Support of Data Warehousing applications in banking domain.
  • Extensive experience in development and designing of ETL methodology for supporting data transformations and processing in a corporate wide environment using Informatica PowerCenter v8.6/ 9.6, Oracle (SQL, PL/SQL), Teradata, UNIX and Scripting.
  • Involved in the Software development lifecycle (SDLC) from requirements gathering through development and support for Financial institution using Informatica PowerCenter, Repository Manager, Designer, Workflow Manager and Workflow Monitor.
  • Involved in creating data maps using Informatica Power Exchange 9.6.
  • Knowledge of data warehousing techniques like Star/ Snowflake schema, Facts, Dimensions, Slowly changing dimension, Data Integration and other ETL methodologies.
  • Experience in integration of various data sources like SQL Server, Oracle, Teradata and Flat Files.
  • Skilled in Performance tuning, Error handling and Production Support.
  • Extensively worked on transformations such as Source Qualifier, Joiner, Filter, router, Expression, Lookup, Aggregator, Sorter, Update Strategy, Sequence generator and stored procedure transformations.
  • Experience in writing Oracle Queries, Procedures, and Functions.
  • Experience in UNIX working environment, writing UNIX shell scripts for Informatica pre & post session operations.
  • Experience in scheduling the batch jobs using workflow monitor, Autosys and CA7 scheduling tools.
  • Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
Informatica Powercenter Oracle Oracle SQL*Plus UNIX Data Integration AutoSys Data Warehousing Teradata SQL Server SQL Snowflake Shell Scripts SDLC Scripting Requirements Gathering Production Support Performance Tuning PL/SQL Informatica IDE ETL Informatica Developer Stored Procedure Project Management
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Bachelor's in Electronics & Communication Engg
GLA University, 2004 - 2008
Skills
Project Management
2021
11
AutoSys
2021
10
Data Integration
2021
10
Data Warehousing
2021
10
ETL
2021
10
IDE
2021
10
Informatica
2021
10
Informatica Developer
2021
10
Informatica Powercenter
2021
10
Oracle
2021
10
Oracle SQL*Plus
2021
10
Performance Tuning
2021
10
PL/SQL
2021
10
Production Support
2021
10
Requirements Gathering
2021
10
Scripting
2021
10
SDLC
2021
10
Shell Scripts
2021
10
Snowflake
2021
10
SQL
2021
10
SQL Server
2021
10
Stored Procedure
2021
10
Teradata
2021
10
UNIX
2021
10
Languages
English, Fluent/Bilingual