Siva Somesula

Senior Data Engineer

Hyderabad, India 7+ yrs exp 90 · Outstanding

About

Senior Data Engineer with 7+ years of experience designing and delivering reliable, analytics-ready data solutions across Fraud, Risk, Payments, and Regulatory Reporting domains. Strong hands-on expertise in Looker, LookML DBT, Snowflake, AWS S3, Google Cloud Platform (GCP), advanced SQL and Paradime with a proven ability to translate complex business requirements into scalable data models and high-impact dashboards. Experienced in optimizing performance, and ensuring data quality through comprehensive ETL testing, data validation, and reconciliation processes. Working knowledge of Power BI for reporting and visualization, enabling data-driven decision-making across stakeholders. Recognized for strong ownership, effective stakeholder collaboration, and delivering trusted data products that support operational monitoring, regulatory compliance, and data-driven decision-making.

Skills & Expertise (23)

Snowflake Advanced

8.5/10

Years Exp

DBT Advanced

8.5/10

Years Exp

Looker Advanced

8.0/10

Years Exp

Git Advanced

8.0/10

Years Exp

Advanced SQL Advanced

8.0/10

Years Exp

GitHub Advanced

7.5/10

Years Exp

AWS S3 Advanced

7.5/10

Years Exp

REST APIs Intermediate

7.0/10

Years Exp

Airflow Intermediate

7.0/10

Years Exp

Power BI Intermediate

7.0/10

Years Exp

Google Cloud Platform Intermediate

7.0/10

Years Exp

Jenkins Intermediate

6.5/10

Years Exp

Streams & Tasks CDC LookML Bitbucket Reconciliation Monitoring Alerting Jira Confluence Agile Scrum

Work Experience

Senior Data Engineer

Amantya Technologies Pvt Ltd (Tide.co)

Dec 2023 - Jun 2026

Own and develop DBT models on Snowflake to support fraud monitoring, investigations, and regulatory reporting. Developed and maintained scalable ETL pipelines using DBT and Snowflake for fraud analytics and regulatory reporting. Built cloud-based analytics solutions on Snowflake to support large-scale business reporting and operational monitoring. Designed and implemented DBT models including staging, intermediate, and mart layers following analytics engineering best practices. Performed ETL testing, source-to-target validation, and data reconciliation to ensure high data quality and accuracy. Optimized Snowflake SQL queries and DBT transformations for improved performance and cost efficiency. Worked extensively with cloud-based data warehouse architecture and data pipeline orchestration. Developed reporting datasets and dashboards using Looker and Power BI for business stakeholders. Collaborated with cross-functional teams including Fraud, Risk, Compliance, and Data Engineering teams in Agile environments.

Data Engineer

ATOS (NCORE Technology Pvt Ltd) (Bayer AG)

Jun 2022 - Nov 2023

Worked on data engineering and analytics solutions supporting large-scale enterprise systems. Developed and validated data pipelines and transformations across Snowflake. Partnered with data engineering teams to design dimensional models, star schemas, and fact tables aligned with analytics use cases. Built executive and operational dashboards for sales, finance, customer, and product analytics with drill-down and cross-filter capabilities. Translated complex business requirements into scalable analytics solutions and intuitive data visualizations for technical and non-technical stakeholders. Wrote complex SQL queries to support analytics, reconciliation, and reporting needs. Collaborated with business and technical teams to deliver reliable data solutions. Followed Agile delivery practices and maintained technical documentation.

Data Engineer

Cognizant (Enterprise Soft labs Pvt Ltd) (EVICO2F1)

Sep 2021 - May 2022

Designed and validated analytics-ready datasets during large-scale data migration to Snowflake. Built SQL-based transformation and validation logic to ensure data correctness across all layers. Worked closely with stakeholders and development teams to understand business rules and reporting needs. Ensured source-to-target consistency and business rule compliance. Actively used XRAY-Jira for tracking issues and delivery.

Data Engineer

ASICS Technologies Pvt Ltd (Kaiser Permanente)

Jun 2018 - Aug 2021

Worked on data-centric applications involving ETL workflows, data validation, and reporting. Developed SQL logic for validating Fact and Dimension tables. Supported data testing, reconciliation, and defect resolution. Gained strong exposure to data quality, STLC, and Agile delivery.