[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 integral 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