Monali malode

Monali malode

ETL / Database / BI Test Engineer
India
Marathi, English, Hindi
Full-time Hybrid

About Me

Quality Assurance professional with 3+ years of experience in ETL, Database, and BI Testing across Pharmaceutical, and Banking domains. Skilled in Test Planning, Test Design, Execution, and Defect Management across the f…

Experience

Software Test Engineer

Roche · Pune , Maharashtra , India
Jun 2025 - Present · 1 year 4 months

<p>Understood the requirements and gathered project information.</p><p> Prepared required SQL scripts as input to the utility.</p><p> Developed and executed test scripts; validated and compared big data.</p><p> Verified and ensured data checks between Oracle and AWS.</p><p> Analysed test results and reported updates to the Test Manager/Testing Team.</p><p> Analysed and identified test cases based on the application's requirement document.</p><p> Verified data was mapped correctly from source to target system, and that null fields were not incorrectly populated.</p><p> Verified data was neither garbled nor truncated, and that data type/format in the target system matched expectations.</p><p> Verified there was no duplication of data in the target system, and that transformations were applied correctly.</p><p> Verified exception handling was robust; performed reconciliation checks between staging and target table record counts after applying filter rules.</p><p> Executed test cases in build cycles and validated impact.</p><p> Performed Smoke, Functional, Compatibility, and User Interface testing.</p>

Software Test Engineer

Tech Mahindra · Pune, India
Jul 2023 - Present · 3 years 4 months

<p>Worked on assigned stories detailing ETL test tasks to be performed by Dev and QA.</p><p> Tasks performed on Oracle / MS SQL / GCP.</p><p> Understood and analysed SRS/Mapping documents to ensure they met customer requirements.</p><p> Responsible for Test Case Writing, Execution, Bug Tracking and Reporting.</p><p> Gathered required documents to prepare test plans and test cases for ETL workflows.</p><p> Prepared SQL queries based on source-to-target mapping sheets.</p><p> Created and executed SQL queries to perform source-to-target testing on Oracle/GCP databases, validating Data Completeness, Validity, Uniqueness, Integrity, Transformation, and Quality.</p><p> Compared data between Source-to-Staging and Staging-to-Target layers.</p><p> Verified and analysed results against target tables, identifying and logging discrepancies.</p><p> Performed regression and reconciliation testing after each ETL release cycle.</p><p> Consolidated analysed reports and communicated results to the test lead.</p>

Skills

SQL Python Tableau Beyond Compare PySpark WinSCP JIRA ADO GCP AWS Oracle 9i/10g/11g SQL Server 2008 SQL Developer SSMS DBeaver BigQuery Athena Windows 7/11 UNIX ETL Testing Database Testing BI Testing Test Planning Test Design Test Execution Defect Management SDLC STLC OLTP OLAP Star Schema Snowflake Schema Functional Testing Regression Testing Manual Testing Agile SIT Smoke Testing Compatibility Testing User Interface Testing Reconciliation Testing
Report this Profile?