QA Automation Analyst

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. Experience:7+ yrs. ExperienceExperienced 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 writingExperience in both AGILE (Scrum) and Waterfall testing modelsStrong in ETL data validation using InformaticaStrong in Bl report validation using MicroStrategyExperience with crons, Linux and API testingExperience with cloud database testingExposure to tools: Toad for Oracle/ PL SQL Developer; Rapid SQL; SQL Plus; SOAP UI; Mulesoft; Selenium; Filezilla ftp client; QuerySurge Education &Certifications:ISTQB or equivalentTesting Tools : ALM 11, Bugzilla, QTP, JIRA, Rally, VersionOneProgramming Languages : SQL, PL/SQL, Shell Scripting, PERL, XML, XSD, VB, T-SQL, Java, C, CRDBMS/Database : Oracle, Hadoop, Teradata V2R6, DB2 9.0, SQL Server 2012, SnowflakeETL/DW Tools : Informatica Power Center, DataStage, SSIS, Abinitio, SAP BODSBI Tools : MicroStrategy (BI Reports),Tableau, TIBCO Spotfire, Business Objects, Qlik, Cognos, SSRSUtility & Tools : SSIS, Visual Source Safe, SQL Profiler, Autosys, Maestro, Power Designer, Web ServicesData Modeling : Erwin 7.0, ER Studio, MS Excel, MS Access