ETL operations

Data Analytics Mumbai, Maharashtra, India

Profile
Contacts

Summary

EXPERIENCE
Tech Mahindra (Sept 2021 - present)
ETL Operations (Production support)
SUMMARY:
2.5+ Years of experience in the IT Industry as
Software Engineer.
Hands on Experience in L2 ETL support.
Have Good Knowledge on ETL Testing and
Preparing Test Data.
Hands on experience in various Ab-Initio transform
components such as reformat, FBE, join, normalize,
rollup, dedup, scan.
Expertise in Ab-Initio utilities commands like air
commands, And m commands like m_dump,
m_eval, m_db etc.
Expertise in testing and validating the Ab Initio
graphs.
Expertise in UNIX commands.
Expertise in Identify/Debug, troubleshoot, modify,
document, test and Hot fix production issues as
part of L3 ETL Support.
Expertise in Working on Incidents for Tracking the
Missing Records or Investigating the Data Loss and
Finding the Duplicates in Data as part of L3 ETL
Support.
Expertise in Working on Work Orders Which Are
related to Data Requests & Jobs running stats
from Production as part of ETL Support.
Expertise in Ordering & Monitoring & Holding &
Releasing and rerunning the Jobs in Production
using Scheduling Tool like Control M.
Run the job on daily, monthly, quarterly and yearly
basis.
Working Knowledge on Performing Daily Server
Health checks and Space Utilization Checks at
regular Intervals as Part of ETL Support Activities.
Expertise in Raising Incidents and Work Orders &
CRQs Using BMC Helix.
Service First as per Project Requirement.
Delivery Reporting
Summary:
SDR (Strategic Data Reporting)
Project Details:
Strategic data and reporting (SDR) - Data acquisition
solution is purposed to migrate RDS data to cloud.
Responsibilities:
As part of SDR Development:
Prepared ETL SQL scripts for each table for taking
out the data from the database using the SQL
scripts.
Prepared on SQL for dummy table for testing.
Worked on Unix commands in order to copy the
files, file
transfer and debug the script.
Need to check for the error if the scripts fail, then
needs to fix it and maintain the defect status.
Worked on WinScp to transfer file in different
location.
As part of SDR Testing:
ETL scripts will be executed, and test cases will be
validated.
Worked on ETL script execution.
Check the proper data is inserted or not into the
file.
Also check the file naming conventions for a
particular file.

Education- Done a bachelor degree in computer science and engineering

Expectations

Wants to works in ETL operations where i gain knowledge, and put some skills in the organisation, I want to work in different fields also, but i will learn new new things and technology, to enhance my skills in the field.