Senior ETL Tester - Prutech Solutions

Senior ETL Tester - -Remote Total Exp: Minimum : 12+ ETL testing: With Recent exp and min 5+ years Data Validation & Integrity Ensure data is correctly extracted, transformed, and loaded into target systems. Test Case Design Develop and execute test cases for ETL processes. ETL Functional Testing Write and run complex SQL queries and stored procedures to verify data correctness. Test the ETL packages for full load and incremental. Verify the data between SQL Server Source to Target; Flat files to SQL Server; JSON to SQL Server and vice versa. Performance Testing Identify performance bottlenecks and help ETL developers in optimizing the ETL workflows. Defect Tracking & Resolution Log and resolve data discrepancies using JIRA. Automation Implement automated testing frameworks for ETL validation. Collaboration Work with data engineers, analysts, and ETL developers to ensure smooth data operations. Required Skills Strong SQL and database knowledge. Strong experience with SQL Server and SSIS. Familiarity with data warehousing concepts (star schema, snowflake schema). Knowledge of Power Shell scripting/.NET/Python/VB Scripting for creating automation frameworks for ETL testing. Understanding of data governance and compliance . All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, or national origin. Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.