Summary
Overview
Work History
Education
Skills
Tools Used
Timeline
Generic

Arunkumar Palani

Chennai

Summary

Practical database engineer possessing in-depth knowledge of data manipulation techniques and computer programming paired with expertise in integrating and implementing new software packages and new products into system. Offering several-year background managing various aspects of development, design and delivery of database solutions. Tech-savvy and independent professional bringing outstanding communication and organizational abilities.

Overview

6
6
years of professional experience

Work History

Data Engineer

PACT EMPLOYMENT SERVICES (DERBY GROUP)
DUBAI
05.2022 - 12.2023
  • Created clone objects to maintain zero-copy cloning.
  • Cloned production data for code modification and testing.
  • The Flatten table function was applied to yield a lateral view of the Variant, Object, and Array columns.
  • Used secure views and materialized views to share the data to the partner application as per the data requests.
  • Developed data pipelines for extracting, transforming, and loading large datasets.
  • Maintained data architecture documentation to support future development initiatives.
  • Analyzed system performance metrics to identify bottlenecks and propose enhancements.
  • Analyzed user requirements, designed and developed ETL processes to load enterprise data into the Data Warehouse.
  • Created stored procedures for automating periodic tasks in SQL Server.
  • Developed Python scripts for extracting data from web services API's and loading into databases.
  • Collaborated with cross-functional teams to gather requirements and translate business needs into technical specifications for data solutions.

Snowflake Developer

WIPRO TECHNOLOGY
Chennai
07.2020 - 04.2022
  • Analyzed the project and tested the source data, staging data, and target data.
  • Creating test cases by studying the mapping documents from Source and target environment.
  • Testing the record counts between the source and target environments.
  • Wide experience in creating test cases for manual test execution using SQL in a database testing environment.
  • Involved in data quality validation includes row counts check, sample data validations and entire data reconciliation.
  • Analyzed application data using the SQL to identify the ETL processes modifying and creating SQL Queries and stored procedures for quality assurance and analysis.
  • Defects identified in testing environment are communicated to the developers.
  • Creating traceability relationship between requirements in the same module and also between different modules.
  • Used UNIX commands to test the files and tables to the comparison of data.
  • Communicated to the business team to get clear about the requirement gaps and understand the functionality.
  • Collaborated with cross-functional teams to gather project requirements and specifications.

Data Engineer

Hinduja Global Solutions
BANGALORE
05.2018 - 02.2020
  • Analyzed the Project and tested the source data, staging data and target data.
  • Creating test cases by studying the mapping documents from the source and target environments.
  • Testing the Record counts between Source and Target environments.
  • Wide experience in creating test cases for manual test execution using SQL in a database testing environment.
  • Involved in data quality validation includes row counts check, sample data validations and entire data reconciliation.
  • Analyzed application data using the SQL to identify the ETL processes modifying and creating SQL Queries and stored procedures for quality assurance and analysis.
  • Defects identified in testing environment are communicated to the developers.
  • Creating traceability relationship between requirements in the same module and also between different modules.
  • Used UNIX commands to test the files and tables to the comparison of data.
  • Communicated to the business team to get clear about the requirement gaps and understand the functionality.

Education

B.COM (ISM) Formerly B.SC (ISM) - INFORMATION SYSTEMS MANAGEMENT

D.R.B.C.C.C. Hindu College
CHENNAI
05-2017

Skills

  • Snowflake DB
  • AWS S3
  • ETL Concepts
  • ORACLE
  • SQL
  • PL/SQL
  • Problem solving
  • Effective communication
  • ETL process design
  • Cloud data warehousing
  • Python
  • Data pipeline optimization

Tools Used

  • IICS
  • DBT
  • Jenkins
  • Jira
  • SnowSQL
  • GitHub

Timeline

Data Engineer

PACT EMPLOYMENT SERVICES (DERBY GROUP)
05.2022 - 12.2023

Snowflake Developer

WIPRO TECHNOLOGY
07.2020 - 04.2022

Data Engineer

Hinduja Global Solutions
05.2018 - 02.2020

B.COM (ISM) Formerly B.SC (ISM) - INFORMATION SYSTEMS MANAGEMENT

D.R.B.C.C.C. Hindu College
Arunkumar Palani