Prepare for and practice interview questions from Iconma.

Iconma Interview Questions

Iconma 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

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

Iconma Salaries by Position

Our Client, a Mutual Insurance Holding Company, is looking for Data Engineer with Python for their Jacksonville, FL/Hybrid location Responsibilities:<ul> <li>Responsible for development, programming, coding of Information Technology solutions using Python to enable Florida Blue Customer Experience applications. </li> <li>Responsible for documentation of the system, conduct unit tests, peer code reviews and maintenance of internally developed applications, evaluation and performance testing of purchased products. </li> <li>Responsible for including IT Controls to protect the confidentiality, integrity, as well as availability of the application and data processed or output by the application. </li></ul> Requirements:<ul> <li>Experience with unit testing, release procedures, coding design and documentation protocol as well as change management procedures</li> <li>Demonstrated organizational, analytical and interpersonal skills</li> <li>Flexible team player</li> <li>Ability to manage tasks independently and take ownership of responsibilities</li> <li>Ability to learn from mistakes and apply constructive feedback to improve performance</li> <li>Must demonstrate initiative and effective independent decision-making skills</li> <li>Ability to communicate technical information clearly and articulately</li> <li>Ability to adapt to a rapidly changing environment</li> <li>In-depth understanding of the systems development life cycle</li> <li>May include database knowledge in; SQL, MySQL, Oracle DB, PostgreSQL, Cassandra, dBase, MS Access, etc</li> <li>Responsible for development, programming, coding of Information Technology solutions using Python</li> <li>Responsible for documentation of the system, conduct unit tests, peer code reviews and maintenance of internally developed applications, evaluation and performance testing of purchased products.</li> <li>Responsible for including IT Controls to protect the confidentiality, integrity, as well as availability of the application and data processed or output by the application.</li> <li>Excellent understanding of RESTful Architecture style.</li> <li>We expect the candidate to have ability to take methodical approach to evaluate various libraries with pros and cons to meet business / technical requirements.</li> <li>Excellent understanding of Python programming mode and required libraries to develop REST API Services.</li> <li>Must have demonstrated experience developing REST APIs using Python.</li> <li>Must have demonstrated experience processing batch files using Python</li> <li>Must have demonstrated experience developing scheduling of batch processes</li> <li>Proficiency using standard desktop applications such as MS Suite and flowcharting tools such as Visio</li> <li>High critical thinking skills to evaluate alternatives and present solutions that are consistent with business objectives and strategy</li> <li>Related Bachelor's degree or related work experience</li> <li>5+ years related work experience, professional experience with technical design and coding in the IT industry</li> <li>UNIX or Linux shell scripting</li> <li>Advanced SQL scripting/querying</li> <li>Working knowledge of PySpark as well as Hadoop environment required</li> <li>Strong focus on working/analysis with very large data sets (millions of records)</li> <li>Technical curiosity and willingness to learn (asks questions, learns processes, data flow, etc.) </li></ul> Preferred qualifications:<ul> <li>The preferred qualifications listed below reflect desired knowledge, skill, and/or experience.</li> <li>Additional Preferred Qualifications:</li> <li>Various Domain experience; Health Care, Financial, etc</li> <li>Experience using Agile, Waterfall, or hybrid methodology</li> <li>Specific tools, languages and specialty skills may vary </li></ul> Why Should You Apply?<ul> <li>Health Benefits</li> <li>Referral Program</li> <li>Excellent growth and advancement opportunities </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.

Our Client, a Healthcare Company, is looking for Business Analyst III for their Remote location Responsibilities:<ul> <li>Responsible for serving as the liaison between the business and IT in translating complex business needs into application software. </li> <li>Primary duties may include but are not limited to: </li> <li>Analyzes complex end user needs to determine optimal means of meeting those needs. </li> <li>Determines specific business application software requirements to address complex business needs. </li> <li>Develops project plans and identifies and coordinates resources, involving those outside the unit. </li> <li>Works with programming staff to ensure requirements will be incorporated into system design and testing. </li> <li>Acts as a resource to users of the software to address questions/issues. </li> <li>May provide direction and guidance to team members and serves as an expert for the team. </li></ul> Requirements<ul> <li>Requires a BS/BA degree, 5-7 years of business analysis experience that includes knowledge of systems capabilities and business operations; or any combination of education and experienced, which would provide an equivalent background.</li> <li>This candidate MUST have HRP experience, preferably in Member & Enrollment. </li> <li>Have working knowledge of EDI and MUST have client facing experience. </li> <li>They must be clear and articulate, be able to negotiate with the client and the delivery team. </li></ul> Why Should You Apply?<ul> <li>Health Benefits</li> <li>Referral Program</li> <li>Excellent growth and advancement opportunities </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.

Our Client, a Software Company, is looking for Business Analyst - II for their Indianapolis, IN location Responsibilities: The analyst will support Client BDRs in generating top-of-funnel sales activities across various industries, managing reporting, conducting event follow-ups, and presenting outcomes to stakeholders. They will manage marketing technology processes, with a focus on maximizing the effectiveness of prospecting. The ability to communicate effectively across several key stakeholder teams is a critical function as well as the ability to analyze data to deliver informed inputs that drive strategy to fuel growth, marketing driven pipeline, and ACV. Analysis and understanding of new business development and reporting of campaign pipeline for effectiveness and results. Manage run-rate marketing tools or technology leveraged by the Business Development teams, such as our automated direct mail and personalized gifting solution. Understand the marketing calendar of events, webinars, and activities coming up and promote them to sales teams. Run standing meetings with Business Development leaders and program managers to review marketing activities and understand asks and priorities of sales. Coordinate and create event follow-up plans and materials to deliver to our Business Development teams. Program management of campaign tactics such as segmentation, campaign creation, email programs, digital campaigns, content creation, and similar demand generation tactics. Collaborate across the extended marketing and sales teams to ensure quality and timely demand generation execution, across all internal & external marketing channels. Budget and Vendor Management. Opening purchase requests related to ongoing programs and tracking against a quarterly budget plan. Assist in data analytics, including but not limited to the development of program metrics, attribution, and overall analytics Requirements: 3-5 years' experience in a role managing and developing integrated marketing campaigns or working directly with Sales/Business Development teams. Knowledge of Client (including internal structure as well as our products & solutions) Preferred experience with Marketing Operations tools such as Tableau CRM and Google Analytics Ability to analyze data to make performance improvements Aptitude to quickly understand systems and technical concepts in order to explain to business partners High energy and the ability to manage multiple initiatives/accounts at one time Track record for delivering results under tight deadlines Experience managing budgets, allocating & optimizing spend Exceptional organizational skills with rigorous attention to detail and strong project management skills Strong verbal, written, presentation, and interpersonal communication skills with the ability to build effective presentations and project plans Ability to lead productive calls, identify decisions made, and clearly state action items 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.

Risk Analyst (Operations, Risk and Audit)<ul> <li>US Wire critical service processes 135m transactions annually with value of ***Tn and enterprise revenues of ***bn+. The payment system is closely monitored and regularly audited by internal and external agencies. This role is critical to wires technology team and will perform the following:</li> <li>•Develop response for various risk and audit issues.</li> <li>Develop overall action plan development process and workflow for various severity of issues.</li> <li>•Develop detailed action plans for issues identified through various channels, such as Operations, Risk and Audit.</li> <li>Develop detailed project plans based on action plans and execute them when necessary</li> <li>Represent operations team to various approval committees and senior management and secure approvals.</li> <li>•Understanding of implementation of payment technology and controls is a must.</li> <li>Collect evidence for closure of issues.</li> <li>Work with appropriate stakeholders for closure of issues.</li> <li>Communicates the target outcomes, coordinates delivery, manages risks, ensures compliance to standards, and provides visibility into the health of the program.</li> <li>Establishes the target outcomes in partnership with the stakeholders and leaders.</li> <li>•Establishes and builds relationships with business and technology leaders across multiple organizations, as well as Compliance and Risk.</li> <li>Coordinates and facilitates the program routines - e.g. kick-off, status reviews, stakeholder meetings, change controls, tollgates, etc.</li> <li>Promotes/facilitates communication and collaboration across organizations to achieve the target outcomes and timeline.</li> <li>•Facilitates dependency management/risk management/impediment removal.</li> <li>Responsible to provide status updates to stakeholders and leadership pertaining to the target outcomes, delivery, risks/issues, and schedule.</li> <li>Ensures that execution is aligned with target outcomes by working with the sponsor/stakeholders.</li> <li>Tracks the success metrics and reviews performance with stakeholders and leadership </li></ul> Required Skills<ul> <li>Develop response for various risk and audit issues.</li> <li>Develop overall action plan development process and workflow for various severity of issues.</li> <li>Develop detailed action plans for issues identified through various channels, such as Operations, Risk and Audit.</li> <li>Develop detailed project plans based on action plans and execute them when necessary.</li> <li>Represent operations team to various approval committees and senior management and secure approvals.</li> <li>Understanding of implementation of payment technology and controls is a must. </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