Role & responsibilities
Solid knowledge of Extraction Transformation and Loading (ETL) processes using frameworks like Azure Data Factory or Synapse or Databricks; establishing cloud connectivity between different systems like ADLS, ADF, Synapse, Databricks etc.
Candidates must possess hands on Power BI skills.
Candidates must have valuable understanding of Informatica.
Design and develop ETL processes based on functional and non-functional requirements in python / pyspark within Azure platform.
A minimum of 5 years' experience with large SQL data marts. Expert relational database experience, Candidate should demonstrate ability to navigate through massive volumes of data to deliver effective and productive data extraction, design, load, and reporting solutions to business partners
Experience in troubleshooting and supporting large databases and testing activities; Identifying reporting, and managing database security issues, user access/management; Designing database backup, archiving and storage, performance tuning, ETL importing large volume of data extracted from multiple systems, capacity planning
Experience in TSQL programming along with Azure Data Factory framework and Python scripting