Prepare for and practice interview questions from Coforge.

Coforge Interview Questions

Coforge 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

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

Let’s say you work for a social media company that has just done a launch in a new city. Looking at weekly metrics, you see a slow decrease in the average number of comments per user from January to March in this city.

The company has been consistently growing new users in the city from January to March.

What are some reasons why the average number of comments per user would be decreasing and what metrics would you look into?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

Decreasing Comments

How would you investigate a decline in the average number of comments per user?

Coforge Salaries by Position

Role: Senior Cloud & Data ArchitectSkills: DWBI, Big Data and GCP/AWS/Azure platforms and ETL and Data ModellingLocation: London UKType: Permanent We are at Coforge hiring for Senior Cloud & Data Architect with DWBI, Big Data and GCP/AWS/Azure platforms and ETL and Data Modelling <ul><li>16-18+ years of total experience in DWBI, Big Data, Cloud Technologies</li><li>Implementation experience and hands on experience in either of the 2 Cloud technologies – Azure, AWS, GCP, Snowflake, Databricks</li><li>Must Have Hands on experience on at least 2 Hyperscalers (GCP/AWS/Azure platforms) and specifically in Big Data processing services (Apache Spark, Beam or equivalent).</li><li>Excellent consulting experience and ability to design and build solutions, actively contribute to RFP response.</li><li>Ability to be a SPOC for all technical discussions across industry groups.</li><li>Excellent design experience, with entrepreneurship skills to own and lead solutions for clients</li><li>Excellent ETL skills, Data Modelling Skills</li><li>Strong knowledge of database structure systems and data mining.</li><li>Knowledge of systems development, including system development life cycle, project management approaches and requirements, design and testing techniques</li><li>Proficiency in data modelling and design, including SQL development and database administration</li><li>Ability to implement common data management and reporting technologies, as well as the Columnar and NoSQL databases, data visualization, unstructured data, and predictive analytics.</li><li>Excellent organizational and analytical abilities.</li><li>Outstanding problem solver.</li><li>Good written and verbal communication skills.</li><li>A minimum of 5 years’ experience in a similar role.</li><li>Ability to lead and mentor the architects.</li><li>Design and implement effective database solutions and models to store and retrieve data.</li><li>Examine and identify database structural necessities by evaluating client operations, applications, and programming.</li><li>Ability to articulate and write POVs on new and old technologies</li><li>Ability to recommend solutions to improve new and existing database systems.</li><li>Assess data implementation procedures to ensure they comply with internal and external regulations.</li><li>Install and organize information systems to guarantee functionality.</li><li>Prepare accurate database design and architecture reports for management and executive teams.</li><li>Oversee the migration of data from legacy systems to new solutions.</li><li>Educate staff members through training and individual support.</li><li>Offer support by responding to system problems in a timely manner.</li><li>In-depth knowledge on key technologies like Big Query/Redshift/Synapse/Pub Sub/Kinesis/MQ/Event Hubs, Kafka Dataflow/Airflow/ADF etc.</li><li>Ability to define the monitoring, alerting, deployment strategies for various services.</li><li>Experience providing solution for resiliency, fail over, monitoring etc.</li><li>Good to have working knowledge of Jenkins, Terraform, Stack Driver or any other DevOps tools.</li></ul> Mandatory Skills<ul><li>At least 2 Hyperscalers</li><li>GCP, AWS, Azure, Big data, Apache spark, beam on Big Query/Redshift/Synapse, Pub Sub/Kinesis/MQ/Event Hubs, Kafka Dataflow/Airflow/ADF</li></ul>Desirable Skills <ul><li>Designing Databricks based solutions for Azure/AWS, Jenkins, Terraform, Stack Driver or any other DevOps tools</li></ul>

Job Title: Lead Business AnalystSkills: Business Analysis, Project management, Airline, GDS Domain, Scrum, Agile, FRD, Experience: 8+ yearsJob Location: Dallas, TXFTE/ Onsite We at Coforge are hiring Lead Business Analyst with the following skillset<ul><li>Minimum 8 years tech experience; Minimum 2 years as TPM / BA with Airline, GDS domain experience</li><li>Breaks down and prioritizes team backlog</li><li>Analyses business/customer problems and identify Client product gaps</li><li>Provides input to technical and business aspects of requirements</li><li>Collaborates with team to provide input on requirements (for sprint planning)</li><li>Provides inputs during sprint execution</li><li>Provides inputs for go/no-go decision making for every release in conjunction with key stakeholders (incl. promotion to CVT, cert, prod environments)</li><li>Authorized to accept/sign-off stories at completion</li><li>Attends scrum ceremonies</li><li>Supports Product Managers, Interfaces with Marketing/Customer for developing an understanding of business problems</li><li>Creates Functional Requirements Document (FRD) as required</li><li>Verifies accuracy of release notes, SAN, User Guide as required in ship with Product Manager</li><li>Owns the sizing process</li><li>Conducts customer demo as needed</li><li>Advanced computer software skills.</li><li>Excellent written and verbal communication skills;</li><li>Ability to handle multiple projects simultaneously.</li></ul>

Role: Data ArchitectSkills: GCP Expertise: Proficiency in GCP services such as Big Query, Cloud Dataflow, Cloud Pub/Sub, and Cloud Storage, ETL Processes: Experience with ETL tools and processes for data integration, SQL and NoSQLExperience: 15+ yearsLocation: Greater Noida or BengaluruNotice Period: Immediate to 30 would be preferred A Data Architect with Google Cloud Platform (GCP) experience is responsible for designing and managing data infrastructure using GCP technologies. Here are some key responsibilities and skills typically associated with this role:Key Responsibilities:• Data Infrastructure Design: Develop and implement scalable data architectures using GCP services such as BigQuery, Cloud Storage, and Cloud SQL.• Data Integration: Design and manage ETL processes to integrate data from various sources into the GCP environment.• Performance Optimization: Optimize data storage and retrieval processes to ensure high performance and reliability.• Security and Compliance: Implement data security measures and ensure compliance with relevant regulations.• Collaboration: Work closely with data engineers, data scientists, and other stakeholders to understand data requirements and deliver solutions.• Monitoring and Maintenance: Monitor data systems for performance issues and implement necessary improvements.• Documentation: Create and maintain documentation for data architectures, processes, and best practices. Key Skills:• GCP Expertise: Proficiency in GCP services such as BigQuery, Cloud Dataflow, Cloud Pub/Sub, and Cloud Storage.• Data Modeling: Strong skills in designing conceptual, logical, and physical data models.• ETL Processes: Experience with ETL tools and processes for data integration.• SQL and NoSQL: Proficiency in SQL and NoSQL databases.• Programming: Knowledge of programming languages such as Python, Java, or Scala.• Analytical Skills: Ability to analyze complex data requirements and design efficient solutions.• Communication: Excellent communication skills to collaborate with technical and non-technical stakeholders.

Job Title: Data EngineerSkill: Azure Data Factory, Azure Data Bricks, Devops, PythonYears of experience: 5-10 yearsLocation: GurugramJob Description:Coforge is seeking a talented Data Engineer to join our team in Greater Noida. The ideal candidate will have expertise in data engineering, with a focus on Databricks, Azure Data Factory (ADF), and DevOps practices. This role involves designing, implementing, and optimizing data pipelines and workflows to support our data-driven initiatives.Key Responsibilities:<ul><li>Data Pipeline Development: Design, develop, and maintain scalable data pipelines using Databricks and Azure Data Factory.</li><li>Data Integration: Integrate data from various sources, ensuring data quality and consistency.</li><li>DevOps Practices: Implement DevOps practices to automate and streamline data engineering processes.</li><li>Performance Optimization: Optimize data workflows for performance and cost-efficiency.</li><li>Collaboration: Work closely with data scientists, analysts, and other stakeholders to understand data requirements and deliver solutions.</li><li>Documentation: Maintain comprehensive documentation of data engineering processes and workflows.</li></ul>Qualifications:<ul><li>Proven experience as a Data Engineer with a focus on Databricks and Azure Data Factory.</li><li>Strong understanding of DevOps practices and tools.</li><li>Proficiency in programming languages such as Python, SQL, and Scala.</li><li>Experience with cloud platforms, particularly Azure.</li><li>Knowledge of data warehousing concepts and ETL processes.</li><li>Excellent problem-solving skills and attention to detail.</li><li>Relevant certifications are a plus.</li></ul>

Job Title: Salesforce Business AnalystSkills: Salesforce.com setup, configuration, BAExperience: 10 to 15 YearsLocation: Princeton, NJJob Type: Full-time We at Coforge are hiring for a Salesforce Business Analyst with the following skills: This role is responsible for the management and development of salesforce, to ensure full utilization and tailoring of the platform to match and support business objectives, using agile techniques and strategies. This role will review and analyze business processes, services and information needs with a view to implementing change management initiatives to improve the user experience and increase productivity.This role will oversee the Salesforce team, will be adaptable and embrace change, as well as having a competent technical understanding so that you are able to support the team and platform. A vital part of the role will be training Salesforce users across the business and being the salesforce champion.Responsibilities:<ul><li>Consult and liaise with stakeholders to gather and confirm business requirements.</li><li>Analyse and consolidate information to develop solutions to ensure business requirements are achieved.</li><li>Partner with key stakeholders to identify how business requirements can be delivered to ensure improved user experiences and reduced cost and time impacts.</li><li>Provide expert support to key stakeholders in managing system and process changes.</li><li>Produce functional, technical and system design documentation.</li><li>Create test scenarios for applications and enhancements, ensuring functional requirements are met.</li><li>Facilitate testing of new Salesforce functionality rollouts.</li><li>Develop complex reports and dashboards to support the delivery of business key metrics.</li><li>Deliver effective training modules and user guides.</li><li>Identify and develop super user knowledge and capabilities across the business.</li><li>Interact with third party vendors and developers where appropriate.</li><li>Salesforce Certified Administrator (ADM201).</li><li>5+ years of experience with Salesforce.com setup and configuration.</li><li>5+ years business analyst experience.</li><li>1-2 years project management experience preferrable.</li><li>Excellent knowledge of the full SDLC.</li><li>Proficient MS Excel, Word, PowerPoint and Visio user.</li><li>Extensive experience in data modelling, process mapping and specification documentation.</li><li>Experience facilitating workshops and discussion sessions.</li><li>Experience in developing, implementing and maintaining system processes and procedures.</li><li>Experience in creating business cases for technology-related solutions.</li><li>Experience in working with B2B Commerce Cloud, Experience Cloud, Sales Cloud and Service Cloud.</li><li>Excellent communication and interpersonal skills.</li><li>High level problem solving and analytical skills.</li><li>Active listener with the ability to think strategically, solve problems and negotiate.</li><li>Strong ability to engage and influence stakeholders, at all levels across the business.</li><li>Ability to build and maintain effective working relationships with stakeholders.</li><li>Superior organization skills including outstanding accuracy and attention to detail.</li><li>Excellent time management skills and ability to prioritize tasks, use initiative and be self-directed to meet deadlines.</li></ul>

Coforge Interview Questions

Coforge Interview Guides

Coforge Interview Questions

Coforge Salaries by Position

Coforge Opening Jobs