Test Analyst

wall, New Jersey

An energy services company is seeking a Test Analyst to join their team in Red Bank, NJ.

Within this role, you will be responsible for leading the QA testing efforts across multiple verticals assigned in the business involving diverse work streams that include ERP, Digital, CRM, Billing, Workforce and Asset Management.


  • Must have at least a Bachelor’s degree in Computer Science, or related field
  • 7+ years of experience involving analysis, both Manual and Automation testing of preferably cloud ERP, CRM systems
  • Experience in ETL backend testing experience
  • Strong knowledge of Software Development Life Cycle and Agile
  • Previous working experience as a Test Analyst on various industry verticals with experience working on methodologies like SDLC and Agile throughout the project
  • Experience interacting with developers, business teams to understand the project business requirements and ETL design document specifications
  • Knowledge in creating Test Plans, Test Scenarios and Test cases execution and mapping it to the defects and business requirements for traceability purposes
  • Expert knowledge in documenting QA processes and vertical procedures and ensuring all test plans, test scenarios, test cases and Defects are managed and adhered to within provided test management tools
  • Experience in working with Quality Center (ALM), Rally or Jira with knowledge of preparing daily test status reports to communicate the test status within the team
  • Experience in Architecting an automation Framework and using automation Tools like Quick Test Professional (QTP), Rally or Selenium
  • Actively involved in User Acceptance Testing (UAT) with strong emphasis of working with active business stakeholders
  • Participated in cross-functional teams to engineer and execute test execution processes
  • Extensive ETL testing experience using Informatica 8.1/7.1/6.2 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager)
  • Excellent Knowledge of Database Systems
  • Extensive experience in developing SQL scripts to validate the databases tables and reports data for backend data verification testing
  • Proficient in troubleshooting database issues and experienced in using performance monitor/profiler to solve dead locks/ long running queries
  • Previous basic programming language experience in Java, Python, Ruby on Rails, VB Scripting
  • Experience with Rest API, webservices, SOAP API would be an added plus
  • Experience in RDBMS, Microsoft SQL Server (T-SQL), Oracle (PL/SQL), MS Access and associated SQL Programming Knowledge with experience developing ETL test scripts based on technical specifications/Data design documents and Source to Target mappings
  • Participate in regular project status meetings and QA status meetings
  • Extensively use and develop SQL scripts/queries in testing of Databases
  • Identify defects and follow the defect management process within the test environments
  • Prepare daily status reports with details of executed, passed, failed test cases and defect status and ensure constant communication with project stakeholders
  • Test a number of complex ETL mappings, mapplets and reusable transformations for data loads
  • Creating test cases for ETL mappings and work with key stakeholders on design documents for support
  • Previous knowledge of working with flat files and excel sheet data sources and writing scripts to test the flat files data in the databases
  • Ability to Schedule and automate jobs to be run in a batch process
  • Effectively communicate testing activities and findings in oral and written formats
  • Work with onsite/offshore vendor groups and knowledge acquisition teams for understating mappings for dimensions and facts

Job keywords:

Files must be less than 2 MB.
Allowed file types: doc docx pdf.

Vertical Tabs