S

Sony Shrestha

About

Detail

Data Engineer
Bagmati Province, Nepal

Contact Sony regarding: 
work
Full-time jobs
Flexible work

Timeline


work
Job

Résumé


Jobs verified_user 0% verified
  • Toptal
    Data Engineer
    Toptal
    May 2022 - Jul 2022 (3 months)
    Prepared python script for scrape data from Sound chart, Chart metric and Spotify to gather music-related data from several APIs. •Prepared SQL Script for migrating data from raw database to clean database. •Experience in using different AWS Services like S3, Athena, ECS, ECR. •Provisioned, changed, and improved resources on AWS using Terraform (Infrastructure as a Code).
  • Verisk
    Software Engineer
    Verisk
    Sep 2021 - Aug 2022 (1 year)
    Optimized Pentaho jobs and transformations, which reduced processing time by 83%. •Identified the root cause of technical bugs raised in production and made necessary changes in ETL to fix them. •Prepared business reports for A-PLUS Property using Jasper Scripts. •Reviewed source code developed by other developers for A-PLUS Property. •Migrated legacy data from Microsoft SQL Server to PostgreSQL. •Implemented data masking techniques, such as pseudonymization, anonymization, encryption, redaction, shuffling, and scrambling to ensure data governance of Personally Identifiable Information (PII). •Evaluated the workflow and increased efficiency of data pipelines that process over 5TB of data daily. •Prepared snow pipe for continuous dat
  • E
    Associate Data Engineer
    ExtensoData, F1Soft
    Oct 2019 - Jan 2021 (1 year 4 months)
    Evaluated the current architecture of Foneloan and designed the new one that satisfies the diverse requirements of multiple clients while keeping the ETL flow generic. •Automated the ETL process, eliminating the necessity of manual coding to manage the data flows. •Performed data cleansing and validation using PDI. •Optimized SQL queries, reducing processing time by more than 50%. •Increased the efficiency of data fetching by approximately 30%, using query optimization and indexing. •Ingested data from disparate data sources like SQL, MySQL, Oracle, and CSV, using Pentaho to create data views for business intelligence tools. •Tested the end-to-end flow of the project named Budget, raised bugs, and provided recommendations. •Generate
  • e
    Associate Data Engineer
    eSewa