Prepare for and practice interview questions from Orange county's credit union.

Orange county's credit union Interview Questions

Orange county's credit union Interview Guides

Let’s say we have a table with an <code>id</code> and <code>name</code> fields. The table holds over 100 million rows and we want to sample a random row in the table without throttling the database.

Write a query to randomly sample a row from this table.

Input:

<code>big_table</code> table

<table>
<thead>
<tr>
<th>Columns</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>

Write a query to randomly sample a row from a big table.

Random SQL Sample

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

What is a key disadvantage of the F-test when compared to multiple t-tests?

What is a key disadvantage of the F-test when compared to multiple t-tests?

Hundreds of Hypotheses

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

Let’s say you work for a social media company that has just done a launch in a new city. Looking at weekly metrics, you see a slow decrease in the average number of comments per user from January to March in this city.

The company has been consistently growing new users in the city from January to March.

What are some reasons why the average number of comments per user would be decreasing and what metrics would you look into?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

Decreasing Comments

How would you investigate a decline in the average number of comments per user?

Orange county's credit union Salaries by Position

<h3>Job Description</h3><div>Job Description<div><div>Exciting Opportunity at Orange County's Credit Union Application Development / Engineering Manager (Core Banking / Symitar / PowerOn) CREDIT UNION’S PURPOSE: Simple Banking. For People, Not Profit.CREDIT UNION’S CORE VALUES: Integrity, Service Excellence, Growth & Development, High Performance, Mutual Respect, Community, and FunWorkplace Excellence. Through our associates' opinions and voices, Orange County's Credit Union is a proud recipient of the Peter Barron Stark Best of the Best Award for highest associate satisfaction in the workplace! As a leading financial service provider with over 80 years of experience serving 123,000+ members, Orange County's Credit Union is currently $2+ billion in assets & growing.Generous benefits including:<ul><li>Anthem Vivity HMO & Delta Care USA Dental - Orange County's Credit Union (OCCU) covers 100% of the associates' monthly premium</li><li>Life insurance at no cost to employee.</li><li>401(k) – OCCU automatically contributes 3% of the employee’s earnings PLUS matches up to 5% of the employee’s contribution (dollar for dollar)</li><li>Vacation hours – 18 days per year and rolls over year to year, and increases with tenure </li><li>Sick hours – 7 days per year and rolls over year to year</li><li>Paid Holidays – 12 days per year plus 3 partial days</li><li>Annual performance merit increases </li><li>Professional and personal development programs, including educational grants up to $2k per year, and step progression opportunities </li><li>Annual discretionary bonus </li><li>Professional, friendly work environment focused on achieving goals, recognizing successes, and excelling at member service.</li></ul>POSITION SUMMARY:The IT Solution Delivery Manager is accountable for the design, build, implementation, and support of vendor packaged and internal custom solutions that support the Credit Union’s core banking platform (Symitar) and other enterprise applications in alignment with our strategic plan and technology roadmap. S/he leads application architecture, design, development, and delivery of business solutions that optimize operational efficiency through technology and automation. Using independent / discretionary judgment and under minimal supervision / direction, this position manages a team of Developers and collaborates with Business Units and internal IT Teams on the delivery of enterprise solutions that support the organization’s operational needs while leveraging product-focused agile solution delivery processes, CI/CD automation and DevSecOps practices. Additionally, s/he will be driving innovation efforts that deliver meaningful growth and operational efficiencies for the Credit Union.In addition to having excellent problem solving skills, solid software engineering discipline, and expertise in Symitar PowerOn, the IT Solution Delivery Manager must be an initiator, self-motivated, creative, agile, accountable, and must be able to balance efficiency with effectiveness. Strong analytical and interpersonal skills are a necessity. ESSENTIAL FUNCTIONS:<ul><li>Work closely with Business and IT leaders to ensure the team’s delivery and focus are in alignment with enterprise strategic goals and objectives.</li><li>Lead solution delivery efforts on enterprise initiatives that require new / enhanced capabilities on core banking platform and related enterprise applications, and manage day-to-day baseline operations for accountable area / systems while ensuring that commitments are properly planned, staffed, monitored, and reported. Coordinate activities and deliverables across multiple teams while resolving issues, removing roadblocks and ensuring priorities are aligned.</li><li>Act as a player-coach by guiding / mentoring engineers and providing hands-on leadership for the architecture, design and development of new core banking solutions as well as day-to-day baseline operations while leading / motivating the team towards common goals and maintaining a high level of performance. </li><li>Partner with Product Management leaders to shape product roadmaps that deliver superior member experience, drive organic growth and improve operational efficiency.</li><li>Continually evaluate emerging technologies to identify opportunities, trends and best practices that can be leveraged to strengthen the Credit Union’s core banking platform and related enterprise applications.</li></ul>Required Qualifications:<ul><li>Bachelor's degree or Master's degree from an accredited college / university in Computer Science, Software Engineering, Information Systems or a related discipline.</li><li>7+ years of hands-on software engineering experience in architecting, designing and delivering enterprise-scale business solutions.</li><li>5+ years of hands-on experience developing, integrating and supporting core banking application (Symitar / RepGen / PowerOn).</li><li>3+ years of leadership and people management experience with an emphasis on coaching, mentoring, guiding and motivating technical team members on project / product delivery and career / professional development.</li><li>3+ years of experience in project leadership, resource planning, and financial management.</li><li>Experience in leading solution delivery efforts in an agile environment with extensive working knowledge of test-driven development (TDD), component-based development (CBD), continuous integration/continuous delivery (CI/CD) and DevSecOps practices.</li><li>Hands-on experience with agile tools (e.g., ClickUp, Jira, Confluence, Microsoft DevOps), Gitlab, Postman, Elasticsearch, RabbitMQ, SSO, OAuth, cloud (AWS and Azure) services, and relational database (such as Microsoft SQL Server).</li><li>Proficiency in modern development technologies like .NET, C#, C++, Java, JavaScript.</li><li>Working knowledge of / experience in on-premises and cloud architecture, design patterns, container technology, orchestration services, event-driven microservices (REST / SOAP or JSON / XML), micro frontends, API management / gateway.).</li></ul>The targeted annual salary range is $140,000.00 to $155,000.00. Final offer will be determined based on experience, education, training/certifications and specialized skills.We perform thorough background checks, credit checks and pre-employment drug screening. EOE</div></div></div>

<h3>Job Description</h3><div>Job Description<div><div>Orange County’s Credit Union is hiring: Technical Business Analyst II.Why Orange County's Credit Union? With over 85 years of experience, serving 123,000+ members, and managing $2.5+ billion in assets, we are a premier financial service provider. Our mantra, "Putting People First: Connect, Discover, Deliver & Wow!" is not just a saying—it’s a way of life. On our team. You’ll work closely with leadership to ensure our projects are aligned with our mission to put people first. What We Offer:<ul><li>Base Pay: Final offer will be determined based on experience, education, training/certifications and specialized skills.</li><li>Comprehensive Benefits: Medical, Dental, and VSP effective day one of employment!</li><li>Financial Security: Enjoy peace of mind with life insurance at no cost to you and a robust 401(k) plan where we contribute up to 8%.</li><li>Work-Life Balance: Generous days of vacation, seven (7) sick days per year, and paid holidays, you’ll have the time to recharge and pursue your passions.</li><li>Growth Opportunities: We believe in your professional and personal development, offering educational grants up to $2,000 per year, step progression opportunities, and annual performance merit increases.</li><li>Rewarding Work: Annual discretionary bonus and a supportive work environment that celebrates achievements and fosters collaboration.</li><li>Make a Difference with Us! If you’re looking for a rewarding role where you can contribute to a positive work environment and make a difference in the community, we’d love to hear from you. Apply today and join a team that puts people first, values your expertise, and supports your growth.</li></ul>POSITION SUMMARY:Under general supervision, has a leading support role in the building, integration, and maintenance of custom-built software applications and integrations used by both Associates and our Members. The Technical Business Analyst II will act as the bridge between business and technology, working with various business stakeholders to capture user stories and requirements and translating those requirements into functional and technical specification. This position works in close collaboration with the Product Management team and the Software Engineering and Quality Assurance teams to support the evolution of our digital platforms.ESSENTIAL FUNCTIONS:<ul><li>Collaborate with business stakeholders to identify opportunities to improve systems and processes.</li><li>Analyze and document current and future business processes, using wireframes, user stories, and formal business requirements documentation to do so, and identify and recommend areas of potential improvement.</li><li>Interact with Product Teams to ensure functional requirements are sound, complete and consumable by the software engineering and quality assurance teams. This includes ensuring the requirements meet the strategic goals of the organization.</li><li>Communicate business requirements to technical team, and assist with defining appropriate technical requirements to implement proposed solutions.</li><li>Facilitate regular Scrum activities, which include leading daily stand-up meetings, manage the team’s sprint backlog, promote the removal impediments that block team members from completing tasks, and conduct sprint retrospective meetings.</li><li>Manage assigned service requests, closely track status, and help prioritize work in order to meet deadlines.</li><li>Perform and facilitate white box and black box quality assurance testing of code changes to ensure behavior matches documented requirements. To support quality assurance testing, create and maintain regression test scripts.</li><li>Assist with system support and troubleshooting of supported applications.</li><li>Construct workflow charts and wireframes for applications; studying system capabilities; writing specifications.</li><li>Proactively help identify and resolve production-related system issues, as well as coordinate application maintenance activities in accordance with the organizations systems development lifecycle.</li></ul>ASSOCIATE EXPECTATIONS:<ul><li>Consistently practices the Service Philosophy of “Put People First” exercising the Connect, Discover, Deliver & Wow components in every encounter with internal and external members, creating extraordinary experiences. </li><li>Displays behavior that matches the value of Mutual Respect by relating favorably at all levels within the organization.</li></ul>QUALIFICATIONS:Experience/ Training/ Education:<ul><li>BS in Information Systems, or equivalent work experience.</li><li>3-5 years of experience as a Business Analyst in a technical role, or related certification.</li><li>3-5 years of experience in software analysis and design or technical business analysis with requirements gathering and formal documentation experience.</li><li>Financial industry operations experience, particularly within a credit union, preferred</li></ul>Knowledge/ Skills/ Abilities:<ul><li>Strong analytical skills</li><li>Excellent oral and written communication skills with proven ability to understand and explain issues from both a technical and a business functional perspective. </li><li>Must have personal computer skills and be proficient with Microsoft programs (Word, Excel, Outlook)</li><li>Detailed knowledge of the Agile Scrum Software Development Lifecycle activities and practices, and the ability to facilitate Scrum activities. Experience with tools such as Jira, Confluence, Gitlab, Azure DevOps, ClickUp, Microsoft 365, and Teams</li><li>Demonstrated ability to create wire-frames, user stories, process workflows, and business requirements documentation. Experience with Figma is highly desirable.</li></ul>The targeted hourly range is $40.00 Per Hour to $48.00 Per Hour. Final offer will be determined based on experience, education, training/certifications and specialized skills.We perform thorough background checks, credit checks and pre-employment drug screening. EOE</div></div></div>

Orange county's credit union Interview Questions

Orange county's credit union Interview Guides

Orange county's credit union Interview Questions

Orange county's credit union Salaries by Position

Orange county's credit union Opening Jobs