Occupation:Datawarehouse Designer |
Location:East Windsor, CT |
Education Level:Master |
Will Relocate:YES |
Description
Experience Summary: * Over 9 + years of professional IT experience in Development, Migration, Enhancement, Testing and Production Support Projects of Data warehousing projects. * Experience in Banking, Manufacturing and Pharmaceutical industry business processes. * Experience in creating complex mappings, sessions, workflows, reusable components in Designer, Workflow Manager using various transformations * Involved in the full development lifecycle from requirements gathering, low level design, requirements analysis, coding and/or testing through development and support using Informatica Power Center, Repository Manager, Designer, Server Manager, Workflow Manager, and Workflow Monitor. * Fixing Informatica code to resolve Business critical errors and deploying the code in production * Worked on the source systems like Oracle, SQL Server, Flat Files, XML and COBOL files. * Managing project deliverables in line with the project plan and recording and managing project issues and escalating where necessary. * Resolving cross-functional issues at project level and managing project scope and change control and escalating issues wherever necessary. * Monitoring project progress and performance * Experienced in coding SQL Queries * Experienced in working Scrum methodology. * Extensive experience in Production support which does not limit not only to monitoring the Batch jobs, tracking and resolving the incidents and provided solutions on time to the application users but also quick turnaround fixes * Experienced in finding the root cause for Batch Job failures, reviewing Logs, Health Checks by coordinating with the respective teams. * Experience in scheduling the batch jobs using Workflow Monitor, Appwrox & other third party tools. * Monitoring the performance of production data loads and initiating action plans to tune the long running data loads.