interview reasons

 

SQl Error

 select * from tbl_WorkFlowMembers where WorkFlow_ID IN (Select wm.WorkFlow_ID,*  from [dbo].[tbl_WorkFlowMembers] wm

JOIN   [dbo].tbl_WorkFlow w ON w.WorkFlow_ID = wm.WorkFlow_ID

where  User_ID='ASAPRA' and w.Country_Code='BH'

order by wm.WorkFlow_ID, wm.Approver_Sequence)

order by WorkFlow_ID,Approver_Sequence

The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP, OFFSET or FOR XML is also specified.

sql mistakes

 UPDATE tbl_WorkFlowMembers

SET Approver_Sequence =

    CASE User_ID

        WHEN 'mtrotter'    THEN 1

        WHEN 'SMIRZA'      THEN 2

        WHEN 'ASAPRA'      THEN 3

        WHEN 'EDIRIX'      THEN 4

        WHEN 'jhoy'        THEN 5

        WHEN 'cwoodhouse'  THEN 6

        WHEN 'SBOISSINOT'  THEN 7

        ELSE Approver_Sequence

    END,

    ModifiedBy = 'pkadma',

    ModifiedOn = GETDATE()

WHERE WorkFlow_ID = 'MSVBH74000027';

here i missed the else condition then remaining record it is updated null in total 13 records.

UPDATE tbl_WorkFlowMembers

SET Approver_Sequence =

    --Approver_Sequence AS CurrentSequence,

    CASE User_ID

        WHEN 'mtrotter'    THEN 1

        WHEN 'SMIRZA'      THEN 2

        WHEN 'ASAPRA'      THEN 3

        WHEN 'EDIRIX'      THEN 4

        WHEN 'jhoy'        THEN 5

        WHEN 'cwoodhouse'  THEN 6

        WHEN 'SBOISSINOT'  THEN 7

        ELSE Approver_Sequence

    END,

  ModifiedBy = 'pkadma',

    ModifiedOn = GETDATE()

WHERE WorkFlow_ID = 'MSVBHSALT027';

COMMIT TRANSACTION;

Codings

 https://onecompiler.com/csharp/44u6z75ja

my all coding links

interview mistakes

 i have done mistakes 
1.coding syntax obesrvation eg:swithc
2.theory with exixsting builtin ex
3.and also coding with hacker ank or leet code everyday
4.sql queries practice daily
5.coding excercie
6.write test cases
7.use more latest one in c# and angular

JD gspann

 

Description

We are hiring a Senior Azure Integration Engineer to build and support end-to-end ecommerce integrations using Azure AIS (APIM, Functions/Logic Apps, ADF, Service Bus, Blob). The role requires expertise in C#/.NET, REST API security, data mapping/ETL, and Azure deployment using CLI, Bicep, and ARM.

Roles and Responsibilities

• Engage with users/other teams to gather integration requirements and coordinating with relevant teams to design a complete end to end integrated solution
• Document and communicate effectively across teams involved with the ecommerce ecosystem
• Initiate and participate in design/technical workshops, work with other teams, designers, project/product managers, and content creators, to design integrations, perform data mapping, arrive at types of integration needed for data flows across ecommerce platform
• Create interface definition docs.
• Support maintenance of AIS configurations and changes
• Troubleshoot data transfer failures and ensure guaranteed as well as complete data delivery.
• Ensure high performance, availability and implement security measures to protect the data being transferred
• Manage and support technical tasks like upgrades, deployments, and troubleshooting related issues.

Skills and Experience

• Mandatory expertise in AIS integrations Azure API Management, Azure Functions / Logic Apps, ADF, Blob storage, Service Bus, etc.
• Working knowledge of data mapping, exception handling, error messaging, APIs, Queue and event-based integrations, ETL, Azure Functions / logic apps, ADF is a must.
• Adept at utilizing Azure CLI, Bicep, and ARM templates for infrastructure deployment and management.
• Hands-on with C#, .NET and related technologies.
• Proficiency in implementing & troubleshooting REST APIs including OAuth 2.0, mTLS, etc.
• Experienced in Git and version control systems is desirable.

DATA engineer

 

Role description

Roles Responsibilities Snowflake Cortex AI Senior Developer USA

Design and implement Snowflake Cortex AI use cases including Cortex Search Cortex Analyst and

any Snowflake AILLM functions while building semantic layers leveraging Snowpark Python UDFs

and prompt engineering to optimize response quality

Develop and maintain MCP Model Context Protocol server integrations with RBC Assist including

Active Directory AD configuration for secure authentication and authorization

Address model governance and risk requirements including model white paper documentation

model validation bias monitoring explainability and alignment with RBCs AI risk framework

Manage Snowflake environment performance and reliability including workload tuning cost

optimization CICD deployment automation Git Terraform Snowflake CLI monitoring and

incident resolution for Cortex AI pipelines

Implement data security access controls and data quality including RBAC data masking access

governance and validation of data feeding into Cortex AI models and semantic layers

Enable AI workflows leveraging Snowflake Cortex Snowpark and cloudnative services while

evaluating emerging Snowflake Cortex features and recommending adoption strategies

Collaborate with stakeholders across data engineering architecture business and risk teams to

align Cortex AI solutions with enterprise requirements

Maintain technical documentation and team enablement including data lineage semantic model

definitions governance artifacts and mentoring junior developers on Snowflake Cortex AI best

practices

Skills

Mandatory Skills : Python, Snowflake, Snowflake AI/ML

Other details

Variable Compensation: This position includes a bonus or variable payout component based on individual and organizational performance. Actual compensation within the range will be dependent upon the individual's skills, experience, performance and internal equity.

Benefits/perks listed below may vary depending on the nature of your employment with LTIMindtree (“LTIM”):

Benefits and Perks:

• Comprehensive Medical Plan Covering Medical, Dental, Vision
• Short Term and Long-Term Disability Coverage
• 401(k) Plan with Company match
• Life Insurance
• Vacation Time, Sick Leave, Paid Holidays
• Paid Paternity and Maternity Leave

The range displayed on each job posting reflects the minimum and maximum salary target for the position across all US locations. Within the range, individual pay is determined by work location and job level and additional factors including job-related skills, experience, and relevant education or training. Depending on the position offered, other forms of compensation may be provided as part of overall compensation like an annual performance-based bonus, sales incentive pay and other forms of bonus or variable compensation.

Disclaimer: The compensation and benefits information provided herein is accurate as of the date of this posting.

LTIMindtree is an equal opportunity employer that is committed to diversity in the workplace. Our employment decisions are made without regard to race, color, creed, religion, sex (including pregnancy, childbirth or related medical conditions), gender identity or expression, national origin, ancestry, age, family-care status, veteran status, marital status, civil union status, domestic partnership status, military service, handicap or disability or history of handicap or disability, genetic information, atypical hereditary cellular or blood trait, union affiliation, affectional or sexual orientation or preference, or any other characteristic protected by applicable federal, state, or local law, except where such considerations are bona fide occupational qualifications permitted by law.

Benefits

Compensation range: $ 129,910.00 to 180,593.00 per year