Prepare for and practice interview questions from Agileengine.

Agileengine Interview Questions

Agileengine 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

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?

Agileengine Salaries by Position

Job Description This is a remote position and we are hiring candidates from the whole country. AgileEngine is one of the Inc. 5000 fastest-growing companies in the US and a top-3 ranked dev shop according to Clutch. We create award-winning custom software solutions that help companies across 15+ industries change the lives of millions. If you like a challenging environment where you're working with the best and are encouraged to learn and experiment every day, there's no better place - guaranteed! What you will do <ul> <li>Work collaboratively with other engineers, architects, data scientists, analytics teams, and business product owners in an agile environment; </li> <li>Architect, build, and support the operation of Cloud and On-Premises enterprise data infrastructure and tools; </li> <li>Design and build robust, reusable, and scalable data driven solutions and data pipeline frameworks to automate the ingestion, processing and delivery of both structured and unstructured batch and real-time streaming data; </li> <li>Build data APIs and data delivery services to support critical operational processes, analytical models and machine learning applications; </li> <li>Assist in selection and integration of data related tools, frameworks, and applications required to expand platform capabilities; </li> <li>Understand and implement best practices in management of enterprise data, including master data, reference data, metadata, data quality and lineage. </li> </ul>Must haves <ul> <li>4+ years of experience with Python or Java (Python preferably, or willingness to work with this language); </li> <li>4+ years of experience in building data lake, cloud data platform leveraging cloud (GCP/AWS) cloud native architecture, ETL/ELT, and data integration ; </li> <li>Three years of development experience with cloud services ( AWS,GCP,AZURE) utilizing various support tools (e.g. GCS, Dataproc, Cloud Data flow, Airflow(Composer), Kafka , Cloud Pub/Sub); </li> <li>Expertise in developing distributed data processing and Streaming frameworks and architectures (Apache Spark, Apache Beam, Apache Flink ); </li> <li>Experience with Snowflake is a must; </li> <li>In-depth knowledge of NoSQL database technologies (e.g. MongoDB, BigTable, DynamoDB); </li> <li>Expertise in build and deployment tools - (Visual Studio, PyCharm, Git/Bitbucket/Bamboo, Maven, Jenkins, Nexus, ); </li> <li>4+ years of experience and expertise in database design techniques and philosophies (e.g. RDBMS, Document, Star Schema, Kimball Model); </li> <li>4 years of experience with integration and service frameworks (e.g API Gateways, Apache Camel, Swagger API, Zookeeper, Kafka, messaging tools, microservices); </li> <li>Expertise with containerized Microservices and REST/GraphQL based API development; </li> <li>Experience leveraging continuous integration/development tools (e.g. Jenkins, Docker, Containers, OpenShift, Kubernetes, and container automation) in a Ci/CD pipeline; </li> <li>Advanced understanding of software development and research tools; </li> <li>Attention to detail and results oriented, with a strong customer focus; </li> <li>Ability to work as part of a team and independently; </li> <li>Analytical and problem-solving skills; </li> <li>Problem-solving and technical communication skills; </li> <li>Ability to prioritize workload to meet tight deadlines; </li> <li>Should have working experience with wealth asset management projects; </li> <li>Upper-intermediate English level. </li> </ul>Nice to haves <ul> <li>Airflow; </li> <li>Big Query; </li> <li>Kafka. </li> </ul>The benefits of joining us <ul> <li>Professional growth </li> </ul>Accelerate your professional journey with mentorship, TechTalks, and personalized growth roadmaps <ul> <li>Competitive compensation </li> </ul>We match your ever-growing skills, talent, and contributions with competitive USD-based compensation and budgets for education, fitness, and team activities <ul> <li>A selection of exciting projects </li> </ul>Join projects with modern solutions development and top-tier clients that include Fortune 500 enterprises and leading product brands <ul> <li>Flextime </li></ul> Tailor your schedule for an optimal work-life balance, by having the options of working from home and going to the office - whatever makes you the happiest and most productive.

Job Description This is a remote position and we are hiring candidates from the whole country. AgileEngine is one of the Inc. 5000 fastest-growing companies in the US and a top-3 ranked dev shop according to Clutch. We create award-winning custom software solutions that help companies across 15+ industries change the lives of millions. If you like a challenging environment where you're working with the best and are encouraged to learn and experiment every day, there's no better place - guaranteed! What you will do <ul><li>Work collaboratively with other engineers, architects, data scientists, analytics teams, and business product owners in an agile environment; </li><li>Architect, build, and support the operation of Cloud and On-Premises enterprise data infrastructure and tools; </li><li>Design and build robust, reusable, and scalable data driven solutions and data pipeline frameworks to automate the ingestion, processing and delivery of both structured and unstructured batch and real-time streaming data; </li><li>Build data APIs and data delivery services to support critical operational processes, analytical models and machine learning applications; </li><li>Assist in selection and integration of data related tools, frameworks, and applications required to expand platform capabilities; </li><li>Understand and implement best practices in management of enterprise data, including master data, reference data, metadata, data quality and lineage. </li></ul>Must haves <ul><li>4+ years of experience with Python or Java (Python preferably, or willingness to work with this language); </li><li>4+ years of experience in building data lake, cloud data platform leveraging cloud (GCP/AWS) cloud native architecture, ETL/ELT, and data integration ; </li><li>Three years of development experience with cloud services ( AWS,GCP,AZURE) utilizing various support tools (e.g. GCS, Dataproc, Cloud Data flow, Airflow(Composer), Kafka , Cloud Pub/Sub); </li><li>Expertise in developing distributed data processing and Streaming frameworks and architectures (Apache Spark, Apache Beam, Apache Flink ); </li><li>Experience with Snowflake is a must; </li><li>In-depth knowledge of NoSQL database technologies (e.g. MongoDB, BigTable, DynamoDB); </li><li>Expertise in build and deployment tools - (Visual Studio, PyCharm, Git/Bitbucket/Bamboo, Maven, Jenkins, Nexus, ); </li><li>4+ years of experience and expertise in database design techniques and philosophies (e.g. RDBMS, Document, Star Schema, Kimball Model); </li><li>4 years of experience with integration and service frameworks (e.g API Gateways, Apache Camel, Swagger API, Zookeeper, Kafka, messaging tools, microservices); </li><li>Expertise with containerized Microservices and REST/GraphQL based API development; </li><li>Experience leveraging continuous integration/development tools (e.g. Jenkins, Docker, Containers, OpenShift, Kubernetes, and container automation) in a Ci/CD pipeline; </li><li>Advanced understanding of software development and research tools; </li><li>Attention to detail and results oriented, with a strong customer focus; </li><li>Ability to work as part of a team and independently; </li><li>Analytical and problem-solving skills; </li><li>Problem-solving and technical communication skills; </li><li>Ability to prioritize workload to meet tight deadlines; </li><li>Should have working experience with wealth asset management projects; </li><li>Upper-intermediate English level. </li></ul>Nice to haves <ul><li>Airflow; </li><li>Big Query; </li><li>Kafka. </li></ul>The benefits of joining us <ul> <li>Professional growth </li></ul>Accelerate your professional journey with mentorship, TechTalks, and personalized growth roadmaps <ul><li>Competitive compensation </li></ul>We match your ever-growing skills, talent, and contributions with competitive USD-based compensation and budgets for education, fitness, and team activities <ul><li>A selection of exciting projects </li></ul>Join projects with modern solutions development and top-tier clients that include Fortune 500 enterprises and leading product brands <ul><li>Flextime </li></ul> Tailor your schedule for an optimal work-life balance, by having the options of working from home and going to the office - whatever makes you the happiest and most productive.

This is WFH. We are looking for scientists or PhDs in Graphs Theory If you are interested pls send me your resume at kapil.nawab@agileengine.com <ul><li>Expert knowledge in Graphs Theory: - </li><li>Graph Algorithms (analyze graph structures and uncover meaningful patterns. Topics such as breadth-first search, depth-first search, shortest path algorithms, centrality measures, and community detection algorithms for exploring relationships and characteristics within graphs -</li><li> Graph Visualization: Visualization techniques, including force-directed layouts, hierarchical layouts, and matrix representations -</li><li> Graph Database Technologies: Graph database technologies, such as Neo4j, Amazon Neptune, or Microsoft Azure Cosmos DB Knowledge of one of the following programming languages: Java, Python Proficient in version control software such as Git, Mercurial or SVN.</li><li> Proficient in using software collaboration tools such as TFS or JIRA Working knowledge of various databases (MySQL, MSSQL, Oracle, Postgres) Working knowledge of various operating systems (Windows, Linux) Working knowledge of integrating with RESTful services using JSON </li></ul>

Job Description AgileEngine is a top-ranking provider of software solutions to Fortune 500, Global 500, and Future 50 companies. Listed on Inc. 5000 among the fastest-growing US companies, we are always open to talented software, UX, and data experts in the Americas, Europe, and Asia. If you like a challenging environment where you're working with the best and are encouraged to learn and experiment daily, there's no better place - guaranteed! :) What you will do <ul><li>Lift and Shift ETL pipelines from Legacy to New environments;</li><li>Monitor data pipelines, identify bottlenecks, optimize data processing and storage for performance and cost-effectiveness;</li><li>Analyze sources and build Cloud Data Warehouse and Data Lake solution;</li><li>Collaborate effectively with cross-functional teams including data scientists, analysts, software engineers, and business stakeholders.</li></ul> Must haves <ul><li>3+ years of professional experience in a Data Engineering role;</li><li>Proficiency in programming languages commonly used in data engineering such as Python, SQL, and optionally</li><li>Scala for working with data processing frameworks like Spark and libs like Pandas;</li><li>Proficiency in designing, deploying, and managing data pipelines using Apache Airflow for workflow orchestration and scheduling;</li><li>Ability to design, develop, and optimize ETL processes to move and transform data from various sources into the data warehouse, ensuring data quality, reliability, and efficiency;</li><li>Knowledge of big data technologies and frameworks such as Apache Spark for processing large volumes of data efficiently;</li><li>Extensive hands-on experience with various AWS services relevant to data engineering, including but not limited to Amazon MWAA, Amazon S3, Amazon RDS, Amazon EMR, AWS Lambda, AWS Glue, Amazon Redshift, AWS</li><li>Data Pipeline, Amazon DynamoDB;</li><li>Deep understanding and practical experience in building and optimizing cloud data warehousing solutions;</li><li>Ability to monitor data pipelines, identify bottlenecks, and optimize data processing and storage for performance and cost-effectiveness;</li><li>Excellent communication skills to collaborate effectively with cross-functional teams including data scientists, analysts, software engineers, and business stakeholders;</li><li>Bachelor's degree in computer science/engineering or other technical field, or equivalent experience;</li><li>Upper-intermediate English level.</li></ul> Nice to haves <ul><li>Familiarity with the fintech industry, understanding of financial data, regulatory requirements, and business processes specific to the domain;</li><li>Documentation skills to document data pipelines, architecture designs, and best practices for knowledge sharing and future reference;</li><li>GCP services relevant to data engineering;</li><li>Snowflake;</li><li>OpenSearch, Elasticsearch;</li><li>Jupyter for analyze data;</li><li>Bitbucket, Bamboo;</li><li>Terraform.</li></ul>The benefits of joining us <ul><li>Professional growth</li></ul> Accelerate your professional journey with mentorship, TechTalks, and personalized growth roadmaps. <ul><li>Competitive compensation</li></ul> We match your ever-growing skills, talent, and contributions with competitive USD-based compensation and budgets for education, fitness, and team activities. <ul><li>A selection of exciting projects</li></ul> Join projects with modern solutions development and top-tier clients that include Fortune 500 enterprises and leading product brands. <ul><li>Flextime</li></ul> Tailor your schedule for an optimal work-life balance, by having the options of working from home and going to the office - whatever makes you the happiest and most productive.

Job Description AgileEngine is a top-ranking provider of software solutions to Fortune 500, Global 500, and Future 50 companies. Listed on Inc. 5000 among the fastest-growing US companies, we are always open to talented software, UX, and data experts in the Americas, Europe, and Asia. If you like a challenging environment where you're working with the best and are encouraged to learn and experiment daily, there's no better place - guaranteed! :) What you will do <ul><li>Lift and Shift ETL pipelines from Legacy to New environments; </li><li>Monitor data pipelines, identify bottlenecks, optimize data processing and storage for performance and cost-effectiveness; </li><li>Analyze sources and build Cloud Data Warehouse and Data Lake solution; </li><li>Collaborate effectively with cross-functional teams including data scientists, analysts, software engineers, and business stakeholders. </li></ul>Must haves <ul> <li>3+ years of professional experience in a Data Engineering role; </li><li>Proficiency in programming languages commonly used in data engineering such as Python, SQL, and optionally </li><li>Scala for working with data processing frameworks like Spark and libs like Pandas; </li><li>Proficiency in designing, deploying, and managing data pipelines using Apache Airflow for workflow orchestration and scheduling; </li><li>Ability to design, develop, and optimize ETL processes to move and transform data from various sources into the data warehouse, ensuring data quality, reliability, and efficiency; </li><li>Knowledge of big data technologies and frameworks such as Apache Spark for processing large volumes of data efficiently; </li><li>Extensive hands-on experience with various AWS services relevant to data engineering, including but not limited to Amazon MWAA, Amazon S3, Amazon RDS, Amazon EMR, AWS Lambda, AWS Glue, Amazon Redshift, AWS </li><li>Data Pipeline, Amazon DynamoDB; </li><li>Deep understanding and practical experience in building and optimizing cloud data warehousing solutions; </li><li>Ability to monitor data pipelines, identify bottlenecks, and optimize data processing and storage for performance and cost-effectiveness; </li><li>Excellent communication skills to collaborate effectively with cross-functional teams including data scientists, analysts, software engineers, and business stakeholders; </li><li>Bachelor's degree in computer science/engineering or other technical field, or equivalent experience; </li><li>Upper-intermediate English level. </li></ul>Nice to haves <ul><li>Familiarity with the fintech industry, understanding of financial data, regulatory requirements, and business processes specific to the domain; </li><li>Documentation skills to document data pipelines, architecture designs, and best practices for knowledge sharing and future reference; </li><li>GCP services relevant to data engineering; </li><li>Snowflake; </li><li>OpenSearch, Elasticsearch; </li><li>Jupyter for analyze data; </li><li>Bitbucket, Bamboo; </li><li>Terraform. </li></ul>The benefits of joining us <ul> <li>Professional growth </li></ul>Accelerate your professional journey with mentorship, TechTalks, and personalized growth roadmaps. <ul><li>Competitive compensation </li></ul>We match your ever-growing skills, talent, and contributions with competitive USD-based compensation and budgets for education, fitness, and team activities. <ul><li>A selection of exciting projects </li></ul>Join projects with modern solutions development and top-tier clients that include Fortune 500 enterprises and leading product brands. <ul><li>Flextime </li></ul> Tailor your schedule for an optimal work-life balance, by having the options of working from home and going to the office - whatever makes you the happiest and most productive.

Agileengine Interview Questions

Agileengine Interview Guides

Agileengine Interview Questions

Agileengine Salaries by Position

Agileengine Opening Jobs