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
Clinical Documentation Specialist at Acuity Solutions India Pvt Ltd (An IKS Health Company) | Client: Coastal MedicalClinical Documentation Specialist at Acuity Solutions India Pvt Ltd (An IKS Health Company) | Client: Coastal Medical