Short DescriptionCapgemini is seeking a who has Good Knowledge in Data Warehouse Concepts.
- Good Knowledge in Building ingestion routines Links Data Sets Pipeline in Azure Data Factory To extract on premise data or Azure BLOB incrementally and load data to Data Lake storage Azure Data Warehouse
- Technical expertise in different activity like Copy Lookup Stored Procedure Custom Meta Data Activity
- Expertise in Error handling and creation of Audit Log mechanism for Pipelines
- Expertise in scheduling the Pipelines like Schedule Tumbling Window and Event Based Technical expertise in knowing the limitations of various Azure Components Ex Storage Accounts BLOB General Purpose V1 General Purpose V2 Data Lake Storage and providing the solutions based on the limitations
- Good Knowledge in Data Warehouse Concepts
- Good Knowledge in Azure DW ADB and good technical expertise in writing stored procedures views Installation of Data Management Gateway to connect to on premise DB and Integrated with Azure Data Factory
- Good Knowledge of Power Shell Scripting Ex Invoking Pipeline Capturing the logging mechanism to capture ADF logs and storing the details in DB Extracting the Parameter values from DB and passing in to the Power Shell Scripts