Prepare for and practice interview questions from Csc.

Csc Interview Questions

Csc Interview Guides

Suppose there exists a new airline named Jetco that flies domestically across North America. Jetco recently had a study commissioned that tested the boarding time of every airline, and it came out that Jetco had the fastest average boarding times of any airline.

What factors could have biased this result, and what would you look into?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

Boarding Times Bias

A new airline came out as the fastest average boarding times compared to other airlines.  What factors could have biased this result and what would you look into?

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?

Csc Salaries by Position

Role: SQL Server Data Integration EngineerLocation: BangaloreWorking Model: Hybrid Job Overview:We are seeking a highly skilled and experienced SQL Server Integration Engineer to join our dynamic team. The ideal candidate will possess expertise in designing, developing, and implementing data integration solutions using Microsoft SQL Server Integration Services (SSIS). The SQL Server Integration Engineer will collaborate with cross-functional teams to ensure the seamless flow of data between various systems and optimize data processes. Primary Responsibilities:<ul><li>Design, develop, and implement robust data integration solutions using SQL Server Integration Services (SSIS), T-SQL, and Dynamic SQL.</li><li>Collaborate with stakeholders to gather and understand data integration requirements.</li><li>Design data structures (staging, intermediate staging, Dimension, Fact, Aggregate, views) well-suited to meet the business requirements.</li><li>Analyze existing data processes and identify opportunities for improvement.</li><li>Troubleshoot and resolve issues related to data integration and ETL processes.</li><li>Perform performance tuning and optimization of SQL Server Integration Services packages.</li><li>Work closely with database administrators to ensure the integrity and security of data.</li><li>Collaborate with software developers, business analysts, and other team members to ensure effective data integration.</li><li>Stay updated on industry best practices and emerging trends in data integration and ETL processes.</li><li>Provide documentation (Data Mapping, Technical Specifications, Production Support, data dictionaries, test cases) for all projects.</li><li>Document technical specifications and provide training to end-users as needed.</li><li>Participate in code reviews and provide constructive feedback to team members.</li></ul> What technical skills, experience, and qualifications do you need?<ul><li>Bachelor's degree in Computer Science, Information Technology, or related field.</li><li>Proven 5+ years of Industry financial experience in developing and maintaining enterprise data warehouse solutions.</li><li>Proven experience in data warehousing and data modeling techniques and methodologies.</li><li>Proficient in dynamic SQL, T-SQL, and SQL Server database development.</li><li>Experience with performance tuning and optimization of ETL processes.</li><li>Knowledge of data warehousing concepts and methodologies.</li><li>Excellent problem-solving and troubleshooting skills.</li><li>Strong communication and collaboration skills.</li><li>Ability to work independently and as part of a team.</li><li>Relevant certifications (e.g., Microsoft Certified: Data Engineer Associate) are a plus.</li><li>Proven experience in dynamic SQL, T-SQL, and SQL Server database development.</li><li>Experience with Power BI for data visualization.</li><li>Experience with SSIS (SQL Server Integration Services)</li><li>Knowledge of Azure Synapse Analytics.</li><li>Knowledge of Azure Data Factory for cloud-based data integration.</li><li>Programming skills in C#.</li></ul>

Csc Interview Questions

Csc Interview Guides

Csc Interview Questions

Csc Salaries by Position

Csc Opening Jobs