Software Engineer - PERSISTENT SYSTEMS
(2024-07)
Software Engineer - POINTEL TECHOLOGY & SOLUTION
(2018-01 - 2024-06)
ETL Tester - Monument
(2024-07)
Participated in end-to-end ETL testing for Monument Banking's data migration and reporting project leveraging AWS Cloud technologies.
- Designed and executed SQL queries in AWS Redshift to validate data transformations, aggregations, and load logic across staging and target layers.
- Utilized AWS AppFlow to automate, monitor, and validate data ingestion from multiple source systems into Redshift staging tables.
- Worked with AWS Glue jobs to transform and load validated data from staging to target tables, ensuring data accuracy, consistency, and quality.
- Performed file-level validation and reconciliation using data stored in Amazon S3, both before and after ingestion.
- Used Apache Airflow to schedule, orchestrate, and monitor ETL workflows between S3 and Redshift.
- Collaborated closely with data engineers and business analysts to investigate data discrepancies and optimize ETL processes.
- Managed test cases, defect reporting, and data validation documentation, ensuring traceability and compliance with banking data standards.
- Supported EC2 instances for executing testing tools, scripts, and configuring connectivity to AWS data services.
- Developed a Python utility using Pandas and AWS connectivity to validate and compare data between S3 files and Redshift tables.
ETL Tester - Houlihan Lokey
(2021-02 - 2023-03)
- Analyzed project requirements and validated source, staging, and target data across the ETL lifecycle.
- Developed and executed SQL-based test cases using subqueries, joins, group functions, and analytical functions.
- Performed record count reconciliation between source and target environments to ensure data completeness.
- Prepared and maintained test reports, defect logs, and test result documents.
- Analyzed application data using SQL to identify ETL issues and supported testing by creating and modifying SQL queries and stored procedures.
- Communicated identified defects to development teams and supported defect resolution.
- Established and maintained traceability relationships between requirements within the same module and across multiple modules.
ETL Tester - Oxymed
(2021-02 - 2023-03)
- Developed detailed test cases by analyzing source-to-target mapping and environment mapping documents.
- Created and executed ETL test scripts by mapping source data to target systems based on technical specifications.
- Performed data validation and database performance testing using well-structured and optimized SQL queries.
- Conducted data quality checks, including row count validation, sample data verification, and end-to-end data reconciliation.
- Verified accurate column-level mapping between source and target tables to ensure data integrity.
- Applied thorough knowledge of the Software Testing Life Cycle (STLC) throughout all testing phases.
- Prepared and maintained detailed documentation for defect logging, prioritization, tracking, and reporting.
