Hello
Hope you are doing well
Position: Sr Data Engineer
Location: NY or NJ or Dallas
Duration: Long Term
Job Description:
Contribute to the migration of legacy data warehouse to a google cloudbased data warehouse for a Telecom Major..
Design and develop very complex ETL pipelines in Google cloud Data environments.
Build data pipelines for the underlying data warehouse and data marts
Our legacy tech stack includes Teradata and new tech stack includes GCP Cloud Data Technologies like BigQuery and Airflow and languages include SQL Python
Maintain detailed documentation of your work and changes to support data quality and data governance
Support QA and UAT data testing activities
Support Deployment activities to higher environments
Be an active participant and advocate of agile/scrum practice to ensure health and process improvements for your team
Basic Qualifications
10 years of data engineering experience developing large data pipelines in very complex environments
Very Strong SQL skills and ability to build Very complex transformation data pipelines using custom ETL framework in Google BigQuery environment
Exposure to Teradata and ability to understand complex Teradata BTEQ scripts
Strong Python programming skills
Strong Skills on build Airflow Jobs and Debug issues
Ability to Optimize the Query in BigQuery
Handson experience on Google Cloud data Technologies ( GCS BigQuery Dataflow Pub sub Data Fusion Cloud Function)
Preferred Qualifications
Experience with cloud data warehouse technology BigQuery.
Nice to have experience with Cloud technologies like GCP (GCS Data Proc Pub/sub Data flow Data Fusion Cloud Function)
Nice to have exposure to Teradata
Solid experience with Job Orchestration Tools like Airflow and ability to build complex Jobs.
Writing and maintaining large Data Pipelines using Custom ETL framework
Very good experience with Code Version control repository like Github
Good Scripting skills including Bash scripting and Python
Familiar with Scrum and Agile methodologies
Problem solver with strong attention to detail and excellent analytical and communication skills
Ability to work in Onsite / Offshore model.