Produces scalable, resilient, Cloud-based systems design using multiple methodologies -- data warehousing, data visualization, and data integration. Simplifies Online Transaction Processing (OLTP) using relational database technologies (Oracle SQL and PL/SQL) and Snowflake. Constructs and compares models using data modelling tools and data ingestion tool sets, including Apache NiFi and Kafka. Sets up reliable infrastructure to perform data-related tasks, particularly with Kafka, to stream analytics. Writes SQL queries in Oracle/Snowflake and performs performance optimization for large datasets. Develops ETL/ELT pipelines to move data to and from Snowflake data store using Python, AWS and Snowflake. Works closely with the business units and architects to gather requirements, plan, design, develop and deploy on-premises and cloud-based applications. Designs, develops and modifies software systems to predict and measure outcomes and consequences of design, using scientific analysis and mathematical models.