S

Sai Kiran Merugu  new_releases

About

Detail

Sr. Data Engineer at Merck
United States
Contact Sai regarding: 
work
Full-time jobs
Starting at USD25/hour

Timeline

work
Job
school
Education

Résumé

Jobs verified_user 0% verified
  • Merck
    Sr. Data Engineer
    Merck
    Sep 2021 - Current (5 years 1 month)
    Evaluated business requirements and prepared detailed specifications that follow project guidelines required to develop written programs.
    Responsible for Big data initiatives and engagement including analysis, brainstorming, POC, and architecture.
    Used cloud shell SDK in GCP to configure the services Data Proc, Storage, BigQuery.
    Very keen in knowing newer techno stack that Google Cloud platform (GCP) adds.
    Developed complex PL/SQL stored procedures, functions, and triggers to automate data processing tasks, improve data quality, and enhance system functionality.

    Optimized SQL queries and PL/SQL code for performance, resulting in significant database query time reductions and improved application responsiven
  • Homesite Insurance
    Big Data Engineer
    Homesite Insurance
    Jun 2019 - Aug 2021 (2 years 3 months)
    Managed ODI repositories, version control, and deployment processes to maintain data integration project integrity and facilitate code sharing among team members.
    Optimized ODI mappings and transformations to enhance data loading performance and reduce processing times, resulting in significant efficiency gains.
    Created and maintained ODI documentation, including technical specifications, process flow diagrams, and data lineage, to ensure knowledge transfer and project scalability.
    Implemented error handling and data quality checks in ODI workflows to proactively identify and address data integration issues.
    Worked on real-time and batch data integration processes, addressing both near-real-time data synchronization and
  • John Deere
    Data Engineer/ Hadoop
    John Deere
    Nov 2018 - May 2019 (7 months)
    - Contributing to the development of key data integration and advanced analytics solutions leveraging Apache Hadoop and other big data technologies for leading organizations using major Hadoop Distributions like Hortonworks.
    - Involved in Agile methodologies, daily Scrum meetings, Sprint planning.
    - Performed Data transformations in HIVE and used partitions, buckets for performance improvements.
    - Created Hive external tables on the MapReduce output before partitioning; bucketing is applied on top of it.
    - Developed business specific Custom UDF's in Hive, Pig.
    - Developed end to end architecture design on big data solution based on variety of business use cases
    - Worked as a Spark Expert and performance O
  • L
    Hadoop Developer
    LEAPS by Analyttica
    Jul 2016 - Aug 2018 (2 years 2 months)
    - Implemented solutions for ingesting data from various sources and processing the Data-at-Rest utilizing Bigdata technologies such as Hadoop, Map Reduce Frameworks, HBase, and Hive.
    - Used Sqoop to efficiently transfer data between databases and HDFS and used Flume to stream the log data from servers.
    - Developer full SDLC of AWS Hadoop cluster based on client's business need
    - Involved in loading and transforming large sets of structured, semi structured and unstructured data from relational databases into HDFS using Sqoop imports.
    - Implement enterprise grade platform (mark logic) for ETL from mainframe to NOSQL (Cassandra)
    - Responsible for importing log files from various sources into HDFS using Flume
  • Mu Sigma Inc
    Data Engineer
    Mu Sigma Inc
    Jun 2014 - May 2016 (2 years)
    - Designed and Developed ETL jobs to extract data from Salesforce replica and load it in data mart in Redshift.
    - Involved in performance tuning, stored procedures, views, triggers, cursors, pivot, unpivot functions, CTE's.
    - Developed and delivered dynamic reporting solutions using SSRS.
    - Extensively used Erwin for Data modeling.
    - Created Staging and Target Models for the Enterprise Data Warehouse.
    - Involved in Normalization / De normalization techniques for optimum performance in relational and dimensional database environments.
    - Resolved the data type inconsistencies between the source systems and the target system using the Mapping Documents and analyzing the database using SQL queries.
    - Develop
Education verified_user 0% verified
  • JNTUH College of Engineering Hyderabad
    Bachelor's degree
    JNTUH College of Engineering Hyderabad
    Jan 2011 - Dec 2014 (4 years)