M
Mallikarjun Ch
About
Detail
Azure Data Engineer and ETL Developer
Contact Mallikarjun regarding:
Flexible work
Résumé
Jobs
verified_user
0% verified
Azure Date EngineerR1RCMJun 2019 - Mar 2022 (2 years 10 months)Clients: Quest Care Pediatrics, HMG, Care Point and RDMG
Project Description:
I worked for R1RCM.Is one of US healthcare company. The company deals with several clients. We work on patient and insurance claims. So, I work for the Credit Balance Report Team (CBR). The agenda of CBR team is to pull data from companies' internal software. There are different types of claims processed claims, Processed, and denied claims, Pending Claims, Payment Posting Pending claims and Overpayment Paid claims. As Data engineering I Have to separate claims on client provided naming standards using Spark-SQL, Snow-SQL, Spark APIS.
Responsibilities:- CETL DeveloperCyient TechnologiesJun 2018 - Jun 2019 (1 year 1 month)Responsibilities
• Created numerous data frames and datasets using the Spark-SQL context to pre- process the model data.
• In charge of ETL design (identifying the source systems, designing source to target relationships, data cleansing, data quality, creating source specifications, ETL design documents).
• Wrote SQL queries to retrieve information from the databases depending on the requirement and for data cleanup process.
• Analyzed and understood the ETL workflows that have been developed.
• Involved in reviewing and understanding the Business requirements.
• Validated the data transformations and performed end-to-end data validation for ETL.
• Used various Transformation likes Aggregations, Loo
Education
verified_user
0% verified
- Computer Science-Data Science ConcentrationFitchburg State UniversityMay 2022 - Aug 2023 (1 year 4 months)
- SBachelor of ScienceSt. Mary's Engineering CollegeAug 2015 - May 2019 (3 years 10 months)