Data Analyst/engineer

Description:

Reading the data from different data sets into SQL server. You need to have minimum basic knowledge basic queries happens. Some concept of datawarehousing is needed. How to load the data into dimension tables or sql server tables. The client is looking to use SSIS as an ETL tool to connect to the sources they are mentioning. We will be using an API. Create an SSIS package and invoke an API using Python. Particular source and then we transform the data into SQL server. What libraries you need to use within that for Python. Beneficial for someone to have SSIS. If someone knows another ETL tool we should really see an intent to learn. Python SQL they can leverage with SSIS. Some SSIS background.

JD:
Proven experience in ETL processes and ETL frameworks.
Strong proficiency in SQL, including writing complex queries and stored procedures.
Proficiency in Python for data analysis and automation.
Experience with cloud platforms such as AWS, Azure, or Google Cloud.
Excellent problem-solving skills and attention to detail.
Strong communication and collaboration skills.