Summary
Overview
Work History
Education
Skills
Languages
Timeline
Generic
Indhuja Selvaraj

Indhuja Selvaraj

Dubai

Summary

  • 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

Anna University
Tuticorin, TamilNadu, India
09/2010 - 04/2014

12th Standard - Computer Science

St. Thomas Matriculation Higher Secondary School
Tuticorin, TamilNadu, India
06/2009 - 05/2010

10th Standard - Matriculation

St. Thomas Matriculation Higher Secondary School
Tuticorin, TamilNadu, India
06/2008 - 05/2009

Skills

  • ETL Tool : Informatica BDM 104 & 102 , Informatica PowerCenter v951,v102, IICS, Informatica B2B
  • Databases : Ambari HIVE 200, Oracle 19c, Teradata SQL Assistant, SQL Server
  • Platform : Hadoop, Cloudera
  • Engine : Blaze, Spark
  • Programming Languages : SQL ,shell scripting
  • Dev Ops Tools : Jenkins
  • Scheduling Tools : Autosys, Oozie
  • FTP Tools : Putty, WINSCP
  • Source Systems : Finacle, Finnone
  • Ticketing Tools : Service Now,Jira,Confluence, HP service center, Remedy, HP ALM
  • Other Tools : Medidata RAVE system , Elastic search, Content Square

Languages

English
Bilingual or Proficient (C2)
Tamil
Bilingual or Proficient (C2)
German
Beginner (A1)

Timeline

Data Engineer

Virtusa Middle East
09.2022 - Current

ETL Informatica Developer

HCL technologies
01.2021 - 08.2022

Informatica and Teradata Developer

Cognizant Technology Solutions
03.2019 - 12.2020

ETL Informatica Developer

Accenture solutions
04.2015 - 02.2019

Bachelor of Engineering - Electrical And Electronics Engineering

Anna University
09/2010 - 04/2014

12th Standard - Computer Science

St. Thomas Matriculation Higher Secondary School
06/2009 - 05/2010

10th Standard - Matriculation

St. Thomas Matriculation Higher Secondary School
06/2008 - 05/2009
Indhuja Selvaraj