Data Engineering Consultant

Job Description

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:

- Be able to write complex SQL's and Python script
- Be able design/Test DataStage(ETL) jobs
- Come up with architecture and design on various aspects like extensibility, scalability, security, design patterns etc., against a predefined checklist and ensure that all relevant best practices are followed
- Execute POCs to make sure that suggested design/technologies meet the requirements
- Architecting with modern technology stack and Designing Public Cloud Application leveraging in Azure
- Research complex functional issues logged by business teams
- Be able to manage/guide technical teams
- Status reporting for the projects
- Recommendations for new data warehouse/ mart design as well as improvements in current data warehouse
- Act as a mentor for junior team members
- Analyzes and investigates
- Provides explanations and interpretations within area of expertise

- 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 regards 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

Required Qualifications:

- B.Tech/MCA (Master of Computer Application)/M.Tech are preferred candidates(16+ years of formal Education)
- 10+ years in supporting requirement gathering of large DWH
- Hands-on experience on writing Complex and Advance SQLs in multiple database environments
- Hands on experience on ETL/Data Model and experience of collecting business requirement
- Hands-on experience on navigation of Unix file system and profiling large data files
- Experience with cloud computing platforms, such as Amazon Web Services (AWS) and Microsoft Azure
- Experience with big data technologies, such as Apache Hadoop and Apache Spark
- Knowledge of SDLC process experience in Agile will be given more preference
- Knowledge on Unix, testing and automation
- Good knowledge in US Health Care domain
- Proven solid communication and presentation skills
- Proven excellent analytical, problem solving and data analysis abilities
- Proven ability to Work collaboratively in global project with a positive team spirit and ensure team work & coordination
- Proven excellent communication and client facing skills
- Proven excellent Analytical and SQL skill set to support in the data validation
- Proven to possess/acquire solid troubleshooting skills and be interested in performing. Troubleshooting of issues in different desperate technologies and environments
- Flexible with the working hours as he/she needs to closely work with the US counterparts

---