Address
Form of workThe Information Technology, Network Operations program at State Fund currently has an opening for a Information Technology Specialist II classification as a Big Data Quality Engineer.
The position's major functions are as follows:
• Testing applications built on Big Data.
• Testing using SQL and PL/SQL.
• Testing using NoSQL systems like HBase or Cassandra.
• Testing applications implemented in Cloudera Distribution 6.x.
• Testing Solr collections in Solr Cloud environment.
• Validating data pipelines using Hadoop components Sqoop, Hive, Solr, MR, Impala, Spark, Spark SQL.
• Testing using Hive QL and UDF's for analyzing semi structured/structured datasets.
• Testing application modules and functionalities implemented using Spring framework, Web Services and REST API's.
• Testing REST API's using tools like Postman and SoapUI.
• Testing ingestion and processing of various file formats like Avro/Parquet/Sequence Files/Text Files etc.
• Testing data warehousing and Business Intelligence systems.
• Handling all technical aspects of testing which includes delivering effective testing strategies and testing artifacts like Test Plans, Test Cases, Testing Execution Reports etc.
• Testing using required modules and features in HP ALM and JIRA.
• Providing test estimates for proposed projects.
• Constantly look for opportunities to improve testing processes.
• Encourage innovation of process and creative testing methodologies.
• Work closely with management on testing assignments.
• Promote high quality of testing and timely completion of testing assignments.
• Knowledge of Test Automation Scripting for both, BDD/TDD and Hybrid, linear test frameworks.
• Testing APIs using service based Automation Scripting.
New to state candidates will be hired into the minimum salary of the classification or minimum of the alternate salary range when applicable. Placement to an alternate salary range may be based on education or experience identified in your state application.
Working Conditions
Telework may be available and is subject to change based on State Fund guidelines and business needs.
Selected candidate(s) hired may be required to attend in-person Onboarding at our Vacaville office with expenses for attendance paid by State Fund.
Minimum Requirements You will find the Minimum Requirements in the Class Specification.
- INFORMATION TECHNOLOGY SPECIALIST II
- Job Application Package Checklist
Position Details Job Code #:
JC-421988
Position #(s):
402-415-1414-XXX
Working Title:
Big Data Quality Engineer
Classification:
INFORMATION TECHNOLOGY SPECIALIST II $8,130.00 - $10,893.00 A
# of Positions:
Multiple
Work Location:
Solano County
Telework:
Hybrid
Job Type:
Permanent, Full Time
Department Information
State Fund is California's largest provider of workers' compensation insurance. Established in 1914 by the state legislature, we offer diverse and comprehensive products and services that provide a strong and stable option for employers and injured employees with fast, reliable claims service and medical and indemnity benefits.
Our culture centers on our purpose and values. We exist to provide fairly priced workers' c ompensation insurance, make workplaces safe, and restore injured workers. To fully represent California, we are committed to our employees by embracing and celebrating our diverse workforce and fostering inclusion to make the workplace a dynamic environment for all. We recognize and reward high performance, yet value a healthy work/life balance.
Department Website: http://www.statefundca.com
Special Requirements
Resumes submitted in lieu of the STD 678 may not be accepted. Completed STD 678 must include duties performed, start and end dates, and hours worked per week for each position held.
The successful candidate must reside in California upon appointment.
Application Instructions
Completed applications and all required documents must be received or postmarked by the Final Filing Date in order to be considered. Dates printed on Mobile Bar Codes, such as the Quick Response (QR) Codes available at the USPS, are not considered Postmark dates for the purpose of determining timely filing of an application.
Final Filing Date: 4/2/2024
Who May Apply
Individuals who are currently in the classification, eligible for lateral transfer, eligible for reinstatement, have list eligibility, are in the process of obtaining list eligibility, or have SROA and/or Surplus eligibility (please attach your letter, if available). SROA and Surplus candidates are given priority; therefore, individuals with other eligibility may be considered in the event no SROA or Surplus candidates apply.
Applications will be screened and only the most qualified applicants will be selected to move forward in the selection process. Applicants must meet the Minimum Qualifications stated in the Classification Specification(s).
How To Apply
Complete Application Packages (including your Examination/Employment Application (STD 678) and applicable or required documents) must be submitted to apply for this Job Posting. Application Packages may be submitted electronically through your CalCareer Account at www.CalCareers.ca.gov. When submitting your application in hard copy, a completed copy of the Application Package listing must be included. If you choose to not apply electronically, a hard copy application package may be submitted through an alternative method listed below:
Address for Mailing Application Packages
You may submit your application and any applicable or required documents to:
State Compensation Insurance Fund
Attn: JC-421988 CF
PO BOX 659015
Sacramento , CA 95865
Address for Drop-Off Application Packages
You may drop off your application and any applicable or required documents at:
State Compensation Insurance Fund
JC-421988 CF
2275 Gateway Oaks Drive
Sacramento , CA 95833
08:00 AM - 05:00 PM
Required Application Package Documents
The following items are required to be submitted with your application. Applicants who do not submit the required items timely may not be considered for this job:
- Current version of the State Examination/Employment Application STD Form 678 (when not applying electronically), or the Electronic State Employment Application through your Applicant Account at www.CalCareers.ca.gov. All Experience and Education relating to the Minimum Qualifications listed on the Classification Specification should be included to demonstrate how you meet the Minimum Qualifications for the position.
- Resume is required and must be included.
Desirable Qualifications In addition to evaluating each candidate's relative ability, as demonstrated by quality and breadth of experience, the following factors will provide the basis for competitively evaluating each candidate:
The successfull candidate shall possess the following skills:
• 4+ years of hands-on testing experience for applications built on Big Data.
• 5+ years of experience in SQL and relational database design and methods for data retrieval.
• Business domain knowledge related to Worker's Compensation Insurance industry is a plus.
• Knowledge of NoSQL systems like HBase or Cassandra.
• Knowledge of Cloudera Distribution 6.x.
• Knowledge of Solr collections in Solr Cloud environment.
• Knowledge of data pipelines using Hadoop components Sqoop, Hive, Solr, MR, Impala, Spark, Spark SQL.
• Experience with developing Hive QL, UDF's for analyzing semi structured/structured datasets.
• Experience with Spring framework, Web Services and REST API's.
• Experience with testing REST API's using tools like Postman and SoapUI.
• Knowledge of Test Planning, Reporting and Defect Management process in HP ALM & JIRA.
• Experience with testing ingestion and processing of various file formats like Avro/Parquet/Sequence Files/Text Files etc.
• Experience in testing data warehousing and Business Intelligence systems.
• Expert in all technical aspects of testing which includes delivering effective testing strategies and testing artifacts like Test Plans, Test Cases, Testing Execution Reports etc.
• Providing test estimates for proposed projects.
• Knowledge of Test Automation Scripting using Selenium, TestNg, AutoIT, Grid & Webdriver, xPath utilities, custom reports, trend analysis, file difference / compare tools, Protractor, Watir for both, BDD/TDD and Hybrid, linear test frameworks.
• Experience in testing APIs using service based Automation Scripting.
Benefits
State Fund employees are eligible for a number of benefits. Our benefit package includes:
Health Benefits Program (CalPERS), Retirement (CalPERS), Employer Health and Consolidated Benefits Contributions, Dental, Vision, 401(k) and 457 Deferred Compensation Plans, Employee Assistance Program, Group Legal Services Insurance, Holidays, Vacation/Sick/Other Paid Leave, Flex Elect Reimbursement Program, Wellness and Recognition, Alternate Work Schedules, Transit Pass Program, Tuition Reimbursement, Dependent Scholarship Program, Leadership Training, Mentoring Program
https://www.calhr.ca.gov/Pages/California-State-Civil-Service-Employee-Benefits-Summary.aspx
Contact Information
The Human Resources Contact is available to answer questions regarding the position or application process.
Department Website: http://www.statefundca.com
Human Resources Contact:
Christine Fong
(209) 273-0567
CFong@scif.com
Please direct requests for Reasonable Accommodations to the interview scheduler at the time the interview is being scheduled. You may direct any additional questions regarding Reasonable Accommodations or Equal Employment Opportunity for this position(s) to the Department's EEO Office.
EEO Contact:
Rosa Gil-Robles
(800) 499-8668
California Relay Service: 1-800-735-2929 (TTY), 1-800-735-2922 (Voice) TTY is a Telecommunications Device for the Deaf, and is reachable only from phones equipped with a TTY Device.
Background Investigation
Prior to employment with State Compensation Insurance Fund, a background investigation (BI) will be initiated.
Acknowledgement
Electronic applications submitted through your CalCareer Account are highly recommended and will be received/processed faster than other methods of filing.
By applying to this position, you are also acknowledging that you have received the following information:
- California State benefits
- Duty statement/Job Description (provided at time of interview)
- Salary ranges and steps for the classification(s) advertised
Equal Opportunity Employer
The State of California is an equal opportunity employer to all, regardless of age, ancestry, color, disability (mental and physical), exercising the right to family care and medical leave, gender, gender expression, gender identity, genetic information, marital status, medical condition, military or veteran status, national origin, political affiliation, race, religious creed, sex (includes pregnancy, childbirth, breastfeeding and related medical conditions), and sexual orientation.
It is an objective of the State of California to achieve a drug-free work place. Any applicant for state employment will be expected to behave in accordance with this objective because the use of illegal drugs is inconsistent with the law of the State, the rules governing Civil Service, and the special trust placed in public servants.
