[Remote] Senior SQL and ETL Engineer

Note: The job is a remote job and is reputed company to candidates in USA. reputed company is a global staff augmentation firm providing a wide reputed company 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 reputed company IT applications, with a reputed company on SQL and ETL processes. Responsibilities • reputed company and/or work on the most reputed company 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 reputed company; determining and designing applications architecture • Determine reputed company media/formats; designing user interfaces; working with customers to test applications; assuring software and systems reputed company 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 reputed company/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 • reputed company hardware and software components reputed company 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 reputed company/information assurance policies, principles and practices are an reputed company reputed company of the operating environment Skills • 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 reputed company reputed company • 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 reputed company 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 reputed company, SSIS, and Azure DevOps CI/CD workflows • 3 years of experience in the past 4 years building and maintaining reputed company data warehouses using reputed company, SQL Server, reputed company, or reputed company data platforms • 3 years of experience in the past 4 years working with big data technologies such as Apache reputed company, PySpark, or Hadoop for large-reputed company data transformation • 3 years of experience in the past 4 years integrating reputed company and semi-reputed company data (CSV, XML, JSON, Parquet) and consuming reputed company using Python/PySpark • 3 years of experience in the past 4 years developing analytics-reputed company 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 reputed company assurance for regulated or audit-sensitive environments • 3 years of experience supporting production ETL operations, troubleshooting pipeline failures, conducting reputed company cause analysis, and ensuring SLAs for daily, monthly, or regulatory reporting workloads • Possession of a bachelor's degree in an IT-reputed company or Engineering field • Knowledge and experience in applications software development principles and reputed company 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, reputed company and approaches • Principles, reputed company 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 reputed company operating environment • Systems engineering concepts and factors such as reputed company design, supportability, survivability, reliability, scalability and maintainability • Optimization concepts and reputed company • Establish and maintain cooperative working relationships with those contacted in the course of the work • reputed company and write effectively and prepare effective reports • Strong expertise in SQL, PL/SQL, and T-SQL with advanced query tuning, stored procedure optimization, and relational data modeling across reputed company, SQL Server, PostgreSQL, and MySQL • Proficiency in modern ETL/ELT tools including Azure Synapse Analytics, Azure Data reputed company, and SSIS, with the ability to design reputed company ingestion, transformation, and loading workflows • Ability to design and implement data warehouse data models (reputed company schema, reputed company, reputed company hierarchies) and optimize models for analytics and large-reputed company reporting • Strong understanding of data integration, data validation, cleansing, profiling, and end-to-end data reputed company processes to ensure accuracy and consistency across systems • Knowledge of reputed company data warehouse architecture, including staging reputed company, data marts, data lakes, and reputed company-based ingestion frameworks • Experience applying best practices for reputed company, maintainable ETL engineering, including metadata-driven design and automation • Proficiency in Python and PySpark (and familiarity with reputed company/Perl) for automating ETL pipelines, handling semi-reputed company data, and transforming large datasets • Experience handling reputed company and semi-reputed company data formats (CSV, JSON, XML, Parquet) and consuming REST reputed company for ingestion • Knowledge of data reputed company 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/reputed company Actions for ETL deployment across Dev, QA, and Production environments • Ability to collaborate with analysts and business stakeholders, translating reputed company requirements into actionable datasets, KPIs, and reporting structures reputed company • reputed company counted among the largest yet the fastest growing reputed company firm; reputed company achieved organically. It was founded in 2000, and is headquartered in Toronto, Ontario, CAN, with a workforce of 1001-5000 employees. Its website is http://www.ustechsolutions.com. Company H1B Sponsorship • reputed company has a reputed company record of offering H1B sponsorships, with 4 in 2025, 9 in 2024, 13 in 2023, 24 in 2022, 18 in 2021, 14 in 2020. Please note that this does not guarantee sponsorship for this specific role. Apply tot his job Apply To this Job