Prepare for and practice interview questions from Nam Info Inc.

Nam Info Inc Interview Questions

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

Nam Info Inc Salaries by Position

Azure Data Bricks with PySparkLocation: Bangalore / ChennaiExperience Required: 6 - 10 YearsEmployment Type: Full-time Overview:We are seeking an experienced Azure Data Engineer to join our team in Bangalore. The ideal candidate will have a strong background in designing, developing, and modernizing data platforms using Azure technologies, including Azure Data Factory (ADF), Azure Synapse Analytics, and SQL. The role involves conducting a current state analysis, architecting new solutions, and leading the migration of data and processes to modern Azure platforms. Key Responsibilities:<ul><li>Conduct a comprehensive assessment of the existing data platform to understand the scope of modernization.</li><li>Collaborate with client architects to design and obtain approval for a new, modern data platform that meets business requirements.</li><li>Lead the modernization of the data platform, including migrating or enhancing existing code to Databricks and Azure Data Factory (ADF).</li><li>Migrate Data Mart to Azure Synapse or other selected tools, ensuring a smooth transition and integration with existing systems.</li><li>Develop and manage CI/CD pipelines, ensuring seamless code deployment and migration across environments.</li><li>Implement robust security measures, including PII encryption, and adhere to ABC (Audit Balance and Control) Framework standards.</li><li>Oversee the infrastructure setup, data management, and code repository management, ensuring best practices in data engineering are followed.</li><li>Design and implement Medallion Architecture and Data Lakes, supporting efficient data management and processing.</li><li>Manage System Integration Testing (SIT), User Acceptance Testing (UAT), and the production release of the platform.</li></ul> Qualifications:<ul><li>Proven experience in Azure data engineering, including ADF, Azure Synapse, and SQL.</li><li>Strong knowledge of CI/CD pipelines, code migration, and infrastructure management.</li><li>Expertise in data security, including PII encryption and audit controls.</li><li>Experience with Medallion Architecture and Data Lakes.</li><li>Excellent communication skills, with the ability to collaborate effectively with client architects and stakeholders.</li><li>Strong problem-solving skills and attention to detail.</li><li>Bachelor’s degree in computer science, Engineering, or a related field.</li></ul> Additional informationWorkdays: Monday to FridayExperience: 5 yrs. to 8 yrs.Work Timings: 9 am to 6 pm IST Interview Process:1- Internal Technical Screening round.2- Client Discussion3- HR Discussion Regards, S. Vijay KumarIT RecruiterNAM Info Pvt Ltd,+91 9945999744 (India)Email - vijay@nam-it.com Website - <a>www.nam-it.com</a>

Job Title: AWS Data Engineer with PySparkLocation: Bangalore, ChennaiFulltime Job Description:Preferred Skills and Qualifications:<ul><li>Proficient in AWS Cloud services and infrastructure.</li><li>Strong experience with Databricks and PySpark.</li><li>Extensive knowledge of data gathering ingestion, manipulation, orchestration, and optimization.</li><li>Proven track record of leading multi-shore teams on sizable cloud and data projects.</li><li>Excellent communication, presentation, and client interaction skills.</li><li>Ability to work effectively in a fast-paced, dynamic environment with multiple stakeholders.</li></ul> Key Responsibilities:<ul><li>Design, develop, and maintain scalable data pipelines and ETL processes using AWS services, Databricks, and PySpark.</li><li>Integrate and manage data from multiple sources, ensuring data quality and integrity.</li><li>Optimize data workflows for performance and cost-efficiency on AWS Cloud.</li><li>Work with AWS services such as Redshift, Aurora, Glue, Lambda, and other AWS data-related technologies.</li><li>Implement and manage data warehousing solutions and cloud data storage.</li><li>Develop RESTful APIs to support data access and manipulation.</li><li>Utilize ETL tools and technologies for data extraction, transformation, and loading.</li><li>Leverage Spark and Python for data processing and analysis.</li><li>Participate in Agile ceremonies and contribute to sprint planning, retrospectives, and daily stand-ups.</li><li>Collaborate with cross-functional teams, including data scientists, analysts, and stakeholders, to deliver high-quality data solutions.</li><li>Lead multi-shore teams on large-scale cloud and data initiatives.</li><li>Provide technical guidance and mentorship to junior team members.</li><li>Communicate effectively with clients and stakeholders to understand requirements and present solutions.</li></ul> Interview Process:1- Internal Technical Screening round.2- Client Discussion3- HR Discussion About CompanyNAM Info Inc. is a leading technology and services delivery organization. We are proud of the relationships we have built over the last two decades with our clients, employees, vendors, and various talent agencies.For more details - <a>http://www.nam-it.com</a>. Regards, PraveenStaffing Executive NAM Info Pvt Ltd,Email: praveen@nam-it.com

Azure DevOps with DBLocation: Bangalore / ChennaiFulltimeExperience Required: 6 - 9 Years Job Summary:We are seeking a skilled Azure DevOps Engineer with a strong background in database management to join our dynamic team. The ideal candidate will have a deep understanding of Azure cloud services, DevOps practices, and database technologies. This role involves designing, implementing, and maintaining CI/CD pipelines, managing cloud infrastructure, and ensuring optimal performance and security of databases. Key Responsibilities:Design, develop, and maintain CI/CD pipelines using Azure DevOps tools.Implement and manage infrastructure as code using tools like Terraform or ARM templates.Monitor and maintain cloud infrastructure, ensuring high availability, scalability, and security.Manage and optimize databases, including SQL and NoSQL databases, ensuring high performance and reliability.Automate database backups, restores, and disaster recovery procedures.Collaborate with development teams to ensure seamless integration of applications with the database and cloud infrastructure.Troubleshoot and resolve infrastructure and database-related issues.Implement best practices for database security, including encryption and access controls.Perform regular audits and assessments of database and cloud infrastructure to ensure compliance with industry standards and regulations.Stay up-to-date with the latest Azure and database technologies and trends. Required Skills and Qualifications:Bachelor’s degree in Computer Science, Information Technology, or related field.Proven experience as a DevOps Engineer with a focus on Azure cloud services.Strong knowledge of CI/CD pipelines and automation tools, particularly Azure DevOps.Proficiency in infrastructure as code tools like Terraform or ARM templates.Extensive experience with database management, including SQL Server, MySQL, PostgreSQL, and NoSQL databases like MongoDB or Cosmos DB.Knowledge of database performance tuning, optimization, and security best practices.Experience with containerization technologies such as Docker and Kubernetes.Familiarity with scripting languages like PowerShell, Bash, or Python.Strong problem-solving skills and ability to work in a fast-paced environment.Excellent communication and collaboration skills. Preferred Skills:Azure certifications such as Azure DevOps Engineer Expert or Azure Solutions Architect.Experience with other cloud platforms like AWS or Google Cloud.Knowledge of monitoring and logging tools like Azure Monitor, Prometheus, or Grafana.Understanding of Agile methodologies and experience working in Agile teams. Thanks & Regards, S. Vijay KumarIT RecruiterNAM Info Pvt Ltd,+91 9945999744 (India)Email - vijay@nam-it.com Website - <a>www.nam-it.com</a>

Job Title: Azure Data EngineerLocation: Bangalore - NAM OfficeExperience Required: 5 - 8 YearsEmployment Type: Full-time with NAM INFO PVT LTD. Overview:We are seeking an experienced Azure Data Engineer to join our team in Bangalore. The ideal candidate will have a strong background in designing, developing, and modernizing data platforms using Azure technologies, including Azure Data Factory (ADF), Azure Synapse Analytics, and SQL. The role involves conducting a current state analysis, architecting new solutions, and leading the migration of data and processes to modern Azure platforms. Key Responsibilities:<ul><li>Conduct a comprehensive assessment of the existing data platform to understand the scope of modernization.</li><li>Collaborate with client architects to design and obtain approval for a new, modern data platform that meets business requirements.</li><li>Lead the modernization of the data platform, including migrating or enhancing existing code to Databricks and Azure Data Factory (ADF).</li><li>Migrate Data Mart to Azure Synapse or other selected tools, ensuring a smooth transition and integration with existing systems.</li><li>Develop and manage CI/CD pipelines, ensuring seamless code deployment and migration across environments.</li><li>Implement robust security measures, including PII encryption, and adhere to ABC (Audit Balance and Control) Framework standards.</li><li>Oversee the infrastructure setup, data management, and code repository management, ensuring best practices in data engineering are followed.</li><li>Design and implement Medallion Architecture and Data Lakes, supporting efficient data management and processing.</li><li>Manage System Integration Testing (SIT), User Acceptance Testing (UAT), and the production release of the platform.</li></ul>Qualifications:<ul><li>Proven experience in Azure data engineering, including ADF, Azure Synapse, and SQL.</li><li>Strong knowledge of CI/CD pipelines, code migration, and infrastructure management.</li><li>Expertise in data security, including PII encryption and audit controls.</li><li>Experience with Medallion Architecture and Data Lakes.</li><li>Excellent communication skills, with the ability to collaborate effectively with client architects and stakeholders.</li><li>Strong problem-solving skills and attention to detail.</li><li>Bachelor’s degree in computer science, Engineering, or a related field.</li></ul> Additional informationWorkdays: Monday to FridayExperience: 5 yrs. to 8 yrs.Work Timings: 9 am to 6 pm IST Interview Process:1- Internal Technical Screening round.2- Client Discussion3- HR Discussion Regards, S. Vijay KumarIT RecruiterNAM Info Pvt Ltd,+91 9945999744 (India)+1 732-392-6534 (US)Email - vijay@nam-it.com Website - <a>www.nam-it.com</a>

Job Title: Data EngineerLocation: BangaloreEmployment Type: Full-time with Nam InfoTime Zone: EST & CTS (Night Shift)Work Schedule: 5 days a weekExperience: 8+ years Job DescriptionWe are looking for a Data Engineer who is responsible for the design and development of scalable data pipelines and integrations to support continual increases in data volume and complexity. Work with analytics and business teams to understand their needs, create pipelines, improve data models that feed BI and visualization tools. Required Education<ul><li>Graduate Degree in B.Tech/B.E. Or Postgraduate in Computer Science.</li></ul> Required Skills<ul><li>Provide Business Intelligence (BI) and Data Warehousing (DW) solutions and support by leveraging project standards and leading analytics platforms.</li><li>Define and build data integration processes to be used across the organization.</li><li>Build conceptual and logical data models for stakeholders and management.</li><li>Experience working with relational databases (RDBMS) like Oracle, MYSQL, MS SQL Server etc.</li><li>Experience designing databases using ER data modeling tools like Embarcadero ER/Studio, ErWin, etc.</li><li>Proficient in Oracle PL/SQL and SQL Server T-SQL programming and tuning.</li><li>Experience working on AWS, Azure, and Google cloud platforms.</li><li>Knowledge of Big Data technologies like Hadoop, Hive, and Spark will be a plus.</li><li>Knowledge of Unix and Python scripting for the automation process.</li><li>Proficiency in Linux and Windows environments.</li><li>Troubleshooting skills, understanding of system's capacity, bottlenecks, basics of memory, CPU, OS, storage, and networks.</li><li>Familiarity and experience in different phases of the software development life cycle.</li><li>Good understanding of algorithms, data structures, performance optimization techniques, and object-oriented programming.</li><li>Experience building complex Enterprise Apps that have been successfully delivered to customers.</li></ul> Interview Process:1- Internal Technical Screening round.2- Client Discussion3- HR Discussion About CompanyNAM Info Inc. is a leading technology and services delivery organization. We are proud of the relationships we have built over the last two decades with our clients, employees, vendors, and various talent agencies. For more details - <a>http://www.nam-it.com</a>. Regards, PraveenStaffing Executive NAM Info Pvt Ltd,Direct: +91-9148263218Email: praveen@nam-it.comWebsite - <a>www.nam-it.com</a>

Position: AWS Data ArchitectLocation:- Jersey City, NJDuration: Long termH1 Transfer candidates accepted Job Description: <ul><li>AWS Data Architect would also develop and deliver AWS Cloud-based Big Data and Analytical Solutions.</li><li>Responsibilities include evangelizing data on cloud solutions with customers, leading Business, and IT stakeholders through designing robust, secure, and optimized AWS architectures, and the ability to be hands-on in delivering the target solution.</li><li> AWS Architect will work with customers and data engineers in delivering big data solutions on cloud. </li><li>Minimum of 5 years of Consulting or client service delivery experience on Amazon AWS (AWS)- Minimum of 10 years of experience in big data, database and data warehouse architecture and delivery</li><li>Minimum of 5 years of professional experience in 2 of the following areas:</li><li>Solution/technical architecture in the cloud</li><li>Big Data/analytics/information analysis/database management in the cloud</li><li>IoT/event-driven/microservices in the cloud- Experience with private and public cloud architectures, pros/cons, and migration considerations.</li><li>Good to have Blue Yonder experience.</li><li>Extensive hands-on experience implementing data migration and data processing using AWS services: VPC/SG, EC2, S3, AutoScaling, CloudFormation, Lake Formation, DMS, Kinesis, Kafka, Nifi, CDC processing Redshift, Snowflake, RDS, Aurora, Neptune, DynamoDB, CloudTrail, CloudWatch, Docker, Lambda, Spark, Glue, Sage Maker, AI/ML, API GW, etc.</li><li>Familiarity with the Technology stack available in the industry for data management, data ingestion, capture, processing and curation: Kafka, Stream Sets, Attunity, Goldengate, Map Reduce, Hadoop, Hive, HBase, Cassandra, Spark, Flume, Hive, Impala, etc.</li></ul> Thanks & Regards:JohnMarketing ManagerNam Info Pvt LTD+1 732 993 5322 (D)+1 732 572 2611 (Fax)John@nam-it.com Hangouts: johnnamit@gmail.com<a>www.nam-it.com</a>

Nam Info Inc Interview Questions

Nam Info Inc Interview Guides

Nam Info Inc Interview Questions

Nam Info Inc Salaries by Position

Nam Info Inc Opening Jobs