Scribd Logo
Upload

Welcome to Scribd!

  • 448 views

    Matillion - Interview - Questions

    Uploaded by

    clouditlab9
    The document contains questions about Matillion, a data integration tool. It includes questions about Matillion's products, supported data warehouses, environments, jobs, variables, data lineage, integration with source control systems like Git, user permissions, scheduling jobs, and APIs.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Matillion - Interview - Questions

    Uploaded by

    clouditlab9
    448 views2 pages
    The document contains questions about Matillion, a data integration tool. It includes questions about Matillion's products, supported data warehouses, environments, jobs, variables, data lineage, integration with source control systems like Git, user permissions, scheduling jobs, and APIs.

    Original Title

    Copy of Matillion_Interview_Questions

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains questions about Matillion, a data integration tool. It includes questions about Matillion's products, supported data warehouses, environments, jobs, variables, data lineage, integration with source control systems like Git, user permissions, scheduling jobs, and APIs.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    448 views2 pages

    Matillion - Interview - Questions

    Uploaded by

    clouditlab9
    The document contains questions about Matillion, a data integration tool. It includes questions about Matillion's products, supported data warehouses, environments, jobs, variables, data lineage, integration with source control systems like Git, user permissions, scheduling jobs, and APIs.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 2

    Matillion Interview Questions (Sample)

     What is Matillion tool & why it is used?


     What all different products Matillion provides?
     Which all Cloud Datawarehouses are supported by Matillion?
     What is an Environment in Matillion?
     How many environments we can create in a single project in Matillion?
     Different types of jobs in Matillion?
     Difference b/w Orchestration & Transformation job?
     What are Automatic/Built-In variables?
     Why environmental variables used for?
     Why Grid variables used for?
     Difference b/w Job & Grid vairables?
     Difference b/w Job & Environmental variables?
     How to see Task history of a job?
     Where to see SQL generated by the component?
     What is Data Lineage in Matillion?
     Can we integrate project with Git?
     What is a Shared job and when to create it?
     What is migrate feature in Matillion?
     What are API Query profiles?
     Which component to use to load data from S3 to Snowflake?
     Which component to use to extract data from Snowflake to S3?
     What are different Target/Write category components?
     How to restart Matillion’s tomcat server?
     How do we configure users in Matillion?
     How do we upload Jar file in Matillion?
     How do we manage user permission in Matillion?
     Can we access shared jobs in multiple projects within same project group?
     Where does Matillion stores the metadata; in which database?
     Which component to use to load data from external RDS database to Snowflake?
     Which component to use to extract data from Snowflake to RDS Database?
     Which component to use to load data from on-prem databases?
     How to give project access to a user?
     What are Versions in Matillion?
     Can Matillion run same job concurrently? If not, then how can we run it?
     Which component to use read data from Snowflake table in Transformation job?
     Which component to use append data to Snowflake table?
     Which component to use to update/upsert data to Snowflake table?
     What is Detect Changes component in Matillion?
     Which component to use to derive a new column & apply transformation?
     How Matillion does ELT operation?
     Can we see sample data in Matillion?
     What is Grid variable & Grid Iterator in Matillion? When to use them?
     What is AWS Managed staging vs Snowflake managed staging in Matillion’s staging
    components?
     What is Matillion Hub?
     How to set child job variables from Parent job?
     Difference b/w Copied & Shared variables?
     What does Query Result to Scalar component do?
     What does Query Result to Grid component do?
     What are conditional components in Matillion?
     What is the location of Catalina.out file on ec2?
     Can we implement SCD Type-1 & Type-2 using Matillion?
     How can we schedule jobs in Matillion?
     Can we write Python commands & call Python script from Matillion and How?
     What are Matillion API useful for?

    You might also like