Data engineer • allen tx
Job Title: SQL Data Engineer with OLTP Exp.Location: Plano, TX (5 days onsite/week) F2F Must Need Only Locals.Job Overview</b></p> <p style="text-align:justify">... Show more
Scalepex is a dynamic services firm specializing in providing solutions for premium brands like Nike, Pepsi, Toyota, Virgin and Walgreens.Our mission is to connect prominent market leaders with top... Show more
Understand and document scope and requirements through interactions with analysts and stakeholders.Design and develop scalable code based custom ETL pipelines using big data technologies on Cloud p... Show more
Extensive experience in designing, configuring, deploying, managing and automating AWS Core Services like S3, IAM, EC2, Route53, SNS, SQS, ELB, CloudWatch, Lambda and VPC.Experience in automating c... Show more
Data Engineer 4 Do you love building and pioneering in the technology space? Do you enjoy solving complex business problems in a fast-paced, collaborative, inclusive and iterative delivery environ... Show more
Must Have Technical/Functional Skills</b></p> <p> </p> <ul> <li>Senior backend engineering experience within enterprise environments</li> <li>Strong... Show more
Our client is currently seeking a Data Engineer with strong experience in data modeling, data warehousing, and cloud-based data platforms.The ideal candidate will have hands-on experience with AWS ... Show more
Domicilie Location: </strong>The location for this hybrid position is Plano, TX.Candidates residing within 50 miles of a FedEx campus will be required to work on-site at a FedEx location seve... Show more
Senior Data Engineer – Plano, TX | Full-Time / Hybrid.We are seeking a highly skilled and experienced .This role will focus heavily on .Azure Databricks, PySpark, Spark SQL, scalable ETL/ELT pipeli... Show more
We have an opportunity to impact your career and provide an adventure where you can push the limits of what's possible.As a Lead Software Engineer at JPMorganChase within the CIB, you are an integr... Show more
Job Description</b></p> <p> </p> <p><b>Senior Data, AI & Reliability Engineer</b></p> <p><b>Must Have Technical/Functional Skills<... Show more
Please review the JD below and let me know if you would be interested in exploring the opportunity</i></p> <p class="wordsection1"> </p> <p class="wordsec... Show more
Data Analyst / Analytics Engineer.Plano, TX (Hybrid — 3 days/week onsite, 2 days remote).Glint Tech Solutions is a women-owned, global IT staffing and recruiting firm serving enterprise clients acr... Show more
We are seeking experienced Data Engineers, Data Architects, and ETL Testing professionals to design, develop, and maintain enterprise data platforms, data pipelines, and data warehouse solutions su... Show more
Join a team that keeps modern cloud data platforms reliable so engineers can deliver features confidently.You will shape secure environments, pipelines, and deployment standards that enable fast, s... Show more
Work Authorization: US Citizen, Green Card, or GC EAD preferred.No C2C, 1099, or third-party profiles accepted.Strong hands-on experience in Python, PySpark and Bigdata technologies for data engine... Show more
Software Data Operations Engineer Plano (Dallas), Texas About MAQ Software MAQ Software enables leading companies to accelerate their business intelligence and analytics initiatives.Our AI-powered ... Show more
Ingest data from sources such as Microsoft SQL Server (BOSS) and Oracle into the Bronze layer, implementing CDC-based incremental ingestion.Develop dbt models for the Silver layer including cleansi... Show more
Understand and document scope and requirements through interactions with analysts and stakeholders.Design and develop scalable code based custom ETL pipelines using big data technologies on Cloud p... Show more
We are seeking a mid-level Data Platform Engineer to build a new greenfield data platform integrating internal systems (GSCM, SEASI, SMART, and BOSS) using a Medallion Architecture.This role owns t... Show more
The average salary range is between $ 102,855 and $ 159,725 year , with the average salary hovering around $ 132,158 year .
The average salary range is between $ 105,570 and $ 172,017 year , with the average salary hovering around $ 130,000 year .
Job Title: SQL Data Engineer with OLTP Exp.
Location: Plano, TX (5 days onsite/week) F2F Must Need Only Locals.
Duration: 6 Months Contract.
Job Overview
We are hiring a Mid Level Data Engineer to design and build OLTP Online Transaction Processing systems and pipelines. This role focuses on transactional system design API driven data flows and building reliable high performance data services. The ideal candidate thinks in terms of system architecture transactional integrity and low latency data handling rather than scheduled data warehouse loads.
Key Responsibilities
Design build and maintain OLTP pipelines for Realtime or near Realtime transactional data processing.
Build and consume APIs to handle data ingestion updates and retrieval from operational systems.
Design SQL Server database schemas optimized for transactional workloads normalization indexing concurrency control and locking behaviour.
Write and optimize SQL queries stored procedures and transaction logic for high throughput low latency operations.
Ensure data consistency atomicity and integrity ACID compliance across services.
Develop ETL processes as needed to support data migration system integration or occasional batch sync between transactional systems.
Handle API request response cycles validation error handling retries and rate limiting on data write operations.
Monitor system performance diagnose issues deadlocks query latency contention and tune for scale.
Deploy and manage data services using Azure Azure SQL Database API Management Azure Blob.
Use SSIS SQL Server Integration Services for occasional data migration or integration tasks.
Collaborate with backend engineers to integrate data layers into application services.
Implement validation idempotency checks and integrity constraints at the transactional level.
Create and maintain documentation for system architecture API contracts and database schemas.
Requirements
Bachelors degree in Computer Science Information Technology or a related field or equivalent practical experience.
7 to 10 years of experience in SQL Server and relational database design for OLTP systems normalization indexing transactions isolation levels.
Solid experience building or consuming APIs REST for data read write operations.
Working knowledge of Azure services Azure SQL Database API Management Azure Blob Storage.
Experience working with transactional data in high concurrency production environments.
Experience writing and optimizing SQL stored procedures for transactional systems.
Handson experience with SSIS or similar tools for data migration integration tasks.
Working knowledge of ETL development for occasional batch sync or migration needs.
Understanding of system design fundamentals concurrency caching request handling and service scalability.
Experience collaborating with backend application engineers to integrate data layers into services.
Strong analytical troubleshooting and communication skills.
Skills
Mandatory Skills: MS SQL Server, OLTP, RDBMs Design, REST APIs, Azure, Azure Blob Storage, SQL, Stored Procedures, SSIS, Data Migration, Integration, ETL, Batch Sync or Migration
