Extract Transform and Load ( ETL) Developer

Are you interested in joining an energetic and highly skilled team of developers? Are you looking for your next career move to grow your developer skills? Want to apply your technical skills with an energetic team of skilled developers? Are you motivated, a team player, enjoy learning and working in a collaborative environment? FTB's data team is looking for you! We are proud of our mission to help our California Taxpayers file accurate tax returns and to fund important state services by maximizing the use of data collected from all sources, ensuring data integrity, and protecting taxpayer privacy with Extract Transform and Load to respective data stores.
As an Extract, Transform, and Load (ETL) Developer, you will work independently and collaboratively with teams to design, maintain, and implement the complex data integration services for FTB's enterprise data stores. Apply your comprehensive understanding of the tools and techniques involved in data analysis and data integration such as data warehousing, data consolidation. You will be responsible to provide complex data and ad-hoc query support to business and technical partners throughout the department and build relationships with stakeholders, diverse groups, and team. As a technical subject matter expert, it will be your responsibility to develop expert knowledge of FTB's enterprise systems, data architecture, data sources and data integration best practices. You are expected to act as a leader and work cooperatively with the multiple levels of management and Technology Services Division (TSD) technical staff in support of planning and software implementation activities. We value an environment of teamwork and cooperation and your ability to foster and promote collaboration is vital to success in this role. We provide opportunities for personal and professional growth in fields like accounting, administration, collections, legal, and technology . Your opportunities are endless here at FTB.
About the Technology Services Division (TSD) The mission of TSD is to securely deliver and support information technology solutions and services essential to the success of the FTB's mission. By acting on our TSD mission, we will realize our vision of a collaborative and diverse team of IT experts who further innovation and empower our business partners to accomplish their goals. Read more about FTB . Learn more about other FTB technical roles at this FTB microsite .
Need help understanding the hiring process or have questions about FTB? We'd love to talk to you! Before applying, read through these step by step instructions to apply, or contact us at IT.Recruit@ftb.ca.gov . Please include the job control (JC) number and the position title in the subject line.
Additional positions may become available (RPA 2324-01250).
Please complete this optional survey letting us know how you heard about this position by clicking here .
You will find additional information about the job in the Duty Statement .
Working Conditions
This position is eligible for remote-working within California based on departmental guidelines and operational need. Some in-office presence required.
This position is considered Remote Centered and authorized to work a hybrid telework schedule consistent with the departmental guidelines of two days in office weekly
Minimum Requirements You will find the Minimum Requirements in the Class Specification.

• INFORMATION TECHNOLOGY SPECIALIST I

Additional Documents

• Job Application Package Checklist
• Duty Statement

Position DetailsJob Code #:
JC-399796
Position #(s):
564-241-1402-XXX
Working Title:
Extract Transform and Load ( ETL) Developer
Classification:
INFORMATION TECHNOLOGY SPECIALIST I$5,960.00 - $7,988.00 A
$6,554.00 - $8,784.00 B
$7,197.00 - $9,643.00 C
# of Positions:
Multiple
Work Location:
Sacramento County
Telework:
Hybrid
Job Type:
12 Month Limited Term - Full Time
Department InformationOur mission is to help taxpayers file timely and accurate tax returns, and pay the correct amount to fund services important to Californians.
FTB fosters an environment of equity and inclusion for all and we welcome everyone to be part of our diverse workforce.
Department Website: http://www.ftb.ca.gov
Special Requirements

• The position(s) require(s) a Background Investigation be cleared prior to being hired.

This business uses E-Verify in its hiring practices to achieve a lawful workforce. E-Verify is a web-based system that allows enrolled employers to confirm the eligibility of their employees to work in the United States. For more information about E-Verify, please go to www.dhs.gov/e-verify .
CALIFORNIA CODE OF REGULATION, SECTION 172: All candidates for, appointees to, and employees in the state civil service shall possess the general qualifications of integrity, honesty, sobriety, dependability, industry, thoroughness, accuracy, good judgment, initiative, resourcefulness, courtesy, ability to work cooperatively with others, willingness and ability to assume the responsibilities and to conform to the conditions of work characteristic of the employment, and a state of health, consistent with the ability to perform the assigned duties of the class. Where the position requires the driving of an automobile, the employee must have a valid state driver's license, a good driving record and is expected to drive the car safely. The foregoing general qualifications shall be deemed to be a part of the personal characteristics of the minimum qualifications of each class specification and need not be specifically set forth therein.
**IMPORTANT NOTICE** As required by the department's rules of conduct, all employees of the Franchise Tax Board (FTB) must be in compliance with the California Revenue and Taxation Code. During the background investigation portion of the hiring process, FTB will review return information to verify California state income tax compliance. Any failure to comply with the California Revenue and Taxation Code may prevent you from being hired at FTB. You must verify your filing status by calling 1-800-852-5711 to resolve any potential tax compliance issues, prior to submitting your application and seeking employment with FTB. All applicants not currently employed with the Franchise Tax Board will be subject to a pre-employment background investigation. The investigation will consist of completion of a pre-employment questionnaire, fingerprinting, and an inquiry to the Department of Justice to disclose criminal records. We comply with the Americans with Disabilities Act. Persons with hearing or speech impairments, call TTY/TDD (800) 735-2929.
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: 12/1/2023
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:
Franchise Tax Board
Attn: Classification & Hiring Unit - Leena Mittal /IT Workforce
P.O. Box 550
Sacramento , CA 95812-0550
Address for Drop-Off Application Packages
You may drop off your application and any applicable or required documents at:
Franchise Tax Board
Classification & Hiring Unit -Leena Mittal /IT Workforce
9646 Butterfield Way
Sacramento , CA 95827
Drop off at Welcome Center in Main Lobby (may be non-operational on weekends and holidays)
07:00 AM - 06: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.
• Other -
  A cover letter is required and must be included
• Other -
  If you are basing your eligibility on educational requirements, you MUST provide a legible copy of your transcripts as proof of meeting the education requirement as listed in the Classification Specification (please see the Class Specification located under "Minimum Requirements" on the left-hand side of this job posting). Applicants with foreign transcripts must provide a foreign transcript evaluation that indicates the number of units to which the foreign course work is equivalent. Transcripts and evaluations may be official or unofficial; please redact birthdates and social security numbers. If you are not basing your eligibility on an educational requirement, you may instead use the bypass option (when applying, select Choose/Upload for the required document and then select Bypass File).

Applicants requiring reasonable accommodations for the hiring interview process must request the necessary accommodations if scheduled for a hiring interview. The request should be made at the time of contact to schedule the interview. Questions regarding reasonable accommodations may be directed to the EEO contact listed on this job posting.
Desirable QualificationsIn 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:
We encourage applications regardless of whether you think you meet 100% of these skills below. Please highlight your knowledge, skills, and experience related to the below desirable qualifications in your application package.

• Experience troubleshooting and diagnosing data issues in a production environment.
• Experience reading and understanding relational database Physical Data Model(PDMM)
• Experience writing complex Structured Query Language (SQL) queries in DB2 or Microsoft SQL or other scripting languages.
• Experience working on large-scale Systems Development Life Cycle (SDLC) projects.
• Experience performing detailed analysis, defining technical problems, and recommending effective solutions.
• Knowledge and experience of ETL process tools such as IBM DataStage and Microsoft SQL server integration services(SSIS).
• Knowledge of relational databases such as IBM DB2, Microsoft SQL server.
• Knowledge of Apache Hive or Hadoop Distributed File Systems (HDFS).
• Knowledge of Big Data or Data Streaming tools such as Java Script Object Notation (JSON), Python, and/or Hibernate Query Language(HQL).
• Knowledge of validating XML with XML Schemas.
• Knowledge of Hive data warehouse tool to analyze the data in HDFS and developed Hive queries
• Ability to work in a team environment and handle multiple project priorities and workloads.
• Self-starter with excellent time management and organizational skills.

BenefitsBenefit information can be found on the CalHR website and the CalPERS website.
In addition, Franchise Tax Board offers the following:

• Convenient transportation and commuting options include : Light Rail stop, bicycle lockers, free parking, and carpool/vanpool opportunities
• On site conveniences include: A variety of dining options

Contact Information
The Human Resources Contact is available to answer questions regarding the application process. The Hiring Unit Contact is available to answer questions regarding the position.
Department Website: http://www.ftb.ca.gov
Human Resources Contact:
Classification & Hiring Unit
(916) 845-3608
Hiring Unit Contact:
Leena Mittal
(916) 845-6092
Leena.Mittal@ftb.ca.gov
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:
EEO Office
(916) 845-2860
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.
ADDITIONAL APPLICATION INSTRUCTIONS
A complete application package must be received in the Classification & Hiring Unit or postmarked by the final filing date and must include:

• Completed employment information on the STD. 678, including the "From" and "To" dates, "Hours Per Week," and "Duties Performed" fields for all jobs listed in the "Employment History" fields (resumes do not take the place of these fields on the STD. 678)
• All of the required documents listed in the "Required Application Package Documents" section ...