Rajesh D Email & Phone Number

Norwalk, Ct, Us

Detroit, Michigan, Us

Mumbai, Maharashtra, In

Interaction with the Business Users to analyze the Business Requirements, High Level Document (HLD), Low Level Document (LLD) and transform the business requirements into the technical requirements.Providing Technical and functional guidance to team and helping them to resolve the day to day issues.Working on design and development of Informatica mappings, workflows to load data into Staging layer.Used Informatica Power Center to create mappings, sessions and workflows for populating the data into staging tables from different source systems (Teradata, Oracle and Flat files).Created mappings using various Transformations.Deployed reusable transformation objects such as mapplets to avoid duplication of metadata, reducing the development time.Performance tuning of Informatica mappings by tuning the Source, Target and Lookup queries and enabling the cache options. Handling huge tables by Table Partitioning and Index Creation. Involved in DBA and BI Server related issues and activities.Informatica Administration activities viz. repository refresh, objects migration and managing users and groups. Involved in Unit Testing, User Acceptance Testing (UAT) to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements. Prepared and used test cases to verify accuracy and completeness of ETL process. Extensive Troubleshooting skills.

Mumbai, Maharashtra, In

Worked closely with the business in understanding their requirements and translating them to BRD and SRDs. Worked extensively on Data modeling for various Data marts in EDW, data profiling and cleansing. As a Lead ETL Developer designed and created 40+ mappings/sessions/workflows to move data from SAP BW source system to reporting data warehouse in MIS industry. Built mappings to load data into flat files/database which was used by the downstream applications. Developed unit and system test cases, using System Procedures to check data consistency with adherence to the data model defined. Leading a team of developers both onshore and offshore to integrate EDW with multiple systems. Having migrating experience to Production servers and handled all the issues during stabilization/warranty support period.

Mumbai, Maharashtra, In

Involved in requirement gathering discussions with Functional Team and also with business users, if required in delivery estimation. Involved in preparing Development Requirement & Technical Design document. Co-ordination/Development of mappings using Informatica to populate data on the Data Warehouse(EDW). Developed Teradata code for data load to EDW using Teradata load utilities. Worked with Performance/DBA Team to improve application performance. Created tables, Materialized Views, Triggers, Packages and Procedures. Vast experience in writing complex Procedures, Functions and Materialized views. Performance tuning of complex PL/SQL blocks and Query Optimizing. Performed data quality check and data integrity. Developed System Testing Test Plan and reviewed Test Results. Coordinating with Functional team for Customer Acceptance Test. Interaction with clients on delivery perspective on daily basis.

Mumbai, Maharashtra, In

Involved in low-level design and developed various jobs and performed data loads and transformations using different transformation of INFORMATICA. Converted the PLSQL Procedures and Packages into Informatica Mapping Played a major role in designing the Facts and dimensions implementing SCD and Star Schema types in Informatica Mapping. Developed Informatica mapping to load Aggregate tables which is used for reporting purposes. Scheduled workflows and fixed the data issues. Performance tuning has been done to increase the throughput at both mapping and session level and SQL Queries Optimization as well. Designed multiple refreshes for the Database by flipping over the Database and delivering the most current data to the users. Involved in unit testing to test the processed data and user acceptance testing.

Mumbai, Maharashtra, In

Performed major role in understanding the business requirements, designing and loading the data into DWH. Assigning the trouble ticket to the offshore team.Developed ETL code with transformation logic applied.Performed root cause analysis for the issue mentioned in trouble ticket and developed code for fixing the issue. Prepared Solution Review document (SRD) followed by development. Proposed analysis and code fix to the client and getting approval. Involved in unit testing to test the processed data and user acceptance testing. Moving the code to system testing team and support the same till the code moves to production. Preparing ST plan and Deployment Guide for production deployment.Validating production data after their first successful job run post-deployment. Code migration to Production according to the Change Management System. Effective interaction with Users and coordinating with offshore team.

Mumbai, Maharashtra, In

Participated in requirement gathering discussions with client and also with business users in estimation of the delivery.Understanding the entire system based on requirements.Co-ordination with the Business users and the IT team to get the Development Requirements prepared.Worked on functional specification and technical specification documents and have also driven introductions of several new source systems in the Data Warehouse.Developing ETL mapping or re-designing the mapping logic.Developing and modifying SQL queries to accommodate the changesDeveloped batch script to dynamically update the session parameters. Experienced in troubleshooting and fix the different issues. Experienced in deploying the developed mappings from Dev/test to Production environment.

Mumbai, Maharashtra, In

Involved in Design, Development, Deployment and Warranty Support.Performed INFORMATICA code migrations, testing, debugging, and document and maintain process/programs and monitor according to Genworth standards. Developed mappings as per demand on client requirement. Developed Appworx jobs for scheduling INFORMATICA workflows as per customer requirement. Load quarterly data from OASys data warehouse to the Vendor System database. Involved in migrations from INFORMATICA 7.1.3 to INFORMATICA 8.1.1. Experienced in Unit Testing and User Acceptance Testing.

Bachelor Of Engineering (Be), Electronics And Communications Engineering

Education record