Sairam Patturi

Senior Azure Data Engineer @Strategic Systems Inc

Dublin, OH, US

Designed and implemented ETL data ingestion pipelines from various sources like SQL Server, APIs, and SFTP into Azure Data Lake Storage (ADLS) using Azure Data Factory (ADF) and Databricks.• Developed scalable and reusable ETL/ELT workflows using PySpark, Scala, SQL, and Talend to transform and process high-volume structured and semi-structured datasets.• Created and optimized SQL queries, stored procedures, and views to support efficient data extraction, transformation, and downstream reporting.• Built Hive tables to store processed and aggregated data in tabular formats for analytical querying using HiveQL and Spark SQL.• Worked on architecting data transformation layers and implemented SCD Type 1 & 2 for dimensional modeling (Star/Snowflake schema) using Databricks, Hive, and SQL.• Migrated and integrated data from legacy sources and traditional ETL tools into the Azure ecosystem, using Talend, Spark custom frameworks, and ADF pipelines.• Scheduled and orchestrated data pipelines using ADF triggers, Databricks jobs, and Autosys to enable reliable daily and incremental data loads.• Involved in full Agile SDLC including requirements gathering, development, QA, and deployment using Jira, Confluence, and Git-based CI/CD pipelines.• Actively debugged data issues, resolved transformation errors, and provided production support for business-critical ETL jobs and analytics pipelines.• Developed the WLDS application, contributed to requirement analysis, and applied modifications as per client feedback to enhance data processing logic.• Proficient in building reusable Talend frameworks and integrating them with Spark or traditional databases like Oracle, Teradata, and SQL Server.