Ivan Warnakulasooriya

Led automation of ETL and data validation test cases using Python, PyCharm, PyTest, and Pandas, significantly improving test coverage and reducing manual testing effort. Developed dynamic HTML-based test reports and created SQL stored procedures to support ETL workflows.

Designed and implemented 100+ Data Quality rules in Ataccama ONE using SQL-based logic, covering null checks, pattern validations, and threshold comparisons. Configured monitoring projects and integrated with Airflow for orchestration.

Translated business requirements into MDM rules for Study, Site, and Investigator domains, ensuring alignment with Data Foundation MDM Cross-Functional Standards. Configured match/merge rules in Ataccama MDM and validated golden record accuracy through survivorship testing.

Wrote and optimized complex SQL queries to validate data transformations, aggregations, and business rules. Performed data profiling and validated ETL mappings, error handling, and data warehouse concepts.

Vast experience on Master Data Management (MDM) Testing with profound knowledge in various MDM tools like Informatica, IBM MDM, IBM Initiate, Reltio. Created numerous Automation Utilities to reduce manual testing effort in HP-UFT, Selenium and Python.

Business Analyst/Data Analyst on Big Data platform project utilizing Spark and associated technologies for client experience analytics, utilizing agile practices to deliver. Responsible for requirement gathering, reviewing, Documenting for Mastering Data(MDM).

QA Deployment Lead responsible for deployment plan night of release and execution of plan. Performed database testing to ensure the ETL process for data extracted from Data Lake, transformed and loaded into target database.

Analyzed requirements from the client and developed test cases based on functional requirements, general requirements and system specifications. Prepared test data for positive and negative test scenarios for Functional Testing.

Designed and created test plan, test scenarios and test cases for Data warehouse and ETL testing. Responsible to translate business requirements into quality assurance test cases.

Associate Degree in Electronic Science from DBTC, Sri Lanka.