QA Analyst (Manual Testing/Data Reconciliation) Onsite in Los Angeles, CA 12-Month Contract/W2 Only. There are no Corp-to-Corp options or Visa Sponsorship available for this position
Optomi, in partnership with a market leader in the entertainment industry, is seeking a QA Analyst for an onsite position out of their office in Los Angeles, CA. The ideal candidate will be skilled in manual data reconciliation testing and have a strong background in working with financial systems. This is not a Business Analyst (BA) or QA automation role-candidates with heavy automation testing experience may not be a good fit, as this position focuses primarily on manual testing and data reconciliation. The team works within an Agile environment, supporting production finance, accounting AR, and financial planning for custom-built applications with an Oracle backend. This position involves significant interaction with Business Analysts and Developers to ensure thorough test coverage and application stability.
What the right candidate will enjoy:- Flexible work schedule.
- Long-term career opportunity.
- Potential for conversion to permanent.
- Working in an enterprise-level environment.
Experience of the right candidate:- Bachelor's degree in Computer Science or a related field, or equivalent work experience.
- 5+ years of experience working on custom software development projects, specifically on financial systems.
- Strong attention to detail with the ability to work independently.
- Proven experience in writing test plans, performing application testing, and conducting user acceptance testing (UAT).
- Comfortable working in an Agile/SCRUM environment.
- Proficient in SQL (basic querying and data validation).
- Advanced Excel skills, including experience with pivot tables, VLOOKUP, and formulas.
- Excellent written communication skills, including producing specifications, test plans, and other deliverables.
- Experience collaborating with developers and business analysts to clarify requirements and ensure test coverage.
Preferred Qualifications:- Experience working in the entertainment or television production industry, specifically with financial systems used in production finance.
- Experience with SAP financials, Hyperion Planning, Snowflake, or Oracle relational databases.
- Experience with SOX applications and compliance.
Responsibilities of the right candidate:- Conduct detailed analysis of data using SQL databases, multi-dimensional databases, and Excel.
- Analyze requirements and create detailed test plans to test applications and reports.
- Develop test cases, estimate test efforts, perform manual application testing, and document results.
- Collaborate closely with developers to understand the application and ensure test coverage.
- Identify and communicate risks and issues in the testing process.
- Perform web application testing, report testing, and reconciliation.
- Conduct interface testing, conversion testing, and data validation using Excel and SQL.
- Work cross-functionally with BA, QA, and development teams to ensure comprehensive test execution.