Uploaded File
no photo
Rajesh Kumar
Senior Lead Informatica Developer
New York City, NY
Available immediately
Actively seeking
no photo
Rajesh Kumar
13
views
Senior Lead Informatica Developer
1 recommendation
1
Recommendation
Average rating
13
Profile views
SQL Oracle DB2 SQL Server Metadata Data Architecture Business Analysis Business Requirements Informatica Developer Data Marts
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
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
Sr. Informatica Developer 04/13 - 07/14
SQL Informatica SQL Server Oracle Informatica Powercenter Data Migration Data Architecture Informatica Developer
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
SQL
2016
Oracle
2016
DB2
2016
SQL Server
2016
Metadata
2018
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