TekIntegral is Hiring a Data Warehouse Developer/Architect Near Plano, TX
Role: Data Warehouse Developer/ArchitectLocation: Plano 1: 3rd Floor (31061-0310) - Must sit onsite in Plano, TX hybrid (Mon & Fri remote/Tue-Thu onsite)Duration: ~4 monthsWork auth: USC/GC or EADsLinkedIn: Must have
Candidate Must be former Capital One contractor
Job Description
Project Name: OneStream Convergence
In this position/role, resource is expected to do:
Understand existing workflows and underlying frameworks
Migrate these existing workflows to new CapitalOne specific data ingestion framework
Collaborate with and across Agile teams
to gather metadata to meet the current data governance standards
Perform unit tests and conduct reviews with other team members to make sure your code is rigorously designed, elegantly coded, and effectively tuned for performance
Build scripts/utilities to accelerate migration
Analyze data & generate reports
Learn-unlearn-relearn concepts with an open and analytical mindset.
Troubleshooting & Critical thinking
Develop & review technical documentation for artifacts delivered.
Requirements
Minimum 7 years of experience in data engineering and Data Pipelines
Minimum 5 years of extensive experience in Python Programming
Minimum 3 years of extensive experience in SQL, Unix/Linux Shell Scripting
Hands-on experience writing complex SQL queries, exporting, and importing large amounts of data using utilities.
Minimum 3 year of AWS experience
Basic Knowledge of CI/CD
Excellent communication skills and Good Customer Centricity.
Nice To Have's
Prior experience with data migration project
Experience with Kafka Streams/building data intensive streaming applications (stream processing, e.g. Kafka, Spark Streaming)
Experience/Knowledge of Scala or Java Programming
Experience with at least one Cloud DW such as Snowflake