ETL Test Analyst

Are you a detail-oriented software testing professional eager to make an impact in the world of data and analytics? Our Validation teams are growing in India, and with big ambitions and a clear vision for the future, now is the time to join Clario as a ETL Test Analyst.

What we offer

• Competitive compensation + shift allowances
• Attractive benefits (security, flexibility, support and well-being)
• Engaging employee programs
• Technology for hybrid working and great onsite facilities

What you'll be doing

Actively participates in the testing of new Clario products by:

• Developing test cases and study data
• Conducting testing for general testing
• Conducting testing for eClinical Services development tools
• Reporting testing and review anomalies, as appropriate, to the department head

Actively participates in post-production product release testing by:

• Developing test cases
• Conducting regression and bug fix testing
• Conducting regression and bug fix testing for eClinical Services development tools
• Reporting testing and review anomalies, as appropriate, to the department head

Actively participates in peripheral software testing by:

• Developing system test use cases and study data
• Conducting system testing of the software
• Reporting testing and review anomalies, as appropriate, to the department head.
• Exploring new opportunities to add value to organization and departmental processes.
• Attending and participating in applicable company-sponsored training
• Reading, understanding, and adhering to organizational Standard Operating Procedures (SOPs)
• Establishing and enforcing departmental standards
• Exploring new opportunities to add value to organization and departmental processes.
• Helping others to accomplish results.
• Performing other duties as assigned
• Attending and participating in applicable company sponsored training.
• Attending educational workshops and reviewing professional publications
• Benchmarking state-of-the-art practices
• Participating in professional societies
• Keeping informed of changes in the regulatory environment and/or regulatory requirements.

What we look for

• Good exposure of Software Testing methodologies, implementation of Data Lakes, Data Warehouse/ETL projects, Big Data projects in On-Premises & Cloud Environments
• Experience in writing complex SQL queries and experience with any data visualization tool is preferable e.g., Tableau, Power BI.
• Experienced in ETL tools like Informatica Power Center, SAAS, PL-SQL
• Ability to write SQL queries to conduct data validations and probe quality issues with data.
• Experience in Project Delivery Methodologies: SDLC, Iterative, Agile, Scrum, Kanban
• Knowledge in ALM Tools like JIRA, TFS (Azure Devops) & Confluence.
• Knowledge on data quality fundamentals and data governance concepts.
• Experienced in ETL tools like Informatica Power Center, SAAS, PL-SQL.
• Experienced in BI tools like Tableau, MS Power BI, QlikView, SAP BO.
• Hands-on experience with all levels of testing includes Smoke Testing, Integration Testing, System Testing and Regression Testing.
• Knowledge of PL-SQL, PySpark & SQL, on framing and tuning the Queries so that it covers all the data scenarios.
• Accountable for high quality and on time delivery for task assigned.

At Clario, we put people first, always. We are united and driven by patients, committed to making a difference, and we are always looking for the best talent to help us transform lives. We value the contribution each of our people brings. It’s only through our people that we can continue to innovate technology that will shape the future of clinical trials.