Prepare for and practice interview questions from State of maryland.

State of maryland Interview Questions

State of maryland 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

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 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

State of maryland Salaries by Position

Introduction The Department of Information Technology (DoIT) leads the State in the creation and implementation of information technology solutions that improve IT infrastructure and government services and keep Maryland current within IT industry trends. GRADE STD 0019 LOCATION OF POSITION Department of Information Technology (DoIT) 100 Community Place Crownsville, MD 21032 POSITION DUTIES This position serves as a Functional/Business Analyst of the Financial Applications System (FAS) team for the statewide Financial Management Information System (FMIS) application. FMIS consists of the Advanced Purchasing and Inventory Control System (ADPICS), the statewide financial information system (R*STARS) and statewide reporting applications ADHOC/FOCUS, ViewDirect and the WEB Based application - ANSWERS. Responsibilities include the resolution of level two and three incidents and requests for user support originating in ServiceNow. The analyst's knowledge of the various FAS applications and general business and accounting practices will enable them to analyze user requests, solve system problems and process user requests into system design specifications. ***Internal Recruitment to State Employees Only*** <ul> <li>Provide FAS application support to end-users which cannot be solved by lower-level help desk support. This includes prioritizing, troubleshooting and communicating issues to the customer. Provide reports through the use of approved ADHOC reporting. </li> <li>Support applications by researching system problems, identifying resolution, and communicating impact. Recommend program modification and enhancements and ensure users have proper procedures. Participate as required with other technical staff in the design, development and testing of system modifications.</li> <li>Attend and lead meetings regarding the application. Meet with varied state financial users to ensure sound financial application management principles are applied within the application. Make presentations as required to all levels of management.</li> <li>Use best practice methods of project management for information technology projects. This includes reviewing and approving project management. Monitor all phases of the project and make recommendations on schedule, budget and scope-change impacts to management. Develop project plans as required and assist in tracking results</li> <li>Provide functional training as required. Provide training documentation as required.</li> <li>Act as liaison between agencies, user groups and other DoIT personnel.</li> </ul>MINIMUM QUALIFICATIONS Experience: Five years of experience providing problem analysis and ongoing user support, coordinating system development and implementation, and training users on the functionality of applications for agency or statewide systems housed on computers or large client server platforms. Notes: 1. Candidates may substitute the possession of a Bachelor's degree from an accredited college or university in Information Technology or other related field with specific coursework in the structure and use of automated information systems and three years of experience providing problem analysis and ongoing user support, coordinating system development and implementation, and training users on the functionality of applications for agency or statewide systems housed on computers or large client server platforms for the required experience. 2. Candidates may substitute U.S. Armed Forces military service experience in the Cyber and Information Systems classifications or Cyber and Information specialty codes in the Information Technology field of work on a year-for-year basis for the required experience. DESIRED OR PREFERRED QUALIFICATIONS Preference will be given to candidates who have the following:<ul> <li>State of MD Government accounting experience, which includes a strong working knowledge of the Financial Management Information System (FMIS).</li> <li>Experience using Structured Query Language (SQL) in running state accounting reports in FOCUS.</li> </ul> SPECIAL REQUIREMENTS Employees in this classification may be subject to call-in 24 hours a day and, therefore, may be required to provide the employing agency with a telephone number where the employee can be reached. Employees may be furnished with a pager or cell phone. Applicants for this classification may handle sensitive data. This will require a full scope background investigation prior to appointment. A criminal conviction may be grounds for rejection of the applicant. Employees may occasionally be required to travel to field locations and must have access to an automobile in the event a state vehicle cannot be provided. Standard mileage allowance will be paid for use of a privately owned vehicle. SELECTION PROCESS Please make sure that you provide sufficient information on your application to show that you meet the qualifications for this recruitment. All information concerning your qualifications must be submitted by the closing date. We will not consider information submitted after this date. Successful candidates will be ranked as Best Qualified, Better Qualified, or Qualified and placed on the eligible (employment) list for at least one year. EXAMINATION PROCESS The assessment may consist of a rating of your education, training, and experience related to the requirements of the position. It is important that you provide complete and accurate information on your application. Please report all experience and education that is related to this position. BENEFITS STATE OF MARYLAND BENEFITS FURTHER INSTRUCTIONS Online applications are highly recommended. However, if you are unable to apply online, the paper application and supplemental questionnaire may be submitted to: Department of Budget and Management, Recruitment and Examination Division, 301 W. Preston St., Baltimore, MD 21201. Paper application materials must be received in our office by the closing date for the recruitment. No postmarks will be accepted. For questions regarding this recruitment, please contact the DBM Recruitment and Examination Division at Application.Help@maryland.gov or 410-767-4850, MD TTY Relay Service 1-800-735-2258. We thank our Veterans for their service to our country. People with disabilities and bilingual candidates are encouraged to apply. As an equal opportunity employer, Maryland is committed to recruitment, retaining and promoting employees who are reflective of the State's diversity. For education obtained outside the U.S., a copy of the equivalent American education as determined by a foreign credential evaluation service must be provided prior to hire.

Introduction The Maryland Department of the Environment is charged with protecting and preserving the State's air, water, and land resources and safeguarding the environmental health of all Maryland's citizens. The Agency's mission is to protect and restore the environment for the health and well-being of all Marylanders with a vision of healthy, vibrant, and sustainable communities and ecosystems in Maryland. If you are looking for an exciting career committed to helping the environment for all Marylanders, please apply to become part of MDE's workforce. MDE offers competitive pay, great benefits, opportunities to telework, as well as opportunities for advancement and professional growth - MDE offers you a wide range of benefits such as medical and dental coverage, paid time off (i.e., vacation, sick leave), state pension, and supplemental retirement options (i.e., 401k, 457b etc.). MDE headquarters facility offers free parking, a food court, and a gym. GRADE 19 LOCATION OF POSITION Office of Information Management and Technology 1800 Washington Blvd. Baltimore, MD 21230 Main Purpose of Job The IT Business Analyst assists the Project Management Office primarily with business requirements gathering, crafting project scope statements, and documentation in accordance with the Agile project methodology. In addition, the IT Business Analyst will also assist the Project Management Office in the development, implementation and monitoring of policies, procedures, and standards throughout the department to ensure that project activities meet stakeholder defined requirements. The incumbent in this position will gather business requirements, recommend new standards, methods of operation, and technologies to the Director of Projects to improve how the agency accomplishes its mission. The IT Business Analyst will be responsible for performing needs assessments, identifying problems or solutions, assessing the current state of the organization, recommending actions to address business needs, and assembling business cases. The position promotes the strategic direction of information technology and may act as the Director of Projects representative in meetings and conferences or as liaison between the Project Management Office and agency units. This position will also act as the team leader on IT projects and may work on sensitive and confidential information at the discretion of the Director of Projects. This position provides technical and business process advice and guidance to the environmental media staff, vendors, supervisory personnel, and to departmental management regarding future direction, customization, software enhancement, and business process standardization for the implementation of ETS, LRCA, and other IT application projects. MINIMUM QUALIFICATIONS Experience: Five years of experience designing, developing, testing, implementing and maintaining applications systems and programs using generally accepted computer programming languages or maintaining and modifying operating systems for computers. Notes: 1. Candidates may substitute graduation from an accredited high school or possession of a high school equivalency certificate and thirty credit hours from an accredited college or university in Computer Information Technology, Management Information Systems, Computer Science, or other information technology-related field to include course work in systems analysis and applications programming using generally accepted computer programming languages for four years of the required experience. 2. Candidates may substitute graduation from an accredited high school or possession of a high school equivalency certificate and one year of experience designing, developing, testing, implementing and maintaining applications systems and programs using generally accepted computer programming languages or maintaining and modifying operating systems for four years of the required experience. 3. Candidates may substitute experience operating computer systems; or scheduling, controlling input and output or maintaining a tape library to process data on computer systems; or evaluating, implementing and maintaining microcomputer hardware and software; or converting data from project specifications by developing program code using generally accepted computer programming languages on a year-for-year basis for a high school education. 4. Candidates may substitute the possession of a Bachelor's degree from an accredited college or university in Computer Information Technology, Management Information Systems, or other information technology related field to include course work in systems analysis and application programming using generally accepted computer programming languages or in operating systems and data communications technology and one year experience designing, developing, testing, implementing and maintaining applications systems and programs using generally accepted computer programming languages or maintaining or modifying operating systems for computer for the required experience. 5. Candidates may substitute U.S. Armed Forces military service experience as a commissioned officer in Cyber and Information Systems classifications or Cyber and Information Systems specialty codes in the Information Technology field of work on a year-for-year basis for the required experience. DESIRED OR PREFERRED QUALIFICATIONS Preference will be given to applicants who possess the following preferred qualification(s). Include clear and specific information on your application regarding your qualifications. -Bachelor's degree -3+ years of experience in Business Assurance -Certification in one of the following: <ul> <li>Business Analyst (BA)</li> <li>Quality Assurance</li> <li>Quality Analyst</li> <li>Project Management</li> <li>Information Technology</li> </ul> SELECTION PROCESS Please make sure that you provide sufficient information on your application to show that you meet the qualifications for this recruitment. All information concerning your qualifications must be submitted by the closing date. We will not consider the information submitted after this date. Successful candidates will be ranked as Best Qualified, Better Qualified, or Qualified and placed on the eligible (employment) list for at least one year. RESUMES ARE NOT ACCEPTED AND ARE NOT CONSIDERED IN THE SELECTION PROCESS. All information concerning the qualifications, including any required documentation (diploma, transcript, certificate, etc.) must be submitted and received by the closing date. Information submitted after this date will not be considered. Should you possess a bachelor's/master's degree from a college or university outside of the United States, you must have your educational credentials evaluated by an approved education review service. This evaluation must be submitted prior to hire. For further information, you may call International Consultants of Delaware, Inc. at 302-737-8715 or World Education Services Inc. at 1-800-932-3897 or 202-331-2925. All Applicants must be legally authorized to work in the United States under the Immigration and Reform Control Act of 1986. You must be legally authorized and possess any necessary documents under this Act in order to be hired in the position for which you applied. BENEFITS STATE OF MARYLAND BENEFITS (Click ctrl+link to view all benefits) PERSONAL LEAVE - New State employees are awarded six (6) personal leave days annually (prorated based on start date). ANNUAL LEAVE - ten (10) days of accumulated annual leave per year. SICK LEAVE - fifteen (15) days of accumulated sick leave per year. PARENTAL LEAVE - up to sixty (60) days of paid parental leave upon the birth or adoption of a child. HOLIDAYS - State employees also celebrate at least twelve (12) holidays per year. FURTHER INSTRUCTIONS It is highly preferred that you apply online. If you are unable to apply online, you may submit the State paper application and supplemental questionnaire (by the closing date) to olivia.sterrett@maryland.gov or mail to: Maryland Department of the Environment OHR - Recruitment and Examination Division 1800 Washington Blvd. Baltimore MD 21230 For questions regarding this recruitment, please contact Olivia Sterrett at 410-537-3105. If you have difficulties submitting your online application, please contact the Department of Budget and Management, Recruitment and Examination Division at 410-767-4850 or Application.Help@maryland.gov. We thank our Veterans for their service to our country. People with disabilities and bilingual candidates are encouraged to apply. As an equal opportunity employer, Maryland is committed to recruitment, retaining, and promoting employees who are reflective of the State's diversity. MDE is dedicated to creating a workforce that reflects the communities we serve. We strive to cultivate an inclusive environment where differences are celebrated.

State of maryland Interview Questions

State of maryland Interview Guides

State of maryland Interview Questions

State of maryland Salaries by Position

State of maryland Opening Jobs