IT - Enterprise Data Platform - ETL Developer

<p style="margin-bottom: 0px; margin-top: 0px;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><strong>TITLE: ETL DEVELOPER</strong></span><br><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><strong>STATUS: EXEMPT</strong></span><br><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><strong>REPORT TO: ENTERPRISE DATA MANAGER</strong></span><br><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><strong>DEPARTMENT: IT – INFRASTRUCTURE SYSTEMS</strong></span><br><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><strong>JOB CODE: 4505</strong></span></p> <p style="margin-bottom: 0px; margin-top: 0px;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><strong>PAY RANGE: $102,000.00 - $125,000.00 ANNUALLY</strong></span></p> <p style="margin-bottom: 0px; margin-top: 0px;"><br><br></p> <p style="margin: 0in 0in 8pt; line-height: 107%; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><strong><u><span style="line-height: 107%;">GENERAL DESCRIPTION:</span></u></strong></span></p> <p style="margin: 0in 0in 8pt; line-height: 107%; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12pt; line-height: 107%; font-family: arial, helvetica, sans-serif;">The ETL Developer / Consultant provides technical expertise in analysis, design, development, rollout and maintenance of data integration implementations.  This position is a contributor to the architecture and implementation methodologies and best practices of the data integration competency within the Enterprise Data Management team. The ETL Developer will work on, and may lead, project teams to analyze, design, develop and deploy implementations of enterprise solutions to support a variety of customer needs.</span></p> <p style="margin: 0in 0in 8pt; line-height: 107%; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><strong><u><span style="line-height: 107%;">TASKS, DUTIES, FUNCTIONS:</span></u></strong></span></p> <ol style="margin-top: 0in; margin-bottom: 0in;" start="1" type="1"> <li style="margin-bottom: 0in; line-height: normal; margin-top: 0in; margin-right: 0in; font-size: 12pt; font-family: arial, helvetica, sans-serif;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Develops, analyzes, implements, configures, tests, debugs and maintains data integration processes to fit project requirements (includes data capture, testing and validation methods)</span></li> <li style="margin-bottom: 0in; line-height: normal; margin-top: 0in; margin-right: 0in; font-size: 12pt; font-family: arial, helvetica, sans-serif;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Functions as a technical resource on projects throughout the project lifecycle</span></li> <li style="margin-bottom: 0in; line-height: normal; margin-top: 0in; margin-right: 0in; font-size: 12pt; font-family: arial, helvetica, sans-serif;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Provides support for application systems and business processes</span></li> <li style="margin-bottom: 0in; line-height: normal; margin-top: 0in; margin-right: 0in; font-size: 12pt; font-family: arial, helvetica, sans-serif;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Diagnoses and remedies technical problems to ensure platform up-time and application service levels are met for the project</span></li> <li style="margin-bottom: 0in; line-height: normal; margin-top: 0in; margin-right: 0in; font-size: 12pt; font-family: arial, helvetica, sans-serif;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Supports, maintains and monitors the health of the processes, inbound and outbound feeds for data integrity</span></li> <li style="margin-bottom: 0in; line-height: normal; margin-top: 0in; margin-right: 0in; font-size: 12pt; font-family: arial, helvetica, sans-serif;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Writes high quality processes utilizing structured development techniques to support process components and development</span></li> <li style="margin-bottom: 0in; line-height: normal; margin-top: 0in; margin-right: 0in; font-size: 12pt; font-family: arial, helvetica, sans-serif;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Utilizes agile-based approach to implementing data services and solutions</span></li> <li style="margin-bottom: 0in; line-height: normal; margin-top: 0in; margin-right: 0in; font-size: 12pt; font-family: arial, helvetica, sans-serif;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Recommend improvements to processes as supported by integration systems</span></li> <li style="margin-bottom: 0in; line-height: normal; margin-top: 0in; margin-right: 0in; font-size: 12pt; font-family: arial, helvetica, sans-serif;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Partner with quality assurance testing teams to identify errors and confirm business specifications have been achieved</span></li> <li style="margin-bottom: 0in; line-height: normal; margin-top: 0in; margin-right: 0in; font-size: 12pt; font-family: arial, helvetica, sans-serif;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Support the transfer of processes from test environment to quality environment to production environment (i.e. for data integration code and related solutions)</span></li> <li style="margin-bottom: 0in; line-height: normal; margin-top: 0in; margin-right: 0in; font-size: 12pt; font-family: arial, helvetica, sans-serif;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Support the development of end-user materials (i.e. Runbook)</span></li> <li style="margin-bottom: 0in; line-height: normal; margin-top: 0in; margin-right: 0in; font-size: 12pt; font-family: arial, helvetica, sans-serif;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Collects information to analyze and evaluate existing or proposed application designs</span></li> <li style="margin-bottom: 0in; line-height: normal; margin-top: 0in; margin-right: 0in; font-size: 12pt; font-family: arial, helvetica, sans-serif;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Convert technical specifications into code using proprietary and/or non-proprietary tools with assistance from more experienced analysts</span></li> <li style="margin-bottom: 0in; line-height: normal; margin-top: 0in; margin-right: 0in; font-size: 12pt; font-family: arial, helvetica, sans-serif;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Maintains system and programming guidelines by adhering to the software development lifecycle; Develops and maintains artifacts of the integration architecture</span></li> <li style="margin-bottom: 0in; line-height: normal; margin-top: 0in; margin-right: 0in; font-size: 12pt; font-family: arial, helvetica, sans-serif;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Assists with the definition and implementation of processes, policies, standards and procedures to ensure compliance with corporate and regulatory policies </span></li> <li style="margin-bottom: 0in; line-height: normal; margin-top: 0in; margin-right: 0in; font-size: 12pt; font-family: arial, helvetica, sans-serif;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Participate in the “on-call” rotation. </span></li> <li style="margin-bottom: 0in; line-height: normal; margin-top: 0in; margin-right: 0in; font-size: 12pt; font-family: arial, helvetica, sans-serif;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Performs other job-related duties as necessary. </span></li> <li style="margin-bottom: 0in; line-height: normal; margin-top: 0in; margin-right: 0in; font-size: 12pt; font-family: arial, helvetica, sans-serif;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Effective oral and written communication skills required to train, direct, and evaluate staff, diagnose, correct and log computer projects and problems. </span></li> </ol> <p style="margin: 0in 0in 8pt; line-height: 107%; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><strong><u><span style="line-height: 107%;">PHYSICAL SKILLS, ABILITIES, AND EXERTION UTILIZED IN THE PERFORMANCE OF THESE TASK:</span></u></strong></span></p> <ol style="margin-bottom: 0in; margin-top: 0px;"> <li style="margin: 0in 0in 0in 0px; line-height: 107%; font-size: 12pt; font-family: arial, helvetica, sans-serif;"><span style="font-size: 12pt; line-height: 107%; font-family: arial, helvetica, sans-serif;">Prolonged sitting throughout the workday to accomplish tasks. </span></li> <li style="margin: 0in 0in 0in 0px; line-height: 107%; font-size: 12pt; font-family: arial, helvetica, sans-serif;"><span style="font-size: 12pt; line-height: 107%; font-family: arial, helvetica, sans-serif;">Availability for emergencies and on call duty 24 hours a day, 7 days a week, as needed. </span></li> <li style="margin: 0in 0in 0in 0px; line-height: 107%; font-size: 12pt; font-family: arial, helvetica, sans-serif;"><span style="font-size: 12pt; line-height: 107%; font-family: arial, helvetica, sans-serif;">Occasional travel may be required. </span></li> <li style="margin: 0in 0in 0in 0px; line-height: 107%; font-size: 12pt; font-family: arial, helvetica, sans-serif;"><span style="font-size: 12pt; line-height: 107%; font-family: arial, helvetica, sans-serif;">Lift and carry communications equipment and computer hardware weighing up to fifty pounds. </span></li> <li style="margin: 0in 0in 0in 0px; line-height: 107%; font-size: 12pt; font-family: arial, helvetica, sans-serif;"><span style="font-size: 12pt; line-height: 107%; font-family: arial, helvetica, sans-serif;">Corrected vision in the normal range required to configure, test, and troubleshoot network server hardware and data. </span></li> <li style="margin: 0in 0in 0in 0px; line-height: 107%; font-size: 12pt; font-family: arial, helvetica, sans-serif;"><span style="font-size: 12pt; line-height: 107%; font-family: arial, helvetica, sans-serif;">Hearing within normal range. </span></li> <li style="margin: 0in 0in 0in 0px; line-height: 107%; font-size: 12pt; font-family: arial, helvetica, sans-serif;"><span style="font-size: 12pt; line-height: 107%; font-family: arial, helvetica, sans-serif;">Must possess sufficient manual dexterity to skillfully operate applicable computer hardware, a variety of hand tools and standard office equipment. </span></li> <li style="margin: 0in 0in 8pt 0px; line-height: 107%; font-size: 12pt; font-family: arial, helvetica, sans-serif;"><span style="font-size: 12pt; line-height: 107%; font-family: arial, helvetica, sans-serif;">May work additional work hours to accomplish tasks. </span></li> </ol> <p style="margin: 0in 0in 8pt; line-height: 107%; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><strong><u><span style="line-height: 107%;">ORGANIZATIONAL CONTACTS & RELATIONSHIPS:</span></u></strong></span></p> <ol style="margin-bottom: 0in; margin-top: 0px;"> <li style="margin: 0in 0in 0in 0px; line-height: 107%; font-size: 12pt; font-family: arial, helvetica, sans-serif;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><strong><span style="line-height: 107%;">INTERNAL: </span></strong><span style="line-height: 107%;">All levels of staff and management</span></span></li> <li style="margin: 0in 0in 8pt 0px; line-height: 107%; font-size: 12pt; font-family: arial, helvetica, sans-serif;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><strong><span style="line-height: 107%;">EXTERNAL: </span></strong><span style="line-height: 107%;">Vendors</span></span></li> </ol> <p style="margin: 0in 0in 8pt; line-height: 107%; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><strong><u><span style="line-height: 107%;">QUALIFICATIONS:</span></u></strong></span></p> <ol style="margin-bottom: 0in; margin-top: 0px;"> <li style="margin: 0in 0in 0in 0px; line-height: 107%; font-size: 12pt; font-family: arial, helvetica, sans-serif;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><strong><span style="line-height: 107%;">EDUCATION:</span></strong><span style="line-height: 107%;"> Bachelor’s degree in Computer Science, Management Information Systems or comparable discipline or equivalent work experience.</span></span></li> <li style="margin: 0in 0in 0in 0px; line-height: 107%; font-size: 12pt; font-family: arial, helvetica, sans-serif;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><strong><span style="line-height: 107%;">EXPERIENCE:</span></strong></span> <ol style="list-style-type: lower-alpha; margin-bottom: 0in; margin-top: 0px;"> <li style="margin: 0in 0in 0in 0px; line-height: 107%; font-size: 12pt; font-family: arial, helvetica, sans-serif;"><span style="font-size: 12pt; line-height: 107%; font-family: arial, helvetica, sans-serif;">Minimum three to five years’ experience developing, deploying and supporting enterprise integration technologies for On-Premises and Cloud solutions.</span></li> <li style="margin: 0in 0in 0in 0px; line-height: 107%; font-size: 12pt; font-family: arial, helvetica, sans-serif;"><span style="font-size: 12pt; line-height: 107%; font-family: arial, helvetica, sans-serif;">3-5 years consulting experience preferred.</span></li> <li style="margin: 0in 0in 0in 0px; line-height: 107%; font-size: 12pt; font-family: arial, helvetica, sans-serif;"><span style="font-size: 12pt; line-height: 107%; font-family: arial, helvetica, sans-serif;">Experience in enterprise architecture, security, management and monitoring.</span></li> <li style="margin: 0in 0in 0in 0px; line-height: 107%; font-size: 12pt; font-family: arial, helvetica, sans-serif;"><span style="font-size: 12pt; line-height: 107%; font-family: arial, helvetica, sans-serif;">Data Integration experience necessary.</span></li> <li style="margin: 0in 0in 0in 0px; line-height: 107%; font-size: 12pt; font-family: arial, helvetica, sans-serif;"><span style="font-size: 12pt; line-height: 107%; font-family: arial, helvetica, sans-serif;">Experience with Data Bricks, SSIS, BI visualization tools and enterprise schedulers desired.</span></li> </ol> </li> <li style="margin: 0in 0in 0in 0px; line-height: 107%; font-size: 12pt; font-family: arial, helvetica, sans-serif;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><strong><span style="line-height: 107%;">KNOWLEDGE / SKILLS:</span></strong></span> <ol style="list-style-type: lower-alpha; margin-bottom: 0in; margin-top: 0px;"> <li style="margin: 0in 0in 0in 0px; line-height: 107%; font-size: 12pt; font-family: arial, helvetica, sans-serif;"><span style="font-size: 12pt; line-height: 107%; font-family: arial, helvetica, sans-serif;">Strong understanding of data management best practices and concepts</span></li> <li style="margin: 0in 0in 8pt 0px; line-height: 107%; font-size: 12pt; font-family: arial, helvetica, sans-serif;"><span style="font-size: 12pt; line-height: 107%; font-family: arial, helvetica, sans-serif;">Strong SQL skills expected</span></li> </ol> </li> </ol> <p style="margin: 0in 0in 8pt; line-height: 107%; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><strong><u><span style="line-height: 107%;">PHYSICAL REQUIREMENTS:</span></u></strong></span></p> <ol style="margin-bottom: 0in; margin-top: 0px;"> <li style="margin: 0in 0in 0in 0px; line-height: 107%; font-size: 12pt; font-family: arial, helvetica, sans-serif;"><span style="font-size: 12pt; line-height: 107%; font-family: arial, helvetica, sans-serif;">Minimum three to five years’ experience developing, deploying and supporting enterprise integration technologies for On-Premises and Cloud solutions</span></li> <li style="margin: 0in 0in 0in 0px; line-height: 107%; font-size: 12pt; font-family: arial, helvetica, sans-serif;"><span style="font-size: 12pt; line-height: 107%; font-family: arial, helvetica, sans-serif;">3-5 years consulting experience preferred</span></li> <li style="margin: 0in 0in 0in 0px; line-height: 107%; font-size: 12pt; font-family: arial, helvetica, sans-serif;"><span style="font-size: 12pt; line-height: 107%; font-family: arial, helvetica, sans-serif;">Experience in enterprise architecture, security, management and monitoring </span></li> <li style="margin: 0in 0in 0in 0px; line-height: 107%; font-size: 12pt; font-family: arial, helvetica, sans-serif;"><span style="font-size: 12pt; line-height: 107%; font-family: arial, helvetica, sans-serif;">Strong understanding of data management best practices and concepts</span></li> <li style="margin: 0in 0in 0in 0px; line-height: 107%; font-size: 12pt; font-family: arial, helvetica, sans-serif;"><span style="font-size: 12pt; line-height: 107%; font-family: arial, helvetica, sans-serif;">Strong SQL skills expected</span></li> <li style="margin: 0in 0in 0in 0px; line-height: 107%; font-size: 12pt; font-family: arial, helvetica, sans-serif;"><span style="font-size: 12pt; line-height: 107%; font-family: arial, helvetica, sans-serif;">Data Integration experience necessary</span></li> <li style="margin: 0in 0in 8pt 0px; line-height: 107%; font-size: 12pt; font-family: arial, helvetica, sans-serif;"><span style="font-size: 12pt; line-height: 107%; font-family: arial, helvetica, sans-serif;">Experience with Data Bricks, SSIS, BI visualization tools and enterprise schedulers desired</span></li> </ol> <p style="margin: 0in 0in 8pt; line-height: 107%; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><strong><u><span style="line-height: 107%;">LICENSES / CERTIFICATIONS:</span></u></strong></span></p> <p style="margin: 0in 0in 8pt; line-height: 107%; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12pt; line-height: 107%; font-family: arial, helvetica, sans-serif;">N/A</span></p> <p style="margin: 0px 0px 7.95pt -0.25pt; line-height: 107%; text-indent: -0.5pt; font-size: 10pt; font-family: Arial, sans-serif; color: #000000;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><em><span style="font-size: 12pt; line-height: 115%; font-family: Aptos, sans-serif;">Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records.</span></em></span></p> <p style="margin: 0px 0px 8pt; line-height: 115%; font-size: 12pt; font-family: Aptos, sans-serif;"><strong><span style="font-size: 10pt; line-height: 115%; font-family: Arial, sans-serif;">THIS JOB DESCRIPTION PROVIDES AN OVERVIEW OF THE GENERAL SCOPE AND LEVEL OF WORK EXPECTED TO BE PERFORMED, BUT IT IS NOT AN EXHAUSTIVE LIST OF ALL DUTIES OR RESPONSIBILITIES ASSOCIATED WITH THE POSITION. THE CREDIT UNION RESERVES THE RIGHT TO MODIFY, ADD, OR REMOVE DUTIES AS NEEDED WITHOUT ADVANCE NOTICE. EMPLOYEES MAY BE REQUIRED TO PERFORM ADDITIONAL TASKS AND DUTIES AS DIRECTED BY THEIR SUPERVISOR, PROVIDED SUCH TASKS ARE WITHIN THE EMPLOYEE’S KNOWLEDGE, SKILLS, AND ABILITIES, OR CAN BE PERFORMED WITH REASONABLE TRAINING. NOTHING IN THIS JOB DESCRIPTION ALTERS THE AT-WILL EMPLOYMENT RELATIONSHIP OR LIMITS THE CREDIT UNION’S RIGHT TO ASSIGN OR REASSIGN DUTIES AND RESPONSIBILITIES TO THIS POSITION AT ANY TIME.</span></strong></p> <p style="margin: 0px 0px 8pt; line-height: 115%; font-size: 12pt; font-family: Aptos, sans-serif;"><strong><span style="font-size: 10pt; line-height: 115%; font-family: Arial, sans-serif;">#LI-Remote</span></strong></p> <p style="margin: 0px 0px 8pt; line-height: 115%; font-size: 12pt; font-family: Aptos, sans-serif; text-align: right;"><strong><span style="font-size: 10pt; line-height: 115%; font-family: Arial, sans-serif;">REV. 1/8/2026</span></strong></p>

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...