Data Warehouse Tester/ Wilmington,DE/6 months |
Job Title: Data Warehouse Tester Location: Wilmington,DE Duration: 6 months Job Summary: The Data Warehouse Test Analyst is responsible for the planning, coordination, execution, and tracking of functional, regression, user acceptance, and performance testing for the Data Warehouse. Essential Functions: • Create detailed test plans based on analysis of requirements and design documents. • In collaboration with other team members, analyze raw data to ensure the data will meet the business need. • Create and execute functional, regression, and performance tests. • Clearly communicate and document test results and defect resolution during all phases of testing. • Focus on Data Quality issues / problems. (completeness, conformity, consistency, accuracy, duplicates, integrity) • Responsible for daily Cube validation process Experience & Qualifications: • At least 3+ years experience in software testing / quality assurance. • 2+ years of data warehousing experience. • 1+ years in agile/SCRUM environment • Knowledge of software development lifecycle and processes for software testing / quality assurance guidelines. • Experience in creating and executing; test plans, cases, and scripts. • Experience in data analysis and data testing. • Technical knowledge and experiences in several areas including: o Testing ETL sessions and PL/SQL scripts in data warehouse applications. o Latest Cognos BI tools and products, including: Cognos Enterprise PowerPlay, Transformer and Visualizer. o BI application development, Cognos cubes and reports. o Windows and UNIX environments including AIX and / or HP-UX and Linux. o Internet and enterprise software technologies including web and application servers. o Oracle database, relational and dimensional data modeling, data dictionary and meta-data repository; full lifecycle design and application development. o Cognos ReportNet, MS SQL Server and Reporting Services. • Demonstrated efficiency in the use of Microsoft Office. (Word, Excel, Access, Project, PowerPoint, and Visio) • Demonstrated knowledge and ability to communicate the understanding of how a warehouse is built and how data is transformed and loaded. Education and/or Certifications: • B.S. Degree, Computer Science, MIS and / or related work experience. • 2+ years experience participating in complex test programs. Technical skills and abilities: • Strong interpersonal skills. • Strong written and verbal communication skills. • Ability to manage conflicting interests and identify compromises. • Ability to deliver results under pressure. • Ability to travel as needed. Ram Relevante | Accounting & Technology Consultants ryadav@relevante.com |