Data Engineering Consultant-SQL,ETL ,Python

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 diversity and inclusion, talented peers, comprehensive benefits and career development opportunities. Come make an impact on the communities we serve as you help us advance health equity on a global scale. Join us to start Caring. Connecting. Growing together.

Primary Responsibilities:

• Research complex functional issues logged by business teams
• Should 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(Minimum 16 years of formal Education)
• Minimum of 7+ 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
• Should have knowledge of SDLC process; experience in Agile will be given more preference
• Solid communication and presentation skills
• Proven excellent analytical, problem solving and data analysis abilities
• Ability to Work collaboratively in global project with a positive team spirit and ensure team work & coordination
• Flexible with the working hours as he/she needs to closely work with the US counterparts
• Proven excellent communication and client facing skills
• Ability to write complex SQL’s and Python script
• Ability to design/Test DataStage(ETL) jobs
• Knowledge on Unix, testing and automation
• Good knowledge in US Health Care domain
• Proven excellent Analytical and SQL skill set to support in the data validation

At UnitedHealth Group, our mission is to help people live healthier lives and make the health system work better for everyone. We believe everyone–of every race, gender, sexuality, age, location and income–deserves the opportunity to live their healthiest life. Today, however, there are still far too many barriers to good health which are disproportionately experienced by people of color, historically marginalized groups and those with lower incomes. We are committed to mitigating our impact on the environment and enabling and delivering equitable care that addresses health disparities and improves health outcomes — an enterprise priority reflected in our mission.