Hands-on experience with Oracle database technologies
Strong expertise in Oracle SQL and SQL scripting
Experience in Python scripting and Unix/Linux commands
Requirements:
Conduct ETL/Data Warehouse testing across source systems, staging areas, and target DW (fact and dimension tables) to verify data mappings and transformations
Develop and execute complex SQL queries and Python scripts to validate data, manipulate test data, and perform data comparisons
Validate data integrity and accuracy of ETL processes and data loads through comprehensive testing and defect reporting
Utilize Oracle database technologies and Unix/Linux commands; support automation efforts (Selenium knowledge is a plus)
Hands-on experience in ORACLE database technologies
Strong expertise in ORACLE SQL and SQL scripting
Experience in Python scripting
Relational database experience with expertise in writing complex SQL queries & joins to verify proper mapping of data elements and manipulating test data through SQL statements.
Good knowledge in Unix/Linux Commands.
Expertise in Data validation and Data comparison.
Experience in ETL Processes (Data Warehouse Testing)
Proficient enough to Analyze Source Systems, Staging area, Fact and Dimension tables in Target D/W
