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

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?

Amtex Systems Inc. Salaries by Position

Senior Data ArchitectNewark, NJ - HybridLong Term Must have:Data ModelingSnowflakeAccounts payable and Capital markets Architect Description:Design and implement architecture and infrastructures for data integrationDevelop data models and data flow processesDesign and optimize scalable data warehousesAct as single POC for Client.Gather requirements, own processes, work with client project management teamProvide requirements to offshore teamEscalate issues to obtain planned inputs and time commitmentsParticipate in weekly status updates. Background:Client will be implementing UI flow pre and post their AP ( Account Payable) system. Currently their AP is in Peoplesoft/AP module. Architects are going to be the primary person(s) who need to own entire arch + design and as well talk to business on how to aspects. Basically, they need to drive things. If you have some background/knowledge of Accounts Payable systems/work flows + Payment flows, invoice processing, Ledgers, payables, Accruals. Cash flow, Amortization etc that would be great. But fundamentally the role is Data Architecture for entire system.

Title: Business Intelligence AnalystLocation: Dallas, TX(Hybrid)Duration: 12+ Months Responsible for using data to drive strategic initiatives. Criticallycompiles and analyzes information from various data sources in order to identify areasof opportunity. Key duties include identifying improvements and leading related projectteams, ensuring key deliverables are met Responsibilities• Mines, synthesizes, and analyzes multiple and complex data types and sourceseffectively for providing Senior Leadership insight on Divisional performance• Proactively delivers analysis, updates and recommendations for case studies, strategicbusiness insights, and ad hoc requests• Creates visualizations for Senior Leadership periodic reports and organizationalscorecards• Reviews data and results consumed in Senior Leadership dashboards to identify trendsand need for further analysis to improve Company and Divisional performance• Takes direct ownership of existing Team deliverables when needed to meet Team'sreporting timelines for Senior Leadership's update on Divisional performance• Works cross-functionally with all groups and proactively builds relationshipsacross the enterprise that rely on reporting and analysis• Works under the guidance of the Team's Manager while assisting the Team in variousinitiatives led by other Team members• Provides constructive feedback to Team members as needed and actively seeks theperspectives of others• May perform other job duties as directed by Employee's Leaders• Knowledge, Skills and Abilities• Knowledge of relational database concepts, and creating reports from data stored in anenterprise data warehouse• Expertly skilled in demonstrating mastery of statistical and analytical techniques thatarrive at fact based decision making• Expertly skilled in using analytical tools such as Alteryx, Tableau, and Power BI togather large data sets and better frame the opportunity space• Skilled in Microsoft Office Suite, with extensive proficiency in Excel (e.g. macros,advanced formulas, pivot tables) and use of spreadsheets, word processing, andgraphics• Expertly skilled in demonstrating initiative and possessing the willingness and skills toadapt as technology/processes change• Skilled in gracefully receiving steady feedback provided by Leadership and Team alongwith offering constructive and respectful feedback to others• Expertly skilled in understanding and applying information to contribute to theorganization’s strategic plan• Expertly skilled in using logic and critical reasoning to identify the strengths andweaknesses of alternative solutions, conclusions, or approaches to problems• Expert ability to write SQL against enterprise databases (e.g. Oracle, Teradata, Sybase)• Expert ability to use various methodologies and statistical concepts to discover newinsights on traditional metrics• Ability to come up with unusual or clever ideas about a given topic or situation, or todevelop creative ways to solve a problem• Ability to concentrate on a task over a period of time without being distracted• Ability to constantly improve executive presence in presenting results of work to SeniorLeadership Additional Experience• Advanced level experience, seasoned and specialized knowledge in::• Data aggregation, analysis and reporting• Utilizing analytical platforms (Alteryx, Structured query language SQL, andTableau)• Licensing/Certification• Must be able to obtain a SIDA (Secured Identification Display Area) badge

About the Company: <a>www.amtexsystems.com</a>Amtex Systems is a global technology innovator with over 25 years of expertise. We specialize in Software Development, IT Consulting, Digital Media, Business Intelligence, Mobile Applications, and Content Management. We are at the forefront of industry evolution, catering to diverse sectors such as Technology, Finance, Media, Fashion, Retail, and the Public Sector.We thrive on fearless experimentation, seizing opportunities, and pushing boundaries to turn vision into reality. Join us in creating a better future. Position: Business Analyst/DeveloperLocation: ChennaiExperience: 5 - 13 years Job descriptionThe Business Analyst/Developer will support, promote and drive implementation of best practices in Business Intelligence (BI) and healthcare analytics. They will assist with the development of the Business Intelligence strategy and will be required to collaborate with other BI team members to help standardize work processes and understand departmental capacity and promote innovation in all aspects of the team’s work. Primary Responsibilities:<ul><li>Ability to gather and analyze data to solve complex problems and evaluate scenarios to make predictions on future outcomes and support decision making</li><li>Acting independently, serves as a technical expert in Business Intelligence and data analysis</li><li>Leverages thorough understanding of business process and system processes to make recommendations and propose technical/non-technical solutions to meet business requirements</li><li>Contribute to and employ best practices and strategies in optimizing the performance of data analysis and stability of data integration solutions</li><li>Collaborate with stakeholders on visual storytelling and architect insightful solutions</li><li>Translate story boards and metrics into technical requirements from which to develop insightful solutions</li><li>Train and develop user community to support casual and power user adoption of BI solutions</li><li>Utilize excellent communication skills both within project teams and with clients</li><li>Work independently, in a team, and as a lead specialist to deliver end-to-end analytic solutions within tight deadlines</li><li>Ensure quality of deliverables using development testing methods, code reviews and user acceptance testing</li><li>Able to adapt quickly to new technologies to create the most insightful analytics for the business need</li><li>Governance / Best Practices -- adhere and contribute to enterprise data governance standards. Also educates and supports colleagues in best practices to ensure that data is used appropriately</li><li>Be a critical part of a scrum team in an agile environment, ensuring the team successfully meets its deliverables each sprint</li><li>Proficiency in SQL database design and SQL programming, including stored procedure and table joins</li><li>Strong and effective inter-personal and communication skills and the ability to interact professionally with a diverse group of clients and staff, including management and senior level executives</li><li>Analytical mind with problem-solving aptitude</li><li>On-call for break/fix outside of standard business hours</li></ul> Education & Experience<ul><li>Business unit domain experience preferred (Marketing/BDO, Compliance, Operations, Finance)</li><li>Relevant degree in Data Science, Computer Science, Operations Research, Economics, Management Science, Mathematics, Industrial Engineering, Statistics or similar field</li><li>Experience in developing and deploying BI Solutions</li><li>Qlik Sense experience; MS PBI experience; SQL Experience; Excel Experience</li><li>Experience in the following BI disciplines: Data Integration, Modeling, Analytics or Reporting</li><li>Must have strong SQL development experience in MSSQL (SSRS/SSIS/SSAS)</li><li>Excellent oral, written, and presentation communication skills</li><li>Background in using Lean principles, Agile processes and tools</li></ul> If you are a dynamic professional with a blend of the above-mentioned skills, we invite you to join our team and contribute to the success of our projects. Please share your resume at hiring@amtexsystems.com.

Candidate needs to visit the office once a month Description:Product Manager is responsible for defining and supporting the building of desirable, feasible, viable, and sustainable products that meet our customer needs over the product-market lifecycle. This role collaborates with a wide range of people to identify and define customer needs, understand the Solution Context, and develops the Program Vision, Roadmap, and Features required to meet these needs including assurance that business needs cascade down to the team level. A PM is responsible for the feature product backlog and serves as the ultimate product authority approving PI/TI and Iteration objectives. General Description: • Owner of creating, managing & prioritizing product features, using a backlog, including experience in serving as the ultimate authority; agrees upon DoD & supports the flow of work at the Program layer • Generates business value work with the Portfolio layer including experience in working with the PO to assure that the work cascades down to the team level including driving and approving PI/TI Iteration/Sprint objectives • Key owner & driver of strategic themes & roadmap for the Product lifecycle including ability to guide the product through the lifecycle states including creating & management of rolling wave plans • Responsible for ensuring that Value Streams are creating feasible and sustainable products & solutions • Owns outlining & prioritizing enabler work including ensuring work is understood & execution coincides with business value work • If part of an ART, is an active participant & skilled in ART ceremonies and associated responsibilities • Key participant in supporting and reviewing system demos to ensure demonstrated delivered work aligns with targeted business value deliverables & scope • Ensures Program risks are identified and handled • Identifies, tracks & handles appropriate feature metrics including tracking feature progress & areas for improvement • Responsible in identifying customers and stakeholders including advanced skills with client/stakeholder management both internal & external. This includes representing their business value needs & validation of proposed solutions and creating a product vision • Works with Epic Owners to develop a Lean Business Case for Epics, or if an Epic Owner, will develop & handle the Lean Business Case • Provides oversight and management of the product financials including assurance to budgets and tracking • Owns development of customer centric ROI models & associated features that provide optimal ROI • Supports new and existing product processes including GS&P, Architecture, Legal, Compliance and Vendors • Responsible for handling vendor relationships including skills in ensuring targeted vendor deliverables meet our product needs including timely alignment • Drives product innovation • Knowledgeable and supportive regarding creation & execution of product SOWs • Participant & reviewer of RFPs • Conducts customer satisfaction surveys/analysis, validates customer response, provides fast feedback, prioritizes defect resolution & enhancements • Works effectively with all levels and roles including fully understanding R&Rs of the PO, team, Preferences: • MS Office • Jira • Confluence • IT store experience • Workforce management experience

About Company :<a>www.amtexsystems.com</a>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! Position: Senior Data EngineerLocation: Hybrid Position What this job involves: We are looking for a Staff Data Engineer who is self-starter to work in a diverse and fast-paced environment that can join our Enterprise Data team. This is an individual contributor role that is responsible for designing and developing of data solutions that are strategic for the business and built on the latest technologies and patterns. This a global role that requires partnering with the broader team at the country, regional and global level by utilizing in-depth knowledge of data, infrastructure, technologies, and data engineering experience. As a Senior Data Engineer, you will: <ul><li>Design, Architect, and Develop solutions leveraging cloud big data technology to ingest, process and analyse large, disparate data sets to exceed business requirements.</li><li>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.</li><li>Interact with internal colleagues and external professionals to determine requirements, anticipate future needs, and identify areas of opportunity to drive data development.</li><li>Develop good understanding of how data will flow & stored through an organization across multiple applications such as CRM, Broker & Sales tools, Finance, HR etc.</li><li>Unify, enrich, and analyse variety of data to derive insights and opportunities.</li><li>Design & develop data management and data persistence solutions for application use cases leveraging relational, non-relational databases and enhancing our data processing capabilities.</li><li>Develop POCs to influence platform architects, product managers and software engineers to validate solution proposals and migrate.</li><li>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.</li><li>Contribute and adhere to CI/CD processes, development best practices and strengthen the discipline in Data Engineering Org</li><li>Mentor other members in the team and organization and contribute to organizations’ growth.</li></ul> What we are looking for:<ul><li>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.</li><li>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.</li><li>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.</li><li>Design & develop data management and data persistence solutions for application use cases leveraging relational, non-relational databases and enhancing our data processing capabilities.</li><li>Build, test, and enhance data curation pipelines integration data from wide variety of sources like DBMS, File systems, APIs and streaming systems for various KPIs and metrics development with high data quality and integrity.</li><li>Maintain the health and monitoring of assigned data engineering capabilities that span analytic functions by triaging maintenance issues; ensure high availability of the platform; monitor workload demands; work with Infrastructure Engineering teams to maintain the data platform; serve as an SME of one or more application.</li><li>Team player, Reliable, self-motivated, and self-disciplined individual capable of executing on multiple projects simultaneously within a fast-paced environment working with cross functional teams.</li><li>3+ years of experience working with source code control systems and Continuous Integration/Continuous Deployment tools.</li><li>Independent and able to manage, prioritize & lead workload.</li></ul> If you are a dynamic professional with the perfect blend of above mentioned skills , we invite you to join our team and contribute to the success of our projects. Please share your resume at hiring@amtexsystems.com

Data AnalystDallas TX (min 3 days onsite) Locals Only12+ Months Mandatory skills: Snowflake, Google BigQuery, strong SQL Queries. "Snowflake and/or Google BQ expert working knowledge to perform data analysis. Retail background preferred. Analyzes data to draw conclusions and derive insights on how to improve a business group and/or application. Should be able to perform statistical analysis and leverage data visualization tools to make value out of data."

Title: Business Intelligence AnalystLocation: NYC, NYDuration: Full Time Limited domestic travel to unanticipated client locations nationwide, telecommute and/or occasional relocation to create SQL scripts for backend database operations and test data for accuracy. Work with Business Intelligence components like reports, charts, graphs. Utilize WebFOCUS, HTML/CSS, MSSQL, SQL Developer, Postman, JSON in multiplatform environments. Reply to: Amtex Systems, Inc., 28 Liberty Street, 6th Floor, New York, NY 10005

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