Your browser does not support javascript! Please enable it, otherwise web will not work for you.

Advisory Services Consultant - ETL Testing on Bigdata app @ Optum

Home > DBA / Data warehousing

 Advisory Services Consultant - ETL Testing on Bigdata app

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.
  •   Test Planning & Automation Lead - Cloud Data Modernization
  •  Position Overview:   We are seeking a highly skilled and experienced Test Planning & Automation Lead to join our team for a Cloud Data Modernization project. This role involves leading the data validation testing efforts for the migration of an on-premises Enterprise Data Warehouse (SQLServer) to a target cloud tech stack comprising Azure Cloud data tools (ADF, SHIR, Logic Apps, ADLS Gen2, Blob Storage, etc.) and Snowflake. The primary goal is to ensure data consistency between the on-premises and cloud environments.
  •  Primary Responsibilities
  •  
  • Lead Data Validation TestingOversee and manage the data validation testing process to ensure data consistency between the on-premises SQLServer and the target cloud environment
  • Tool Identification and AutomationIdentify and implement appropriate tools to automate the testing process, reducing reliance on manual methods such as Excel or manual file comparisons
  • Testing Plan DevelopmentDefine and develop a comprehensive testing plan that addresses validations for all data within the data warehouse
  • CollaborationWork closely with data engineers, cloud architects, and other stakeholders to ensure seamless integration and validation of data
  • Quality AssuranceEstablish and maintain quality assurance standards and best practices for data validation and testing
  • ReportingGenerate detailed reports on testing outcomes, data inconsistencies, and corrective actions
  • Continuous ImprovementContinuously evaluate and improve testing processes and tools to enhance efficiency and effectiveness
  • 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
  •  
  • Bachelor degree or above education
  • Leadership Experience6+ years as a testing lead in Data Warehousing or Cloud Data Migration projects
  • Automation ToolsExperience with data validation through custom built python frameworks and testing automation tools
  • Testing MethodologiesProficiency in defining and implementing testing methodologies and frameworks for data validation
  • Technical ExpertiseSolid knowledge of Python, SQL Server, Azure Cloud data tools (ADF, SHIR, Logic Apps, ADLS Gen2, Blob Storage), Databricks, and Snowflake
  • Analytical
    Skills:
  • Proven excellent analytical and problem-solving skills to identify and resolve data inconsistencies
  • CommunicationProven solid communication skills to collaborate effectively with cross-functional teams
  • Project ManagementDemonstrated ability to manage multiple tasks and projects simultaneously, ensuring timely delivery of testing outcomes
  •  Preferred Qualifications
  •  
  • Experience in leading data validation testing efforts in cloud migration projects
  • Familiarity with Agile methodologies and project management tools
  • 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.

    • Job Classification

    Industry: Retail
    Functional Area / Department: Engineering - Software & QA
    Role Category: DBA / Data warehousing
    Role: Data warehouse Architect / Consultant
    Employement Type: Full time

    Contact Details:

    Company: Optum
    Location(s): Hyderabad

    + View Contact

    Keyskills:   snowflake python data warehousing azure cloud sql server project management advisory services data validation blob storage cloud migration azure logic apps adls gen2 data bricks oracle adf cloud data migration validation testing agile methodology

     Fraud Alert to job seekers!

    ₹ Not Disclosed

    Similar positions

    Staff Consultant

    • Oracle
    • 0 - 8 years
    • Kolkata
    • 1 day ago
    ₹ Not Disclosed

    Lead Administrator - L1

    • Wipro
    • 4 - 8 years
    • Hyderabad
    • 1 day ago
    ₹ Not Disclosed

    Staff Consultant - OFSAA

    • Oracle
    • 0 - 8 years
    • Kolkata
    • 2 days ago
    ₹ Not Disclosed

    Application Database Administrator-NoSQL Cloud Databases

    • IBM
    • 3 - 7 years
    • Mumbai
    • 3 days ago
    ₹ Not Disclosed

    Optum

    About: OptumInsight India Pvt Ltd, a UnitedHealth group company is a leading health services and innovation company dedicated to help make the health system work better for everyone. With more than 115,000 people worldwide, Optum combines technology, data and expertise to improve the delivery, ...

    IndigoJobs © 2025

    For enquiries: contact(at)indigojobs.in

    We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in