ETL Tester

Agile, ETL, Testing, SQL, Informatica, Cognos
Full Time, Contract Corp-To-Corp, Contract W2, Long-term
Work from home not available Travel not required

Job Description

Plans, designs, executes testing for Data Warehouse projects to certify that they meet business and technical requirements with minimum supervision in an Agile environment:



  • Analyze testability of requirements
  • Provide testing estimate
  • Design and prepare Test Strategies & Approach, testing metrics and other testing artifacts
  • Creates test cases based on requirements and conducts reviews with development team/business users
  • Prioritize and Executes functional tests and regression tests
  • Reports defects, raises issues or concerns
  • Participates in design meetings, risk analysis meetings
  • Create and maintain quality assurance standards and processes
  • Monitor common business specific quality measurement frameworks and track improvement against predefined metrics
  • Plan and deploy software/DWH testing and project management processes based on the current methodologies of the company
  • Create and monitor quality assurance-related activities at both the program and project level to ensure appropriately planned and executed
  • Provides leadership and mentoring to junior staff, interns, and business testers

Minimum Requirements:


  • 5+ years of ETL testing experience in Informatica environment
  • Good understanding of DWH/BI concepts/ETL testing
  • Strong DB skills
  • MUST have strong experience with SQL and able to write complex SQL queries
  • Experience in creating test cases using data mapping documents
  • Experience in Data Quality, Source Systems Analysis, and Business Rules Validation
  • Ability to create sufficient QA testing evidence to satisfy audits
  • Technical ability to understand relational databases and raw data
  • Manage data of the Test & Model environments from a data and test case perspective
  • Must have the experience to identify issues in data loads and provide recommendations
  • Understanding of data integration best practices in data warehouse environments
  • Collect, organize, and store test artifacts
  • Experience working in fast-paced Agile projects
  • Experience in test execution analysis & reporting, testing life cycle processes and test tools like HP ALM

Posted By

5005 West Royal Lane, Suite 279 Irving, TX, 75063

Dice Id : 10120357
Position Id : ETL-Tester-QA
Have a Job? Post it