Preshanth Dk

Data Engineering and Analytics Professional with 6+ years of experience designing, developing, and maintaining ETL/ELT pipelines, cloud data warehouses, data lakes, and enterprise analytics solutions across financial services, healthcare, and energy industries. Strong proficiency in SQL, Azure Data Factory, SSIS, Azure Databricks, Snowflake, and Power BI, with experience in data modeling, pipeline optimization, automated testing, and production support. Experienced in cloud-based machine learning applications involving energy demand forecasting and sentiment analysis, along with DevOps practices, CI/CD, data governance, and monitoring.

Skilled in collaborating with business and technical stakeholders to translate requirements into secure, scalable, maintainable solutions that improve data quality, operational efficiency, and data-driven decision-making.

Data Engineer - Power Factors - Brossard, QC

(2025-12)

• Designed and maintained enterprise ETL/ELT pipelines using Azure Data Factory, Azure Data Lake Storage, SQL Server, and PostgreSQL, integrating data sources to support scalable cloud analytics and downstream reporting.
• Developed and optimized SQL transformations and relational database schemas, improving data consistency, query efficiency, and maintainability of analytical datasets.
• Supported machine learning and AI use cases using Azure Databricks, including energy demand forecasting, sentiment analysis, and large-scale analytical processing.
• Supported Snowflake data replication, recovery, and warehouse operations to strengthen data availability, reliability, and operational continuity.
• Implemented data lineage, metadata management, and impact analysis using Microsoft Purview and Azure Data Factory, improving governance, traceability, and visibility into data dependencies.
• Automated recurring SSIS workflows through SQL Server Agent and supported production monitoring, troubleshooting, and reliable data delivery.
• Supported controlled deployment and release processes using Azure DevOps, Git, and validation gates to maintain solution quality and traceability.

Data Analyst - Fiera Capital - Toronto, ON

(2024-08 - 2025-12)

• Developed and maintained cloud-based data integration and ETL/ELT workflows using Azure Data Factory, SSIS, and Azure Functions to support enterprise financial-services analytics.
• Built reusable Snowflake User-Defined Functions to standardize business calculations, simplify SQL transformation logic, and improve consistency across reporting solutions.
• Integrated structured and semi-structured data, including JSON and XML, into enterprise data warehouse and analytical reporting environments.
• Performed exploratory data analysis, profiling, and performance investigations using Azure Databricks to identify anomalies, validate datasets, and strengthen analytical reliability.
• Developed unit, integration, and regression tests for SSIS packages to validate transformations, detect inconsistencies, and improve data quality before downstream reporting.
• Collaborated with technical teams to identify SQL performance bottlenecks, optimize database processing, and support maintainable analytical solutions.
• Supported application and pipeline monitoring using Azure Monitor, Azure DevOps, and database logging, while maintaining auditing, data lineage, and role-based access controls.

Power BI and Azure Engineer - Apollo Hospitals - Bengaluru, IN

(2021-02 - 2023-07)

• Developed automated ETL pipelines using Azure Data Factory, SSIS, and SQL to integrate healthcare operational data from enterprise applications into reporting environments.
• Created SQL transformations for data extraction, cleansing, enrichment, and validation, supporting accurate datasets for operational and finance-related analysis.
• Developed custom data connectors using Azure Databricks to support integration between enterprise source systems and centralized analytical platforms.
• Applied partitioning and parallel processing techniques in Azure Data Factory to improve efficiency and reliability of recurring data workloads.
• Performed integration testing, deduplication, and data quality validation to reduce inconsistencies and support dependable reporting.
• Supported secure enterprise data access through database permissions, role-based controls, and governance practices.

Associate BI Developer - HSBC Bank - Pune, IN

(2019-06 - 2021-02)

• Developed and maintained SQL Server and SSIS-based ETL workflows to extract, transform, and prepare enterprise banking data for financial-services analytics and reporting.
• Performed data profiling, cleansing, and validation to identify inconsistencies and improve reliability of downstream datasets.
• Optimized SQL scripts and SSIS configurations to support efficient execution and maintainability of recurring data integration workflows.
• Developed database monitoring queries to analyze performance, resource utilization, and capacity requirements.
• Supported reporting quality assurance, secure database access, and data integrity controls in an enterprise banking environment.

Pg certificate - Big Data Solution Architecture - Conestoga College

Pg certificate - Applied Artificial intelligence and machine learning - Conestoga College