Sign In
Looking for talent?
Check out our hiring section
Login to your account
Remember me?
Login
Forgot password?
Not a user yet?
Click here to register.
LOADING
Select Login
Uploaded File
Rajesh Kumar
rajesh86smile@gmail.com
201-744-0155
New York City, NY 10002
Senior Lead Informatica Developer
15 years experience
C2C
1
Recommendation
Average rating
197
Profile views
Summary
Over 8 years of extensive IT experience in Capital markets, Investment Banking, Insurance, Retail and healthcare domains which helped me to groom as a Data warehouse specialist, by performing SDLC process right from
requirement gathering
,
analysis, design, development, testing, deployment,
and
Maintenance
for various software applications.
Hands on experience in
ETL
design, development of SQL Scripts, Stored Procedures, Functions, Packages, Triggers and maintenance using
Oracle PL/SQL, DB2 SQL, Informatica Power Center 9.x/8.x/7.x
on UNIX and Windows platforms.
Expertise in Data Analysis, Data Requirement Analysis, Data Mapping, Data Warehousing, Data Migration, Data Integration for ETL processes using
Business Intelligence (BI)
tools such as
Informatica Power Center, Power Exchange Change Data Capture, B2B Data Transformation, Informatica Data Quality, Informatica Data Explorer, MDM
etc.,
Extensive knowledge of various
Performance Tuning Techniques
on various source systems such as
Relational Sources
,
Flat files, XML, Mainframe COBOL
and
VSAM
files
, SAP
Sources/Targets,
web based applications in Java using Servlets, JSPs
and
Web Services
etc.., Informatica Mappings, Sessions, and Data Base Tuning.
Proficient in defining and documenting
ETL Process Flow
,
Job Execution Sequence
,
Job Scheduling
and
Alerting Mechanisms
using command line utilities, integration mappings including dynamic cache lookup, shared, and persistent cache for mappings of
Type I, Type II, and Type III
Slowly Changing Dimensions and implementing
update strategies, incremental loads,
and
change data capture
.
Strong knowledge of various
Data Modeling
techniques such as
E-R modeling
, and
Dimensional modeling
(
Star/Snowflake
Schema)
and in implementing Error Handling, Auditing and Reconciliation and Balancing Mechanisms in ETL process.
Committed individual with excellent interpersonal, analytical and communication skills.
Ability to work simultaneously on multiple projects, work independently as well as a team member.
Experience
Edit Skills
Non-cloudteam Skill
Education
Bachelor's in Electrical
Anna University, 2004 - 2008
Minor: Computer science
Record has not been verified.
Skills
Windows
2016
7
Data Warehousing
2016
6
Oracle
2016
6
SQL
2016
6
SQL Server
2016
6
BRD
2021
5
Data Dictionary
2021
5
FRD
2021
5
Business Intelligence
2021
4
DB2
2016
4
Business Analysis
2021
3
Business Requirements
2021
3
Data Marts
2021
3
Data Modeling
2021
3
Informatica
2021
3
Informatica Powercenter
2021
3
PL/SQL
2016
3
UNIX
2013
3
Warehouse
2016
3
Compliance
2016
2
Data Architecture
2021
2
Data Migration
2014
2
Informatica Developer
2021
2
Java
2014
2
Metadata
2021
2
MS SharePoint
2011
2
UI
2011
2
Business Objects
2016
1
Data Analysis
2013
1
Data Integration
2013
1
Data Profiling
2013
1
IDQ
2013
1
OPTIM
2013
1
Project Management
2012
1
Requirements Gathering
2013
1
Teradata
2012
1
TOAD
2013
1
Auditing
0
1
Data Mapping
0
1
ETL
0
1
Java Servlet
0
1
Requirement Analysis
0
1
SAP
0
1
SDLC
0
1
Snowflake
0
1
SQL Developer
2012
1
Stored Procedure
0
1
Triggers
0
1
WebServices
0
1
XML
0
1
Languages
English, Fluent/Bilingual
