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

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?

Georgia It, Inc. Salaries by Position

Data Engineer Location: Dallas, Texas Type: Contract Rate: DOE NO third-party Corp to Corp accepted for this job Description •Strong Python, bash, Linux shell or similar •Experience integrating with native AWS services (CodePipeline, CodeCommit, CodeBuild, CodeDeploy, EC2, EKS, ECR, S3) •Knowledge of networking, IAM, API and security assessment tools/methodologies. •Familiar with container and orchestration. •Familiar with IAM protocols such as SAML, SPML, XACML, SCIM, OpenID and OAuth. •Understanding of the cyber threat landscape and methodologies to protect technology assets. •AWS Certified Developer Associate or AWS Certified Solutions Architect Associate preferred. •Excellent verbal and written communication skills •Proficient in automation and deploying CI and CD tools and services (Jenkins Pipeline as Code, Git, Maven). •Hands on experience building solutions with tools and services like AWS CloudFormation, Terraform, or custom build orchestration tools leveraging SDKs or directly interacting with APIs •Strong understanding of fundamental Application and Infrastructure Security concepts, including common types of attacks and exploitation techniques. •Solid Experience with various application security tools (Example-ZAP, BURP, Tenable,Check Mark, Semmel, fortify, Sonatype, Kali, WebInspect/AppScan, dependency check). •Solid understanding of common web and systems application vulnerabilities.Experience integrating security tools into the DevOps environment (such as Zap or Burp)

Position Data Engineer Location Denver, CO Position type Contract Rate - DOE US Citizens and those authorized to work in the U.S are encouraged to apply. We are unable to sponsor at this time. <ul> <li> Python, Cloud Data engineering & ETL Data Bricks Snowflake, Azure</li> </ul>

Business Analyst/Tester Location: Baltimore, MD 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 Skills and Experience Needed<ul> <li>8 years of experience as an analyst/tester on software projects in supporting requirement analysis, application test script development, and execution.</li> <li>5 years of experience in mapping the business and technical requirements into test cases and generating test scripts. </li> <li>5 years of practical experience in using relational databases and generating SQL scripts is required. </li> <li>5 years of experience in using MS Office (Word, Excel, PowerPoint, Visio) </li> <li>Strong ability to communicate effectively with technical and non-technical teams and users. </li> <li>Should be able to triage change requests, and incidents during all phases of design, development, testing, and training. </li> <li>Practical knowledge in manual and automated testing, 508 compliance, performance, UAT, Unit, regression, and integration testing. </li> <li>Experience with automated testing and automated testing tools. Preferred Qualifications: </li> <li>Master'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. </li> <li>Experience in testing Web applications and mobile applications in a cross-platform and browser environment. </li> <li>Experience in testing Java, JavaScript, jQuery, AngularJS, JMeter, and GitHub is required. </li> <li>Should be able to triage change requests, and incidents during all phases of design, development, testing, and training.</li></ul>Duties: <ul> <li>Develops requirements for information systems from a project's inception to conclusion </li> <li>Gather requirements from end users and document in a pre-defined format for the development team to build solutions. </li> <li>The resource will develop and document test cases, testing plans, and procedures in an agile environment. </li> <li>Resource will design and execute IT software tests and evaluate results to ensure compliance with applicable regulations. </li> <li>Resources will design and prepare all needed test data. And will also review test results and evaluate for conformance to design. </li> <li>Develop and maintain automated regression and integration test plans for validation. </li> <li>Resources will communicate test results and feedback with development teams. </li> <li>Perform database queries to identify and validate test data. </li> <li>Database testing using SQL queries. </li> <li>Assist with data setup for test automation and perform validation of test results. </li> <li>Review data flow across multiple systems </li> <li>Report and track defects and work closely with Developers in defect resolution. </li> <li>Analyze the resolution of software defects to serve as input to plans for retesting. </li> <li>Assist Test AnalystsEngineers with the development and maintenance of the test framework. Education Qualification: </li> <li>A 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.</li></ul>

Business Analyst Location: Lansing, MI ON-SITE: 2 days/week required 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 Skills and Experience Needed <ul> <li> 10 years of experience directing the analysis, definition, and documentation of system and business requirements with clients, for large-scale systems. Business process design and re-engineering. Communication and translating requirements between the business and technical teams.</li> <li> 10 years of experience developing large-scale software systems, using agile methodology and frameworks. Ability to write user stories to support Agile development. The collection of stories and other requirements are recorded in Atlassian JIRA and Confluence.</li> <li> 10 years of experience to facilitate, capturing, organize, and documenting business requirements from all stakeholders, including business-side employees, product owners, and technical resources. Requirement analysis and the ability to decipher what is said to what is really wanted or needed.</li> <li> 10 years of experience developing technical designs in consultation with application/solution architects to set the direction of design and development for large application development projects. Review technical design and specification for completeness and conformance to quality standards, especially as a mentor to less experienced business analysts. Also, experience in the use of responsive design application development with a focus on human-centric designs.</li> </ul> ** Please ignore the email in case you are not interested OR overqualified . We have openings with our clients throughout the country that match your job title and skills. I am here to help you in getting your dream job. If you are available and interested PLEASE CLICK ON THE LINK AT THE BOTTOM OF THE PAGE which will subscribe you to our emails and please forward your Resume to me or please call me ASAP at (718) 668-5300. If you do respond via e-mail please include a daytime phone number so I can reach you. If you are not interested, kindly refer anyone who would be interested. We offer great referrals! Thank you in advance! Sincerely yours, Jerom Russel Sr. Recruiter Jerom@Georgiait.com +01 (470) 798-5000 Ext. 1060 ( Please send me the resume) Alpharetta GA 30005 www.GeorgiaIT.com Note: Please allow me to reiterate that I chose to contact you either because your resume had been posted to one of the internet job sites to which we subscribe, or you had previously submitted your resume to Gerogia IT Inc I assumed that you are either looking for a new employment opportunity, or you are interested in investigating the current job market. If you are not currently seeking employment, or if you would prefer I contact you at some later date, please indicate your date of availability so that I may honor your request. In any event, I respectfully recommend you continue to avail yourself to the employment options and job market information we provide with our e-mail notices.

Position: Data Engineer Location: Baltimore, MD Duration: Contract Rate: DOE <ul> <li> Must have at least 5 years of experience</li> <li> Must have good experience in Sql queries</li> <li> Must have good experience in Agile</li> <li> Must have good experience in AWS</li> <li> Experience in Java, Springboot would be an added advantage</li> <li> Must have a bachelors degree</li> <li> Must have good communication skills</li> </ul>

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>

VP, Data Engineer Location: Philadelphia, PA or Whitehouse Station, NJ . Hybrid role 3 days in office Duration: 6 months + CTH Job description Client team is a small, agile group of technology enthusiasts. We are tasked with solving the complex data needs of both US and International reserving and pricing actuaries. Our group is responsible for collating data from several disparate systems and platforms to provide analytic solutions for the world's largest publicly traded property and casualty insurer. Our systems are the foundation for the loss triangles which are reported externally and ensure we have the capital to pay future claims. This position is for a full-time AVP Data Engineer in either our Philadelphia, PA or Whitehouse Station, NJ office. WHAT YOU'LL BE WORKING ON Expanding our new claim data warehouse responsible for producing actuarial loss triangles Implementing BI processes so end users can quickly and easily derive value from billion row datasets Creating of new ETL process to accurately stitch data together Helping to design the future cloud architecture and migration of the warehouse Investigating, diagnosing, and actioning on business questions and requests Direct handling of production support and maintenance of existing financial feeds Delivering solutions on time and within budget, meeting both internal change management standards and external SOX controls QUALIFICATIONS Microsoft SQL Server guru with strong data warehousing fundamentals Fluency in other databases, coding languages (eg R, Python, .NET), and BI solutions (eg Shiny, Cognos, PowerBI) Proficient in DevOps tools (GIT, Jenkins, Octopus) dept in Agile project management ideologies Extensive technical analysis and investigative capabilities Strong communication skills, comfortable interfacing with senior business users Financial/actuarial data, application, or practical experience a plus

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