Skip to main content Skip to Footer

Job Listing

Accenture Flex - ETL/SSIS Tester - Richmond, VA

Job Location: DC, DC - Washington

Regional Description: Southeast

Job Number: 00623215


- Job description

Accenture Flex offers you the flexibility of fixed duration project-based work powered by Accenture, a leading global professional services company. Accenture is consistently recognized on FORTUNE’s 100 Best Companies to Work For and DiversityInc’s Top 50 Companies for Diversity lists. 
As an Accenture Flex employee, you will apply your skills and experience to help drive business transformation for leading organizations and communities.  In addition to delivering innovative solutions for Accenture’s clients, you will work with a highly skilled, diverse network of people across Accenture businesses who are using the latest emerging technologies to address today’s biggest business challenges.  You will receive competitive rewards and access to benefits programs and world-class learning resources. 
Job Description
Responsible for creating an end-to-end test plan; executing the plan and managing all activities in the plan to ensure that all the objectives are met and that the solution works as expected. The solution should be tested in terms of functionality, performance, reliability, and stability.
Ensure testing is well defined, planned, and executed; and that any potential issue is identified and fixed before the product goes live.
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
  • Develop test plans, test cases, test scripts, and test reports on multiple projects of varying size.
  • Execute and evaluate manual or automated test cases and report test results.
  • Experience on ETL testing
  • Knowledge on ETL tool and process
  • Knowledge on basic Database objects and relational data model
  • Experience on SQL query and script
  • Testing experience with different file types
  • ETL test validations and checks / Quality checks
  • Test automation experience is huge plus
  • Data profiling is plus
  • Understanding of ETL requirements (source-to-target mappings)
  • Experience on test data preparation/sampling
  • Writing basic SQLs to check record counts, data truncation, invalid datatypes, NULLs and data integrity
  • Basic test cases for a ETL process (for a ETL process that loads data from files to SQL database and vise versa)
  • How ETL testing is different from functional testing
  • Hold and facilitate test plan/case reviews with cross-functional team members.
  • Ensure that validated deliverables meet functional and design specifications and requirements.
  • Isolate, replicate, and report defects and verify defect fixes.
  • Interface with diverse levels of internal and external personnel to develop and maintain effective rapport and to resolve issues and inquiries.
  • Administer and adhere to Corporate and departmental policies, practices, and procedures.
  • Other duties may be assigned.
  • Involved in the design of product and project requirements / user stories
  • Experience working in a Agile development environment
  • Identify test approaches, coverage, requirement gaps and risks and risk remediation
  • Ensures quality measures are included in the initial project design.
  • Writes detailed test strategies and plans, making full use of different test estimation techniques in
    assessing best balance of coverage and efficiency for a project or sprint
  • Contributes directly to estimation efforts.
  • Writes detailed test scripts to functionally and regression test the functionality of the proposed system and supported applications.
  • Performs risk analysis on the various components of the system to determine how to derive testing regression most effectively.
  • Ensures requirements traceability and identifies areas for improvement.
  • Preparation and management of complex test environments and test data conditions.
  • Focuses on solution-oriented approach and identifies complete regression testing needs involving
    multiple parts of a product and system.
  • Manages the validation test phase including executing scripts, logging and tracking
    problems found, and regression testing any changes made to the system.
  • Able to design and manage automated test approach for tests and ensure that manual tests are
    automated using suitable tools and framework for the product.
  • Reviews and approves and executes the Integration Test Plan and Procedures
  • Validates the completion of Integrated Testing. Consults with development engineers in resolution of problems and suggest functional solutions.
  • Develops, executes and analyzes the output from scripts that capture application and platform quality
  • Troubleshoots errors found in the test environment with minimal help from Development teams.
  • Configures complex software solutions by following user guides and manuals instead of waiting to get
    helped by experts.
  • Analyzes and logs defects functionally and technically before assigning them to Development teams
  • Supports project managers and other stakeholders to complete projects/sprints within schedule, without compromising quality.
  • Raises quality issues to right levels of management using established channels of escalation.
Basic Qualifications:
5 years ETL Testing Experience
5 Years SSIS or Informatica Experience
Preferred Skills:
  • Medicare Advantage Experience
  • Experience related to Centers for Medicare and Medicaid Services (CMS) Regulations
  • Experience with JIRA and Confluence
Applicants for employment in the US must have work authorization that does not now or in the future require sponsorship of a visa for employment authorization in the United States and with Accenture. 
Candidates who are currently employed by a client of Accenture or an affiliated Accenture business may not be eligible for consideration.
Accenture is an EEO and Affirmative Action Employer of Females/Minorities/Veterans/Individuals with Disabilities.
Equal Employment Opportunity
All employment decisions shall be made without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, veteran status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status or any other basis as protected by federal, state, or local law.

Find a job

Start your search here: Enter job title, skill, experience level or city

Stay in touch

Join the Accenture Talent Connection, follow our Careers blog, or sign up for job alerts.