Jay Patel Email & Phone Number

Mumbai Area, India

Tatamotors Teradata upgrade project involves the upgrade of the Analytics database using Oracle to use the Teradata database.This involves the migration of all the Analytics data from Oracle to the Teradata. It involves Upgrading the informatica which incudes changing of the Oracle source qualifier queries in the informatica to the equivalent Teradata Queries and also changing the other functional aspects related to mappings and workflows according to Teradata Requirement.Role : Solution DeveloperClient : Tata MotorsTools/Technology : Informatica(9.0.1),Teradata databaseVertical : AutomotiveResponsibilities :• Changing the source qualifier queries of infomatica mappings to make them Teradata database compatible and changing the other functional aspects related to mappings and workflows

Mumbai Area, India

Data Extraction/Change Request : To extract the data by tuning the sql query.Data is required by the business every month for Analysis, to develop the customized mappings/workflows in Informatica to provide the data and schedule the I-Bots in OBIEE and session in Informatica so that the user will receive the data at the scheduled time.To check change requests raised everyday, do the required development and closing the CR as soon as possible.Performance Tuning – To reduce the time required to run the query, by doing changes in the query. Informatica Workflow, transformations and Database level.Testing– To test the developed mapping in DEV platform, and check whether it is giving correct output(data) as required by the Business and then migrate this changes to Production environment.

Tata Motors, Thane

Client : Tata MotorsRole : Solution DeveloperTools/Technology : Informatica(8.6.1),DAC(10.1.3.4.1) ,Toad,Oracle databaseResponsibilities:Change Request – Studying the business requirement(Approach Note) that comes from client for every development, and develop the required mappings in Informatica and schedule them in DAC(Data Warehouse Application Console). preparing a technical note for the same to describe how the module is going to be developed. Supporting the Project by Solving the Support issues whichever comes from business.Testing– To test the developed mapping in DEV environment, and check whether it is giving correct output(data) as required by the Business and then migrate this changes to Production environment.Performance Tuning – To tune the mappings and Report performace by doing changes in the query. Informatica Workflow, transformations and Database level.

Tata Motors ,Thane

TATA Motors has built its DMS using Oracle's Siebel verticals and uses Siebel eDealer, Automotive and Siebel Analytics for all pre and post sales operations. The real time availability of customer and product information is enabling the company and its channel partners to improve response time and customer service. Client : Tata MotorsTools/Technology : Informatica(7.1.2),DAC(7.8.5 ) ,Toad,Oracle databaseResponsibilities : Change Request - To check change requests raised everyday, do the required development and closing the CR as soon as possible.Support Request – To check the Support Requests created every day, find the solution for the same, discuss with B.A and Technical Lead, taking approvals if required, implementing the solution and closing the SR as earliest.Performance Tunning – To increase the throughput and improve the performance of ETL by tuning the sql queries used in sessions,reports,etc.Report testing: To test the reports and document the error or mismatches in the report.