US Tech Solutions · 1 day ago
Senior SQL and ETL Engineer
United States
Contract
Remote
Senior Level
$47/hr - $53/hr
7+ years expUS Tech Solutions is a global staff augmentation firm providing a wide range of talent on-demand and total workforce solutions. They are seeking a Senior SQL and ETL Engineer responsible for leading the design, development, testing, and implementation of complex IT applications, with a focus on SQL and ETL processes.
Information Technology
Hiring Manager
Raviteja Chowdary Yarram
Responsibilities
Lead and/or work on the most complex IT applications design, documentation, development, modification, testing, installation, implementation and support of new or existing applications software
Plan, install, configure, test, implement and manage a systems environment in support of an organization’s IT architecture and business needs
Analyze and refine systems requirements; translating systems requirements into applications prototypes; planning and designing systems architecture; writing, debugging and maintaining code; determining and designing applications architecture
Determine output media/formats; designing user interfaces; working with customers to test applications; assuring software and systems quality and functionality; integrating hardware and software components; writing and maintaining program documentation
Evaluate new applications software technologies; and/or ensure the rigorous application of information security/information assurance policies, principles and practices to the delivery of application software services
Analyze systems requirements in response to business requirements, risks and costs; evaluate, select, verify and validate the systems software environment; evaluate, select and install compilers, assemblers and utilities
Integrate hardware and software components within the systems environment; monitor and fine-tune performance of the systems environment; evaluate new systems engineering technologies and their effect on the operating environment; and/or ensure that information security/information assurance policies, principles and practices are an integral element of the operating environment
Qualification
Required
Minimum of seven (7) years of experience in electronic data processing systems study, design, and programming
At least four (4) years of that experience must have been in a lead capacity
3 years of experience in the past 4 years developing and optimizing SQL, PL/SQL, and T-SQL logic, including stored procedures, functions, performance tuning, and advanced relational modeling across Oracle and SQL Server
3 years of experience in the past 4 years working with mainframe including data extraction, mapping, and conversion into modern ETL/ELT pipelines
3 years of experience in the past 4 years designing, orchestrating, and deploying ETL/ELT pipelines using Azure Synapse Analytics, Azure Data Factory, SSIS, and Azure DevOps CI/CD workflows
3 years of experience in the past 4 years building and maintaining enterprise data warehouses using Oracle, SQL Server, Teradata, or cloud data platforms
3 years of experience in the past 4 years working with big data technologies such as Apache Spark, PySpark, or Hadoop for large-scale data transformation
3 years of experience in the past 4 years integrating structured and semi-structured data (CSV, XML, JSON, Parquet) and consuming APIs using Python/PySpark
3 years of experience in the past 4 years developing analytics-ready datasets and supporting business intelligence platforms such as Power BI or Cognos, including writing optimized SQL for reporting
3 years of experience in the past 4 years performing data cleansing, validation, profiling, and data quality assurance for regulated or audit-sensitive environments
3 years of experience supporting production ETL operations, troubleshooting pipeline failures, conducting root cause analysis, and ensuring SLAs for daily, monthly, or regulatory reporting workloads
Possession of a bachelor's degree in an IT-related or Engineering field
Knowledge and experience in applications software development principles and methods sufficient to participate in the design, development, testing and implementation of new or modified applications software
Operating systems installation and configuration procedures
Organization's operational environment
Software design principles, methods and approaches
Principles, methods and procedures for designing, developing, optimizing and integrating new and/or reusable systems components
Pertinent government regulations
Infrastructure requirements, such as bandwidth and server sizing
Database management principles and methodologies, including data structures, data modeling, data warehousing and transaction processing
Functionality and operability of the current operating environment
Systems engineering concepts and factors such as structured design, supportability, survivability, reliability, scalability and maintainability
Optimization concepts and methods
Establish and maintain cooperative working relationships with those contacted in the course of the work
Speak and write effectively and prepare effective reports
Preferred
Strong expertise in SQL, PL/SQL, and T-SQL with advanced query tuning, stored procedure optimization, and relational data modeling across Oracle, SQL Server, PostgreSQL, and MySQL
Proficiency in modern ETL/ELT tools including Azure Synapse Analytics, Azure Data Factory, and SSIS, with the ability to design scalable ingestion, transformation, and loading workflows
Ability to design and implement data warehouse data models (star schema, snowflake, dimensional hierarchies) and optimize models for analytics and large-scale reporting
Strong understanding of data integration, data validation, cleansing, profiling, and end-to-end data quality processes to ensure accuracy and consistency across systems
Knowledge of enterprise data warehouse architecture, including staging layers, data marts, data lakes, and cloud-based ingestion frameworks
Experience applying best practices for scalable, maintainable ETL engineering, including metadata-driven design and automation
Proficiency in Python and PySpark (and familiarity with Shell/Perl) for automating ETL pipelines, handling semi-structured data, and transforming large datasets
Experience handling structured and semi-structured data formats (CSV, JSON, XML, Parquet) and consuming REST APIs for ingestion
Knowledge of data security and compliance practices, including credential management, encryption, and governance in Azure
Expertise in optimizing ETL and data warehouse performance through indexing, partitioning, caching strategies, and pipeline optimization
Familiarity with CI/CD workflows using Git/GitHub Actions for ETL deployment across Dev, QA, and Production environments
Ability to collaborate with analysts and business stakeholders, translating complex requirements into actionable datasets, KPIs, and reporting structures
Company
US Tech Solutions
US Tech Solutions counted among the largest yet the fastest growing staffing firm; all achieved organically.
1001-5000 employees
H1B Sponsorship
US Tech Solutions has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (4)
2024 (9)
2023 (13)
2022 (24)
2021 (18)
2020 (14)
Funding
Current Stage
Late StageLeadership Team
Manoj Agarwal
Chief Executive Officer
Recent News
Kelly Services, Inc.
2025-05-17
GlobeNewswire News Room
2024-12-13
Company data provided by crunchbase