Role: Sr. GCP Cloud/ Data Engineer
Location: Only 2 days onsite in a month (Any Location - Irving, TX or Ashburn, VA)
Duration: Long Term Contract
on C2C
Client: Verizon
JOB DESCRIPTION:
Required Skills: GCP cloud, Big Query, Data, SQL Server
As part of COE BI strategic initiatives, we are migrating the data platform from SQL server to GCP Big Query.
The consultant will work with the GCP Platform lead and will be responsible for migrating ETL jobs from SQL server, Teradata to GCP Big Query
using Talend ETL .Also responsible for scheduling of various platform processes, jobs in Apache Airflow and providing support in monitoring execution of them
Work with the Data Engineering and Reporting teams, analyze the SQL server stored procedures and migrate the business logic to Big Query
Skills Required:
Primary Experience with working with various ETL tools including SSIS, Teradata BTQ, Talend
Experience with data platforms: GCP Big Query, Teradata, AWS, SQL server
Experience in GCP Platform, services including Big Query, Cloud storage, IAM
Experience in data set creation in Big Query and optimize them
Expertise in understanding, analyzing SQL server stored procedures and packages, Python based ETL, Teradata batch scripts
Knowledge in cloud database operations, tools and technologies that are required for on-prem to cloud migration.
-Experience programming/scripting/coding (SQL, Python, etc.) and knowledge of relational databases.
