Prepare for and practice interview questions from Moody'S Analytics.

Moody'S Analytics Interview Questions

Moody'S Analytics Interview Guides

<p>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.</p>

<p>How would you assess the validity of the result?</p>


Experiment Validity

<p>You are testing hundreds of hypotheses with many <em>t</em>-tests. What considerations should be made?</p>


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

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?

<p>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.</p>

<p>Write a query to randomly sample a row from this table.</p>

<p><strong>Input:</strong></p>

<p><code>big_table</code> table</p>

<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

Moody'S Analytics Salaries by Position

<p>Experience Level: Experienced HireCategories: Engineering & TechnologyLocation(s): 7 World Trade Center, 250 Greenwich Street, New York, New York, 10007, USLine Of Business: Customer, Operations, & Risk OU(COR OU)Entity: Moody's Analytics(MA)At Moody's, we unite the brightest minds to turn today's risks into tomorrow's opportunities. We do this by striving to create an inclusive environment where everyone feels welcome to be who they are-with the freedom to exchange ideas, think innovatively, and listen to each other and customers in meaningful ways.If you are excited about this opportunity but do not meet every single requirement, please apply You still may be a great fit for this role or other open roles. We are seeking candidates who model our values: invest in every relationship, lead with curiosity, champion diverse perspectives, turn inputs into actions, and uphold trust through integrity.Skills and Competencies Overall experience 5 years. Minimum 4 years of hands-on experience in Salesforce and Apttus/Conga CPQ development - both point-and-click and customizations with focus on Lightning and Lightning Components (Java-script and HTML), Apex, Visual Force, API, Force.com and workflows taking into account force.com best practices and limitations. Apttus/Conga CPQ advanced configuration experience strongly preferred Strong understanding of Saleforce.com platform and best practices in designing data model, security and Apex coding standards. Minimum one year of hands-on development experience in Salesforce Lightning. Strong communication and interpersonal skills with the ability to communicate to both functional and technical teams. Excellent problem solver and independent thinker who has the ability to create innovative solutions. Self-directed, adaptable, flexible, and forward thinking.Education Bachelors or Master's degree in Computer Science or related technical field. Salesforce Developer Certification Desirable. Apttus/Conga CPQ Certification required.Responsibilities The Apttus/Conga CPQ Developer will work on a range of data and technology projects that focus on Quote-to-Cash systems built on Apttus/Conga & Salesforce.com platforms. The Apttus/Conga CPQ Developer will also work as technical lead on highly visible roadmap programs and acquisition integration projects. Apttus/Conga developer and will work closely with product owners, solution architects, testers and DevOps engineers. This role is responsible for translating the business requirements into well-architected solutions that best leverage the Conga/Salesforce platform and products, leading the technical delivery of Conga CPQ implementations including development of custom solutions using Conga CPQ & Salesforce framework. This role requires working closely with business analysts, Quality Assurance teams, Dev Ops Engineers, Moody's sales teams, and various other IT professionals to develop secure, scalable and high quality solutions. Requires performing code reviews for ongoing projects to ensure that code quality is at the highest level possible and appropriate design patterns are being used. Ensure the lead to cash system aligns with company's business processes and collaborate with stakeholders to continually improve and further optimize the system. This role requires staying up to date with the latest product (Conga & Salesforce) updates and features to provide guidance on best practices and new functionalities. Design and develop advanced customizations using Apex, Lightning UI, Conga & Salesforce APIs. Work independently with moderate supervision. Analyze and translate business requirements into functional and technical design. Perform technical fit/gap analysis on the Apttus/Conga CPQ application to support new initiatives and products. Build configurations and customizations on Salesforce, Apttus/Conga Configure Price Quote (CPQ), Contract Lifecycle Management (CLM), and Order Management (OM) components. Drive issue resolution, risk identification and mitigation, and dependency management. Plan and sequence release deployment activities in coordination with Release Management. Develop proof of concepts (POC) on Apttus/Conga, Salesforce, and other AppExchange components and connectors. Mentor team members , review code ,define and maintain coding standards, and guide team members to comply with these standards. Support the company standards for software development (SDLC), compliance, and SOX controls by producing required artifacts and adhering to process and access controls. 40% Development and coding 20% Design & documentation 20% Team collaboration and Meetings 10% Code Review and Mentorship 10% Learning and developmentAbout the teamThe COR (Customer, Operations & Risk) business systems team at Moody's plays a crucial role in enhancing operational efficiency and supporting various business functions. The team manages systems like Salesforce and Apttus CPQ, which are essential for the sales process from lead generation to cash collection. This team also focuses on creating efficiencies across operational processes to modernize the way things are done, ensuring that customer-facing teams can deliver best-in-class operations. The team is part of the broader COR operating unit, which includes other functions like risk management, learning and development, and early career programs.For US-based roles only: the anticipated hiring base salary range for this position is$127,500.00-$184,950.00, depending on factors such as experience, education, level, skills, and location. This range is based on a full-time position. In addition to base salary, this role is eligible for incentive compensation. Moody's also offers a competitive benefits package, including not but limited to medical, dental, vision, parental leave, paid time off, a 401(k) plan with employee and company contribution opportunities, life, disability, and accident insurance, a discounted employee stock purchase plan, and tuition reimbursement.Moody's is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, sex, gender, age, religion, national origin, citizen status, marital status, physical or mental disability, military or veteran status, sexual orientation, gender identity, gender expression, genetic information, or any other characteristic protected by law. Moody's also provides reasonable accommodation to qualified individuals with disabilities or based on a sincerely held religious belief in accordance with applicable laws. If you need to inquire about a reasonable accommodation, or need assistance with completing the application process, please email accommodationsmoodys.com. This contact information is for accommodation requests only, and cannot be used to inquire about the status of applications.For San Francisco positions, qualified applicants with criminal histories will be considered for employment consistent with the requirements of the San Francisco Fair Chance Ordinance.This position may be considered a promotional opportunity, pursuant to the Colorado Equal Pay for Equal Work Act.Click here to view our full EEO policy statement. Click here for more information on your EEO rights under the law. Click here to view our Pay Transparency Nondiscrimination statement.Click here to view our Notice to New York City Applicants.Candidates for Moody's Corporation may be asked to disclose securities holdings pursuant to Moody's Policy for Securities Trading and the requirements of the position. Employment is contingent upon compliance with the Policy, including remediation of positions in those holdings as necessary.Moodys Corporation is a Government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act of 1974, as amended by the Jobs for Veterans Act of 2002, 38 U.S.C. 4212 (VEVRAA), which requires Government contractors to take affirmative action to employ and advance in employment: (1) disabled veterans; (2) recently separated veterans; (3) active duty wartime or campaign badge veterans; and (4) Armed Forces service medal veterans.VEVRAA Federal ContractorWe Request Priority Protected Veteran and Disabled Referrals for all of our locationsPlease contact Donna Hutchinson, Assistant Vice President, Talent Attraction for any questions regarding this listing. Minimum Salary: 30 Maximum Salary: 40 Salary Unit: Other</p>

Moody'S Analytics Interview Questions

Moody'S Analytics Interview Guides

Moody'S Analytics Interview Questions

Moody'S Analytics Salaries by Position

Moody'S Analytics Opening Jobs