Prepare for and practice interview questions from Tech Mahindra.

Tech Mahindra Interview Questions

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

Tech Mahindra Salaries by Position

The ideal looking for candidate with data analytics + Project Management + JMP tool Responsibilities·Experience with Data analysis tools (JMP, Datapower, O+, PDF Solutions, etc.) for Vmin, Yield, Test Time & Bin Pareto Analysis·Ability to write scripts to automate and speed up data analysis in a repeated manner with different input data sets (mainly Tester STDF format) and sources·Analyze test and characterization data to benchmark performance specifications; Define NPI and production test plans, DoEs for product performance study·Support product sustaining activities for yield improvement, lot disposition, test time reduction and RMA management·Partnering with the ATE, Bench, SLT, FA, Qual, Vector Simulation Test teams for test program definition, test hardware specification and vector generation guidelines·Knowledge on Advantest 93K & Teradyne J750 tester platforms; Hands-on experience on Smartest 8 versions·Hands-on experience on Test Program Development, Digital device testing, and debug·Test Vector plan creation with DFT/DV/SIM/PE teams. Bring up and debug test patterns, development of test flows.·Yield debug activities. Yield report preparation on a weekly basis. WS/FT Yield analysis (fetching data from data tools), unit search analysis, identifying the outliers, failures, and issues. Debug rejects with respective block owners.·Support Test Time Reduction activities·Create detailed project execution timelines / graphs / Gantt charts (mainly Post-Silicon) and update / maintain throughout the project lifecycle·Manage communication of progress/status with stakeholders in various locations and time zones; own and nurture relationships between cross functional teams·Assess complexities and scope out the project through design, development, test, implementation, deployment, and sustaining activities·Proactively implement process improvements to streamline product development

Data EngineerExp - 5 to 7 years•Strong understanding of data engineering principles and practices.•Proficiency in Azure Data Factory and related tools.•Expertise in data processing, analysis, and visualization.• Experience with data quality and verification methods.• Ability to work with SQL and other relevant scripting languages.• Familiarity with data sharing mechanisms like COSMOS, Data Factory, and Power BI.

We are looking Product Manager/Product Owner- With Java Background in Austin, TX.

Qualifications

Bachelor's degree or equivalent 8+ years of experience in Product Management, Engineering, or Consulting
Experience in Java, Spring and Microservices
Strong written, verbal and collaboration skills

The pay range for this role is $100,000 - $130,000* per annum including any bonuses or variable pay. Tech Mahindra also offers benefits like medical, vision, dental, life, disability insurance and paid time off (including holidays, parental leave, and sick leave, as required by law). Ask our recruiters for more details on our Benefits package. The exact offer terms will depend on the skill level, educational qualifications, experience and location of the candidate.

Apply now and lets uncover insights together!

<a>Tech Mahindra</a> is <a>#hiring</a> for GCP Data Engineer . If you're an experienced professional looking for an exciting new challenge.We want to hear from you! Please apply to BA00858299@TechMahindra.com with your resume explaining your experience and qualifications. Location: Pan India GCP Data Engineer : U2 – up to 3 yearsPrimary Skill : Big Querry, Data flow, Data Composer, SQL, Python.• Proven experience as a Data Engineer with a focus on GCP services.• Strong proficiency in GCP services such as Dataflow, BigQuery, Data Composer.• Proficiency in SQL and Python for data manipulation and analysis.• Solid understanding of data warehousing concepts and ETL processes.• Experience with real-time data processing and streaming analytics.• Strong problem-solving skills and attention to detail.• Excellent communication and collaboration skills. GCP Data Engineer : U3 – 3 to 6 yearsPrimary Skill : Big Querry, Data flow, Data Composer, SQL, Python, Pyspark• Proven experience as a Data Engineer with a focus on GCP services.• Strong proficiency in GCP services such as Dataflow, BigQuery, and Pub/Sub.• Hands-on experience with Terraform for provisioning and managing GCP infrastructure.• Proficiency in Pyspark, SQL and Python for data manipulation and analysis.• Solid understanding of data warehousing concepts and ETL processes.• Experience with real-time data processing and streaming analytics.• Strong problem-solving skills and attention to detail.• Excellent communication and collaboration skills. GCP Data Engineer : U4 – 6 to 9 yearsPrimary Skill : Big Querry, Data flow, Data Composer, SQL, Python, Pyspark along with 3+ Years strong GCP experience & worked as Module lead / Tech Lead • Proven experience as a Data Engineer with a focus on GCP services.• Strong proficiency in GCP services such as Dataflow, BigQuery, and Pub/Sub.• Hands-on experience with Terraform for provisioning and managing GCP infrastructure.• Proficiency in Pyspark, SQL and Python for data manipulation and analysis.• Solid understanding of data warehousing concepts and ETL processes.• Experience with real-time data processing and streaming analytics.• Strong problem-solving skills and attention to detail.• Excellent communication and collaboration skills. GCP Data Architect – P1 – 10+ years<ul><li>GCP Certification (Either GCP Data Engineer or GCP Cloud Architect)</li><li>15+ years of experience in Architecting Data projects and knowledge of multiple ETL tools (like Informatica, Talend, DataStage, etc.)</li><li>5+ experience in Data modeling and Data warehouse and Data lake implementation experience in implementing Teradata to Bigquery migration project</li><li>Ability to identify and gather requirements to define a solution to be built and operated on GCP, perform high-level and low-level design for the GCP platform</li><li>Capabilities to implement and provide GCP operations and deployment guidance and best practices throughout the lifecycle of a project.</li><li>3+ Years of Strong experience in GCP technology areas of Data store, Big Query, Cloud storage, Persistent disk IAM, Roles, Projects, Organization.</li><li>Databases including Big table, Cloud SQL, Cloud Spanner, Memory store, Data Analytics Data Flow, DataProc, Cloud Pub/Sub, Kubernetes, Docker, managing containers, container auto scaling and container security</li><li>GCP technology areas of Data store, Big Query, Cloud storage, Persistent disk IAM, Roles, Projects, Organization.</li><li>Databases including Big table, Cloud SQL, Cloud Spanner, Memory store, Data Analytics Data Flow, DataProc, Cloud Pub/Sub, Kubernetes, Docker, managing containers, container auto scaling and container security</li><li>Experience in Design, Deployment, configuration and Integration of application infrastructure resources including GKE clusters, Anthos, APIGEE and DevOps Platform</li><li>Application development concepts and technologies (e.g. CI/CD, Java, Python)</li></ul>

Tech Mahindra is hiring Azure Data Engineers in HYDERABAD! Role Requirements: -Graduate in any stream with 3-5 years of experience in data, data science, or data engineering.-Proficiency in ETL processes and tools like Azure Data Factory (ADF).-Expertise in MS Excel, VBA, and programming languages like SQL; Python and DAX are a plus.-Experience in data visualization using Power BI, including report and dashboard development.-Knowledge of Agile methodologies (Kanban, Scrum) and tools (Jira, Azure DevOps).-Familiarity with SAP data modeling and Azure DataBricks.-Ability to work closely with IT and business stakeholders, maintaining productive relationships.-Strong communication skills for explaining technical concepts to non-technical stakeholders. If you fit the bill, apply today and join our dynamic team!Mail your CVs to SS00833152@techmahindra.com

Job Title : Data EngineerJob Location : Hyderabad/Bangalore As a Data Engineer, the associate will play a crucial role in managing data engineering and pipeline infrastructure for processing, analyzing, and retrieving large streams of data. The associate will be responsible for developing and maintaining data pipelines, ensuring data quality, and supporting data-driven decision making. Minimum 7+ Years Of Experience Needed Responsibilities:<ul><li>Data Engineering: Manage and maintain data engineering infrastructure, including Azure Data Factory and related tools.</li><li>Data Acquisition: Develop pipelines to acquire data from various sources like COSMOS, EDL, SQL, and EventHub.</li><li>Data Processing: Build and maintain data pipelines, ensuring data quality and verification.</li><li>Data Integration: Integrate data with other systems like Office Insights for cross-selling and upselling purposes.</li><li>Data Analysis: Analyze data to extract insights and support decision-making.</li><li>Data Sharing: Enable data sharing through COSMOS, Data Factory, and Power BI.</li><li>Process Improvement: Identify and suggest improvements to the data engineering infrastructure based on domain knowledge.</li></ul>Skills and Qualifications:<ul><li>Strong understanding of data engineering principles and practices.</li><li>Proficiency in Azure Data Factory and related tools.</li><li>Knowledge of data acquisition techniques from various sources.</li><li>Expertise in data processing, analysis, and visualization.</li><li>Experience with data quality and verification methods.</li><li>Ability to work with SQL and other relevant scripting languages.</li><li>Familiarity with data sharing mechanisms like COSMOS, Data Factory, and Power BI.</li><li>Understanding of data integration with other systems.</li><li>Strong analytical and problem-solving skills.</li><li>Ability to work independently and as part of a team.</li></ul>Additional Qualifications (Preferred):<ul><li>Experience with Nitro and Pipeline Studio within Microsoft.</li><li>Proficiency in building Power BI dashboards.</li></ul> Sowmya Jayam RMG | Support Lead | Microsoft BUEmail: SJ00691726@TechMahindra.com<a>www.techmahindra.com</a>

Experience : 5+ YearsLocation: PAN IndiaNotice Period: Immediate - 30 DaysKey Skills : Adobe Analytics, Adobe Launch, JavaScript, jQuery, TMS architecture & functioning(Launch), Adobe Experience Platform debugger. Detailed JD: - Adobe Analytics (aka Omniture / Site Catalyst) implementation experience across the life-cycle.- Person should be very well versed with Adobe Launch tag management system.- Proficient JavaScript experience in coding and troubleshooting analytics implementation.- Convert business requirements to solution design references (SDR) & able to convert SDR to implementation in tag management system.- Manage Adobe Analytics configuration including variables & processing rules.- Hands-on experience in third party or marketing pixels such as Facebook, Floodlight etc- Build and execute tagging test cases to ensure that the appropriate metrics are being collected by Adobe Analytics/third party tags.- Through knowledge of Adobe Analytics analysis workspace reporting.- Hands-on experience in Fiddler debugging tool.- Adobe Analytics Developer / Adobe Analytics Architect certification.- Experience with agile methodologies: Scrum.- Ability to work with limited supervision, therefore strong time management and organization skills required.

Hi All,Hiring GCP Data Engineer .Experience : 2- 9 yearsJob Location : Pan IndiaPrimary Skill : Big Query, Data flow, Data Composer, SQL, Python, PySpark• Proven experience as a Data Engineer with a focus on GCP services.• Strong proficiency in GCP services such as Dataflow, BigQuery, Data Composer.• Proficiency in SQL and Python for data manipulation and analysis.• Solid understanding of data warehousing concepts and ETL processes.• Experience with real-time data processing and streaming analytics.• Strong problem-solving skills and attention to detail.• Excellent communication and collaboration skills.

Tech Mahindra is looking for Avaloq Developers, scrum master, Avaloq Automation Testers and Program Manager who has good experience in Avaloq for more than 2 yrs. Please find the JD below: Developers with Avaloq knowledge and experience (min 3years)Exposure to either of the following topics on Avaloq: STEX Trading, Forex, MMKT, Credits & Loans, Client Onboarding, SWIFT messaging, Reporting, interfaces (AMI / CAPI) Perks-Avaloq certifications will be provided Location-Any TechM Locations

Tech Mahindra Interview Questions

Tech Mahindra Interview Guides

Tech Mahindra Interview Questions

Tech Mahindra Salaries by Position

Tech Mahindra Opening Jobs