A dynamic individual with 9+ years of experience in Data warehouse analysis/design/development and application management of various business applications in different platforms using Informatica 10.x, Oracle 12c/19c, SQL ,Unix and cloud.
Worked in Dubai and France ON-SITE/Offshore and US Healthcare/Life Science/Telecom/UAE banking Projects. Worked for L2 (Level II) and L3 (Level III) support platform team.
Overview
9
9
years of professional experience
Work History
Data Engineer
Virtusa Middle East
09.2022 - Current
Working as Informatica BDM developer in BANKING domain with reputed UAE Bank
Worked on Informatica BDM 10.2 to 10.4 (Blaze to Spark Engine migration)
Coordinate all Scrum Ceremonies including Sprint Planning, Daily Stand-ups, Sprint retrospectives, Sprint Demos, Story Grooming and Release Planning.
Configured Jenkins job to provide seamless deployment across production, staging and QA environment
Worked in migration of HDP (Hadoop Data Platform) to CDP (Cloudera Data Platform)
Participating in gathering business requirements, analysis and design.
Develop complex Informatica mappings and workflows.
Created Databases, Schemas, Tables, write SQL queries against HiveDB
Used PowerShell to effectively automate data imports and exports from various data warehouses.
converted sequential oozie jobs to run in parallel for job optimization (tuning long running jobs for respective entities)
ETL Informatica Developer
HCL technologies
01.2021 - 08.2022
Worked in a telecom development project as ETL Informatica developer.
worked on unconnected Lookups in-order to retrieve data for a new column from the existing column.
Added a new column to the existing mapping/workflow.
Interacted with Client and followed up on all the tasks assigned to team.
Working on Medallia Sales feedback analysis. Involved in deeper analysis using Elastic search (Kibana logs) and content square tools
worked on medallia tickets and resolved the data issues raised by customers
Explored and created new ways to resolve problems with processes, technology or team members to improve overall efficiency.
Informatica and Teradata Developer
Cognizant Technology Solutions
03.2019 - 12.2020
Worked ON-SITE at France (Client location) and Increased customer satisfaction. Maintained good rapport with the Client.
Handled meetings/calls to address customer inquiries and concerns. provided support 24/7 in case of any issues.
Communicated with offshore team. provided support and shared my knowledge gained ON-SITE with the Client.
Worked on CLINSTORE application which deals with Clinical and Operational data, handled and processed by Maestro Portal which includes data extraction and Integration process, populated using Teradata tables.
Operational data is loaded from Rave Webservices for all studies available. Operational data is recalculated for all studies depending on events received from the Rave audit table in an ODM.xml format.
Proficient in using Debugger wizard to find the root cause of failures or bottlenecks in the mapping or at session level.
ETL Informatica Developer
Accenture solutions
04.2015 - 02.2019
Created several informatica mappings to populate the data into dimensions and fact tables.
Worked on automation of daily reports using UNIX shell script, informatica upgrade testing from 9.5 version to 10.2 and prepared test cases and test results.
Worked on optimizing and tuning the Teradata views and SQLs to improve the performance of batch and response time of data for users.
Production support knowledge with performance tuning in ETL , Oracle Tuning, monitoring and automation.
Prepared Test Scenarios, Test Cases, Test Scripts based on the Functional Specification documents and involved in Query preparation & Execution
Resolved Incident management, Problem management, Request management tickets without SLA miss in HP Service Centre (HPSC) ticketing tool.
Develop ETL bug fixes and enhancements to existent BAU processes and applications. Prepared Root Cause Analysis (RCA)
Education
Bachelor of Engineering - Electrical And Electronics Engineering
HVAC - Senior Sales and Technical Manager at Lennox Middle East (LNX Middle East)HVAC - Senior Sales and Technical Manager at Lennox Middle East (LNX Middle East)