Iral Dsouza

Architected and implemented a scalable Snowflake-based data warehouse, improving data retrieval performance by 40% and enabling reliable access for 50+ business users. Automated end-to-end ETL pipelines by developing modular Python components, reducing total processing time by 30% and increasing system maintainability. Optimized complex SQL workloads, delivering a 25% reduction in report generation time and significantly improving analytical efficiency for sales and business teams.

Senior Data Engineer at Caterpillar (2024-07 – Present)

• Architected and implemented a scalable Snowflake-based data warehouse, improving data retrieval performance by 40% and enabling reliable access for 50+ business users.
• Automated end-to-end ETL pipelines by developing modular Python components, reducing total processing time by 30% and increasing system maintainability.
• Optimized complex SQL workloads, delivering a 25% reduction in report generation time and significantly improving analytical efficiency for sales and business teams.
• Demonstrated rapid adaptability to new data platforms, tools, and technologies, driving measurable cost savings and improving overall data infrastructure efficiency.
• Designed and deployed a production-grade Dagster orchestration pipeline executing weekly workloads and delivering validated datasets powering 80+ BI dashboards.

Data Engineer at Mercedes Benz Research And Development India (2021-02 – 2024-07)

• Orchestrated and optimized complex ETL workflows using Azure Databricks (PySpark, SQL) integrated with Azure Data Factory, achieving a 40% reduction in processing time and a 30% improvement in pipeline efficiency.
• Built and deployed an automation application to classify and assess ECU data points for legal risk, reducing manual compliance review effort by 90% and accelerating production workflows.
• Developed and maintained 20+ Azure Databricks notebooks to transform, standardize, and clean large-scale datasets, ensuring strict data governance and alignment with business requirements.
• Designed and delivered interactive analytics-ready Power BI dashboards for 50+ enterprise stakeholders to enable risk-aware, data-driven decision-making.
• Conducted rigorous root cause analysis across internal and cloud-native datasets, resolving critical data quality issues and implementing robust data observability frameworks.
• Led data engineering initiatives and mentored junior team members collaborating cross-functionally to translate complex business metrics into technical delivery plans and architectural specifications.

Bachelors of Computer Science And Engineering in Computer Science And Engineering – Malnad College Of Engineering (2021)