ETL Developer with Azure Databricks

<spanstyle=""font-size:12pt/""><spanstyle=""font-family:Aptos,sans-serif/"">ETL Developer with Azure Databricks

<spanstyle=""font-size:12pt/""><spanstyle=""font-family:Aptos,sans-serif/"">Location: Remote – anywhere in US

<spanstyle=""font-size:12pt/""><spanstyle=""font-family:Aptos,sans-serif/"">Type: ongoing on W2

<spanstyle=""font-size:12pt/""><spanstyle=""font-family:Aptos,sans-serif/"">Key Skills & Requirements:

• <spanstyle=""font-size:12pt/""><spanstyle=""tab-stops:list"" .5in/"><spanstyle=""font-family:Aptos,sans-serif/"">5+ years of experience in creating ETL jobs using Azure Databricks with Oracle and SQL Server as backend.
• <spanstyle=""font-size:12pt/""><spanstyle=""tab-stops:list"" .5in/"><spanstyle=""font-family:Aptos,sans-serif/"">Strong understanding of ETL concepts including full load and incremental load using Databricks and Azure Data Factory (ADF) pipelines.
• <spanstyle=""font-size:12pt/""><spanstyle=""tab-stops:list"" .5in/"><spanstyle=""font-family:Aptos,sans-serif/"">Experience in creating ETL pipelines with Azure Data Factory and sequencing Databricks jobs in ADF.
• <spanstyle=""font-size:12pt/""><spanstyle=""tab-stops:list"" .5in/"><spanstyle=""font-family:Aptos,sans-serif/"">Experience in creating reusable notebooks in Azure Databricks, including the use of functions and parameters.
• <spanstyle=""font-size:12pt/""><spanstyle=""tab-stops:list"" .5in/"><spanstyle=""font-family:Aptos,sans-serif/"">Proficiency in Python programming language.
• <spanstyle=""font-size:12pt/""><spanstyle=""tab-stops:list"" .5in/"><spanstyle=""font-family:Aptos,sans-serif/"">Strong Oracle and SQL Server query experience, with knowledge of CTEs, ANSI SQL, and Oracle functions.
• <spanstyle=""font-size:12pt/""><spanstyle=""tab-stops:list"" .5in/"><spanstyle=""font-family:Aptos,sans-serif/"">Experience with SQL set operators such as MINUS, EXCEPT, UNION, etc.
• <spanstyle=""font-size:12pt/""><spanstyle=""tab-stops:list"" .5in/"><spanstyle=""font-family:Aptos,sans-serif/"">Proficiency in creating PL/SQL blocks, triggers, and indexes.
• <spanstyle=""font-size:12pt/""><spanstyle=""tab-stops:list"" .5in/"><spanstyle=""font-family:Aptos,sans-serif/"">Experience in query performance tuning, including working with indexes and partitions.
• <spanstyle=""font-size:12pt/""><spanstyle=""tab-stops:list"" .5in/"><spanstyle=""font-family:Aptos,sans-serif/"">Strong troubleshooting and defect resolution skills.
• <spanstyle=""font-size:12pt/""><spanstyle=""tab-stops:list"" .5in/"><spanstyle=""font-family:Aptos,sans-serif/"">Excellent communication and client-facing skills.