Hi,
The following requirement is open with our client.
Title : Data Engineer with SQL
Location : Plano, Texas - onsite
Duration : 12+ Months
Relevant Experience (in Yrs.):
Job Description:
Professional data engineering experience (adjust range as needed).
Advanced T‐SQL skills: complex joins, window functions, dynamic SQL, error handling, and transaction control.
Strong hands‐on with SQL Server engine internals: indexes, partitioning, execution plans, statistics, tempdb usage, isolation levels, and deadlock analysis.
Proven experience building ETL/ELT with one or more: SSIS, Azure Data Factory, Informatica, Talend, PySpark, or Airflow.
Solid understanding of data warehousing concepts (Kimball/Dimensional modeling), SCDs, and data quality practices.
Proficiency with Git and at least one CI/CD tool; experience scripting in Python or PowerShell.
Experience operating in Windows/Linux server environments.
Preferred Qualifications
Experience with Azure Data Platform (ADF, Databricks, Synapse, ADLS, Key Vault) or AWS equivalents.
Exposure to NoSQL (Cosmos DB, MongoDB) and event/streaming (Kafka/Event Hubs).
BI exposure (Power BI/Tableau) and DAX/semantic modeling understanding.
Knowledge of Terraform/ARM/Bicep for infra‐as‐code and Kubernetes/Docker for containerized workloads.
Performance tuning at scale: workload management, columnstore indexes, table distribution strategies, and querying external data (PolyBase/Linked Servers where applicable).
Pipeline Development: Design and implement robust ETL/ELT workflows that move data from diverse sources (APIs, flat files, cloud stores, operational DBs) into SQL Server data marts and data warehouse layers (staging, core, semantic).
SQL Engineering: Write high‐performance T‐SQL (stored procedures, functions, views, window functions, CTEs) and optimize queries using execution plans, indexing strategies, partitioning, and statistics maintenance.
Data Modeling: Build dimensional models (star/snowflake), conformed dimensions, and fact tables; enforce data standards, naming conventions, and SCD strategies (Type 1/2).
Thanks & regards,
Balu Garibe
ASCII Group, LLC
Mobile: / Email: