Uploaded File
no photo
Rajesh Kumar
Senior Lead Informatica Developer
11 years experience C2C New York City, NY
Available immediately
Actively seeking
no photo
Rajesh Kumar
97
views
Senior Lead Informatica Developer
1 recommendation
1
Recommendation
Average rating
97
Profile views
Data Warehousing Oracle SQL SQL Server BRD Data Dictionary FRD Business Intelligence DB2 Business Analysis
Remove Note
View Note
Recent Experience
Senior Lead Informatica Developer 08/16 - present
Metadata Informatica Business Analysis Business Requirements Data Marts Informatica Powercenter Data Architecture Informatica Developer Data Modeling Business Intelligence BRD Data Dictionary FRD
Senior Data warehouse Developer 08/14 - 08/16
SQL Metadata Business Objects Business Analysis Business Requirements Data Marts Data Modeling Data Warehousing DB2 SQL Server Oracle PL/SQL Business Intelligence BRD Compliance Data Dictionary FRD Windows
Sr. Informatica Developer 04/13 - 07/14
SQL Informatica SQL Server Oracle Informatica Powercenter Data Migration Data Architecture Informatica Developer Java Data Warehousing
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/SnowflakeSchema) 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.

Top 5 Skills
SkillsProficiencyLast Used
Data Warehousing
2016
Oracle
2016
SQL
2016
SQL Server
2016
BRD
2020
Education and Certifications
Bachelor's in Electrical
Anna University, 2004 - 2008
Preferences
Availability:Immediately
Willing to relocate?:Yes
Relocation preference
Any location
Prepared to Travel:Up to 25%
Employment Type:Any
Security Clearance:No clearance
Citizenship:H-1B Visa