MMIS Quality Assurance

Daily Duties / Responsibilities:

Responsible for performing tests on technical solutions to isolate and solve issues. Initiates

tests, analyzes results, and finds solutions to technical problems

• Develop test strategies and detailed test cases to validate data pipelines and

transformations.

• Create automated test scripts using Python for ETL processes.

• Write advanced SQL queries for data profiling, validation, and debugging across various

platforms (e.g., SQL Server, Oracle).

• Automate ETL validation processes using Python and Pytest frameworks.

• Conduct Web UI automation using Selenium for front-end validation of data-driven

applications.

• Implement REST API test automation to validate microservices and data ingestion

endpoints.

• Work closely with data engineers, analysts, and business users to clarify requirements

and understand data flows.

• Perform regression testing of ETL jobs during enhancements or maintenance cycles.

• Build reusable Python-based test frameworks to automate ETL testing.

• Integrate test automation into CI/CD pipelines.

• Validate performance benchmarks and ensure ETL jobs scale with data volume.

• Document test results, defects, and communicate findings effectively.

• Work with tools such as Apache Airflow, Prefect, or similar orchestration platforms (a

plus).

• Use Git for source control and tools like JIRA or Azure DevOps for test case and defect

management.



Required Skills:

• 3+ years translating business requirements or policy documentation into test cases and

scenarios.

• 3+ years building test cases and scenarios into test systems

• 5+ years Automating ETL validation processes using Python and Pytest frameworks

• 5+ years Creating automated test scripts using Python for ETL processes.

• 3+ years Writing advanced SQL queries for data profiling, validation, and debugging

across various platforms (e.g., SQL Server, Oracle).

• 1+ year Conducting Web UI automation using Selenium for front-end validation of data-

driven applications.


Preferred Skills:

• Integrate test automation into CI/CD pipelines.

• 5+ years large enterprise or e-business systems experience.