Sr. GCP Cloud/ Data Engineer

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 Queryusing Talend ETL .Also responsible for scheduling of various platform processes, jobs in Apache Airflow and providing support in monitoring execution of themWork with the Data Engineering and Reporting teams, analyze the SQL server stored procedures and migrate the business logic to Big QuerySkills Required:Primary Experience with working with various ETL tools including SSIS, Teradata BTQ, TalendExperience with data platforms: GCP Big Query, Teradata, AWS, SQL serverExperience in GCP Platform, services including Big Query, Cloud storage, IAMExperience in data set creation in Big Query and optimize themExpertise in understanding, analyzing SQL server stored procedures and packages, Python based ETL, Teradata batch scriptsKnowledge 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.