Advisory Services Consultant

2 weeks ago

Hyderabad, Telangana, India UnitedHealth Group Full time

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.

As an ETL Tester (SDET), candidate will be predominantly involved in creating test strategy and automation solutions for validating large data platforms or data interfaces/workloads on both Azure and On-Premise environments. The successful candidate will be a primary contributor in developing test solutions and framework for optimization and supporting all types of applications testing on Azure cloud and established standard operating procedures, and methodologies to deliver business value. This is more than a challenging role with primary focus on developing test solutions and capabilities for Azure cloud migration and data management workloads.

Primary Responsibilities:

Working with various product and implementation teams; develop test strategy/test plans and test solutions to implement such strategies/plans. This includes automation requirements for different products and applications across the enterprise landscapeUnderstand the complex Data Model, architecture and Source to Target mapping and to create efficient test approach and test scripting by writing Complex SQL queries. Able to develop automated test solutions and frameworks for Data conversion/ETL and Data interfaces or any data related workloadsUnderstand complex data models across the application landscape to design, develop and provision test data as per test data requestsIdentify the Process Gaps and technical debt and come up with the strategies and solutions for improvements, focusing on standardization and Automation Problem solving techniques & Interpersonal skillsProvide Support in for Continuous Integration and Continuous Delivery You will be involved in solving moderately complex problems and/or conduct moderately complex analysis Demonstrate experience in supporting team members in providing the technical or business-related solutions and guiding them to complete the tasks on timeYou will provide explanation and information to others including Senior Leadership on challenging issues and recommend solution to solve themYou will maintain awareness of current technology assets, and the applicability and capability of eachComply 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:

At least 6 + years of experience as SDET primarily in developing and testing of ETL/Data conversion and data related work loadsImplementation experience for testing workloads migrated from On-premise to Azure Cloud along with test estate and tools etcKnowledge and understanding of complex data ingestion/data integration patterns – Both Batch and Real time patternsSolid understanding on commonly used test design patterns to validation data ingestion and integration patterns for batch and Real timeHands on Development and Scripting Experience using Python/Spark.Should be aware of Azure Data Factory, Databricks environments and Snowflake.Data testing experience, ability to write complex SQL Queries to on relational and Non-Relational databasesManaging Code repositories (Git Actions/Azure Pipelines), implementing Continuous testing tool (Git Actions/Azure Pipelines)Ability to identify opportunities to improve and communicate effectively to improve the capabilities

Preferred Qualifications:

Experience with ETL, Data warehouse and Big data testing Experience with Azure Data services and Azure DevOps Experience working on Snowflake data platform and understanding it intricaciesWorking knowledge of Relational/ NoSQL/Azure DatabasesAny relevant industry certifications (Azure Fundamentals AZ certification or any)Automation experience using Java/.Net/Python with solid SQL Skills

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.

  • Consultant – Innovation Advisory

    2 weeks ago

    Hyderabad, Telangana, India Sathguru Management Consultants Full time

    Position : Consultant – Innovation Advisory (Agrochemicals) Experience: Minimum 5 years Location : Hyderabad Key Responsibilities: About The Role : As an Agrochemical Specialist within Sathguru's agri consultancy team, this techno-managerial role encompasses a comprehensive grasp of the latest advancements in technology and product innovations...

  • Consultant / Senior Consultant – Pharma & Healthcare Advisory

    2 weeks ago

    Hyderabad, Telangana, India Sathguru Management Consultants Full time

    Position : Consultant / Senior Consultant – Pharma & Healthcare Advisory Experience: 3 – 5 yrs Qualification : Bachelors/Masters in Pharma/Healthcare/Bio-Medical Location : Hyderabad Overview: The current position is in the life sciences practice of Sathguru and will be based in Hyderabad, India. Founded in 1985, Sathguru is a boutique strategy and...

  • Principal Consultant-Advisory

    2 weeks ago

    Hyderabad, Telangana, India Wipro Full time

    Role Purpose Principal Consultants are expected to have a deep area of consulting expertise, with a good understanding of the client's business landscape and an ability to manage the delivery of consulting solutions that achieve clear business value. The role may have managerial responsibilities in leading a team of consultants and managing quality and...

  • Service Advisory

    2 weeks ago

    Hyderabad, Telangana, India Chaitanya HR Consultancy Full time

    Share: Share _ Share _ Tweet_Responsibilities: _- _Provide expert advice and assistance to clients regarding insurance products and services. _- _Assess clients' insurance needs and recommend suitable coverage. _- _Resolve customer inquiries, concerns, and issues in a timely and professional manner. _- _Collaborate with internal teams to ensure seamless...

  • Advisory Services Senior Consultant

    2 weeks ago

    Hyderabad, Telangana, India UnitedHealth Group Full time

    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,...

  • Assoc. Consultant/Consultant – Agri Business Advisory

    2 weeks ago

    Hyderabad, Telangana, India Sathguru Management Consultants Full time

    Position : Assoc. Consultant/Consultant – Agri Business Advisory Experience: 2 – 3 years Location : Hyderabad Job overview: The candidate will work with new ventures and established companies in the Agri Input space like Seeds, Agrochemicals, AgBiologicals, AgBiotech and AgTech to advise them on business planning, strategy, and corporate finance...

  • Advisory Services Senior Consultant

    2 weeks ago

    Hyderabad, Telangana, India UnitedHealth Group Full time

    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,...

  • Advisory Services Consultant

    2 weeks ago

    Hyderabad, Telangana, India UnitedHealth Group Full time

    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,...

  • Advisory Services Consultant

    2 weeks ago

    Hyderabad, Telangana, India UnitedHealth Group Full time

    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,...

  • Advisory Services Consultant

    2 weeks ago

    Hyderabad, Telangana, India UnitedHealth Group Full time

    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,...

  • Associate advisory Services

    2 weeks ago

    Hyderabad, Telangana, India Colliers International Full time

    Full-time Location: IndiaCompany Description:Colliers International Group Inc (NASDAQ and TSX:CIGI) is an industry leading global real estate services company with 15,000 skilled professionals operating in 68 countries. With an enterprising culture and significant employee ownership, Colliers professionals provide a full range of services to real estate...

  • Vice President – Agri Business Advisory

    2 weeks ago

    Hyderabad, Telangana, India Sathguru Management Consultants Full time

    Position : Vice President –Agri Business Advisory Experience: yrs Location : Hyderabad Sathguru leads agri business transformation globally with propriety approach in Technology, markets, value chain, regulations and business alliances delivered to industry leading agri and food enterprises, for over three decades. About the position: As the Senior...

  • Advisory Services Consultant

    2 weeks ago

    Hyderabad, Telangana, India UnitedHealth Group Full time

    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,...

  • Advisory Services Consultant

    2 weeks ago

    Hyderabad, Telangana, India UnitedHealth Group Full time

    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,...

  • Executive - Residential Advisory Services

    2 weeks ago

    Hyderabad, Telangana, India JLL Full time

    JLL supports the Whole You, personally and professionally.Executive - Residential Advisory ServicesAbout JLLJLL (NYSE: JLL) is a leading professional services firm that specializes in real estate and investment management. Our vision is to reimagine the world of real estate, creating rewarding opportunities and amazing spaces where people can achieve their...

  • Executive, Residential Advisory Services

    2 weeks ago

    Hyderabad, Telangana, India JLL Full time

    JLL supports the Whole You, personally and professionally.Executive, Residential Advisory ServicesAbout JLLJLL (NYSE: JLL) is a leading professional services firm that specializes in real estate and investment management. Our vision is to reimagine the world of real estate, creating rewarding opportunities and amazing spaces where people can achieve their...

  • Advisory Services Consultant

    2 weeks ago

    Hyderabad, Telangana, India UnitedHealth Group Full time

    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,...

  • Associate - Risk Advisory Services

    2 weeks ago

    Hyderabad, Telangana, India Sathguru Management Consultants Full time

    Position : Associate - Risk Advisory ServicesExperience: 0-2 yrLocation : HyderabadResponsibilities: Responsibility of executing client engagements in the areas of risk & compliance process audits, internal audits, internal financial controls. Ensure that the work delivered is of high quality. Actively establish & strengthen client and internal relationships...

  • Associate – Risk Advisory Services

    2 weeks ago

    Hyderabad, Telangana, India Sathguru Management Consultants Full time

    Position : Associate – Risk Advisory Services Experience: 0-2 yr Location : Hyderabad Responsibilities: Responsibility of executing client engagements in the areas of risk & compliance process audits, internal audits, internal financial controls. Ensure that the work delivered is of high quality. Actively establish & strengthen client and internal...

  • Associate - Risk Advisory Services

    2 weeks ago

    Hyderabad, Telangana, India Sathguru Management Consultants Full time

    Position : Associate - Risk Advisory ServicesExperience: 0-1 yrsQualification : Qualified Chartered Accountant from ICAILocation : HyderabadRoles & Responsibilities: Responsibility of executing client engagements in the areas of risk & compliance process audits, internal audits, internal financial controls. Ensure that the work delivered is of high quality....