Data Engineer

Title-Data Lead engineerLocation-Fremont, CA(Only local)Visa Only-USC, GC-Only w2 No C2C or C2H or 1099Job Description10+ yrs expAzure Data Factory (ADF), Azure Databricks & PySpark, Azure Synapse, Azure SQL, Python, and Spark SQLProfile SummaryAccomplished Data Architect / Senior Data Engineer with 12+ years of experience designing and modernizingenterprise data platforms across banking, healthcare and retail domainsArchitected scalable ETL/ELT pipelines using Python, PySpark, Databricks, AWS Glue and Azure Data Factory,supporting high-volume transactional and regulatory data processing.Led enterprise-scale Data Architecture initiatives, defining logical and physical data models, governancestandards and cloud-native platform blueprints across AWS and Azure environments.Designed and implemented Medallion (Bronze/Silver/Gold) Lakehouse architectures using Delta Lake, S3, ADLSGen2, Snowflake, Redshift and Synapse Analytics.Engineered large-scale distributed processing workloads using Apache Spark, PySpark, Databricks, EMR, Hiveand HDFS, processing billions of records for enterprise analytics.Orchestrated complex data workflows using Apache Airflow, Databricks Workflows, AWS Step Functions andAzure Data Factory triggers, ensuring SLA-driven pipeline execution.Strong hands-on experience in Advanced SQL, including complex joins, CTEs, window functions, storedprocedures, indexing strategies, partitioning and execution plan optimization across Snowflake, PostgreSQLand Oracle.Built real-time streaming architectures using Apache Kafka, AWS Kinesis, Azure Event Hub and Service Bus,supporting fraud detection, claims monitoring and operational telemetry.Recruiter Instructions