Prepare for and practice interview questions from Intraedge.

Intraedge Interview Questions

Intraedge 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

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?

Intraedge Salaries by Position

We have an opening for Data Engineer role with a focus on building pipelines, data quality, governance, and transformation using the required tools: Job Title: Data Engineer (DBT & Snowflake specialist)Location: Pune or Remote (immediate Joining or 1 month)Job Type: Full-timeExp Level- 3 To 9 years Data Engineering, building pipelines, SQL, Informatica Data Quality, Informatica Data Governance, Informatica Lineage, S3, Experience in data modelling, and Transformation using DBT & Snowflake is must Overview:We are seeking a highly skilled and motivated Data Engineer to join our team. The successful candidate will have strong experience in building data pipelines, managing data quality and governance using Informatica tools, and transforming data with modern frameworks like DBT (Data Build Tool). This role will be responsible for ensuring data integrity, building efficient ETL/ELT pipelines, and collaborating with cross-functional teams to meet business goals.Key Responsibilities:<ul><li>Build and Maintain Data Pipelines:</li><li>Design, develop, and implement scalable and efficient data pipelines for ingestion, processing, and transformation of structured and unstructured data from various sources.</li><li>Optimize and automate workflows for data extraction, transformation, and loading (ETL/ELT).</li><li>Data Quality and Governance:</li><li>Implement and maintain data quality frameworks using Informatica Data Quality tools to ensure data integrity, accuracy, and reliability.</li><li>Collaborate with the data governance team to define and enforce policies for data security, privacy, and compliance using Informatica Data Governance and Informatica Lineage.</li><li>Data Modeling and Transformation:</li><li>Develop and maintain scalable and efficient data models to support analytics and reporting needs.</li><li>Use DBT (Data Build Tool) to perform data transformations, ensuring the data is well-structured and optimized for analysis. Experience using Snowflake is must.</li><li>Cloud Infrastructure:</li><li>Manage and optimize data storage solutions on Amazon S3, ensuring cost-effective and secure data storage.</li><li>Collaborate with cloud and DevOps teams to ensure smooth integration and deployment of data solutions.</li><li>Collaboration and Reporting:</li><li>Work closely with business analysts, data scientists, and stakeholders to understand data requirements and deliver solutions that meet business objectives.</li><li>Produce documentation and reports on data flows, models, and quality metrics to ensure transparency and accountability.</li></ul>Key Qualifications:<ul><li>Experience:</li><li>5+ years of experience in data engineering, building data pipelines, and managing large datasets.</li><li>Hands-on experience with SQL for querying and transforming data.</li><li>Experience with Informatica Data Quality, Informatica Data Governance, and Informatica Lineage for ensuring data accuracy and compliance.</li><li>Proven experience working with Amazon S3 for data storage and retrieval.</li><li>Strong experience in data modeling and transformation using DBT (Data Build Tool) & Snowflake</li><li>Skills:</li><li>Proficient in designing and maintaining data pipelines using modern data tools and frameworks.</li><li>Strong knowledge of data management best practices, including data quality, governance, and security.</li><li>Experience with cloud-based data platforms, preferably AWS.</li><li>Excellent problem-solving skills and attention to detail.</li><li>Strong communication skills and ability to work in a collaborative environment.</li><li>Education:</li><li>Bachelor's degree in Computer Science, Information Systems, or a related field.</li></ul>

Data AnalystUK Burgess Hill LocationGood combo skills below (specifically C360) & excellent comm skills. Analysis <ul><li>Analyse and identify Source System requirements from C360 Backlog </li><li>Involvement and at times ownership of Source System Engagement </li><li>Analysis of Source System Data </li><li>Identify valuable data (Insight opportunities for future use as well as value related to backlog use cases) </li><li>Own an engagement; from analysis, documentation, conclusion and communicating the result back to stakeholders </li><li>Identify key PII fields and related colleague privacy impacts </li><li>Investigate and resolve data issues from a product perspective </li><li>Pro-actively explores data and comes up with use cases or newly discovered insights </li></ul> Testing <ul><li>Defines expected results in collaboration with Data Ingestion & Tableau Team </li><li>Validates Source System data (end to end), business rule application and data transformation through to Tableau </li></ul> Product Delivery <ul><li>Identify risks, challenges, and opportunities </li><li>Involvement in the Engagement, backlog and prioritisation process </li><li>Writes definition transformation/business rules for source system data and stories for data needs for tableau work in collaboration with PO </li><li>Co-manages content to be displayed in our insight application DDX in collaboration with PO </li><li>Assist in data extraction as per requirement in engagements </li></ul> Compliance <ul><li>Keeps Colleague Privacy and protection of Colleague Data in the forefront of everything they do </li><li>Works with and supports the Colleague 360 Compliance Manager in:- </li><li>Researching data usage impact related to Colleague Privacy </li><li>Defines and presents Colleague 360 Data usage to Compliance Stakeholder (Global Privacy, Colleague Privacy, Colleague Labor Relations, GCO, Data Privacy Office) </li><li>Completes and drives Compliance documentation for alignment and approval (Privacy Impact Assessment, Data Privacy Impact Assessment, </li><li>Provide data analysis and/or documentation to support process and/or audit activities </li></ul> Skillset The successful candidate for this position must be a proven self-starter with the ability to manage multiple priorities for various stakeholders. In addition, the candidate must possess the following skill set: <ul><li>Strong written and verbal communication skills combined with an ability to comprehend, collect, and communicate complex information, policies and procedures and adjust the message accordingly based on the audience </li><li>Passionate about the role data can play in improving our colleague’s life. </li><li>Previous experience of working/analysing complex datasets with the ability to identify unrecognised value and maintaining attention to detail </li><li>Proficient with SQL </li><li>Basic understanding of tools such as Python, Jupyter Notebook, Spark SQL </li><li>Experience conducting statistical analysis, including and not limited to hypothesis testing, regression analysis, t-test, correlation analysis & factor analysis </li><li>Experience working within Agile project management frameworks is a plus </li><li>Strong understanding of data governance principles and standards </li><li>Outstanding analytical thinker and problem solver, comfortable working with data and able to drive resolution to complex problems/use cases </li><li>Strong skills in the use of Excel and some competency in SharePoint, PowerPoint, Confluence are preferred. </li><li>Experience with Jira would be advantageous but training will be provided </li><li>Basic knowledge of Tableau/ Power BI, or willingness to learn </li><li>Any understanding of Colleague Privacy would be an advantage but training will be provided </li><li>Proven ability to quickly adjust to shifting priorities, multiple demands, ambiguity and rapid change </li><li>Able to challenge the status quo and drive creative ideas and solutions </li><li>Basic understanding of software development, testing and deployment (Solution Delivery Lifecycle) principles </li><li>Recognizes the importance of teamwork to achieve objectives </li><li>Adapts to change quickly and easily </li><li>Knows when to escalate decisions and when to make on the spot decisions </li><li>Interest in growing the product management muscle </li></ul> Immediate - 2 weeks joiners preferred.

Job Summary: Backend or Frontend Java ProfessionalWe are seeking a highly skilled and motivated Java Developer to join our team. The ideal candidate will have a strong background in Java development, be proficient in designing and implementing complex software solutions, and possess excellent problem-solving abilities. This role requires the ability to work both independently and as part of a team, with a focus on delivering high-quality, maintainable, and scalable software.Location - Chennai Mode - HybridNotice Period - Immediate or maximum 30 Days (Serving Notice period) Key Responsibilities:<ul><li>Design and Development: Develop, test, and maintain robust, scalable, and efficient Java applications.</li><li>Code Quality: Write clean, maintainable, and efficient code, adhering to coding standards and best practices.</li><li>Requirement Analysis: Collaborate with stakeholders to gather and analyze requirements, and translate them into technical specifications.</li><li>System Integration: Integrate software components into a fully functional software system.</li><li>Performance Tuning: Optimize application performance, including profiling and troubleshooting to identify and fix bottlenecks.</li><li>Testing and Debugging: Perform unit and integration testing, and debug existing software to ensure reliability and performance.</li><li>Documentation: Create and maintain documentation for code, processes, and procedures.</li><li>Collaboration: Work closely with other developers, architects, and QA teams to ensure successful project delivery.</li><li>Continuous Improvement: Stay up-to-date with industry trends and technologies to ensure continuous improvement of software development practices.</li></ul>Required Qualifications:<ul><li>Education: Bachelor’s degree in computer science, Engineering, or a related field.</li><li>Experience: Minimum of [5] years of experience in Java development.</li></ul> Technical Skills:<ul><li>Proficiency in Java J2SE/J2EE with Kotlin</li><li>Experience with frameworks such as Spring, Hibernate, or Struts.</li><li>Knowledge of web technologies including HTML, CSS, JavaScript, and RESTful APIs.</li><li>Familiarity with database systems (SQL, NoSQL) and ORM technologies.</li><li>Understanding of version control systems (e.g., Git).</li><li>Soft Skills:</li><li>Strong problem-solving and analytical skills.</li><li>Excellent communication and collaboration abilities.</li><li>Ability to work independently and as part of a team.</li><li>Attention to detail and commitment to quality.</li><li>Ability to manage multiple tasks and meet deadlines.</li></ul>Preferred Qualifications:<ul><li>Experience with microservices architecture.</li><li>Familiarity with cloud platforms (AWS, Azure, Google Cloud).</li><li>Knowledge of DevOps practices and tools.</li><li>Experience with containerization technologies (Docker, Kubernetes).</li><li>Familiarity with Agile/Scrum methodologies.</li></ul>

Intraedge Interview Questions

Intraedge Interview Guides

Intraedge Interview Questions

Intraedge Salaries by Position

Intraedge Opening Jobs