Prepare for and practice interview questions from Georgia It, Inc..

Georgia It, Inc. Interview Questions

Georgia It, Inc. Interview Guides

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?

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

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

Georgia It, Inc. Salaries by Position

Sr Embedded Software Engineer Location: Plano, TX Duration: Contract Rate: DOE US Citizens, GC, EAD ( H4, L2), E3 TN visa holders preferred, NO third party corp to corp accepted for this job Roles & Responsibilities:<ul> <li>Understanding Technical and Requirement Specifications for telematics and connected vehicle applications.</li> <li>Integrating embedded software development processes & best practices by designing and developing solutions.</li> <li>Complete requirement analysis and traceability.</li> <li>Participate in architecture design, low-level design, and exposure to UML Diagrams.</li> <li>Collaborate with cross functional teams (e.g., hardware engineers, system architects, and product managers) to define software requirements and specifications.</li> <li>Write efficient, maintainable, and well-documented code for embedded systems.</li> <li>Implement device drivers, communication protocols, and low-level software components.</li> <li>Conduct system-level and unit-level testing to ensure software reliability and functionality.</li> <li>Use of debugging skills is a must - logging mechanisms, log analysis and optimizing software.</li> <li>Excellent communication and teamwork skills to collaborate effectively with cross-functional teams.</li></ul> Experience & Qualification:<ul> <li>Proven experience in software engineering, embedded systems development or related field; preferred higher-level education in Computer Science, Electrical Engineering, or a related field.</li> <li>Strong programming skills in embedded C/C++ programming.</li> <li>Experience in Linux Application programming.</li> <li>Experience with embedded systems development, including real-time operating systems (RTOS).</li> <li>Knowledge of software version control systems (e.g., Git).</li> <li>Experience in Unit and Integration testing.</li></ul> Additional Experience:<ul> <li>Good understanding of vehicle communication network - CAN & Ethernet.</li> <li>Vehicle network architecture - ECU nodes, Gateways, and Network log analysis.</li> <li>Exposure to vector tools - CANoe and CAPL.</li> <li>Diagnostics - UDS, DoCAN, and DoIP.</li> <li>Experience in automotive coding standards and practices - MISRA and Secure coding.</li> <li>Exposure to automotive quality processes.</li> <li>ASPICE standards.</li> <li>Automotive software development life cycle, processes, and quality templates.</li></ul>

Job- Data Engineer Location- Remote Core skills needed - <ul> <li>Data Engineering tools and techniques (any ETL/ ELT skills are good to have )</li> <li>Python, XML, XPath</li> <li>SQL</li> <li>AWS Lambda, SQS, Fargate, S3,</li> <li>Dev Ops</li> <li>10-12 year of exp must have</li> <li>Proficiency in Python</li> <li>Proficiency in Linux/Unix environments</li> <li>Experience building applications for public cloud environments (AWS preferred)</li> <li>Experience with AWS DevOps tools (git, Cloud Development Kit, CDK Pipeline) is highly desired</li> <li>Experience building applications using AWS Serverless technologies such as Lambda, SQS, Fargate, S3 is highly desired</li> <li>Experience with Apache Airflow is a plus</li> <li>Experience building containerized applications (Docker, Kubernetes) is a plus</li></ul> Skills Position Responsibilities<ul> <li>Data Engineer is responsible for developing Life Sciences content curation and delivery system for the purpose of building life sciences databases.</li> <li>Develops data transformation and integration pipelines and infrastructure foundations of life sciences content in support of scientific databases and data curation</li> <li>Combines strong software development and data engineering skills with a working knowledge of basic biology/chemistry/physics to develop sophisticated informatics solutions that drive efficiencies in content curation and workflow process. Applies data transformation and other data-engineering software development capabilities to contribute to the building of new scientific information management systems supporting scientific database building activities.</li></ul> Competencies/Technologies<ul> <li>Experience with databases technologies (NoSQL, relational, property graph, RDF/triple store)</li> <li>Experience with data engineering tools and techniques is highly desired</li> <li>Experience working with XML and XPath is highly desired</li> <li>Experience with MarkLogic/Xquery is a plus</li></ul>

Data Architect Location: Baltimore, Maryland Work Style: Hybrid (3 days on-site; 2 days work from home); Only USC OR Green Card Duties: Developing and overseeing the data architecture strategy, ensuring the successful integration and management of data across the lake house infrastructure Data Architecture Design: Develop and maintain a robust data architecture strategy for the AWS Cloud-based Lake House, encompassing data modeling, data storage, data processing, and data integration across various AWS services, such as S3, Glue, Athena, and Redshift. Cloud Data Governance: Define and enforce data governance principles, standards, and best practices to ensure data quality, security, and compliance with relevant regulations. Data Integration: Design and implement efficient data integration processes, enabling seamless data flow between diverse data sources and the data lake infrastructure. Performance Optimization: Collaborate with data engineers and technical teams to optimize the performance and scalability of the data lake architecture, ensuring high availability and low latency for data access and processing. Metadata Management: Implement metadata management solutions to enhance data discoverability, lineage, and cataloging within the data lake house. Data Security: Develop and enforce security measures to protect sensitive data, adhering to industry best practices and AWS security standards. Collaboration and Leadership: Work closely with cross-functional teams, including data analysts, data scientists, and data engineers, to understand their data requirements and provide technical guidance on data-related initiatives. Data Architecture Documentation: Maintain comprehensive documentation of the data architecture, including architectural diagrams, design specifications, and data flow processes. Technology Evaluation: Stay informed about the latest AWS services and data- related technologies, assessing their potential value and recommending their adoption as appropriate. Continuous Improvement: Continuously evaluate the effectiveness of the data architecture, identifying opportunities for enhancement and driving improvements to meet evolving business needs. Education Qualification Bachelor's Degree from an accredited college or university with a major in Computer Science, Information Systems, Engineering, Business, or other related scientific or technical discipline is required. General Experience: At least Fifteen (15) years of experience in architecting on-prem/cloud based multi user environments with expertise in planning, designing, building, and implementing IT application modernization/implementation effort. Proven experience as a Data Architect, with a focus on designing and implementing data solutions in AWS cloud environments. Extensive knowledge of AWS cloud services, data lake architecture, and big data technologies. Strong understanding of data modeling principles, data governance, and data security practices. Demonstrated expertise in designing data integration solutions and optimizing data processing performance. Excellent analytical and problem-solving skills, with the ability to make data-driven decisions. Leadership skills to guide and mentor junior data architects and collaborate with cross- functional teams. AWS certifications, such as AWS Certified Solutions Architect, AWS Certified Data Analytics - Specialty, or AWS Certified Big Data - Specialty, are highly desirable. Strong communication and presentation skills to effectively convey complex technical concepts to non-technical stakeholders.

Senior Data Analyst Location: Phoenix AZ Duration: 06 Months Rate: DOE US Citizens and Green cards & GC-EAD Only. No Third-party C2C available for this job Core skills needed:<ul> <li>Senior level experience with SQL</li> <li>Python proficiency analyzing complex and massive timeseries datasets</li> <li>Familiarity with data pipelining (ETL, Airflow)</li> <li>Timescale DB hyperfunctions (or related) Prior experience working with SharePoint administration, SQL Server and Cohesity</li> <li>Cloud Platforms such as Azure, AWS and GCP.</li> <li>Preferably a background in a production or manufacturing related field</li></ul> Top Skills Details<ul> <li>5 years prior experience working as a Senior Data Analyst</li> <li>Advanced/expert level ability with SQL Server and Python</li> <li>Data pipelining with ETL and or Airflow</li> <li>Timescale DB hyperfunctions</li> <li>Familiar with and strong ability to work will work with tools and technologies to enable and support a variety of IaaS services (Compute, Storage, Network) for Cloud Platforms such as Azure, AWS and GCP.</li> <li>Professional, excellent organizational and communication skills, desire to serve and help others</li></ul>

Data Architect Location: Palo Alto, CA (Hybrid) Duration: Long Term Rate: DOE Key Responsibilities: Data Orchestration:<ul> <li>Design, implement, and manage data workflows using Airflow to automate and orchestrate data processing tasks.</li> <li>Optimize Airflow DAGs (Directed Acyclic Graphs) for performance and scalability.</li></ul>Task Management:<ul> <li>Develop and maintain distributed task processing using Celery and ensure robust task queue management with Redis or RabbitMQ.</li></ul>Database Management:<ul> <li>Design and manage databases using Cosmos DB, MongoDB, and PostgreSQL.</li> <li>Develop and maintain efficient data models and ensure data consistency and integrity.</li></ul>API and Webhooks:<ul> <li>Implement and manage FastAPI webhooks to handle data ingestion and integration tasks.</li> <li>Develop and maintain Azure Functions to support webhook operations and integrate with cloud services.</li></ul>Streaming Data:<ul> <li>Implement and manage Kafka Streams to handle real-time data processing and streaming requirements.</li></ul>Data Lake Management:<ul> <li>Work with Iceberg to manage and optimize large-scale data lake storage and querying.</li></ul>Collaboration and Communication:<ul> <li>Collaborate with data scientists, engineers, and business analysts to understand data requirements and provide technical solutions.</li> <li>Document processes, architectures, and configurations to ensure knowledge sharing and compliance with best practices.</li></ul>Required Skills and Qualifications: Experience and Knowledge:<ul> <li>Proven experience with Airflow for data orchestration and workflow management.</li> <li>Hands-on experience with Celery for task management and Redis or RabbitMQ for messaging.</li> <li>Proficiency with Cosmos DB, MongoDB, and PostgreSQL for data storage and management.</li> <li>Experience developing and managing webhooks using FastAPI and integrating with Azure Functions.</li> <li>Knowledge of Kafka Streams for real-time data processing.</li> <li>Familiarity with Iceberg for data lake management and optimization.</li> <li>Healthcare domain experience is good to have .</li></ul>Technical Skills:<ul> <li>Strong understanding of data pipelines, ETL processes, and data integration.</li> <li>Proficient in Python, with experience in building and maintaining data-oriented applications.</li> <li>Ability to work with large datasets and optimize performance across distributed systems</li></ul>Soft Skills:<ul> <li>Excellent problem-solving and analytical skills.</li> <li>Strong communication and collaboration skills.</li> <li>Ability to work independently and manage multiple priorities in a fast-paced environment.</li></ul>

UIPATH or Blue Prism Business Analyst Location: Charlotte NC - Hybrid Duration: 6 months Rate: DOE Execute and lead the requirements gathering process to define and document the functional requirements for RPA / Intelligent Automation solutions. Develop and document process flows, use cases, and other artifacts to support Automation / Intelligent Automation solution design. Experience in working in Agile methodology and write the user stories and acceptance criteria Develop test plans, scenarios, scripts, and other documentation to support the development of Automation solutions. Coordinate with stakeholders to ensure Automation solutions meet business needs. Act as a liaison between the IT team and the business to ensure that Automation solutions are designed and implemented in line with the business requirements. Monitor and report on Automation project progress, performance, and issues. Analyze existing processes and recommend ways to improve process efficiency using Automation solutions. Research emerging Automation technologies and trends and recommend potential solution opportunities. Develop and maintain comprehensive business process, data, and system models for Automation solutions. Train and mentor other team members in the use of Automation technologies and processes. Requirements •Strong understanding of the clients' (internal and external) needs and issues and applies knowledge to support critical systems and projects. •4+ years RPA experience with at least one RPA toolset (Workfusion, UIPATH, Automation Anywhere, Blue Prism) •8+ years Business Analysis experience •Complete understanding of agile processes such as Scrum and Kanban to mentor and guide teams •Excellent communicator; able to gain the respect of the team, external stakeholders, and management •Mentors team members on Agile/Scrum best practices •Must have experience with one of these agile tools: JIRA or VersionOne •Bachelor's degree in Software Engineering, Computer Science, Business Management, or related discipline

Position- Data Engineer Location- Plano TX Duration- Contract Job Description: Required Skills: Unix,Python,PySpark,SQL,AWS Roles & Responsibilities :<ul> <li>Analyze business processes to identify areas for improvement and optimization.</li> <li>Develop and maintain data pipelines using Python and PySpark to ensure efficient data processing.</li> <li>Utilize AWS services to manage and deploy scalable data solutions.</li> <li>Write and optimize SQL queries to extract and manipulate data for analysis.</li> <li>Implement Unix scripts to automate routine tasks and enhance system performance.</li> <li>Collaborate with stakeholders to gather requirements and translate them into technical specifications.</li> <li>Provide actionable insights through data analysis to support strategic decision-making.</li> <li>Create and maintain comprehensive documentation for data processes and business workflows.</li> <li>Conduct data validation and quality checks to ensure accuracy and reliability of data.</li> <li>Lead data-driven projects from inception to completion, ensuring timely delivery and alignment with business goals.</li> <li>Communicate findings and recommendations to both technical and non-technical audiences.</li> <li>Stay updated with industry trends and best practices to continuously improve data solutions.</li> <li>Work closely with IT and development teams to integrate data solutions into existing systems</li></ul>Qualifications:<ul> <li>Possess strong analytical skills with the ability to interpret complex data sets.</li> <li>Demonstrate proficiency in Python and PySpark for data processing and analysis.</li> <li>Have hands-on experience with AWS services for data management and deployment.</li> <li>Show expertise in writing and optimizing SQL queries for data extraction and manipulation.</li> <li>Be skilled in Unix scripting for automation and system performance enhancement.</li> <li>Exhibit excellent communication skills to effectively collaborate with cross-functional teams.</li> <li>Display a proactive approach to problem-solving and continuous improvement.</li> <li>Hold a Bachelor's degree in Computer Science, Information Technology, or a related field.</li> <li>Have a proven track record of delivering data-driven projects on time</li></ul>

Software Engineer Java Location: Whitehouse station, NJ. Hybrid 3 days onsite 2 days WFH Duration: 4 months CTH Job description As a Java Software Engineer for Client's Global Risk Systems, you will enhance a geospatial application critical to underwriting and risk management. The technology stack is Java 1.8 front end on WebSphere Application Server 8.5 hosted on Linux servers, with persistence to Oracle on AIX. You will design, size, build, and deliver enhancements to remove dependency on an existing technology for file storage, retention, and delivery. As part of the ELAIS team, you will participate in story refinement, sizing, and acceptance criteria, sprint planning and commitment, daily stand-ups, sprint retrospectives, and other ceremonies associated with Agile methodology. You will collaborate with a dedicated and highly experienced development team with specialization in the development of geospatial solutions. Top 3 must have skill sets: Minimum 5 years development experience: Java 1.8 (core skills, some front end experience with servlets, security) JMS / MQ messaging File storage and retention to NAS storage Top 3 nice to have skill sets: UNIX / AIX scripting ksh Spring Boot

Job Title - Data Analyst / Modeler Location - Westlake, Texas Duration - 12 Plus Months Rate - DOE U.S. Citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time. Job Description<ul> <li>Bachelor's Degree or equivalent in a technology related field (e.g. Computer Science, Engineering, etc.) with a focus on data analysis, data structures, or data modeling.</li> <li>Understanding of modeling strategies - dimensional, relational, semi-unstructured (e.g. JSON, XML etc.).</li> <li>Robust SQL experience.</li> <li>Proven track record of solving real world problems using a design-oriented understanding of different database (e.g. Oracle, Snowflake, MongoDB) and streaming (e.g. Kafka) platforms.</li> <li>Expert level analysis skills in the form of research, gap analysis, data mining, and data profiling.</li> <li>Familiarity with enterprise data lakes and Cloud data platforms such as Snowflake.</li> <li>Financial domain knowledge is a huge plus</li></ul>

Ometria CDP Lead Business Analyst Location - Columbus, OH Rate - DOE Start date - immediately Job Description<ul> <li>We are looking for a Lead Business Analyst with Ometria CDP experience. They need to be able to help the client understand how to use the tool and support the implementation process from a BA and Lead perspective.</li> <li>Strong CDP experience is key.</li></ul>

Georgia It, Inc. Interview Questions

Georgia It, Inc. Interview Guides

Georgia It, Inc. Interview Questions

Georgia It, Inc. Salaries by Position

Georgia It, Inc. Opening Jobs