Skills Required
- SQL Server
- ADF
- Power Automate (nice to have)
Duties & Responsibilities
- Must be well versed with the ETL Concepts.
- Can create complex sql queries, parameterized stored procedure , view.
- Create scripts to transform the data in staging tables and load into L2 tables and perform proper validation.
- Should be able to create complex ADF pipelines with different source and destination like blob storage,sftp,azure sql database.
- Must handle the different types of source file like CSV, Excel , Json stc.
- Error handling process in ADF pipelines.
- Knowledge of Power Automate(good to have)
Education & Training
- IT Education
