Prepare for and practice interview questions from Htc Global Services.

Htc Global Services Interview Questions

Htc Global Services Interview Guides

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

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

Htc Global Services Salaries by Position

Data EngineerExperience: 3+ yearsLocation: Chennai/Bangalore/HyderabadNotice Period: Immediate to 15 days Job Description: Degree in Computer Science or equivalent 5 or more years of relevant experience in IT industry. 3 to 4 years of data warehouse, data lake and business intelligence implementation experience Technical Skills (must have these skillsets) : 1 - 2 years of ETL Experience (Talend) and able to <ul><li>Design and develop ETL Jobs </li><li>Write JAVA programs </li><li>Preferred Experience : </li><li>Install, configure and administer Talend jobs/ scripts </li><li>Create SCD dimension using Talend components </li><li>Fluent in using all sort of Talend components (including bigdata) </li><li>Have very good knowledge in TOS Architecture and TOS Functional architecture </li></ul> 2 - 3 years of Power BI Experience and able to <ul><li>Develop, publish and schedule dashboards and reports as per user requirement </li><li>Develop advanced DAX queries in Power BI Desktop </li><li>Implement and Manage Data Security on Power BI deliverables </li></ul> Scripting Language - SQL, Functions and Stored Procedures Azure SQL DB Fine tuning and optimization Ability to analyse, understand and effectively communicate the business processes, requirements and technical design, solution and implementation Ability to communicate effectively with various stakeholders (e.g business/ end users, management and co[1]workers to prepare, present and explain data. Excellent leadership capabilities Motivated and independent, and has good interpersonal and communication skill Possess strong analytical and decision-making skills Good organizational skills Interested candidates please do share your updated CV with nivetha.harikrishnan@htcinc.com along with below mentioned details: Total years of Exp.:Rel. Exp. in Power BI:Rel. Exp. in Talend ETL :Notice Period:CTC:E.CTC:Current Location:Preferred Location

BI Developer/Data AnalystExperience: 5+ yearsLocation: Chennai/Bangalore/HyderabadNotice Period: Immediate to 15 daysJob Description:<ul><li>Senior Data Analyst/BI Developer with 5+ years of experience in data analysis and reporting.</li><li>Proficiency in multiple BI tools like Tableau, Power BI, and Qlikview,</li><li>Experience in analysing data to identify trends, patterns, and actionable insights.</li><li>Advanced proficiency in writing and optimizing complex SQL queries for data extraction and transformation.</li><li>Ability to design, develop, and maintain dashboards and reports for business users.</li><li>Work closely with stakeholders to understand reporting requirements and provide data-driven solutions.</li><li>Strong interpersonal and communication skills for managing stakeholders</li><li>Consultant should be ready to work on the second shift.</li><li>Good knowledge of Agile.</li></ul> Interested candidates please do share your update CV with janani.srinivasan@htcinc.com along with below mentioned details:Rel. Exp. in Tableau:Rel. Exp. in Power BI:Rel. Exp. in QlikView:Rel. Exp. in SQL:Notice Period:CTC:E.CTC:Current Location:

Job Description: <ul> <li>Capture data, reporting and analytic requirements for Financial data sets which include Financial investment Operations Data, loan and equity accounting data sets, Financial expenses and revenue data, treasury data, and other financial data sets. </li><li>Perform data analysis, data lineage, and profiling of data from the source system to data repositories and reports. Responsible for data mapping to any to-be data structures. </li><li>Create specifications for Reporting requirements and work with business users to elicit hidden requirements and clarify vague requirements, as well as ensure sign-offs on requirements. </li><li>Interact with technical teams and guide offshore development resources to help translate requirements into solutions. Responsible for providing functional and technical guidance to the development team. </li><li>Coordinate user acceptance testing of reports and data-driven solutions by working with the business users. </li><li>Assist the Program Managers with tracking work program deliverables using the appropriate SDLC methodologies including agile scrum. </li><li>Manage daily technical challenges and communicate to management any risks or issues. </li><li>Develop, manage, and maintain processes, procedures, and documentation for handover to application support. </li></ul> Skills/Experience Required: <ul> <li>Minimum 8+ yrs. of relevant experience and master's degree plus required industry certificates; or bachelor's degree and 12+ years of relevant experience. </li><li>Experienced IT professional working on large data and reporting applications as well a strong understanding of Operational data stores, Data Warehouses, and/or Data Marts. </li><li>Should have participated in data implementation efforts with exposure to relational database concepts, ETL fundamentals, transaction processing, and testing protocols. </li><li>Shows an understanding of data management concepts data quality, data lineage, data lifecycle, master/reference data management, and metadata management. </li><li>Ability to understand the meaning of the data and work cohesively with the business to leverage it for better and advanced insights. Domain knowledge of accounting and financial data sets is essential. </li><li>Has strong analytic, problem-solving and logical reasoning skills with high attention to detail and the ability to multi-task. </li><li>Proficient in the use of PL/SQL and the ability to read data models, infer data flows, and write complex queries. </li><li>Hands-on experience with reporting tools (like Power BI, SAP BO, and Tableau). </li><li>Excellent skills in analyzing data, gathering requirements, and working with clients and technical teams to translate requirements into solutions. </li><li>Familiarity with using agile tools such as Azure DevOps. </li><li>Strong project management skills with a process orientation (understand problems, do analysis, interview stakeholders, write requirements, get sign off, hand off to dev, coordinate UAT etc.) and ability to leverage Agile concepts. </li><li>Excellent oral and written communication skills and experience interacting with both business and IT individuals. </li></ul> Benefits: At HTC Global Services our associates have access to a comprehensive benefits package that includes Health, Dental, Vision, Paid-Time-Off, Paid Holidays, 401K matching, Life and Accidental Death Insurance, Short- & Long-Term Disability Insurance, and a variety of other offerings. Diversity & Inclusion Our success as a company is built on practicing inclusion and embracing diversity. HTC Global Services is committed to providing a work environment free from discrimination and harassment, where all employees are treated with respect and dignity. Together we work to create and maintain an environment where everyone feels valued, included, and respected. At HTC Global Services, our differences are embraced and celebrated. HTC is an Equal Opportunity Employer. We respect and seek to empower each individual and support the diverse cultures, perspectives, skills, and experiences within our workforce. HTC is proud to be recognized as a National Minority Supplier

Job Description: <ul><li>Capture data, reporting and analytic requirements for Financial data sets which include Financial investment Operations Data, loan and equity accounting data sets, Financial expenses and revenue data, treasury data, and other financial data sets.</li><li>Perform data analysis, data lineage, and profiling of data from the source system to data repositories and reports. Responsible for data mapping to any “to-be” data structures.</li><li>Create specifications for Reporting requirements and work with business users to elicit hidden requirements and clarify vague requirements, as well as ensure sign-offs on requirements.</li><li>Interact with technical teams and guide offshore development resources to help translate requirements into solutions. Responsible for providing functional and technical guidance to the development team.</li><li>Coordinate user acceptance testing of reports and data-driven solutions by working with the business users.</li><li>Assist the Program Managers with tracking work program deliverables using the appropriate SDLC methodologies including agile scrum.</li><li>Manage daily technical challenges and communicate to management any risks or issues.</li><li>Develop, manage, and maintain processes, procedures, and documentation for handover to application support.</li></ul> Skills/Experience Required:<ul><li>Minimum 8+ yrs. of relevant experience and master's degree plus required industry certificates; or bachelor's degree and 12+ years of relevant experience.</li><li>Experienced IT professional working on large data and reporting applications as well a strong understanding of Operational data stores, Data Warehouses, and/or Data Marts.</li><li>Should have participated in data implementation efforts with exposure to relational database concepts, ETL fundamentals, transaction processing, and testing protocols.</li><li>Shows an understanding of data management concepts – data quality, data lineage, data lifecycle, master/reference data management, and metadata management.</li><li>Ability to understand the meaning of the data and work cohesively with the business to leverage it for better and advanced insights. Domain knowledge of accounting and financial data sets is essential.</li><li>Has strong analytic, problem-solving and logical reasoning skills with high attention to detail and the ability to multi-task.</li><li>Proficient in the use of PL/SQL and the ability to read data models, infer data flows, and write complex queries.</li><li>Hands-on experience with reporting tools (like Power BI, SAP BO, and Tableau).</li><li>Excellent skills in analyzing data, gathering requirements, and working with clients and technical teams to translate requirements into solutions.</li><li>Familiarity with using agile tools such as Azure DevOps.</li><li>Strong project management skills with a process orientation (understand problems, do analysis, interview stakeholders, write requirements, get sign off, hand off to dev, coordinate UAT etc.) and ability to leverage Agile concepts.</li><li>Excellent oral and written communication skills and experience interacting with both business and IT individuals.</li></ul> Benefits:At HTC Global Services our associates have access to a comprehensive benefits package that includes Health, Dental, Vision, Paid-Time-Off, Paid Holidays, 401K matching, Life and Accidental Death Insurance, Short- & Long-Term Disability Insurance, and a variety of other offerings. Diversity & Inclusion Our success as a company is built on practicing inclusion and embracing diversity. HTC Global Services is committed to providing a work environment free from discrimination and harassment, where all employees are treated with respect and dignity. Together we work to create and maintain an environment where everyone feels valued, included, and respected. At HTC Global Services, our differences are embraced and celebrated. HTC is an Equal Opportunity Employer. We respect and seek to empower each individual and support the diverse cultures, perspectives, skills, and experiences within our workforce. HTC is proud to be recognized as a National Minority Supplier

Job Description: Key Responsibilities:<ul><li>Work closely with client application team to ensure that the end-to-end designs meet the business and data requirements.</li><li>Nice to have AWS Cloud Architect certification.</li><li>Analyze and interpret all complex data on all target systems and analyze and provide resolutions to all data issues and coordinate with data analyst to validate all requirements, perform interviews with all users and developers.</li><li>Design & review, scalable, secure and efficient data architectures that support smoother onboardings of SOR’s into the EDC platform.</li><li>Participate in workshops/meetings with business/Product owners and key stakeholders</li><li>Understand business objectives, explores existing data architecture</li><li>Converts business requirements into technical requirements</li><li>Help in outlining a design to integrate, centralize and maintain data aligning to future state architecture</li><li>Guide the team, on design aspects. Review deliverables</li><li>Design secure, scalable architectures aligned with business needs.</li><li>Translate business requirements into technical solutions for EDC 2.0.</li><li>Review deliverables and engage with stakeholders in workshops.</li></ul>

Job Description:<ul><li>Experience in working in an implementation team from concept to operations, providing deep technical subject matter expertise for successful deployment. Implement methods for automation of all parts of the pipeline to minimize labor in development and production.</li><li>Experience in analyzing complex data, organizing raw data and integrating massive datasets from multiple data sources to build subject areas and reusable data products.</li><li>Experience in working with architects to evaluate and productionalize appropriate GCP tools for data ingestion, integration, presentation, and reporting.</li><li>Experience in working with all stakeholders to formulate business problems as technical data requirement, identify and implement technical solutions while ensuring key business drivers are captured in collaboration with product management This includes designing and deploying a pipeline with automated data lineage. Identify, develop, evaluate and summarize Proof of Concepts to prove out solutions.</li><li>Test and compare competing solutions and report out a point of view on the best solution.</li><li>Integration between GCP Data Catalog and Informatica EDC.</li><li>Design and build production data engineering solutions to deliver pipeline patterns using Google Cloud Platform (GCP) services: BigQuery, DataFlow, Pub/Sub, BigTable, Data Fusion, DataProc, Cloud Composer, Cloud SQL, Compute Engine, Cloud Functions, and App Engine.</li></ul> Experience Required:<ul><li>In-depth understanding of Google’s product technology (or other cloud platform) and underlying architectures</li><li>5+ years of analytics application development experience required - 5+ years of SQL development experience.</li><li>3+ years of Cloud experience (GCP preferred) with solution designed and implemented at production scale.</li><li>Experience working in GCP based Big Data deployments (Batch/Real-Time) leveraging Terraform, Big Query, Big Table, Google Cloud Storage, PubSub, Data Fusion, Dataflow, Dataproc, Cloud Build, Airflow, Cloud Composer etc.</li><li>2 + years professional development experience in Java or Python, and Apache Beam.</li><li>Experience developing with micro service architecture from container orchestration framework.</li><li>Extracting, Loading, Transforming, cleaning, and validating data - Designing pipelines and architectures for data processing.</li><li>1+ year of designing and building Tekton pipelines</li></ul> Benefits:At HTC Global Services our associates have access to a comprehensive benefits package that includes Health, Dental, Vision, Paid-Time-Off, Paid Holidays, 401K matching, Life and Accidental Death Insurance, Short- & Long-Term Disability Insurance, and a variety of other offerings. Diversity & Inclusion Our success as a company is built on practicing inclusion and embracing diversity. HTC Global Services is committed to providing a work environment free from discrimination and harassment, where all employees are treated with respect and dignity. Together we work to create and maintain an environment where everyone feels valued, included, and respected. At HTC Global Services, our differences are embraced and celebrated. HTC is an Equal Opportunity Employer. We respect and seek to empower each individual and support the diverse cultures, perspectives, skills, and experiences within our workforce. HTC is proud to be recognized as a National Minority Supplier

perience – 4+ YearsLocation – Chennai/HyderabadWork mode – Hybrid (3 days office)Shift timings – 2 PM -10 PMNotice- only Immediate Primary skills – 1. AWS Services – IAM, VPC, EC2, S3, Lambda, Glue, Athena, Aurora, RDS, Redshift, Step Functions, SFTP, Data Sync, Route53, CloudFront, API Gateway, AWS Quicksight2.Teraform3. Python, Py Spark, SQL4. CI/CD Pipelines – Gitlab

Htc Global Services Interview Questions

Htc Global Services Interview Guides

Htc Global Services Interview Questions

Htc Global Services Salaries by Position

Htc Global Services Opening Jobs