Prepare for and practice interview questions from Rangam consultants.

Rangam consultants Interview Questions

Rangam consultants 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

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 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

Rangam consultants Salaries by Position

Pay Scale: $52 to $65 per hour depending on experience Location: Seattle, WA* 100% Onsite Preferred Qualifications:<ul><li>Experience with production and purification of LNPs or molecule of similar nature.</li><li>Degree in biological or chemical engineering, biochemistry, or bio-related field</li><li>Experience with handling of nucleic acids</li><li>Experience with LNP characterization techniques (HPLC, DLS, MALs, NTA, etc.)</li><li>Experience downstream purification of biological molecules (AKTA, chromatography, TFF, viral filtration, etc.)</li><li>Experience with development of continuous processes and implementation process-analytical technologies (PATs)</li><li>Experience with microfluidic technologies</li><li>Experience in the development of other gene delivery or editing materials (e.g. adeno-, retro-, lenti-, RNPs, Cas, mRNA, etc.)</li></ul>The Assoc. Scientist will join the Gene Delivery and Editing Process Development (GDEPD) organization supporting process development for production of lipid nanoparticles (LNPs), which are critical to generating groundbreaking cell therapies.<ul><li>The associate will join the LNP Platform Development team working on initiatives intended to drive next-generation LNP platform development focused on gene editing capabilities.</li><li>Specifically, in the pursuit of end-to-end assessment of novel technologies and approaches, the associate will seek to become highly proficient in developing processes to produce and purify LNPs, while also gaining familiarity with analytical assays for characterization of LNPs.</li><li>The associate will also have the unique opportunity to be exposed to a wide range of other gene editing technologies and will be encouraged to work collaboratively with a range of different groups doing different types of process development.</li></ul>Responsibilities:<ul><li>Execute and troubleshoot process development experiments supporting LNP production and purification.</li><li>Assist in the design of experiments and interpretation of data relating to LNP production and purification.</li><li>Manage the flow of samples and data and perform analyses.</li><li>Optimize workflows for assessing new modes of production and purification.</li><li>Support research-to-development transition endeavors, including early-stage/pipeline molecular assessment activities.</li><li>Actively participate and support lab maintenance and continuous improvement initiatives.</li><li>Maintain accurate and detailed laboratory notebook and documentation.</li><li>Summarize and present data in group meetings and contribute to group discussions and team strategy.</li><li>Author technical reports and study memos.</li></ul>Basic Qualifications: <ul><li>STEM degree with 2+ years of relevant industry experience; title/compensation will ultimately be commensurate with education, experience, and skillset</li><li>Demonstrated and extensive experience with TFF and sterile filtration of biological molecules</li><li>Experience with JMP for DoE design and analyses</li><li>Independently motivated with ability to work in teams</li><li>Ability to communicate clearly and concisely through oral presentation and technical writing.</li><li>Ability to leverage literature, internal and external resources to solve problems</li><li>Desire to identify and advance the cutting edge</li><li>Possess a growth mindset and the ability to thrive in a fast-paced, highly collaborative environment</li></ul>

SourceAbled is seeking Business Analyst candidates for a full time, direct hire position with Freddie Mac. This is located in McLean, VA Only for applicants living in or near McLean, VA will be considered for this position. This position is being offered as part of a neurodiversity program which is designed to provide a more inclusive and supportive hiring process and work environment for job seekers with neurodivergence, which includes, but is not limited to autism, ADD/ADHD, PTSD, OCD, Anxiety Disorder, Dyslexia, Bipolar, and Tourette's Syndrome <ul><li>Candidates must have a bachelor’s degree with graduation in December 2024 - May 2025.</li><li>This position has start dates in January and June 2025.</li><li>Salary range of $58,000 - $88,000 and will be eligible for the annual incentive program.</li></ul> At Freddie Mac, you will do important work to build a better housing finance system and you’ll be part of a team helping to make homeownership and rental housing more accessible and affordable across the nation. Position Overview:Are you looking for an inclusive company culture to ease the transition from college into the workforce? The Single-Family division within Freddie Mac is searching for creative individuals to join our organization. Our Program will involve continuous business and skills training to set you up for success! As part of the Single-Family College Analyst Cohort program, we provide support through mentorship and buddy programs, as well as group activities and best-in-class learning opportunities with senior leadership. Apply now and learn why there’s #MoreAtFreddieMac! Our Impact: <ul><li>Single-Family supports the housing market by providing essential liquidity, promoting responsible lending and sustainable home ownership, and facilitating positive servicing industry change</li><li>Our team is responsible for supporting the activities related to the mortgage loan acquisition, securitization, and servicing processes</li><li>We assist in the integration of our innovative applications and capabilities that enable Freddie Mac and our mortgage lenders to deliver an outstanding borrower experience</li><li>We collaborate with financial institutions, security investors, and Freddie Mac technology teams to assist and support the design, development, and implementation of effective systems</li></ul> Your Impact:<ul><li>You will work across various departments to understand the needs of Single-Family and support the enhancement or development of new business capabilities through data analytics, product development, seller experience, etc.</li><li>Your responsibilities could include documenting business processes, developing business requirements, assisting with project management, performing research and analytics, identifying process improvements, and assisting in operational improvements and risk mitigation</li></ul> Qualifications:<ul><li>Bachelor’s degree in Business Administration, Management, Finance, Economics, Business Statistics, or a related discipline</li><li>Graduation in December 2024 or May 2025 with availability to begin full time employment in January 2025 or June 2025</li></ul> It is the policy of Rangam Consultants, Inc. to provide equal employment opportunities to all applicants and employees without regard to any legally protected status such as race, color, religion, gender, national origin, age, disability or veteran status.

Job Title: Data ArchitectLocation: Cambridge, MA 02141Duration: 6 Months Job Description: Hybrid Role - Local Candidates Only This team is comprised of 8 internal and multiple teams in Digital, depending on the initiatives taken on, on a rolling basis. *Top must-have skills:<ul><li>Minimum 8 years of related experience Data Mesh, domain-driven design Data, Object modeling Database/Data warehouse - AWS RDS, Snowflake, AWS Redshift</li><li>Candidate should have strong communication and presentation skills </li></ul>*Nice-to-have skills:<ul><li>Previous biotech/ pharma experience Master Data Management and Governance Big Data, Data Analytics TOGAF, Architectural frameworks (TOGAF is an architectural framework like ZACHMAN, UAM, others) </li></ul>Description<ul><li>Designs and implements systems and frameworks that can succeed long term (The Data Architect designs Architecture to meet business needs, within the agreed requirements, and are both pragmatic and supportive of the strategic architecture direction)</li><li>Works in close collaboration with Business, Technology and Product stakeholders to contextualize the architecture design</li><li>Verifies the consideration of non-functional requirements as part of the solution architecture</li><li>Designs and produces design documents and solution roadmaps showing the states of transition for the Architecture</li><li>Leverages the existing Portfolio of digital products, catalog of services and promotes the usage of existing building blocks</li><li>Defines and manages standards, guidelines and processes for analytics solutions and architecture, aligning with the broader architecture council</li><li>Remains up to date on IT industry practices and emerging standards</li><li>Recommend emerging technologies for Data Analytics tech stack; optimize existing stack</li><li>Contributes to the prioritization of technology enablers in solution roadmaps</li><li>Be a champion for high-standards to ensure Digital Data Standards for Processes and Technologies are shared and used.</li></ul>Key Functional Requirements & Qualifications:<ul><li>Experience with Agile methodologies, supporting and working with cross-functional teams</li><li>Experience in all phases of a Data lifecycle: concept & design, development, implementation, change and operation</li><li>Demonstrate excellent skills of translating requirements into workable, fit for purpose, technical designs and solutions</li><li>Have extensive experience in technical solution identification and rationalization</li><li>Facilitates design and review sessions to define broad solutions with the big picture in mind</li><li>Ability to understand architectural dependencies of technologies in a vast and complex environment</li><li>Explore how new technologies can be applied to solve challenging business problems and compile architecture decision records (ADRs)</li><li>Desires to work in a fast-paced, constantly evolving environment; ability to manage multiple priorities</li><li>Ability to work independently as well as in a team with a proven ability to influence</li><li>Structured, planned and traceable approach</li><li>Integrity and trust -- unwavering commitment to "doing the right thing"</li><li>Good communication and facilitation skills.</li></ul>Key Technical Requirements & Qualifications:<ul><li>Bachelor’s degree in Computer Science, Information Systems, Software Engineering or similar field</li><li>Strong Experience designing and implementing Enterprise Data & Analytics Architectures</li></ul>Strong background in the areas of Data:<ul><li>Integration Services: Informatica Cloud, Airflow</li><li>Database/Data Warehouse: AWS RDS, Snowflake, AWS Redshift, Knowledge of SQL</li><li>Data modeling: SQLDBM</li><li>BIG Data: Experience with distributed systems (Spark, Hadoop) is a plus</li><li>Data Quality: Informatica CDQ</li><li>Master Data Management: Informatica MDM</li><li>Meta data management/Data Catalog: Informatica EDC</li><li>Data Mesh and domain-driven design</li><li>Data Governance</li><li>Data Security: Experience in working within compliance (e.g.: quality, regulatory – data privacy, GxP, SOX) and cybersecurity requirements is a plus</li><li>Experience in Agile development processes and DevOps methodology / principles:</li><li>Cloud-based services (AWS, Azure)</li><li>Infrastructure as a code (Terraform)</li><li>GIT-based source code management (GitHub) and Continuous Integration and Continuous</li><li>Delivery (CI/CD) practices (GitHub Actions)</li><li>Python, Shell scripting</li><li>Data storage technologies (Object, structured, and unstructured)</li><li>Automating deployment, scaling, and management of containerized applications</li><li>Experience in Data Science/cloud-based machine learning platforms (AWS Bedrock, AWS Sagemaker, Snowflake Cortex etc..,) is a plus.</li></ul>

Shift: Monday – Friday 8:00am – 5:00pm - Hybrid Core Essential Skill sets:<ul><li>Minimum of 2 years experience in Government Pricing calculations</li><li>Prior Government Pricing experience; preferably in processing and reviewing various price types, ie, AMP, BP, ASP</li><li>Strong analytical skills</li><li>Strong excel skills and power point</li><li>A Plus if prior experience in Revitas classic and FLEX</li><li>Organized</li></ul> Position Summary<ul><li>The primary role of the GP Senior Analyst is to perform, validate and submit pricing under the Medicaid Drug Rebate Program, Medicare Modernization Act, and Sections 602 and 603 of the Veterans Healthcare Act, including Average Manufacturer’s Price (“AMP”), Best Price (“BP”), 340B ceiling price (“340B”), Non-Federal Average Manufacturer’s Price (“nFAMP”) and the Federal Ceiling Price (“FCP”).</li><li>The GP Senior Analyst will be responsible for researching/validating data anomalies & variances and must have deep analytical and Excel skills.</li><li>The GP Senior Analyst will support other GP related functions including, but not limited to Federal Supply Schedule (“FSS”) request for modification (“RFM”), public law, 340B audit/non-compliance letters; TX Medicaid COI applications; DDR submissions; product and class of trade maintenance.The GP Senior Analyst requires a strong background in Government Pricing calculations, the 340B and Medicaid.</li><li>They need to be able to work independently, multi-task and manage timelines.</li><li>This position will report to the Senior Manager, Government Pricing Administration.</li></ul>Essential Duties & Responsibilities Percentage of Time<ul><li>Run monthly, quarterly & annual GP price calculations in ModelN GP.</li><li>Perform in-depth analyses to identify data anomalies.</li><li>Responsible for researching/validating prior period variances/trends/outliers.</li><li>Creates summary reports for management review.</li><li>Submit pricing to DDR, VA & other government agencies as required 70%Assist in preparing documents/reports/analysis needed for pre-certification reviews with executive management 20% Assist with annual Public Law 102-585 process including, annual nFAMP, FCP, request for modification (“RFM”)/price proposals 10%</li></ul>Core competenciesAnalysis<ul><li>Uses good analytical and data interpretation skills to analyze and resolve complex problems</li><li>Analyzes processes and systems to improve efficiency and effectiveness through standardization, simplification and automation.</li></ul>Interpersonal Ability<ul><li>Develops and fosters strong relationships with internal and external clients</li><li>Builds reputation for being credible, trustworthy, and fair</li><li>Displays high level of integrity by doing what is right for the company</li></ul>Planning and Organization<ul><li>Committed to meeting deadlines</li><li>Demonstrates sense of urgency by effectively prioritizing workload according to organizational needs</li><li>Demonstrates the ability to manage multiple priorities</li></ul> Technical skills<ul><li>Possesses solid accounting skills particularly around accuracy and internal controls</li><li>Demonstrates advanced data management and Excel skills</li><li>Understands fundamental mechanics of Model N/Revitas CARS/FLEX systems</li><li>Qualifications necessary to perform successfully in this position</li></ul> Education:<ul><li>Bachelor’s degree with emphasis in Business, Finance, Accounting or related fields or equivalent combination of education, training and/or direct work-related experience</li></ul> Experience required:<ul><li>Minimum three (3) + year’s prior experience in Government pricing pharmaceutical/consulting role working with large manufacturers with both brands and generics.</li><li>Hands-on working knowledge of Revitas GP, Flex and SAP.</li><li>Thorough understanding of Government pricing regulations and a hands-on role in the analysis and validation of multiple price types</li></ul>Specialized or Technical :<ul><li>MS Office with a proficiency in MS Excel, Outlook, SAP, Revitas GP</li></ul>

Rangam consultants Interview Questions

Rangam consultants Interview Guides

Rangam consultants Interview Questions

Rangam consultants Salaries by Position

Rangam consultants Opening Jobs