Grant Thornton LLP Jobs

Job Information

Grant Thornton LLP Data Warehouse ETL Tester in Arlington, Virginia

Grant Thornton is seeking a Senior Associate to join its TT-ADTA service line and take an active role in engagement execution, project management and key business development activities.

Grant Thornton Public Sector helps executives and managers at all levels of government maximize their performance and efficiency in the face of ever tightening budgets and increased demand for services. We give clients creative, cost-effective solutions that enhance their acquisition, financial, human capital, information technology, data analytics, and performance management. For more information, visit

At Grant Thornton, our professional staff applies traditional, cutting-edge approaches and methods to a variety of analyses. As part of our team, the Senior Associate will utilize various methodologies and models to execute client projects.

ESSENTIAL DUTIES: Develop test strategies, test plans, and execute test cases for ETL processes. Develop and execute detailed ETL related functional, performance, integration and regression test cases, and documentation. Design and develop SQL scripts to generate test data, and compare expected vs. actual data created by ETL processes. Implement ETL testing and deployment automation procedures in Linux environment. Review data and reporting for accuracy, functionality, and consistency. Test other team members' Informatica PowerCenter work products, and perform code reviews. Utilize design documentation to create functional test case requirements. Analyze Informatica PowerCenter objects to create technical test case requirements. Create technical products and provide recommendations regarding performance improvements, best practices, and fulfilling requirements. Develop documentation and project artifacts to support solution delivery. Support to technical and operational activities. Assist in the development of technical and operational processes, documentation, and plans. Assist in the implementation of technical and operational activities. Collaborate with data modelers, systems analysts, data warehouse developers, ETL developers, etc. and uphold quality management standards for consistency, completeness, accuracy, and productivity.

Meet or exceed targeted billing hours (utilization). Assist with business development activities, such as proposals, capture, account teams, whitepapers, conferences, and/or other thought leadership materials.

Enterprise data architecture / Information Management, Quality Assurance, Enterprise Data Management (EDM), Data Analysis, Data Integration, Data Cleansing, Data Mapping, Testing Management

Bachelor’s Degree required from an accredited college or university in a related field. Ability to obtain and maintain certain job-related certifications if no job-related advanced degrees. U.S. citizenship may be required. Ability to work in the United States indefinitely required. Travel may be required. Ability to work overtime required on occasion. Ability to sit in an office environment for long periods of time. Ability to obtain and maintain a security clearance. Ability to communicate clearly in writing and verbally. Ability to obtain and maintain firm independence and abide by firm ethics requirements. Meet or exceed continuing professional education (CPE) requirements.

Grant Thornton Public Sector LLC (“Grant Thornton Public Sector”), based in Arlington, VA, is a global management consulting business with the mission of providing responsive and innovative financial, performance management and systems solutions to governments and international organizations. Visit Grant Thornton’s Public Sector

It is Grant Thornton’s policy to promote equal employment opportunities. All personnel decisions, including, but not limited to, recruiting, hiring, training, promotion, compensation, benefits and termination, are made without regard to race, creed, color, religion, national origin, sex, age, marital status, sexual orientation, gender identity, citizenship status, veteran status, disability, or any other characteristic protected by applicable federal, state, or local law.

Title: Data Warehouse ETL Tester

Location: Virginia-Arlington

Requisition ID: 048156