Looks like you have JavaScript disabled. For the full Twine experience, you will need to re-enable it.

Hi, I’m a Data Engineer with about four years of experience designing scalable data pipelines, optimizing data warehousing, and delivering real-time insights on cloud-native platforms. I specialize in ETL framework development, dimensional modeling, and building efficient reporting workflows using Azure Data Factory, Snowflake, Power BI, Python, and SQL. I’ve shipped 20+ ETL pipelines, designed dimensional models to support 15+ executive dashboards, reduced Power BI load times, automated large-scale data ingestion, and helped improve data quality and governance. I enjoy collaborating with analysts and product teams to translate business metrics into robust data solutions and operationalize data workflows with automation and monitoring.…Hi, I’m a Data Engineer with about four years of experience designing scalable data pipelines, optimizing data warehousing, and delivering real-time insights on cloud-native platforms. I specialize in ETL framework development, dimensional modeling, and building efficient reporting workflows using Azure Data Factory, Snowflake, Power BI, Python, and SQL. I’ve shipped 20+ ETL pipelines, designed dimensional models to support 15+ executive dashboards, reduced Power BI load times, automated large-scale data ingestion, and helped improve data quality and governance. I enjoy collaborating with analysts and product teams to translate business metrics into robust data solutions and operationalize data workflows with automation and monitoring.

Matta Om Pranay Reddy

Data Scientist, Data Analyst, Full Stack Developer, +4





Hi, I’m a Data Engineer with about four years of experience designing scalable data pipelines, optimizing data warehousing, and delivering real-time insights on cloud-native platforms. I specialize in ETL framework development, dimensional modeling, and building efficient reporting workflows using Azure Data Factory, Snowflake, Power BI, Python, and SQL. I’ve shipped 20+ ETL pipelines, designed dimensional models to support 15+ executive dashboards, reduced Power BI load times, automated large-scale data ingestion, and helped improve data quality and governance. I enjoy collaborating with analysts and product teams to translate business metrics into robust data solutions and operationalize data workflows with automation and monitoring.…Hi, I’m a Data Engineer with about four years of experience designing scalable data pipelines, optimizing data warehousing, and delivering real-time insights on cloud-native platforms. I specialize in ETL framework development, dimensional modeling, and building efficient reporting workflows using Azure Data Factory, Snowflake, Power BI, Python, and SQL. I’ve shipped 20+ ETL pipelines, designed dimensional models to support 15+ executive dashboards, reduced Power BI load times, automated large-scale data ingestion, and helped improve data quality and governance. I enjoy collaborating with analysts and product teams to translate business metrics into robust data solutions and operationalize data workflows with automation and monitoring.

Available to hire

Hi, I’m a Data Engineer with about four years of experience designing scalable data pipelines, optimizing data warehousing, and delivering real-time insights on cloud-native platforms. I specialize in ETL framework development, dimensional modeling, and building efficient reporting workflows using Azure Data Factory, Snowflake, Power BI, Python, and SQL.

I’ve shipped 20+ ETL pipelines, designed dimensional models to support 15+ executive dashboards, reduced Power BI load times, automated large-scale data ingestion, and helped improve data quality and governance. I enjoy collaborating with analysts and product teams to translate business metrics into robust data solutions and operationalize data workflows with automation and monitoring.

Skills

Experience Level

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Intermediate

Intermediate

Intermediate

Language

English

Fluent

Work Experience

Data Engineer at Tetra Tech

January 1, 2024 - Present

Architected and maintained end-to-end ETL pipelines in Azure Data Factory and Databricks to ingest, transform and curate terabytes of structured/unstructured enterprise data for Power BI dashboards. Constructed dimensional data models in Azure Synapse SQL and Snowflake to support self-service BI and reporting, aligning with Kimball methodology and stakeholder KPIs. Optimized SQL Server and Snowflake performance by partitioning and indexing large datasets, reducing query latency by 60%. Engineered automated BI datasets in Power BI and Tableau integrating data lineage and version controls, enabling real-time insights for business users. Collaborated with business analysts and product leads to translate metrics and business logic into technical requirements, producing entity relationships diagrams and transformation specs. Implemented Airflow orchestration to schedule and monitor Python and PySpark jobs, achieving 99.9% pipeline reliability and integrated alerting via Slack and email. Har

Data Engineer (Internship) at Kinaxis

May 1, 2023 - August 31, 2023

Built and tested modular ETL workflows using Talend to extract data from ERP systems and load into Redshift/Snowflake for analytics consumption. Designed interactive Power BI reports on operational KPIs, creating calculated measures, drill-throughs, and row-level security for cross-functional stakeholders. Automated data ingestion and transformation steps with Python scripts and SQL procedures scheduled via Airflow, reducing manual workload by ~40%. Tuned performance of Redshift queries and optimized table structures (sort keys, compression) leading to 30% faster report generation. Applied data profiling tools to identify and clean duplicate or inconsistent records; implemented cleansing logic in the ETL layer. Collaborated with senior data engineers and business teams to clarify reporting requirements, define data schema and data validation rules. Authored technical documentation and led peer knowledge-sharing sessions on Talend workflows and Power BI development.

Associate Data Developer at Infosys (Client: KP-Data & Analytics, India)

June 1, 2021 - July 31, 2022

Developed scalable ETL jobs using Informatica PowerCenter integrating data from Oracle, SQL Server and flat-file sources into Enterprise Data Warehouse. Created star schema and snowflake models in Oracle and Teradata to support BI reporting and analytics for telecommunications clients. Programmed complex stored procedures, views and SQL tuning to streamline monthly data aggregation processes in Teradata, reducing run time by 45%. Implemented incremental load patterns (CDC) and partition pruning techniques to efficiently process daily data feeds. Integrated Pentaho Data Integration (PDI) components to orchestrate transformations and automation pipelines across workflows. Generated dashboards and business data extracts in Tableau and Cognos, ensuring alignment with user requirements and KPIs. Collaborated with data governance team to establish data quality metrics and monitored ETL job success/failure rates via SLAs. Conducted UAT, created reusable test scripts and documentation, and sup

Data Associate (Internship) at Dell Technologies

January 1, 2021 - May 31, 2021

Assisted in the design and implementation of Python-based ETL pipelines to ingest web log and CRM data into Hadoop HDFS and Hive tables. Constructed Hive SQL queries and HiveQL scripts to prepare data marts for BI dashboards supporting sales reporting. Participated in building Power BI dashboards on sales performance and lead conversion, configuring visuals and filters to highlight trends. Supported the ingestion of semi-structured JSON data from APIs using Python and Spark (in AWS EMR) into Parquet format. Validated data consistency and resolved schema drift issues by implementing schema registry and validation rules in Spark jobs. Documented pipeline architecture, transformation logic, and contributed to team knowledge base for reuse across future projects.

Associate Data Developer at Infosys (Client: KP-Data & Analytics)

June 1, 2021 - July 1, 2022

Developed scalable ETL jobs using Informatica PowerCenter, integrating data from Oracle, SQL Server, and flat-file sources into the Enterprise Data Warehouse. Created star and snowflake schemas in Oracle and Teradata to support BI reporting for telecommunications clients. Implemented incremental loads (CDC) and partition pruning to efficiently process daily data feeds. Integrated Pentaho Data Integration (PDI) components to orchestrate transformations, and generated dashboards in Tableau and Cognos. Collaborated with data governance to monitor data quality metrics, conducted UAT, and supported production rollouts.

Data Associate at Dell Technologies

January 1, 2021 - May 1, 2021

Assisted in Python-based ETL pipelines to ingest web log and CRM data into Hadoop HDFS and Hive; built Power BI dashboards; ingested JSON data from APIs into Parquet; addressed schema drift via registry and validation in Spark jobs.