Job Description :
QA for Data Warehouse Broad knowledge of testing approaches and techniques for certifying software acceptance.
Demonstrated ability to work independently as well as in project teams, providing relevant quality assurance services to a broad audience.
AWS, FlleZllla, Microsoft Visio, WinSCP, Java, MS Office, CVS, Microsoft Outlook, Atlassian JIRA, Putty, SAS.
Perform other duties as assigned, Test Professional (QTP), TOAD for oracle 12.6, Pig, Python, Scala, Oracle SQL Developer 18.2, PL/SQL, UNIX, IBM Cognos Query Studio 11, Apache Spark, Apache Hive, Sqoop, HDFS, Map Reduce, Hädoop,
Ensure that an application continues to function normally through software maintenance and testing. Responslble for System testing of Ad-Hoc Query
Packages in Cognos which involves execution of Ad-hoc reports and corresponding test SQL's based on various join conditions and filters and calculations.
Toois used include HP Load Runner, 18M Rational Test Manager, Oracle, IBM Rational Clear Quest, Quick Document software and application defects, using a bug tracking system, and report defects to software developers using Atlassian JIRA and track the defects until closure,
Develop or specify standards, methods, or procedures to determine product quality or release readiness, Develop and execute manual/automation tests which includes functional, Integration, negative, regression, system, IJAT and performance tests.
Design and Develop complex SQL scripts, PL/SQL blocks, stored procedures for testing the dimensions and facts in the DWH that includes data validation, count validatlon, referential integrity validation and duplicate check validation.
Experience in preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality deliverables.
Design. develop data flow/data lineage diagrams, data mapping from source to staging and staging to target mapping documents indicating the tables, columns, data types, transformations required and business rules to be applied.