venkat - Lead Data Engineer

Demonstrated experience with Snowflake.

Demonstrated experience with AWS.

Demonstrated experience with Python.

Demonstrated experience with SQL.

Architect enterprise data warehouse, data lake, lakehouse, and scalable cloud platform solutions supporting Sales, Finance, Commerce, Compensation, and recurring revenue analytics teams.. Lead large-scale data modernization and migration initiatives, overseeing Teradata/Oracle-to-Snowflake delivery, including target architecture, schema design, data marts, semantic layers, secure access, and migration of 600+ reports.. Design scalable batch and streaming ETL/ELT patterns using Snowflake, Amazon S3, SQL, Python, and Informatica with comprehensive data quality, reconciliation, and validation controls.. Model enterprise reporting layers using dimensional modeling, conformed dimensions, fact tables, star/snowflake schemas, data vault concepts, and reusable data marts for self-service analytics.. Integrate cloud data platforms with web and mobile applications through APIs, FastAPI services, secure retrieval layers, and backend integration patterns.. Implement data quality assurance and validation processes throughout ETL lifecycle; establish reconciliation frameworks, production monitoring, root cause analysis, and preventive controls reducing processing errors by 30%+.. Provide technical leadership, architecture guidance, stakeholder management, and mentoring across onsite/offshore Agile teams; translate business requirements into scalable solutions and govern CI/CD, code review, releases, secure coding, and cybersecurity standards.

Led data integration workstreams for Cisco goaling and account transfer platforms using Snowflake, Oracle, Informatica, and Teradata.. Designed centralized repositories, data validation frameworks, and quality assurance processes enabling planning analytics, scenario modeling, and sales operations insights.. Translated complex compensation and sales planning rules into reusable data pipeline components and scalable data models.

Delivered robust ETL pipelines with comprehensive data quality assurance, validation frameworks, SQL/PL-SQL optimization, and compensation reporting solutions for Fortune 500 technology and financial services clients.. Managed onsite/offshore Agile delivery, sprint planning, code reviews, deployment cycles, regression testing, and production support.. Optimized complex SQL and PL/SQL workloads, reducing batch processing runtimes by up to 50% in large-scale migration programs.

Developed Oracle SQL/PL-SQL logic and secure ETL support processes with data quality validation, and enterprise reporting solutions using Oracle XML Publisher and SAP BusinessObjects.. Supported production systems with debugging, SLA management, incident triage, and cross-team issue resolution.

Enhanced Oracle-based compensation systems with SQL development, ETL support, data quality validation, and production troubleshooting.