Senior Data Engineer With GCP
Long Term
Nashville TN
Skillset Required.
Project is for Migration of SQL Server on Prem to PostgreSQL on GCP.
.. SQL Server
... Stored Procedure
... SSIS
... SSRS
.. PostgreSQL
... Stored procedure
.. GCP Data services
PostgreSQL on GCP
Job Description
Need to Know:
- SQL Server
- Intermediate level
- Knowledge required: Tables views stored procedure user functions)
- Why: Need to understand the source structure to be able to check in the target if the respective structure was created and the data was correct ingested
- SSIS
- Junior leve (basic understanding is enough)
- Knowledge required: now how to use open the packages and identify the stored procedures database connections and other dependencies.
- Why: to help Shannon map design the new solution with cloud run jobs
- PostgreSQL
- Google Platform
- Basic to intermediate level
- Knowledge required: knows how to use the platform find the services like cloud run database instances etc.
- Why: the migration is to GCP platform.
- Database management tools
- Intermediate level
- Knowledge required: know how to use PGAdmin Dbeaver or any other tool to connect to the database and make any validation required
Nice to have
- ISpirer
- Why: tool used by the client to migrate databases from onprem to cloud (will be used in other projects as well)
- Programming like go/python
- Why: help Shannon if needed in the SSIS packages recreation
- GCP Big Query
- Why: the client is moving into the direction to have bigquery as the source of true. I believe this project will have a phase 2 and this knowledge will be important.
Senior Data Engineer With GCP Long Term Nashville TN Skillset Required. Project is for Migration of SQL Server on Prem to PostgreSQL on GCP. .. SQL Server ... Stored Procedure ... SSIS ... SSRS .. PostgreSQL ... Stored procedure .. GCP Data services PostgreSQL on GCP Job Description ...
Senior Data Engineer With GCP
Long Term
Nashville TN
Skillset Required.
Project is for Migration of SQL Server on Prem to PostgreSQL on GCP.
.. SQL Server
... Stored Procedure
... SSIS
... SSRS
.. PostgreSQL
... Stored procedure
.. GCP Data services
PostgreSQL on GCP
Job Description
Need to Know:
- SQL Server
- Intermediate level
- Knowledge required: Tables views stored procedure user functions)
- Why: Need to understand the source structure to be able to check in the target if the respective structure was created and the data was correct ingested
- SSIS
- Junior leve (basic understanding is enough)
- Knowledge required: now how to use open the packages and identify the stored procedures database connections and other dependencies.
- Why: to help Shannon map design the new solution with cloud run jobs
- PostgreSQL
- Google Platform
- Basic to intermediate level
- Knowledge required: knows how to use the platform find the services like cloud run database instances etc.
- Why: the migration is to GCP platform.
- Database management tools
- Intermediate level
- Knowledge required: know how to use PGAdmin Dbeaver or any other tool to connect to the database and make any validation required
Nice to have
- ISpirer
- Why: tool used by the client to migrate databases from onprem to cloud (will be used in other projects as well)
- Programming like go/python
- Why: help Shannon if needed in the SSIS packages recreation
- GCP Big Query
- Why: the client is moving into the direction to have bigquery as the source of true. I believe this project will have a phase 2 and this knowledge will be important.
View more
View less