Prepare for and practice interview questions from Amtex Systems Inc..

Amtex Systems Inc. Interview Questions

Amtex Systems Inc. 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

Suppose there exists a new airline named Jetco that flies domestically across North America. Jetco recently had a study commissioned that tested the boarding time of every airline, and it came out that Jetco had the fastest average boarding times of any airline.

What factors could have biased this result, and what would you look into?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

Boarding Times Bias

A new airline came out as the fastest average boarding times compared to other airlines.  What factors could have biased this result and what would you look into?

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

Amtex Systems Inc. Salaries by Position

Title: Data Engineering ManagerLocation: Charlotte, NC(Hybrid)Duration: 12+ Months CTH Must Have Skills 1) Strong proficiency in SQL, Python and Spark programming languages. 2) Strong experience with cloud platforms such as AWS, Azure, or GCP is a must. 3) Hands-on experience with big data technologies such as Hadoop, Spark, Kafka, and distributed computing frameworks. 4) Knowledge of data lake and data warehouse solutions, including Databricks, Azure Data Factory, Airflow etc. 5) Experience in implementing CI/CD pipelines for automating build, test, and deployment processes. 6) Solid understanding of data modeling concepts, data warehousing architectures, and data management best practices. 7) Excellent communication and leadership skills, with the ability to effectively collaborate with cross-functional teams and drive consensus on technical decisions. 8) Prior experience in leading multiple teams Nice to Have Skills1) Recent ( not more than 3 years old) hands on experience on Azure tech stack.2) Experience on Retail domain data .3) Prior experience on working with offshore team ( India , Europe..etc) . List top Skills, Experience, Background, Certifications, Education, etc.1) Bachelor’s or master’s degree in computer science, Engineering, or a related field.2) Proven experience (12 +) in a data engineering role, with expertise in designing and building data pipelines, ETL processes, and data warehouses with 2+ years of Team Manager role.3) Relevant certifications (e.g., Azure, databricks, snowflake) would be a plus.

About Company : www.amtexsystems.com Amtex Systems, a global technology innovator with 25+ years of expertise. Specializing in Software Development, IT Consulting, Digital Media, Business Intelligence, Mobile Applications, and Content Management, we're at the forefront of industry evolution caters to diverse sectors, including Technology, Finance, Media, Fashion, Retail, and the Public Sector. People who thrive on fearlessly experimenting, seizing opportunities, and pushing boundaries to turn our vision into reality. And as you help us create a better world, we will help you build your own intellectual . Come, transform with us. We are hiring for our team .Elevate your career with us – where innovation meets opportunity! Role : Senior Data EngineerLocation :Bangalore Design, Architect, and Develop solutions leveraging cloud big data technology to ingest, process and analyse large, disparate data sets to exceed business requirements.Develop systems that ingest, cleanse, and normalize diverse datasets, develop data pipelines from various internal and external sources and build structure for previously unstructured data.Interact with internal colleagues and external professionals to determine requirements, anticipate future needs, and identify areas of opportunity to drive data development.Develop good understanding of how data will flow & stored through an organization across multiple applications such as CRM, Broker & Sales tools, Finance, HR etc.Unify, enrich, and analyse variety of data to derive insights and opportunities.Design & develop data management and data persistence solutions for application use cases leveraging relational, non-relational databases and enhancing our data processing capabilities.Develop POCs to influence platform architects, product managers and software engineers to validate solution proposals and migrate.Develop data lake solution to store structured and unstructured data from internal and external sources and provide technical guidance to help migrate colleagues to modern technology platform.Contribute and adhere to CI/CD processes, development best practices and strengthen the discipline in Data Engineering OrgMentor other members in the team and organization and contribute to organizations’ growth. What we are looking for: 6+ years’ work experience and bachelor’s degree in information science, Computer Science, Mathematics, Statistics or a quantitative discipline in science, business, or social science.Hands-on engineer who is curious about technology, should be able to quickly adopt to change and one who understands the technologies supporting areas such as Cloud Computing (AWS, Azure(preferred), etc.), Micro Services, Streaming Technologies, Network, Security, etc.3 or more years of active development experience as a data developer using Python-spark, Spark Streaming, Azure SQL Server, Cosmos DB/Mongo DB, Azure Event Hubs, Azure Data Lake Storage, Azure Search etc.Design & develop data management and data persistence solutions for application use cases leveraging relational, non-relational databases and enhancing our data processing capabilities. If interested please share resume at hiring@amtexsystems.com

Title: Product Manager with Snowflake & ADFLocation: Hybrid(2 Days Onsite)Duration: 12+ Months Looking for Product Manager with 10+ Years of IT experiencestrong experience with Snowflake & ADF(Azure Data Factory)

We are seeking a highly skilled and motivated Data Scientist to join our dynamic Advanced Analytics and Solutions team. This role will bridge the gap between machine learning and DevOps, ensuring the seamless deployment, scalability, and maintenance of our machine learning models and data pipelines. The ideal candidate will have a strong background in software development, data infrastructure, and machine learning operations (MLOps). Key Responsibilities:· Design, build, and maintain data predictive models.· Design, build, and maintain robust, scalable, and efficient data pipelines to support machine learning workflows.· Collaborate with data scientists and data engineers to streamline model development, deployment, and monitoring.· Implement CI/CD pipelines for machine learning models to ensure rapid, reliable deployment and updates.· Develop and maintain infrastructure for data storage, processing, and analysis, ensuring high availability and performance.· Automate the provisioning, configuration, and monitoring of infrastructure to support data and machine learning applications.· Monitor and troubleshoot issues in data pipelines, machine learning models, and production systems to ensure reliability and performance.· Ensure security, compliance, and data privacy standards are met across all data and machine learning workflows.· Document processes, configurations, and best practices to facilitate collaboration and knowledge sharing within the team. Skills Required: · Strong programming skills in Python and familiarity with other languages such as JavaScript, HTML, and CSS.· Deep understanding of machine learning concepts, algorithms, and frameworks (e.g., TensorFlow, PyTorch, Scikit-learn).· Expertise in data engineering tools and frameworks (e.g., Apache Spark, Synapse Analytics, PySpark)· Proficiency in DevOps tools and practices, including CI/CD, containerization (Docker), and orchestration (Kubernetes).· Experience with cloud platforms (Azure is preferred) and their machine learning and data services.· Familiarity with infrastructure as code (IaC) tools such as Terraform.· Strong knowledge of database systems (SQL and NoSQL).· Experience with monitoring and logging tools (e.g., MLFlow).· Experience with version control software (e.g., Git and GitHub)· Excellent problem-solving skills and the ability to troubleshoot complex data and infrastructure issues.· Strong communication skills and the ability to work collaboratively in a team environment. Preferred Qualifications: · Experience with MLOps tools and platforms (e.g., MLflow).· Experience with Epic EMR system (Certified in Cogito and Clarity).· Experience with Microsoft Azure Platform (Certified in Azure Data Science).· Experience with real-time data processing and streaming applications.· Advanced degree (master’s or PhD) in Computer Science, Data Science, Engineering, or a related field. Programming and Software Required: · Programming Languages: Python and familiarity or ability to learn: JavaScript, HTML, CSS· Machine Learning Frameworks: TensorFlow, PyTorch, Scikit-learn· Data Engineering Tools: Apache Spark, Synapse Analytics, PySpark· DevOps Tools: Docker, Kubernetes, Git· Cloud Platforms: AzureDatabases: SQL, NoSQL

About Companywww.amtexsystems.com Amtex Systems, a global technology innovator with 25+ years of expertise. Specializing in Software Development, IT Consulting, Digital Media, Business Intelligence, Mobile Applications, and Content Management, we're at the forefront of industry evolution caters to diverse sectors, including Technology, Finance, Media, Fashion, Retail, and the Public Sector. People who thrive on fearlessly experimenting, seizing opportunities, and pushing boundaries to turn our vision into reality. And as you help us create a better world, we will help you build your own intellectual . Come, transform with us. We are hiring for our team .Elevate your career with us – where innovation meets opportunity! Skill: Angular and Python Development Key Responsibilities: Develop high-quality, efficient, and reusable user interface components using Angular framework.Develop backend Flask python API’s to process application data.Demonstrate excellent English communication skills, both written and verbal, to effectively communicate with team members.Take initiative in proposing new ideas and solutions to enhance the functionality and user experience of our application.Bring a process-oriented mindset to the team.Emphasis on documenting both application understanding as well as the validation of your code prior to releases.Participate in code reviews and provide constructive feedback to improve overall code quality.Display a positive attitude and willingness to learn and grow within the team, as well as contribute to the overall success of the company.Ensure dependability by meeting deadlines, maintaining consistent availability, and providing timely updates on project progress.Requirement : 1. Bachelor's degree in Computer Science, Engineering, or a related field. 2. 3+ years of hands-on experience in Angular development. 3. 3+ years of hands-on experience in Flask python development. 4. A positive attitude and strong work ethic, with a focus on dependability and delivering results. 5. Excellent problem-solving skills and the ability to work independently or as part of a team. 6. Strong proficiency in JavaScript, HTML5, CSS, SQL, as well as familiarity with RESTful APIs. 7. Knowledge of modern web development tools and practices, such as Git, Continuous Integration, and Agile methodologies If interested please share resume at hiring@amtexsystems.com

Liferay Engineer/DeveloperAtlanta, GA- Onsite 4 Days BASIC PURPOSEIndependently performs software design, development, test, and integration for Bank applications and provides support of those applications, with a focus on Java and Liferay DXP portal application development. ESSENTIAL FUNCTIONS:• Performs all functions of software engineers, with a focus on Java and Liferay Portal application development.• Under limited supervision, develops innovative approaches to address business needs. Creates detailed design specifications for subsequent programming and implementation.• Participates in application design sessions – proposing and documenting technical alternatives required to achieve business objectives, suggesting improvements to reduce technical debt.• Implements new system software or modifications to existing software that are high-quality.• Writes and executes unit tests necessary to ensure the bank applications developed in Liferay DXP to meet the requirements.• Maintains application builds and deployments. Assists in application configuration.• Performs peer reviews to ensure adherence to standards and accuracy of the implementation of requirements.• Interacts with project management, other project teams, and peers in a team environment for purposes of application integration and project coordination.• Maintains up-to-date knowledge of systems software and future trends and directions in the software industry. KNOWLEDGE, SKILLS, AND ABILITIES:Excellent knowledge in Java 8 and above, Java Server Pages, Liferay Portal DXP 7.2 and above, Git, SQL Server, HTML, JavaScript, CSS

Title: Lead Data EngineerLocation: Charlotte, NC(Hybrid)Duration: 12+ Months · Apply advanced knowledge of Data Engineering principles, methodologies and techniques to design and implement data loading and aggregation frameworks across broad areas of the organization.· Gather and process raw, structured, semi-structured and unstructured data using batch and real-time data processing frameworks.· Implement and optimize data solutions in enterprise data warehouses and big data repositories, focusing primarily on movement to the cloud.· Drive new and enhanced capabilities to Enterprise Data Platform partners to meet the needs of product / engineering / business.· Experience building enterprise systems especially using Databricks, Snowflake and platforms like Azure, AWS, GCP etc· Leverage strong Python, Spark, SQL programming skills to construct robust pipelines for efficient data processing and analysis.· Implement CI/CD pipelines for automating build, test, and deployment processes to accelerate the delivery of data solutions.

Position DescriptionSQL Data Migration Analyst will be responsible for designing, developing and managing the data migration process within the Finance Division which will include converting scripts/stored procedures from Oracle SQL to SQL Server. Duties and Responsibilities· Experience in data migration from Oracle SQL to SQL Server using Oracle SQL Developer and SQL Server Management Studio· Expert in creating/modifying various stored procedures and functions as part of the data migration and cleansing process· Extensive experience in complex SQL queries, analytical functions, and Oracle/SQL server objects· Ability to manipulate large datasets· Strong interpersonal skills and ability to interact with people at all levels· Ability to perform under pressure and multi-tasking· Skillful problem solver with excellent analytical skills· Ability to analyze the business rules and put it into programmable logic· Experience in managing financial data is a plus Qualifications· Bachelor’s degree in Computer Science, Computer Technology, Statistics, Engineering, Mathematics, Finance, or related field· Minimum of 3 years of relevant experience in data migration and advanced analytics· Strong critical thinking, analytical and problem-solving skills

Amtex Systems Inc. Interview Questions

Amtex Systems Inc. Interview Guides

Amtex Systems Inc. Interview Questions

Amtex Systems Inc. Salaries by Position

Amtex Systems Inc. Opening Jobs