Validate ETL workflows and perform source-to-target data validation. Design and execute test cases, write complex SQL to verify transformations, log defects, support UAT/production validation, and collaborate with engineers and analysts to ensure data quality.
Beghou brings over three decades of experience helping life sciences companies optimize their commercialization through strategic insight, advanced analytics, and technology. From developing go-to-market strategies and building foundational data analytics infrastructures to leveraging artificial intelligence to improve customer insights and engagement, Beghou helps life sciences companies maximize performance across their portfolios. Beghou also deploys proprietary and third-party technology solutions to help companies forecast performance, design territories, manage customer data, organize, and report on medical and commercial data, and more. Headquartered in Evanston, Illinois, we have 10 global offices.
Our mission is to bring together analytical minds and innovative technology to help life sciences companies navigate the complexity of health care and improve patient outcomes.
Purpose of Job:
As an ETL Tester, you will play a critical role in ensuring the accuracy, consistency, and reliability of data as it moves through our ETL pipelines — from extraction and transformation through to loading into the data warehouse. You'll be responsible for designing test scenarios, executing source-to-target validations, and writing advanced SQL queries (joins, subqueries, window functions, aggregations) to catch data quality issues such as duplicates, nulls, and referential integrity gaps before they reach production. Working within an Agile team, you'll partner with data engineers, and business analysts to validate transformation logic and business rules, support UAT and production validation, and track defects through tools like Jira or Azure DevOps or GitHub. This role is ideal for someone with 3–5 years of ETL/DW testing experience who thrives on precision, enjoys solving data puzzles, and wants to grow into cloud, Big Data, or automation-driven testing.
We'll trust you to:
- Validate ETL workflows (Extract, Transform, Load).
- Create and execute test cases and test scenarios.
- Perform source-to-target data validation.
- Write complex SQL queries to verify data accuracy.
- Test data transformation rules and business logic.
- Perform functional, regression, integration, and data quality testing.
- Log and track defects using tools like Jira or Azure DevOps or GitHub.
- Work closely with ETL developers, data engineers, and business analysts.
- Support UAT and production validation.
You'll need to have:
- Strong SQL (joins, subqueries, window functions, aggregations)
- ETL testing concepts
- Data Warehouse concepts (Fact & Dimension tables, Star/Snowflake schema)
- Working experience with Databricks, or Snowflake
- Unix/Linux commands
- Defect tracking tools (Jira, Azure DevOps, GitHub)
- Knowledge of Agile/Scrum methodology
- Basic understanding of APIs and automation is an added advantage.
- 3–5 years in ETL/Data Warehouse testing
- Python or PySpark
- Cloud platforms (Azure, AWS, GCP)
- CI/CD tools (Jenkins, Git)
- Big Data testing (Hive, Hadoop, Spark)
Nice-to-Have Skills
At Beghou Consulting, you'll join a highly collaborative, values-driven team where technical excellence, analytical rigor, and personal growth converge. Whether you're passionate about AI innovation, building commercialization strategies, or shaping the next generation of data-first solutions in life sciences, this is a place to make an impact!
Beghou Consulting Hyderabad, Telangana, IND Office
Telangana, Hyderabad, India, 500081
Similar Jobs
Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
Leads the strategy, architecture, delivery, and operationalization of agentic AI solutions in enterprise healthcare environments. Manages engineering teams building LLM workflows, copilots, intelligent automation, and integrated AI platforms. Responsibilities include cloud architecture, secure deployment, AI evaluation, stakeholder alignment, delivery planning, technical governance, executive communication, and coaching engineering leaders. The role also drives scalable engineering practices and production-ready solutions across marketing technology deployments.
Top Skills:
Adobe Experience PlatformAPIsAzureData PlatformsInfrastructure As CodeLlmsMachine LearningNextjsReact
Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
Leads a team of AI engineers while designing, deploying, monitoring, and optimizing agentic AI systems and AI-driven developer lifecycle tools. Oversees production delivery, team development, PI planning, resource forecasting, roadmaps, stakeholder collaboration, and healthcare provider platform enhancements. The role requires hands-on expertise with agent orchestration, LLM platforms, observability, performance tuning, and AI-enabled SDLC automation, along with strong leadership and delivery management.
Top Skills:
Adk ToolkitsAgentic ArchitecturesAIAi Developer Lifecycle FrameworksAi System ObservabilityAnthropicClaudeCopilotGeminiLlmsMcp ServersOpenai
Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
Leads enterprise AI/ML and Generative AI engineering strategy, architecture, delivery, MLOps, governance, and production deployment. Builds and mentors engineering teams, drives LLM, AI agent, predictive analytics, and automation initiatives, evaluates emerging technologies, and partners with business, product, architecture, and technology stakeholders to deliver secure, responsible AI solutions in a healthcare technology environment.
Top Skills:
Ai AgentsAWSAzureAzure OpenaiDatabricksGCPGenerative AiLangchainLarge Language Models (Llms)MlflowMlopsPythonRag ArchitecturesSemantic Kernel
What you need to know about the Hyderabad Tech Scene
Because of its proximity to leading research institutions and a government committed to the city's growth, Hyderabad's tech scene is booming. With plans to establish India's first "AI city," the city is on track to become one of the world's most anticipated tech hubs, with companies like TransUnion, Schrödinger and Freshworks, among others, already calling the city home.
