Kumar Ranjan Email & Phone Number

Pune, Maharashtra, India

This Project is to manage current security master data, and new security master data / data feeds. It has Strategic centralized instrument data service that provides accurate and timely information consistently across front, middle, and back office applications.Golden source for instrument indicative data in Fixed Income, Equities, Prime Brokerage, Risk, Financial Controls, Compliance, Regulatory, and Barclays Wealth.

Pune Area, India

Pune Area, India

Efficient in analyzing customer needs and taking appropriate steps to implement them in the application development.Prepare project-phase plans and implementation schedule, plan and conduct meeting and workshops relative to the project plans, and communicate day to day project status to all levels of management.Expertise in proposing effective ETL designs and also having experience in implementing real-time CDC solution using Informatica power exchange and Oracle… Show more Efficient in analyzing customer needs and taking appropriate steps to implement them in the application development.Prepare project-phase plans and implementation schedule, plan and conduct meeting and workshops relative to the project plans, and communicate day to day project status to all levels of management.Expertise in proposing effective ETL designs and also having experience in implementing real-time CDC solution using Informatica power exchange and Oracle .Well-developed analytical, problem solving, and decision making skills; strong troubleshooting .skills; also having ability to identify patterns and generate idea.Skills in ETL Tool( Informatica,Teradata,SQL,Unix,ShellScripting,Tivoli) Show less

Pune Area, India

Good understanding of Database concepts and competence in writing/debugging complex Oracle SQL.Extensively involved in optimization and tuning of mappings and sessions in Informatica by identifying and eliminating bottlenecks, memory management and parallel threading.Good understanding and experience in dimensional Modeling concepts (Star Schema, Slow Changing Dimensions etc.)Experience in designing Informatica templates and other reusable components which can be leveraged… Show more Good understanding of Database concepts and competence in writing/debugging complex Oracle SQL.Extensively involved in optimization and tuning of mappings and sessions in Informatica by identifying and eliminating bottlenecks, memory management and parallel threading.Good understanding and experience in dimensional Modeling concepts (Star Schema, Slow Changing Dimensions etc.)Experience in designing Informatica templates and other reusable components which can be leveraged across a range of projects and solutions.Experience in the full-cycle software development including requirements gathering, prototyping, design, documentation, implementation, testing, maintenance and production support.Well-developed analytical, problem solving, and decision making skills; strong troubleshooting skills; also having ability to identify patterns and generate idea. Show less

Pune Area, India

• Handling the Changes Requests and Bug fixing.• involved in ETL developing Creating the mappings and transformations using Informatica • creating and managing workflow and mapping,writing query and script as user need• The data from the staging area was transformed and loaded to the target using Informatica Tool.• Responsible for creating workflow and queries.• Responsible for writing validation script to maintain data consistency.• Used transformations like Filter… Show more • Handling the Changes Requests and Bug fixing.• involved in ETL developing Creating the mappings and transformations using Informatica • creating and managing workflow and mapping,writing query and script as user need• The data from the staging area was transformed and loaded to the target using Informatica Tool.• Responsible for creating workflow and queries.• Responsible for writing validation script to maintain data consistency.• Used transformations like Filter, Expression, Lookup, Router.• Creating validation and loading the rejected records into the relevant tables and send to the user for re-submitting.• Involved in designing the mapplet and reusable transformation according to the business needs. Show less