QA Automation Analyst

  • SPI,
  • Irving, TX
  • 1 month ago
Data modeling, ETL, ETL QA
Contract W2, Contract Independent, 1 null
Depends on Experience
Travel not required

Job Description

Duties &Key requirements:

- Create queries (medium to complex) using SQL Developer and document with each test case to validate ETL for various BI projects
- Manual and ETL testing of web based, ecommerce client/server application on various platforms and MicroStrategy Report validation
- Write SQL queries for Database Testing to ensure data integrity, validating database consistency and verifying accurate transaction
- Provide Source to Target data validation for ETL, tables and files, before and after transformation, including Business Intelligence
- Utilize robust ETL, Bl processes and data warehousing concepts
- Create test plans, test strategies and test summary results artifacts
- Create and document test cases in Application Lifecycle Management
- Execute Test Procedures and document results for each step. (verifying and validating Technical Mapping documents, Data models, DDL scripts and ETL; and any code migrated to Test environment)
- The duties for this position are to be performed on-site at DFW Airport Headquarters.


7+ yrs. Experience
Experienced QA lead who has worked in a high volume demanding ITS environment, who is held accountable to accomplish the project schedule deadlines. 
Exceptional QA project management skills both verbal and in writing
Experience in both AGILE (Scrum) and Waterfall testing models
Strong in ETL data validation using Informatica
Strong in Bl report validation using MicroStrategy
Experience with crons, Linux and API testing
Experience with cloud database testing
Exposure to tools: Toad for Oracle/ PL SQL Developer; Rapid SQL; SQL Plus; SOAP UI; Mulesoft; Selenium; Filezilla ftp client; QuerySurge


Education &Certifications:

ISTQB or equivalent
Testing Tools : ALM 11, Bugzilla, QTP, JIRA, Rally, VersionOne
Programming Languages : SQL, PL/SQL, Shell Scripting, PERL, XML, XSD, VB, T-SQL, Java, C, C++
RDBMS/Database : Oracle, Hadoop, Teradata V2R6, DB2 9.0, SQL Server 2012, Snowflake
ETL/DW Tools : Informatica Power Center, DataStage, SSIS, Abinitio, SAP BODS
BI Tools : MicroStrategy (BI Reports),Tableau, TIBCO Spotfire, Business Objects, Qlik, Cognos, SSRS
Utility & Tools : SSIS, Visual Source Safe, SQL Profiler, Autosys, Maestro, Power Designer, Web Services
Data Modeling : Erwin 7.0, ER Studio, MS Excel, MS Access

Dice Id : 10115553
Position Id : SPI2024-24
Originally Posted : 2 years ago
Have a Job? Post it