Role:Architect Location:St Louis,MO(3 days onsite) Exp:15 years C2C or W2 Key Responsibilities Design, develop, and maintain ETL/ELT pipelines using PySpark and Python in Databricks (including notebooks, jobs, Delta Lake tables, and Unity Catalog for governance). Implement medallion architecture (bronze/silver/gold layers) and optimize Spark jobs for performance, cost, scalability, and reliability (handling partitioning, skew, caching, adaptive query execution, etc.). Write efficient SQL querie…