Prepare for and practice interview questions from Iconma.

Iconma Interview Questions

Iconma Interview Guides

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

Iconma Salaries by Position

<ul>
<li> Materials Management Platform (MMP) is a multi-year transformation initiative aimed at transforming client Materials Requirement Planning & Inventory Management capabilities. </li>
<li> This is part of a larger Industrial Systems IT Transformation effort. </li>
<li> This position responsibility is to design & deploy Data Centric Architecture in GCP for Materials Management platform which would get / give data from multiple applications modern & Legacy in Product Development, Manufacturing, Finance, Purchasing, N-Tier Supply Chain, Supplier Collaboration. </li>
<li> Design and implement data-centric solutions on Google Cloud Platform (GCP) using various GCP tools like Big Query, Google Cloud Storage, Cloud SQL, Memory Store, Dataflow, Dataproc, Artifact Registry, Cloud Build, Cloud Run, Vertex AI, Pub/Sub, GCP APIs. </li>
<li> Build ETL pipelines to ingest the data from heterogeneous sources into our system. </li>
<li> Develop data processing pipelines using programming languages like Java and Python to extract, transform, and load (ETL) data. </li>
<li> Create and maintain data models, ensuring efficient storage, retrieval, and analysis of large datasets. </li>
<li> Deploy and manage databases, both SQL and NoSQL, such as Bigtable, Firestore, or Cloud SQL, based on project requirements </li>
<li> Optimize data workflows for performance, reliability, and cost-effectiveness on the GCP infrastructure. </li>
<li> Implement version control and CI/CD practices for data engineering workflows to ensure reliable and efficient deployments. </li>
<li> Utilize GCP monitoring and logging tools to proactively identify and address performance bottlenecks and system failures. </li>
<li> Troubleshoot and resolve issues related to data processing, storage, and retrieval. </li>
</ul>

Software Engineer Location: Wilmington, NC Duration: 12 Months Description: Responsibilities: Develop, test, and debug software required for the operation of computer systems used to manufacture optical fiber. Support automation and image processing systems Work on interfaces with control and measurement equipment Interact with customers at all levels in Production, Engineering and IT. Required Education & Experience: B.S. in Computer Science, Electrical Engineering or Physics 2+ years of experience developing and maintaining applications using .NET (VB, C#, ASP) Familiar with SQL queries for Oracle or other databases Desired Skills: Knowledge of camera systems Ability/experience with digital image processing and vision systems Familiar with integration of software and electrical hardware Soft Skills (Communication/Team/Leadership): Comfortable working in a team-oriented environment Able to communicate equally well with engineers, production associates, and managers Self-motivated, independent, high initiative As an equal opportunity employer, ICONMA provides an employment environment that supports and encourages the abilities of all persons without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.

Data Engineer Location: Dearborn, MI Duration: 12 months Description: Key Responsibilities: Data Pipeline Development: Design, build, and maintain scalable and robust data pipelines on GCP using tools such as Apache Airflow, Cloud Composer, and Cloud Dataflow. Implement data integration solutions to ingest data from various sources, including cloud storage, and third-party APIs. Data Warehousing: Develop and optimize data warehouse solutions using Big Query and other GCP services. Ensure data accuracy, consistency, and security within the data warehouse environment. Monitor and troubleshoot data pipeline and warehouse issues to maintain system reliability. Cloud Platform Expertise: Utilize GCP services such as Cloud Storage, Cloud Run, and Cloud Functions to build scalable and cost-effective data solutions. Implement best practices for cloud infrastructure management, including resource provisioning, monitoring, and cost optimization. Collaboration and Communication: Work closely with data scientists, analysts, and business stakeholders to understand data requirements and deliver high-quality data solutions. Collaborate with cross-functional teams to design and implement data models, ETL processes, and reporting solutions. Automation and Optimization: Develop automated workflows using Apache Airflow and Astronomer to streamline data processing and improve efficiency. Continuously optimize data pipelines for performance, scalability, and cost-effectiveness. Documentation and Training: Create and maintain comprehensive documentation for data pipelines, data models, and infrastructure components. Provide training and support to team members and stakeholders on data engineering best practices and GCP services. Skills Required: Technical Skills: Proficiency in data pipeline tools and frameworks such as Apache Airflow, Cloud Composer, and Cloud Dataflow. Strong knowledge of GCP services, including Big Query, Cloud Storage, Cloud Run, and Cloud Functions. Experience with SQL, Python, and other programming languages commonly used in data engineering. Familiarity with data modeling, ETL processes, and data integration techniques. Soft Skills: Excellent problem-solving and analytical skills. Strong communication and collaboration abilities. Ability to work independently and as part of a team in a fast-paced, dynamic environment. Experience Required: 5+ years in data warehouse and 2+ years in GCP Education Required: Bachelors in Science Education Preferred: Masters in Science As an equal opportunity employer, ICONMA provides an employment environment that supports and encourages the abilities of all persons without regard to race, color, religion, gender, sexual orientation, gender identity or express, ethnicity, national origin, age, disability status, political affiliation, genetics, marital status, protected veteran status, or any other characteristic protected by federal, state, or local laws.

Overview:Daily engagement with the team and outreach to impacted business operations to help document impacts around processes current and future state. Documenting key design decisions in partnership with solution team. With oversight from the Program Manager.Please rank your preferred top skill sets: (For Example: tools, previous experience, technologies)Must have skills: Process Documentation, mapping, using process design/mapping tools and experience with financial processes/operations documenting requirements.Optional skills: Core financial processes, Workday ERP implementationResponsibilities: The Business Analyst collaborates with the Product Owner on requirements, business value scoring and success metrics. The BA drives the requirements gathering process that accurately reflects business needs which includes: Risk analysis, as is and to be process documentation, agnostic of a specific technical solution. The BA reviews technical solutions for compliance to business process and objectives. The BA coordinates end to end UAT cycle. The BA develops organizational change management framework; communication, training, and post implementation support. The BA also writes business level (feature group/functional success metrics) acceptance criteria.As a Business Analyst, you perform the core duties of a BA and typically work with medium to large BU requests that have issues, requests or projects of moderate scope and complexity. You respond to problems, prioritize correctly, systematically gather information, sort through issues, seek input from others, develop accurate conclusions from findings, and make timely decisions to prioritize and adapt to change.Experience 2-4 years of relevant experience at Client or two to three years of relevant experience elsewhere.As an equal opportunity employer, ICONMA provides an employment environment that supports and encourages the abilities of all persons without regard to race, color, religion, gender, sexual orientation, gender identity or express, ethnicity, national origin, age, disability status, political affiliation, genetics, marital status, protected veteran status, or any other characteristic protected by federal, state, or local laws

Data Scientist III Location: Huntsville, AL/ Kent, WA/ Rocket Park, FL/Hybrid Duration: 6 months Responsibilities: <ul> <li>Building and setting up new development tools and infrastructure to support Client</li> <li>Designing, building, and maintaining efficient, reusable, and tested code in Python and other applicable languages and library tools</li> <li>Working on ways to automate and improve development and release processes</li> <li>Deploying Machine Learning (Client) to large production environments</li> <li>Working towards continuous learning in the AI and computer vision fields</li> <li>Testing and examining code written by others and analyzing results</li> <li>Identifying technical problems and developing software updates and 'fixes'</li> <li>Working with data scientists and software engineers to ensure that development follows established processes and works as intended</li> <li>Share knowledge in performance, scalability, enterprise system architecture, and engineering standard methodologies</li> <li>We are looking for someone to apply their technical expertise, leadership skills, and commitment to quality to impact safe human spaceflight positively.</li> <li>Passion for our mission and vision is required </li></ul>Requirements: <ul> <li>3+ Years of Experience Working in a Data Scientist or Statistician Role</li> <li>Proven expertise in Python, R or Scala</li> <li>Expertise leveraging MLOps methodology in Azure, AWS, or GCP</li> <li>Experience coaching Jr Data Scientists and leading complete data science projects end-to-end</li> <li>Demonstrated experience in developing and deploying statistical learning/machine learning techniques with significant business outcomes</li> <li>Expertise with git/version control and build/release pipelines.</li> <li>Strong theoretical and practical background in NLP including experience with innovative LLM architectures optimized for handling large contexts and low inference cost</li> <li>Proficiency in deep learning frameworks (e.g., PyTorch, TensorFlow, etc.) and libraries commonly used in NLP and Generative AI.</li> <li>Obsession with quality and customer experience - attention to detail coupled with the ability to think abstractly</li> <li>Bachelor's or Master's Degree in Computer Science or a related field, or experience commensurate with education requirements.</li> <li>Ability to earn trust, maintain positive and professional relationships, and strengthen our culture of inclusion </li></ul> Why Should You Apply? Health Benefits Referral Program Excellent growth and advancement opportunities. As an equal opportunity employer, ICONMA provides an employment environment that supports and encourages the abilities of all persons without regard to race, color, religion, gender, sexual orientation, gender identity or express, ethnicity, national origin, age, disability status, political affiliation, genetics, marital status, protected veteran status, or any other characteristic protected by federal, state, or local laws.

Location: Plano, TX/ Chicago, IL/ Atlanta, GA Duration: 3 Months Description: <ul> <li>Candidate will be a member of a team of business analysts, developers, testers and scrum masters.</li> <li>Candidate would have experience in Business Analysis and Requirements documentation.</li> <li>Candidate will support solution development for the following groups involved in the trade lifecycle:</li> <li>Front office</li> <li>Middle office</li> <li>Finance</li> <li>Operations</li> <li>Regulatory and Operational Compliance</li> <li>Risk (market, credit, capital, liquidity, etc...)</li> <li>Candidate would have hands on experience delivering solutions for:</li> <li>Interest Rate Derivatives</li> <li>Foreign Exchange Derivatives</li> <li>Futures</li> <li>Bonds and Securities</li> <li>Secured and Unsecured Money Market Instruments</li> <li>Loans</li> <li>Candidate would have experience as a working member of an agile software development team</li> <li>Candidate would have experience working with teams in geographically diverse locations</li> <li>Candidate would have knowledge on balance sheet and income statements</li> <li>Candidate would be comfortable working in an environment with Python, Java, Angular2 and like solutions.</li> <li>Candidate would have good communication skills and experience working in a cross functional organization.</li> <li>8+ years of experience in Business Analysis and/ or Requirements documentation</li> <li>5+ years of experience working with clients or stakeholder groups to solve problems and design solutions.</li> <li>Experience delivering solutions for Capital Markets.</li> <li>Experience working in an agile software development team.</li> <li>Chartered Financial Analyst (CFA) or Financial Risk Manager (FRM) certification.</li> <li>Experience using Python for data analysis or modeling. </li></ul> As an equal opportunity employer, ICONMA provides an employment environment that supports and encourages the abilities of all persons without regard to race, color, religion, gender, sexual orientation, gender identity or express, ethnicity, national origin, age, disability status, political affiliation, genetics, marital status, protected veteran status, or any other characteristic protected by federal, state, or local laws.

Iconma Interview Questions

Iconma Interview Guides

Iconma Interview Questions

Iconma Salaries by Position

Iconma Opening Jobs