Data QA/etl Tester

**Location**:India, Remote (Work from Anywhere in India) **Minimum Qualification**:B. Tech. (or equivalent) from an accredited institution **Indicative Experience**:5+ Years **Domain**:Preferably in Life-sciences / Pharma. **Customer Profile**:Captive research and development pods for a $ 500 million group of pharma data research companies that help patients gain access to life-saving therapies. We help our clients navigate the complexities at each step of the drug development life cycle, from pipeline to patient. **Other benefits**:Health Insurance, Provident Fund, Life Insurance, Reimbursement of Certification Expenses, Gratuity, 24x7 Health Desk **About the Company** We are headquartered in Pittsburgh in USA with locations across the globe we are a team of thoughtful experts driven by the power of our client's unique ideas. We also have micro offices in Hyderabad, Chennai, Bengaluru, and Delhi NCR in India. While technical expertise is ingrained into Agilite's DNA, we are more than just engineers and developers '” we are trusted product strategists. We pride ourselves on being a ready resource for critical market insights with the knowledge and experience required to design, build and scale big ideas to serve our growing list of customers in the USA and Europe. Our preferred working model is "Work from Anywhere" (WFA). In addition, you can also decide on your work timings: All we need is the outcome. Our people-centric culture is built on the belief that extraordinary employees create amazing things. Work with us and attain your Ikigai in a place where your aspirations and business objectives intersect **Job Summary**: ETL tester who should be strong in SQL & python. Should have 5+ years' experience in ETL testing/DWH/Database testing. Working experience in ETL testing including Data Completeness and Data Quality for various data feeds coming from the source. Good knowledge of Data Warehousing concepts & Data Modelling Well-versed with relational databases, non relational databases, data streams, and file stores. Must have good hands-on experience in creating/executing Stored Procedures, Functions, Tables, Views & Cursors. Should know about working of Joins, Subqueries, CTEs and complex query writing skills. Experience in ETL testing tools: SSIS/Informatica Experience in testing of BI reports-Power-BI/Tableau Experienced in structured test methods and processes. Valuable experience in Azure Data Factory, Azure Synapse, Azure Databricks, and Azure SQL DB and Snowflake. Good hands-on exp. on CI/CD pipeline (Azure DevOps) to move test code to a higher environment and have knowledge of Pipelines to run the notebooks via pipeline. Experience in Agile methodologies and DevOps would be an added advantage. Must have excellent interpersonal and communication skills, both written and oral. Works as part of the technology team to drive quality in the organization to deliver high-quality products and services to our clients. Prepare the testing plans and create the automation test scripts to verify and validate the quality of the product. Must be able to function effectively in a high volume, rapid delivery agile environment. Using left shift and lean methodologies. **Responsibilities**: Experience analyzing project requirements and Discuss User Requirements with PO/Business Analysts. Experience in testing of ETL Mappings to extract data from multiple sources like SQL Server, Flat files etc. into target tables using transformations. Support business data validation & user interface testing good knowledge in validating the delta, and full loads. Experience in analyzing the Source to Target Mapping Document Authoring ETL test scenarios & test cases, Test Scripts Understand the business Rules which involves in each layer. Routers, Lookups, Source Qualifiers, Aggregators, Filters, and Joiners etc. Well-versed in using Test Case Management/Defect Management tool - Test Link, JIRA. Load, manage and track test cases in our test management tool JIRA. Good knowledge of ETL Concepts, SQL, Tools, and best practices. Creating and/or reviewing Test Scripts Managing SQA testing issue documentation & resolution Summarizing the results of the Testing Experience in Monitoring the WF Jobs and analyzing the WF failure Errors. Logging Service Requests Ability to work independently. Works as part of the technology team to drive quality in the organization to deliver high-quality products and services to our clients. Prepare the testing plans and create the automation test scripts to verify and validate the quality of the product. Must be able to function effectively in a high volume, rapid delivery agile environment. Using left shift and lean methodologies **Competencies (mandatory)** Experience with JIRA and Azure DevOps Board. Familiarity with the SAFe Agile framework **Skill Set Required**: Strong SQL knowledge Python for Automation Manual / Functional testing Database - MS S