Aswini Priya Ganesh
ETL Developer (Extraction, Transformation, Loading)
0
Followers0
Following8+ yearsTexas City, TX, USA
About Aswini Priya Ganesh
ETL Developer (Extraction, Transformation, Loading)Experience level
Senior-level8+ yrs
Hourly rate
$88/hrOpen to
Skills
GithubWeb designJavaAngularC#Python
Education
JNTU
Computer science
Bachelor's DegreeClass of 2013
Experience
Senior Big Data Engineer
Mercedes- Benz Financial Services
contract10/2021 - 1/2023
- • Used Agile methodology in developing the application, which included iterative application development, weekly Sprints, stand up meetings and customer reporting backlogs. • Monitoring resources and Applications using AWS Cloud Watch, including creating alarms to monitor metrics such as EBS, EC2, ELB, RDS, S3, SNS and configured notifications for the alarms generated based on events defined. • Analyze and develop programs by considering the extract logic and the data load type using Hadoop ingest processes using relevant tools such as Sqoop, Spark, Scala, Kafka, Unix shell scripts and others • Assist with the analysis of data used for the tableau reports and creation of dashboards. • Design and implement large scale distributed solutions in AWS. • Optimized Map Reduce Jobs to use HDFS efficiently by using various compression mechanisms. • Development of efficient pig and hive scripts with joins on datasets using various techniques. • Automating the ETL tasks and data work flows for the data pipeline of the ingest process through UC4 scheduling tool. • Used Matillion tool blob storage component and loaded the tables to snowflake Stage layer • Solved performance issues in Hive and Pig scripts with understanding of Joins, Group and aggregation and how does it translate to MapReduce jobs. • Used ORC and Parquet file formats in Hive. • Writing code and creating hive jobs to parse the logs and structure them in tabular format to facilitate effective querying on the log data. • Created and managed cloud VMs with AWS EC2 Command line clients and AWS management console. • Migrated on premise database structure to Confidential Redshift