Senior SQL and ETL Engineer

Job Role: Senior SQL and ETL Engineer

Location: Downey, CA (Remote)

Duration: 12 Months Contract

Experience Required:

This classification must have a 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.

Additional Experience Required:

• 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.