Prepare for and practice interview questions from Atr International.

Atr International Interview Questions

Atr International Interview Guides

Let’s say that your company is running a standard control and variant AB test on a feature to increase conversion rates on the landing page. The PM checks the results and finds a .04 p-value.

How would you assess the validity of the result?

Experiment Validity

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?

Atr International Salaries by Position

1 year contract Hybrid in Cupertino, CA (3 days onsite weekly)Large client in IT industryW2 Candidates OnlyJob Description: We are looking for a software engineer who is passionate about developing innovative product features and human-computer interactions. We are looking for candidates with expertise inembedded systems programming, edge and on-device implementations of algorithms, Frameworks, and experience in time-series data. Requirements:MINIMUM QUALIFICATIONS:• Expert in Swift, Objective-C, C++, or similar systems programming languages• Experience building libraries, frameworks, testing/automation, and command-line tools• Experience building iOS and watchOS apps with basic UI/UX design• Strong grasp of companies development APIs (UIKit, Cocoa, etc.)• Strong understanding of object-oriented design, data structures, algorithm design, complexity analysis, performance analysis, problem solving and diagnosis• Deep understanding of multi-threaded programming and synchronization• Past experience in creating high-performance implementations of deep learning algorithms• Proficiency in Python programming• Able to communicate clearly and collaborate with cross-functional teams• Excellent problem solving and root cause analysis skills• 2+ years of software engineering experience PREFERRED QUALIFICATIONS:• Demonstrated ability to quickly learn and modify large, existing codebases• Experience designing high performance software and algorithms for resource constrained embedded systems• Experience with on-device machine learning, deep learning, and using sensor data to power novel use cases and applications• Experience in human computer interaction (HCI) space• Experience with signal processing, such as applying filtering to noisy signa

12 month Contract to hireHybrid in Chicago, IL (3 days onsite weekly)Large client in banking industry Will work with Hyland Onbase software as an SME and implementing within a large bank. Will work in correlation with USCIS and the government. Hyland onbase software experience required. 1. Solution/project planning;2. Solution discovery;3. Solution documentation;4. Solution design;5. Solution implementation;6. Solution testing; and7. Solution support.

6 month contract to hireHybrid in Palo Alto, CA (3 days onsite weekly)Large client in banking industryW2 Candidates OnlyJob Description: Neuron (aka GFC Modernization) is getting architected as distributed system to be deployed in private cloud and requires experienced engineers for transforming to next-gen platform. It is one of the key foundational work and needs to be finalized in early stage for build-out. It has been challenging to find right candidate as FTE in US. In process of delivering Neuron MVP this year, An cloud engineer needs to be on boarded asap. Job DescriptionAs a member of our Software Engineering Group you will dive head-first into creating innovative solutions that advance businesses and careers. You’ll join an inspiring and curious team of technologists dedicated to improving the design, analytics, development, coding, testing and application programming that goes into creating high quality software and new products. You’ll be tasked with keeping the team and other key stakeholders up to speed on the progress of what’s being developed. Coming in with an understanding of the importance of end-to-end software development-such as Agile frameworks-is key. And best of all, you’ll be working with and sharing ideas, information and innovation with our global team of technologists from all over the world. Requirements:• BS/BA degree or equivalent experience• Advanced knowledge of application, data and infrastructure architecture disciplines• Understanding of architecture and design across all systems• Developing distributed system using Java/RX Java, Kafka, distributed cache and Cockroach DB.• Expertise in Spring Framework, GraphQL and Micro-services architecture to build secure and data resilient system with strong communication skills• Working experience with cloud infrastructure, Kubernetes, S3, compute etc.• Ability to collaborate with high-performing teams and individuals throughout the firm to accomplish common goals• Must be able to assess the current state data model and recommend target state.• Expertise in designing system for immediate consistency and highly performant real-time aggregation• Experience with Splunk, Grafana, Open Telemetry, Dynatrace etc.

Sr Product Associate Promote innovation in product development, user research, and analysis to shape and optimize our offerings. Unleash your expertise in product development and optimization by leveraging user research, analyzing metrics, and collaborating across one of the worlds most innovative financial organizations. As a Senior Product Associate in the Service Product Group, you contribute to the team by leveraging your expertise in product development and optimization to make a significant impact, supported by user research and customer feedback to fuel the creation of innovative products and continuously improve existing offerings. Collaborate closely with cross-functional teams and play a crucial role in shaping the future of our products and ongoing success. Consumer & Community Banking (CCB) Operations Product organization provides critical cross line of business support across the bank and serves as one of the largest product portfolios in CCB, delivering value to millions of customers and over 30,000 employees. As a product team member, your problem-solving skills will place you on the cutting edge of defining the vision, creating the strategy and building the roadmap to solutions that impact millions. Along the way, youll develop a deep, end-to-end understanding of the business and find an inclusive culture that welcomes diverse ideas and supports your individual growth and career mobility. Job responsibilities Partners with the Product Manager to identify new product opportunities that reflect the needs of our customers and the market through user research and discovery Considers and plans for upstream and downstream implications of new product features on the overall product experience Supports the collection of user research, journey mapping, and market analysis to inform the strategic product roadmap and provide insight on potential product features that provide value to customers Analyzes, tracks, and evaluates product metrics including work to time, cost, and quality targets across the product development life cycle <ul><li> Writes the requirements, epics, and user stories to support product development </li></ul> Required qualifications, capabilities, and skills 3+ years of experience or equivalent expertise in product management or a relevant domain area Proficient knowledge of the product development life cycle Experience in product life cycle activities including discovery and requirements definition Developing knowledge of data analytics and data literacy Must have the ability easily assimilate information and learn new applications and processes and ability to analyze complex system requirements and present findings to both Effective presentation and interpersonal skills; proficient skills in communicating ideas both written and verbal Preferred qualifications, capabilities, and skills Experience, ideally in project management, process re-engineering, strategy, or customer-centric functions and working with global teams Experience with agile product development and software delivery lifecycle; advanced knowledge of using tools like Confluence and JIRA; Agile/Scrum certifications a plus Proven track record of delivery and new product feature creation; effective communicator with excellent written communication skills including requirements writing Familiarity with the business services and offerings associated with financial services and understanding of the financial services industry and Regulatory, Legal, and Risk environments

We are seeking a Financial Reporting Analyst for a very important client Job Description Risk Reporting & Middle Office (RRMO), a group within Corporate Risk is responsible for reporting and analysis to internal Risk Management and to Regulators monitoring controls and the quality of risk data, and is accountable for the management and execution of key reporting projects Examples of the group's work include the preparation of periodic overviews of Firmwide VaR and Economic Stress Tests results for the Firm's Board of Directors Producing daily, weekly & monthly risk/ financial overview reports which are used by the Firm's most senior management to monitor risk profiles Reporting the Firm's external disclosures includes quarterly Press Release, and Form 10-Q/10-K filings The group also has project management responsibilities for major projects within and outside the group. This role is part of the RRMO group and lies specifically within the Market Risk Reporting team in NA region It is an ideal opportunity for someone keen, enthusiastic, and curious to learn or expand knowledge of market risk management and reporting technologies in one of the leading global financial services firms As an Analyst within the Market Risk Reporting team, you are expected to manage below responsibilities. Responsibilities •Report Production and Development oProduction of periodic Market Risk reports and metrics, including regulatory reporting oProactively identifying control gaps and improve controls as well as resolve issues oContribute to identifying and executing on opportunities to streamline processes oContribute to developing new reports or metrics to meet internal or external requirements oSupport the control processes through periodic review of the reports and maintain relevant documentation •Cross-Functional Collaboration oPartner with cross functional teams and lines of business, mainly Market Risk Coverage, Product Controllers, Technology, Compliance and Audit to collaborate on report production, data testing, and projects oContribute to the implementation of key business decisions and change efforts oCommunicate effectively to all levels of executive management and peers •Teamwork oParticipate in multiple projects and reporting needs by working with teams across the globe Requirement: Qualifications •Require an individual with strong analytical skills •Keen attention to details and self-review work •Ability to multitask, think independently and make continuous progress towards meeting business objectives •BA or BS degree preferably in Finance/Business Top 4: 1 Quick learner 2 Proficient in Excel and experience with other reporting software (Tableau and/or Alteryx experience an added advantage) 3 Can think outside the box and work independently with manager's guidance 4 Can communicate at senior manager level Disqualifiers: Low reporting technology experience, Cannot work 60% of the time from the office, Cannot communicate well up to senior manager level "Typical" day: Report production, data analysis, research, control review of reports and processes, respond to stakeholder requests. Stand Out Experience: Excel Proficiency Experience with other reporting software (Tableau, COGNOS, Alteryx) Financial services experience in financial reporting

Sr Product Associate Promote innovation in product development, user research, and analysis to shape and optimize our offerings.Unleash your expertise in product development and optimization by leveraging user research, analyzing metrics, and collaborating across one of the world’s most innovative financial organizations. As a Senior Product Associate in the Service Product Group, you contribute to the team by leveraging your expertise in product development and optimization to make a significant impact, supported by user research and customer feedback to fuel the creation of innovative products and continuously improve existing offerings. Collaborate closely with cross-functional teams and play a crucial role in shaping the future of our products and ongoing success. Consumer & Community Banking (CCB) Operations Product organization provides critical cross line of business support across the bank and serves as one of the largest product portfolios in CCB, delivering value to millions of customers and over 30,000 employees. As a product team member, your problem-solving skills will place you on the cutting edge of defining the vision, creating the strategy and building the roadmap to solutions that impact millions. Along the way, you’ll develop a deep, end-to-end understanding of the business and find an inclusive culture that welcomes diverse ideas and supports your individual growth and career mobility. Job responsibilities· Partners with the Product Manager to identify new product opportunities that reflect the needs of our customers and the market through user research and discovery· Considers and plans for upstream and downstream implications of new product features on the overall product experience· Supports the collection of user research, journey mapping, and market analysis to inform the strategic product roadmap and provide insight on potential product features that provide value to customers· Analyzes, tracks, and evaluates product metrics including work to time, cost, and quality targets across the product development life cycle<ul><li>· Writes the requirements, epics, and user stories to support product development</li></ul> Required qualifications, capabilities, and skills· 3+ years of experience or equivalent expertise in product management or a relevant domain area· Proficient knowledge of the product development life cycle· Experience in product life cycle activities including discovery and requirements definition· Developing knowledge of data analytics and data literacy· Must have the ability easily assimilate information and learn new applications and processes and ability to analyze complex system requirements and present findings to both· Effective presentation and interpersonal skills; proficient skills in communicating ideas both written and verbal Preferred qualifications, capabilities, and skills· Experience, ideally in project management, process re-engineering, strategy, or customer-centric functions and working with global teams· Experience with agile product development and software delivery lifecycle; advanced knowledge of using tools like Confluence and JIRA; Agile/Scrum certifications a plus· Proven track record of delivery and new product feature creation; effective communicator with excellent written communication skills including requirements writing· Familiarity with the business services and offerings associated with financial services and understanding of the financial services industry and Regulatory, Legal, and Risk environments

We are seeking a Business Analyst Advanced for a very important client CCB Operations provides critical cross-line of business support across the Company and serves as one of the largest product portfolios in CCB. Our portfolio consists of 11 product groups that develop a wide range of cross-functional platforms and capabilities, delivering value to millions of customers and over 30,000 employees As a product team member, your problem-solving skills will place you on the cutting edge of defining the vision, creating the strategy and building the roadmap to solutions that impact millions Along the way, you'll develop a deep, end-to-end understanding of the business and find an inclusive culture that welcomes diverse ideas and supports your individual growth and career mobility. Description CCB Service Product Group (SPG) is responsible for delivering end-to-end service journeys through modernized applications that allow for a seamless customer experience across channels and lines of business How we deliver is equally as important as what we deliver The Strategy team within SPG provides support on a variety of initiatives by gathering and analyzing information about modules and workflows, identifying areas for improvement, and executing controls This role will expose you to what SPG is launching and will allow you to enhance your analytical research and reporting skills We will use research, customer data, modeling and advanced analytics to understand all we can about customer behaviors and preferences We will use end-to-end process mapping to understand delighters and drivers of dissatisfaction We will use design thinking, emerging technologies and agile development to create and deploy outstanding experiences to our customers We will dramatically improve the customer experience and reduce the Company's cost and time to serve Our team will own the identification and design of the Journey, meaning we will design it in partnership with product, channel, and others across the Company, and then ensure delivery across the same centers of excellence. The Role Key responsibilities of the Strategic Business Analyst role include: Executing research on current state experiences and providing output recommendations to business partners for execution, prior to module build Conducting deep dive analysis into voice of the customer channels (listen to calls, read complaints and social media, etc) to gather insights and root cause of journey friction points Acting as a project manager of Pre-Initiate, owning documentation and follow-ups required for delivery tollgates Leading the Identification and Design stage of the Journey to identify initiatives which will improve the customer, specialist or banker's end-to-end experience Documenting the customer's journey today, including ability to map it and articulate break points, and ownership of outputs through design Setting direction and expectations while moving initiatives through the ideation lifecycle Communicating progress, status, issues, decisions on regular cadence Interfacing with other execution efforts cross impacting the journey scope Requirement: The ideal candidate will possess the following qualifications: Qualifications, Skills and Behaviors of the Successful Candidate: Minimum of 3-5 years' work experience, ideally in project management, process re-engineering, strategy, or customer-centric functions Focus on customer experience enhancements and communications Aware and comfortable operating in an Agile environment Strong understanding of the financial services industry and Regulatory, Legal, and Risk environments Strong communication skills - both written & verbal - with ability to quickly solve problems and present ideas and results to multiple stakeholders superior verbal and interpersonal skills Strong leader, comfortable in a deadline-driven, fast-paced environment, with flexibility and willingness to adapt and change course as needed Known for being a thought leader and engaged, flexible partner and listener willingness to contribute on projects outside his/her scope Consultative approach with the ability to interact, influence, and communicate effectively with all levels of the organization Excellent organizational skills with the ability to prioritize and identify big ideas Ability to build, drive & motivate teams of various sizes without direct line reporting responsibilities Analytical, leadership, communications, and problem-solving skills

We are seeking a Business Analyst Advanced for a very important client CCB Operations provides critical cross-line of business support across the Company and serves as one of the largest product portfolios in CCB. Our portfolio consists of 11 product groups that develop a wide range of cross-functional platforms and capabilities, delivering value to millions of customers and over 30,000 employees As a product team member, your problem-solving skills will place you on the cutting edge of defining the vision, creating the strategy and building the roadmap to solutions that impact millions Along the way, you'll develop a deep, end-to-end understanding of the business and find an inclusive culture that welcomes diverse ideas and supports your individual growth and career mobility. Description CCB Service Product Group (SPG) is responsible for delivering end-to-end service journeys through modernized applications that allow for a seamless customer experience across channels and lines of business How we deliver is equally as important as what we deliver The Strategy team within SPG provides support on a variety of initiatives by gathering and analyzing information about modules and workflows, identifying areas for improvement, and executing controls This role will expose you to what SPG is launching and will allow you to enhance your analytical research and reporting skills •We will use research, customer data, modeling and advanced analytics to understand all we can about customer behaviors and preferences •We will use end-to-end process mapping to understand delighters and drivers of dissatisfaction •We will use design thinking, emerging technologies and agile development to create and deploy outstanding experiences to our customers •We will dramatically improve the customer experience and reduce the Company's cost and time to serve Our team will own the identification and design of the Journey, meaning we will design it in partnership with product, channel, and others across the Company, and then ensure delivery across the same centers of excellence. The Role Key responsibilities of the Strategic Business Analyst role include: •Executing research on current state experiences and providing output recommendations to business partners for execution, prior to module build •Conducting deep dive analysis into voice of the customer channels (listen to calls, read complaints and social media, etc) to gather insights and root cause of journey friction points •Acting as a project manager of Pre-Initiate, owning documentation and follow-ups required for delivery tollgates •Leading the Identification and Design stage of the Journey to identify initiatives which will improve the customer, specialist or banker's end-to-end experience •Documenting the customer's journey today, including ability to map it and articulate break points, and ownership of outputs through design •Setting direction and expectations while moving initiatives through the ideation lifecycle •Communicating progress, status, issues, decisions on regular cadence •Interfacing with other execution efforts cross impacting the journey scope Requirement: The ideal candidate will possess the following qualifications: Qualifications, Skills and Behaviors of the Successful Candidate: •Minimum of 3-5 years' work experience, ideally in project management, process re-engineering, strategy, or customer-centric functions •Focus on customer experience enhancements and communications •Aware and comfortable operating in an Agile environment •Strong understanding of the financial services industry and Regulatory, Legal, and Risk environments •Strong communication skills - both written & verbal - with ability to quickly solve problems and present ideas and results to multiple stakeholders superior verbal and interpersonal skills •Strong leader, comfortable in a deadline-driven, fast-paced environment, with flexibility and willingness to adapt and change course as needed •Known for being a thought leader and engaged, flexible partner and listener willingness to contribute on projects outside his/her scope •Consultative approach with the ability to interact, influence, and communicate effectively with all levels of the organization •Excellent organizational skills with the ability to prioritize and identify big ideas •Ability to build, drive & motivate teams of various sizes without direct line reporting responsibilities Analytical, leadership, communications, and problem-solving skills

Atr International Interview Questions

Atr International Interview Guides

Atr International Interview Questions

Atr International Salaries by Position

Atr International Opening Jobs