Backend ETL Tester

CompuGain, a global business and technology consulting firm, is currently seeking a Backend ETL Tester. CompuGain collaborates with clients to help improve their business and technology effectiveness through consistent delivery of quality services.  CompuGain serves clients in the Financial Services, Healthcare, Energy, Media & Entertainment, Education, and Public Sectors.  We have an outstanding track record of delivering high value consulting services to our clients.

LOCATION:  Washington DC Metro Area

POSITION RESPONSIBILITIES:

  • Perform quality assurance analysis and testing on an Enterprise-level web application for the mortgage industry.
  • Responsible for application analysis, test strategy development, test case creation, test script development, test execution, defect tracking and reporting.
  • Responsible for the Analysis of software applications and computer systems, Focus of the effort is on batch process modules, UI screens, and Reports.
  • Create automated test scripts using QTP for automation of the manual scripts
  • Perform Backend database testing to validate the data using complex SQL queries, PL/SQL, Oracle and AbInitio
  • Perform Integration test by running ETL jobs, validating data loads, troubleshooting job execution errors and executing test scripts.
  • Perform Regression test for every module of Software development
  • Use AbInitio graphs to test positive & negative scenarios based on the test cases
  • Work with development, QA, and Automation engineers to research, design, and develop complex test automation units.
  • Participate in all stages of testing, such as Unit, Integration, Regression System and UAT testing, in both manual and automation environment.
  • Absorb and understand system design, data model, and functional components of large software system
  • Mentor testers and answer technical questions related to SQL/UNIX and test strategy

POSITION REQUIREMENTS:

  • Strong Backend testing experience - Strong Oracle/SQL/UNIX
  • Heavy SQL experience, must be able to write complex SQL queries for joints, sub-queries, functions and procedures and be able to code SQL it in the interview
  • Strong problem solving with ability to analyze complex system requirements and define discreet test scenarios to provide full functional coverage
  • Experience with different testing methodologies, such as Waterfall, Agile and Scrum
  • Strong Analytical skills in Requirement Analysis and Business Process Testing
  • Experience with UNIX batch processing and file manipulation, Shell Scripting is a plus
  • Strong knowledge in Datawarehouse Testing using AbInitio
  • Experience with Programming language, such as Java, C, C++ or Perl
  • Solid communication skills (speak clearly, communicate testing processes, etc.)
  • Experience with Reporting tools, like Business Objects and Crystal Reports in a big plus
  • Previous experience with Mortgage Loan Data is preferred
  • At least 5 years of hands on experience in Quality Center
  • At least 5 years of Experience with UNIX, SQL, batch processing
  • Experience with QTP and WinRunner is a plus
  • Familiarity with DOORS, Clear Quest and Clear Case
  • Experience with Autosys strongly desired.
  • Knowledge of Remedy is a plus

To apply for this position, please send your resume and cover letter to recruiting@compugain.com.

***

ABOUT COMPUGAIN

CompuGain is a global provider of business solutions, technology consulting services and outsourced project services. Established in 2000, CompuGain has partnered with its clients in the Financial, Education, Media & Entertainment, Healthcare, Energy and Public Sectors to produce real, measurable results.  CompuGain's flexible business model and expertise in Technology Consulting, Finance & Accounting, Program/Project Management and Outsourced Project Solutions helps clients improve productivity, reduce costs and increase revenue.  CompuGain has global footprints in the US and India with offices in Herndon, VA; New York City, NY; Atlanta, GA; Chicago, IL; Dallas, TX; Philadelphia, PA and an off-shore facility in Hyderabad, India.