siri Gajjala

• Lead end to end data engineering across cloud and on prem platforms (AWS S3, Snowflake, Redshift, Teradata), building scalable ETL/ELT pipelines with Databricks, Spark, Python, AWS Glue, AWS Step Functions and NotebookOne to ingest, transform, and load batch and streaming data.
• Design and execute targeted marketing campaigns for US card customers using Unica Affinium / Quantum, Snowflake, S3,

• Design and implement data ingestion pipelines to migrate data from SQL Server to AWS and Snowflake, leveraging Hadoop for intermediate processing and ensuring secure, auditable transfers.
• Automate Snowflake operations by developing stored procedures and scripts to orchestrate SnowSQL tasks and streamline data workflows.
• Develop complex SQL and analytical scripts across SQL Server, Hive, and

• Develop automated ETL and streaming pipelines to ingest, transform, and load real time and batch data from SDP and other sources into analytical warehouses using Databricks, Spark, and Python.
• Develop complex SQL and PySpark scripts to perform cross platform data validation, root cause analysis, and reconciliation across Snowflake, Redshift, and Teradata.
• Perform data engineering and analysi

• Led requirement analysis and translated business needs into technical specifications for cross‑functional engineering, QA, and product teams.
• Drove business and functional requirements gathering across multiple batch teams to design and implement new data processing batches.
• Developed and optimized complex SQL queries (inline queries, subqueries, multi‑table joins) to improve data retrieval

• Architected scalable relational and de‑normalized data models to support high‑performance analytical and transactional workloads across enterprise Oracle environments.
• Developed and implemented database Views, Functions, Packages, Stored Procedures, and Materialized Views to implement application logic.
• Optimized SQL performance through strategic indexing, partitioning, and query tuning, sig

• Led end‑to‑end requirements gathering, translating business needs into detailed Technical and Functional Specification documents for new data initiatives and system enhancements.
• Designed enterprise‑grade data migration mappings to move data from transactional systems into a centralized data warehouse supporting BI and analytics platforms.
• Developed robust Oracle database components like SQL

• Led business requirements collection and authored detailed Requirements Specification documents to guide development, testing, and compliance activities.
• Developed and executed test strategies including unit testing, integration testing, UAT, and debugging to ensure high‑quality application delivery.
• Wrote and optimized JCL and DB2 scripts to support SOX compliance processes and ensure accur