QA Tester – Data Migration / ETL

Hands-on experience with SQL in different database platforms (e.g., Oracle, SQL Server, PostgreSQL etc). Ability to write and optimize complex SQL queries for validation and reconciliation. Good understanding of ETL processes, data pipelines, and data movement between systems. Experience validating data flows and transformations against business and technical requirements. Strong ability to work from mapping documents to design and execute test cases. Proficiency in identifying data mismatches, missing records, and transformation logic issues. Familiarity with full data migration lifecycle (data profiling, cleansing, migration, and validation). Ability to create test scenarios and scripts based on mapping and transformation rules. Experience executing reconciliation testing between different data sources and target systems. Strong defect management and documentation skills.

Conducting independent testing to ensure the Program’s target solution meets FEMA’s documented requirements and non-functional standards. Validating that delivered software solutions align with user needs and compliance expectations. Collaborating with the integrated compliance team to support release and configuration management activities. Assisting in maintaining quality control throughout software release cycles. Writing, optimizing, and executing complex SQL queries across platforms (Oracle, SQL Server, PostgreSQL, etc.). Performing validation and reconciliation of data across multiple environments. Testing Extract, Transform, Load (ETL) processes, ensuring data pipelines and data movement between systems meet business and technical requirements. Validating data flows, transformations, and accuracy across integration points. Designing and executing test cases based on data mapping documents. Identifying and resolving mismatches, missing records, and transformation logic issues. Supporting the full data migration lifecycle, including profiling, cleansing, migration, and validation. Creating detailed test scenarios and scripts aligned with mapping and transformation rules. Performing reconciliation testing between different data sources and target systems. Documenting defects, tracking resolutions, and ensuring corrective actions are implemented. Participating in Agile ceremonies (sprint planning, stand-ups, retrospectives) to align testing activities with development cycles. Continuously improving testing approaches using industry best practices.