Prepare for and practice interview questions from Open Systems Technologies.

Open Systems Technologies Interview Questions

Open Systems Technologies 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 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?

In an A/B test, how can you check if assignment to the various buckets was truly random?

In an A/B test, which of the following is a common method to determine if the assignment to the test groups was truly random?

In an A/B test, which of the following is a common method to determine if the assignment to the test groups was truly random?

Random Bucketing

Open Systems Technologies Salaries by Position

Title: Software Engineer/ETL; SQL; Cloud ONSITE in Nashville, TN Duties: Provides expert content/professional leadership on complex Engineering assignments/projects. Designs and develops a consolidated, conformed enterprise data warehouse and data lake which store all critical data across Customer, Provider, Claims, Client and Benefits data. Designs, develops and implements methods, processes, tools and analyses to sift through large amounts of data stored in a data warehouse or data mart to find relationships and patterns. Participates in the delivery of the definitive enterprise information environment that enables strategic decision-making capabilities across enterprise via an analytics and reporting. Exercises considerable creativity, foresight, and judgment in conceiving, planning, and delivering initiatives. Uses deep professional knowledge and acumen to advise functional leaders. Focuses on providing thought leadership within Information Management but works on broader projects, which require understanding of wider business. Recognized internally as a subject matter expert. Skills: Design, develop and maintain ETL platforms for various business use cases which are fault tolerant, highly distributed and robust. Analyze large sets of structured and semi structured data for business analytics and ETL design. Translate business needs and vision into roadmap, project deliverables and organization strategies. Design and implement ETL solutions using leveraging cloud native platforms. Collaborate with analytics and business teams to design data models that feed business intelligence tools, increasing data accessibility and encouraging data driven solutions. Experience with data modelling techniques for cloud data stores and on prem databases like Teradata, Teradata Vantage (TDV), etc. Preferred working experience in ETL development in Teradata vantage and data migration from on prem to Teradata vantage. Proficiency in SQL, relational and non-relational databases, query optimization and data modelling. Experience with source code control systems like Gitlab. Experience with large scale distributed relational and NoSQL database systems. Good experience on designing and developing data pipelines for data ingestion and transformation using Spark. Distributed computing experience using Python, Pyspark. Good understanding of spark framework and spark architecture. Experience working in Cloud based big data infrastructure. Excellent in trouble shooting the performance and data skew issues. Must have good understanding of spark run time metrics and tune applications based on metrics. Deep knowledge in partitioning, bucketing concepts of data ingestion. Good understanding of AWS services like Glue, Athena, S3, Lambda, Cloud formation. Preferred working knowledge on the implementation of datalake ETL using AWS glue, Databricks etc. Technologies: Pyspark, Python, AWS services, Teradata Vantage, CI/CD technologies, Terraform, SQL. #LI-HM1

A financial firm is looking for a Software Engineer to join their team in Houston, TX. Compensation: $150-200k Qualifications: Required: <ul> <li>3+ years of work experience as a backend developer, with proficiency in Python and/or C#.</li> <li>Solid experience with messaging solutions such as Kafka, RabbitMQ, or Solace.</li> <li>Demonstrated ability in code optimization, performance tuning, and testing.</li> <li>Good understanding of both SQL and NoSQL database technologies.</li> <li>Comprehensive knowledge of application development processes, including authentication, API integration, build process, testing, validation, and state management.</li> <li>Familiarity with source code control systems, with a preference for Git.</li> <li>Strong analytical skills with the ability to troubleshoot, assess problems logically, and devise solutions.</li> <li>A Bachelor's degree in computer science or a closely related field.</li></ul>Preferred:<ul> <li>Some exposure to or understanding of energy/commodity markets (e.g., Power, Gas, Oil, Coal, Metals, Emissions) is beneficial but not required.</li> <li>Familiarity with OTC products (forwards, swaps, options, swaptions) is a plus.</li> <li>Knowledge of securities and OTC trades, including lifecycle management, asset servicing, position management, transaction reporting, reconciliation, exception management, and break resolution workflow, would be advantageous.</li></ul>

A software company is looking for a .NET Software Engineer to join their team in Wall, NJ. Compensation: $100-125k The chosen candidate will have proven experience with: <ul> <li>Visual Studio</li> <li>C# <ul> <li>.NET 6/7/8</li> <li>Windows Services</li> <li>WebAPI/Minimal API</li> <li>Knowledge of SOLID</li> <li>xUnit</li> <li>Dapper</li> </ul> </li> <li>SQL Server</li> <li>GIT </li></ul> These skills will be a plus: <ul> <li>Blazor</li> <li>Microsoft Power BI</li> <li>.Net Framework </li></ul>24-02404 #LI-ML1

A financial firm is looking for a Software Engineer to join their team in New York, NY. Pay: $100/hr Responsibilities: •Developing and testing integrations between software products •Extending products and services through contributions in development, enhancements, testing and implementation •Developing, modifying, extending code for building cloud infrastructure, and automate using CI/CD pipeline •Ability to perform problem analysis, data analysis, reporting, and communication Qualifications: •Strong analytical and communications skills •Ability to design and implement interfaces by incorporating established best practices. •Experience using Continuous Integration and Deployment tools such as Gitlab/Jenkins, etc. •Strong technical skill in software engineering for Java EE /Cloud technologies and proficiency in Java Lambdas, Java Streams API, Java functional programming •Proficiency in one or more programming languages e.g., Python, Scala. •Required Technologies: Java 8-21, JavaScript, Spring (Data, MVC, Security, Core, etc.), App/Web server(Tomcat, JBoss, etc.), RDBMS(Oracle, PostgreSQL) •Required Experience: Building, integrating, and testing systems end-to-end •Preferred Experience: Building web UIs using React, Vue or Angular. •Preferred Technologies: Docker, Terraform, Playwright and AWS services (IAM, S3, CloudFront, Secrets Manager, EC2, ECS, ALB, RDS, Elasticache, MSK, AmazonMQ) •Preferred Experience: building and integrating decision support applications for operations and trading in the financial industry, specifically with middle and back office and or compliance and risk management products 24-04842

A financial firm is looking for a Data Analyst to join their team. This role is remote. Pay: $45/hr USC only - will go through L2 background Responsibilities: •Elicit and document business requirements. •Translates business requirements to technical requirements. •Produces actionable dashboards in Power BI and/or Tableau and reports that show key performance indicators; identify areas of improvement for processes, products, or services. •Responds to ad-hoc requests and provides reporting solutions across multiple business areas. Creates and maintains specifications for reports and analyses based on business needs and required or available data elements. •Generates ad hoc reports or data extracts, dashboards, canned reports, and regular datasets for end-users using system tools, queries, and scripts. Integrates data from multiple sources to produce requested or required data elements. •Identifies areas of improvement in data collection processes or systems and make recommendations to correct any deficiencies. Qualifications: •Diverse professional work experience in data visualization, data analysis, Tableau, Power BI •Proficient in SQL including Complex SQL joins, inline tables, complex business logic •Advanced Calculations in Tableau •Demonstrated experience in analytical, problem solving, critical thinking, operational excellence, communication (written and verbal), stakeholder management, interpersonal, and self-management skills. Experience with Agile development methodologies. •Experience with Cloud technologies such as Aws, Azure with an emphasis on serverless architecture. -Tableau reporting experience is a must - parameters and advanced calculations using tableau is key -The team uses scrum - they want someone with agile experience -Proficient in SQL including Complex SQL joins, inline tables, complex business logic -Analytical thinker with strong communication skills -Experience with Cloud technologies such as Aws, Azure

Open Systems Technologies Interview Questions

Open Systems Technologies Interview Guides

Open Systems Technologies Interview Questions

Open Systems Technologies Salaries by Position

Open Systems Technologies Opening Jobs