ETL Tester

ETL Tester

Experience- 4+ Yrs

Relevant Experience: 3 to 6 years

Location- Pune

Budget- open

Work mode - Hybrid/WFH

Notice period - Immediate (currently not working)

Archimedis helps clients manage operational, technological, and regulatory risk to enhance enterprise value Our growing practice is helping clients manage their enterprise -wide business, technology and regulatory risks and compliance on a sustained basis. We use proprietary tools, technologies and accelerators to allow clients a more proactive approach to managing risk and achieving regulatory compliance. We design comprehensive compliance programs.

The Team

At Archimedis, we're changing how we develop and deliver our next-generation Digital services and technology products. Our capabilities include designing the target operating model, assessing policies and procedures, testing and monitoring on a managed services and project basis, assessing risk, reporting and communicating, as well as building the analytics and reporting structures to allow for ongoing measurement and monitoring.

ETL Tester

1. Develop and execute test plans, test cases, and test scripts to validate ETL processes, data transformations, and data migrations in compliance with GxP regulations and industry standards.

2. Perform functional, regression, and integration testing of ETL workflows, ensuring proper data extraction, cleansing, transformation, and loading across various data sources and targets.

3. Collaborate with business analysts, data engineers, and stakeholders to understand project requirements, data mappings, and business rules governing ETL processes.

4. Design and implement automated ETL test suites using testing frameworks and tools, and maintain regression test suites for ongoing validation of ETL pipelines.

5. Conduct data profiling and data quality assessments to identify anomalies, discrepancies, and data integrity issues, and work with data stewards to resolve data quality issues.

6. Document and report test results, defects, and validation findings using standardized reporting templates and issue tracking systems, and communicate findings to project stakeholders.

7. Ensure compliance with regulatory requirements, including GxP, FDA regulations, and other relevant industry standards for data integrity, traceability, and auditability.

8. Participate in validation activities, including validation planning, validation execution, and documentation of validation deliverables in accordance with regulatory guidelines and company SOPs. 

9. Stay informed about industry trends, best practices, and emerging technologies in ETL testing and GxP compliance, and apply this knowledge to enhance testing methodologies and processes.

10. Contribute to process improvements, quality initiatives, and knowledge sharing activities within the testing team and across project teams, fostering a culture of continuous improvement and excellence.

11. AWS, Data bricks knowledge is essential

12 Python program skill is required to automate ETL validations

Tech stack backround: AWS, Python, SQL, Snowflake, S3

How you will grow

At Archimedis, we have invested a great deal to create a rich environment in which our professionals can grow. We want all our people to develop in their own way, playing to their own strengths as they hone their leadership skills. And, as a part of our efforts, we provide our professionals with a variety of learning and networking opportunities—including exposure to leaders, sponsors, coaches, and challenging assignments—to help accelerate their careers along the way. No two people learn in exactly the same way. So, we provide a range of resources, including live classrooms, team-based learning, and eLearning.