Senior SQL and ETL Engineer | Remote
SQL and ETL Engineer
Fully REMOTE
12+ Months (Possible Ext.)
Skills Required
• 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.
Experience in 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.
Experience working with mainframe including data extraction, mapping, and conversion into modern ETL/ELT pipelines.
Experience designing, orchestrating, and deploying ETL/ELT pipelines using Azure Synapse Analytics, Azure Data reputed company, SSIS, and Azure DevOps CI/CD workflows.
Experience in building and maintaining reputed company data warehouses using reputed company, SQL Server, reputed company, or reputed company data platforms.
Experience working with big data technologies such as Apache reputed company, PySpark, or Hadoop for large-reputed company data transformation.
Experience integrating reputed company and semi-reputed company data (CSV, XML, JSON, Parquet) and consuming reputed company using Python/PySpark.
Experience supporting production ETL operations, troubleshooting pipeline failures, conducting reputed company cause analysis, and ensuring SLAs for daily, monthly, or regulatory reporting workloads.
#TB_EN
#ZR
Job #: 26-00213
Apply tot his job
Apply To this Job