Senior Data Engineer - Databricks Snowflake SQL ETL Spark Data Warehouse

Optum is a global organization that delivers care, aided by technology to help millions of people live healthier lives. The work you do with our team will directly improve health outcomes by connecting people with the care, pharmacy benefits, data and resources they need to feel their best. Here, you will find a culture guided by inclusion, talented peers, comprehensive benefits and career development opportunities. Come make an impact on the communities we serve as you help us advance health optimization on a global scale. Join us to start Caring. Connecting. Growing together.

Primary Responsibilities

• Understand Caredata architecture/domain and start contributing for new/existing business requests
• Develop efficient and high performing ETL solutions
• Design, develop, test and performance tune complex ETLs,Automation and AI Skills
• To make sure all the cloud infra is intact and resolve any issues encountered
• Schedule the deployed pipelines using Airflow following proper dependency hierarchy of jobs
• Move the code/application to higher environments(stage/prod) from non-prod for go-live
• Build and maintain pipelines and automation through Git Ops (GitHub Actions, Jenkins, etc)
• Supports a work environment in which people can perform to the best of their abilities. Holds self-accountable for technical abilities, productive results, and leadership attributes
• Productions Support
• Design and implement efficient data pipelines to ensure a smooth flow of information into the data warehouse or storage system
• Demonstrates and applies understanding of modern development methodologies and tools to develop, deploy, and maintain impactful, high-value market solutions
• Communicate effectively with technical and non-technical stakeholders
• Collaborate with cross-functional teams
• Comply with the terms and conditions of the employment contract, company policies and procedures, and any and all directives (such as, but not limited to, transfer and/or re-assignment to different work locations, change in teams and/or work shifts, policies in regard to flexibility of work benefits and/or work environment, alternative work arrangements, and other decisions that may arise due to the changing business environment). The Company may adopt, vary or rescind these policies and directives in its absolute discretion and without any limitation (implied or otherwise) on its ability to do so
  
  

• B.E/B.Tech./MCA/Graduation
• Bachelor or master's degree in computer science or information technology or equivalent
• 3+ years of total experience
• 3+ years of experience in designing and developing ETL solutions
• 3+ years of working knowledge in a Data Warehouse/BI environment
• Experience in Data Integration and Data Warehousing and Cloud
• Solid DBMS experience: Snowflake, SQL, Hive, Databricks
• Good experience in job schedulers like Airflow
• Good experience in working on cloud environment, preferably Azure
• Experience with Continuous Integration CI/CD pipelines using Jenkins, GitHub Actions
• Experience with contemporary SDLC methodologies such as Agile, Scrum
• Expertise in BigData frameworks like Spark
• Solid SQL skills including complex SQL constructs, DDL generation
• Proven excellent organizational, analytical, writing, problem solving and interpersonal skillsGood to have Healthcare Domains exposure
• Proven excellent written and verbal communication skills, co-ordination skills
  
  

• Databricks, snowflake, SQL queries, ETL, sparq, Data warehouse