Data QA-ETL Tester

1 week ago

Delhi, India Norstella Full time
About Norstella
At Norstella, our mission is simple: to help our clients bring life-saving therapies to market quicker—and help patients in need.
Founded in 2022, but with history going back to 1939, Norstella unites best-in-class brands to help clients navigate the complexities at each step of the drug development life cycle —and get the right treatments to the right patients at the right time.
Each organization (Citeline, Evaluate, MMIT, Panalgo, The Dedham Group) delivers must-have answers for critical strategic and commercial decision-making. Together, via our market-leading brands, we help our clients:
Citeline – accelerate the drug development cycle
Evaluate – bring the right drugs to market
MMIT – identify barrier to patient access
Panalgo – turn data into insight faster
The Dedham Group – think strategically for specialty therapeutics
By combining the efforts of each organization under Norstella, we can offer an even wider breadth of expertise, cutting-edge data solutions and expert advisory services alongside advanced technologies such as real-world data, machine learning and predictive analytics. As one of the largest global pharma intelligence solution providers, Norstella has a footprint across the globe with teams of experts delivering world class solutions in the USA, UK, The Netherlands, Japan, China and India.
Responsibilities:
• Works as part of the technology team to drive quality in the organization by delivering high-quality products and services to our clients.
• Prepare test plans and create automation test scripts to verify and validate the quality of the product.
• Analyze & understand project requirements and discuss requirements with PO/Business Analysts.
• Willing to ask questions and push back when something is not right.
• Test ETL Mappings to extract data from multiple sources like SQL Server, Flat files, etc., into target tables using transformations.
• Analyze the Source to Target Mapping Documents
• Author ETL test scenarios, cases, and scripts.
• Handle defects as they arise, entering and following through to completion.
Experience
• 5+ years' experience in ETL DWH/Database testing.
• Strong SQL & python skills, including joins, subqueries, CTEs, and writing complex queries.
• Hands-on experience in testing Data Completeness and Quality for various data feeds.
• Conceptual knowledge of Cloud Data Warehousing concepts and Data modeling.
• Well-versed with relational databases, nonrelational databases, data streams, and file stores. Experienced in structured test methods and processes.
• Strong experience creating/executing Stored Procedures, Functions, Tables, Views & Cursors.
• Experience in AWS(ECS, Lambda, API Gateway, S3, RDS, Athena, Glue, Airflow, RedShift).
Understand and implement testing across CI/CD pipeline (Azure DevOps) to move test code to a higher environment.
• Mandatory to have Python, Pytest, Pyspark
• Good to know the programming languages like Ruby,Java
• Legacy applications – Mongo Db , Apache Cassandra.
• Have worked in Agile Environments. Experience in Monitoring the WF Jobs and analyzing the WF failure Errors.
• Familiarity with QA tools like JIRA, TestRail, or Azure.
• Experience with version control systems (e.g., Git).
Skill Set
• Cloud Data Warehousing Concepts
• Data Pipelines & Data Modelling
• Python, Pytest, Pyspark
• AWS (ECS, Lambda, API Gateway, S3, RDA)
• AWS (Glue, Airflow, Redshift)
• RDBMS , Advanced SQL (including joins, subqueries, CTEs and writing complex queries)
• Data Quality Testing with SQL & orchestrated SQL testing
• Scripted ETL Testing (Data Completeness and Quality for various data feeds)
• AWS Devops CI/CD
Soft Skills
• Must have excellent interpersonal and communication skills, both written and oral.
• Must be able to function effectively in a high volume, rapid delivery agile environment.
• Work in a team setting.
• Take coaching and advice to heart.
The guiding principles for success at Norstella:
01: Bold, Passionate, Mission-First
We have a lofty mission to Smooth Access to Life Saving Therapies and we will get there by being bold and passionate about the mission and our clients. Our clients and the mission in what we are trying to accomplish must be in the forefront of our minds in everything we do.
02: Integrity, Truth, Reality
We make promises that we can keep, and goals that push us to new heights. Our integrity offers us the opportunity to learn and improve by being honest about what works and what doesn’t. By being true to the data and producing realistic metrics, we are able to create plans and resources to achieve our goals.
03: Kindness, Empathy, Grace
We will empathize with everyone's situation, provide positive and constructive feedback with kindness, and accept opportunities for improvement with grace and gratitude. We use this principle across the organization to collaborate and build lines of open communication.
04: Resilience, Mettle, Perseverance
We will persevere – even in difficult and challenging situations. Our ability to recover from missteps and failures in a positive way will help us to be successful in our mission.
05: Humility, Gratitude, Learning
We will be true learners by showing humility and gratitude in our work. We recognize that the smartest person in the room is the one who is always listening, learning, and willing to shift their thinking.
Benefits:
Health Insurance
Provident Fund
Reimbursement of Certification Expenses
Gratuity
24x7 Health Desk
Norstella is an equal opportunities employer and does not discriminate on the grounds of gender, sexual orientation, marital or civil partner status, pregnancy or maternity, gender reassignment, race, color, nationality, ethnic or national origin, religion or belief, disability or age. Our ethos is to respect and value people’s differences, to help everyone achieve more at work as well as in their personal lives so that they feel proud of the part they play in our success. We believe that all decisions about people at work should be based on the individual’s abilities, skills, performance and behavior and our business requirements. Norstella operates a zero tolerance policy to any form of discrimination, abuse or harassment.
Sometimes the best opportunities are hidden by self-doubt. We disqualify ourselves before we have the opportunity to be considered. Regardless of where you came from, how you identify, or the path that led you here- you are welcome. If you read this job description and feel passion and excitement, we’re just as excited about you.

  • Database and ETL Tester

    6 days ago

    Delhi, Delhi, India DigitalXNode Full time

    About the Role:We are looking for an experienced DB/ETL Tester to join our team at DigitalXNode. As a key member of our data quality assurance team, you will be responsible for ensuring the accuracy and consistency of our data-intensive applications.Key Responsibilities:Design and execute comprehensive test cases for database and ETL processes.Perform data...

  • ETL Tester

    1 month ago

    delhi, India True Tech Professionals Full time

    Notice Period: Only 15 days or less will be considered ETL Tester Experience : 5+ years Location : Remote (But would be required to visit office occsionally when required) Job Description We are seeking a skilled Data Tester to ensure the accuracy, integrity, and consistency of data across data warehouses, integrations, and curated business-ready layers....

  • ETL Tester

    1 month ago

    delhi, India Truelancer.com Full time

    Job Title: Senior ETL QA Experience: 8-12 yrs Must Have Skills: Performance Testing, snowflake, Automation, Comprehensive ETL Testing, Documentation Skills, Talend, Regulatory Compliance, Data Masking, sql, Python Primary Skillsets: Comprehensive ETL Testing Performance Testing Data Masking SQL Snowflake - Optimization Responsibilities: We are seeking...

  • ETL Tester

    1 month ago

    Delhi, India Truelancer.com Full time

    Job Title: Senior ETL QAExperience: 8-12 yrsMust Have Skills: Performance Testing, snowflake, Automation, Comprehensive ETL Testing, Documentation Skills, Talend, Regulatory Compliance, Data Masking, sql, PythonPrimary Skillsets:- Comprehensive ETL Testing- Performance Testing- Data Masking- SQL- Snowflake - OptimizationResponsibilities:We are seeking a...

  • ETL Tester

    1 month ago

    Delhi, India True Tech Professionals Full time

    Notice Period: Only 15 days or less will be consideredETL TesterExperience : 5+ yearsLocation : Remote (But would be required to visit office occsionally when required)Job DescriptionWe are seeking a skilled Data Tester to ensure the accuracy, integrity, and consistency of data across data warehouses, integrations, and curated business-ready layers. This...

  • ETL Tester

    1 month ago

    delhi, India True Tech Professionals Full time

    Notice Period: Only 15 days or less will be consideredETL TesterExperience : 5+ yearsLocation : Remote (But would be required to visit office occsionally when required)Job DescriptionWe are seeking a skilled Data Tester to ensure the accuracy, integrity, and consistency of data across data warehouses, integrations, and curated business-ready layers. This...

  • ETL Tester

    3 weeks ago

    Delhi, India Truelancer.com Full time

    Job Title: Senior ETL QA Experience: 8-12 yrsMust Have Skills: Performance Testing, snowflake, Automation, Comprehensive ETL Testing, Documentation Skills, Talend, Regulatory Compliance, Data Masking, sql, PythonPrimary Skillsets:Comprehensive ETL TestingPerformance TestingData MaskingSQLSnowflake - OptimizationResponsibilities:We are seeking a...

  • Etl tester

    1 month ago

    Delhi, India Truelancer.com Full time

    Job Title: Senior ETL QAExperience: 8-12 yrsMust Have Skills: Performance Testing, snowflake, Automation, Comprehensive ETL Testing, Documentation Skills, Talend, Regulatory Compliance, Data Masking, sql, PythonPrimary Skillsets:Comprehensive ETL TestingPerformance TestingData MaskingSQLSnowflake - OptimizationResponsibilities:We are seeking a highly...

  • ETL Tester

    4 weeks ago

    Delhi, India Truelancer.com Full time

    Job Title: Senior ETL QAExperience: 8-12 yrsMust Have Skills: Performance Testing, snowflake, Automation, Comprehensive ETL Testing, Documentation Skills, Talend, Regulatory Compliance, Data Masking, sql, PythonPrimary Skillsets:Comprehensive ETL TestingPerformance TestingData MaskingSQLSnowflake - OptimizationResponsibilities:We are seeking a highly...

  • ETL Data Quality Expert

    6 days ago

    Delhi, Delhi, India GAIUS HYPERLOCAL PRIVATE LIMITED Full time

    **Job Opportunity:** ETL Data Tester**About the Role:Duration: 6 monthsLocation: RemoteTimings: Full Time (As per company timings)Notice Period: Immediate Joiner PreferredExperience: 5+ YearsJoin us at GAIUS HYPERLOCAL PRIVATE LIMITED as an ETL Data Tester and take advantage of our exciting work-from-home opportunity.This role involves selecting and...

  • Etl Tester

    2 months ago

    Delhi, India Talentmatics Full time

    ETL Tester - Python, Databricks, Advance SQLLocation Hybrid : Chennai/KolkataExperience : 5 to 12 yearsETL Tester:As an ETL Test Engineer, you will be responsible for both manual and automated testing to validate data sources, extract data, apply transformation logic, and load data into target tables. You'll work closely with data engineering teams to ensure...

  • Data QA-ETL Tester

    5 days ago

    Delhi, India Norstella Full time

    About NorstellaAt Norstella, our mission is simple: to help our clients bring life-saving therapies to market quicker—and help patients in need.Founded in 2022, but with history going back to 1939, Norstella unites best-in-class brands to help clients navigate the complexities at each step of the drug development life cycle —and get the right treatments...

  • Data qa-etl tester

    1 week ago

    Delhi, India Norstella Full time

    About NorstellaAt Norstella, our mission is simple: to help our clients bring life-saving therapies to market quicker—and help patients in need.Founded in 2022, but with history going back to 1939, Norstella unites best-in-class brands to help clients navigate the complexities at each step of the drug development life cycle —and get the right treatments...

  • ETL Tester

    1 month ago

    delhi, India True Tech Professionals Full time

    Notice Period: Only 15 days or less will be consideredETL TesterExperience : 5+ yearsLocation : Remote (But would be required to visit office occsionally when required)Job DescriptionWe are seeking a skilledData Testerto ensure the accuracy, integrity, and consistency of data across data warehouses, integrations, and curated business-ready layers. This is a...

  • QA Tester

    7 months ago

    Delhi, India Arramton Infotech Private Limited Full time

    **Job Title: QA Tester (Quality Assurance Tester)** We are seeking a detail-oriented and dedicated QA Tester to join our dynamic team. As a QA Tester, you will play a crucial role in ensuring the quality and functionality of our software products. You will work closely with developers, product managers, and other team members to identify, report, and track...

  • Talentmatics | ETL Tester | delhi

    4 weeks ago

    delhi, India Talentmatics Full time

    ETL Tester - Python, Databricks, Advance SQL Location Hybrid : Chennai/Kolkata Experience : 5 to 12 years ETL Tester: As an ETL Test Engineer, you will be responsible for both manual and automated testing to validate data sources, extract data, apply transformation logic, and load data into target tables. You'll work closely with data engineering teams to...

  • ETL Tester

    1 month ago

    Delhi, India True Tech Professionals Full time

    Notice Period: Only 15 days or less will be consideredETL TesterExperience : 5+ yearsLocation : Remote (But would be required to visit office occsionally when required)Job DescriptionWe are seeking a skilledData Testerto ensure the accuracy, integrity, and consistency of data across data warehouses, integrations, and curated business-ready layers. This is a...

  • QA Tester

    7 months ago

    Delhi, Delhi, India Mobineers Info System Pvt. Ltd Full time

    Should be expertise on Android mobile app Testing and IOS. - Design and implement data visualization dashboards and reports to communicate insights and findings effectively. - Identify opportunities for process improvement and automation to enhance data quality and efficiency. - Stay current with industry trends and best practices in data analysis,...

  • Sr. etl qa

    2 weeks ago

    Delhi, India Truelancer.com Full time

    Job Title: Senior ETL QA Experience: 8-12 yrsMust Have Skills: Performance Testing, snowflake, Automation, Comprehensive ETL Testing, Documentation Skills, Talend, Regulatory Compliance, Data Masking, sql, PythonPrimary Skillsets:Comprehensive ETL TestingPerformance TestingData MaskingSQLSnowflakeResponsibilities:We are seeking a highly skilled and...

  • Sr. etl qa

    4 weeks ago

    Delhi, India Truelancer.com Full time

    Job Title: Senior ETL QAExperience: 8-12 yrsMust Have Skills: Performance Testing, snowflake, Automation, Comprehensive ETL Testing, Documentation Skills, Talend, Regulatory Compliance, Data Masking, sql, PythonPrimary Skillsets:Comprehensive ETL TestingPerformance TestingData MaskingSQLSnowflakeResponsibilities:We are seeking a highly skilled and...