RAJARAM

+•• ••••• •••••••••••@•••••.com

6.2 yrs

As an Azure Data Engineer, I am driven by a curious ambition to continuously explore and implement innovative data solutions, always approaching challenges with diligence and determination. I take deep accountability for my work, guided by an empathetic understanding of project needs and an idealistic vision for creating robust, scalable architectures that adapt to evolving requirements.

  • Remote

Ask about RAJARAM

Skills

Claimed

Mentoring and Peer CoachingProfessional Skill DevelopmentTransparent CommunicationTaking OwnershipTeamworkRapid LearningSLA AdherenceLow-Latency System OptimizationApplication Performance OptimizationAgile MethodologyStakeholder ManagementCustomer Relationship Building

Proof of Experience

Azure Data Engineer

Synthima Technologies Pvt Ltd · Aug 2023 – Aug 2026

  • Designed and managed end-to-end ETL/ELT pipelines using Azure Data Factory to ingest healthcare data from NHS Digital systems, clinical applications, and external sources.
  • Built scalable ADLS Gen2 storage for structured, semi-structured, and unstructured healthcare datasets and Implemented Bronze, Silver, and Gold Medallion Architecture using Azure Databricks and Delta Lake.
  • Developed PySpark notebooks for large-scale cleansing, standardization, aggregation, complex joins, validation, and transformation.
  • Integrated SQL Server and legacy NHS systems into Azure Synapse Analytics with schema consistency, reconciliation, and query optimization.
  • Managed the migration of legacy on-premises SSIS packages to Azure Data Factory, converting package-level Control Flow and Data Flow logic into scalable, reusable ADF pipeline components.
  • Re-engineered SSIS-based ETL workloads by mapping Execute SQL, Lookup, Conditional Split, Derived Column, and file-processing logic to ADF activities and parameterized stored procedures.
  • Validated SSIS-to-ADF migration results through source-to-target reconciliation, record-count validation, data-quality checks, and parallel-run comparison before production cutover.
  • Implemented Auto Loader and DLT pipelines for incremental ingestion, declarative ETL, data-quality expectations, and reliable transformations.
  • Developed Microsoft Fabric pipelines for Lakehouse and Data Warehouse environments and integrated Snowflake for enterprise analytics.
  • Implemented Azure Event Hubs for real-time ingestion and Unity Catalog for centralized governance, access control, and metadata management.
  • Integrated curated data with Power BI and implemented datasets, DAX measures, dashboards, scheduled refreshes, and row-level security.
  • Implemented CI/CD using Azure DevOps and supported monitoring, troubleshooting, production releases, and stakeholder collaboration.

Azure Data Engineer

Pentagram Infotech Pvt Ltd · Jan 2022 – Jun 2023

  • Designed and developed scalable ADF ETL/ELT pipelines for clinical, patient, operational, laboratory, financial, and external healthcare data.
  • Built reusable ADF pipelines using Copy Activity, Lookup, ForEach, Stored Procedure, If Condition, parameterization, triggers, and dynamic datasets.
  • Implemented Azure Databricks and PySpark frameworks for cleansing, transformation, enrichment, aggregation, validation, exception handling, and incremental processing.
  • Designed Azure Synapse Analytics data warehouse solutions using optimized fact and dimension tables for enterprise reporting.
  • Migrated legacy SSIS packages to Azure Data Factory by redesigning Control Flow orchestration, dependencies, scheduling, and error-handling logic using ADF pipelines and activities.
  • Converted SSIS Data Flow transformations and source/target mappings into ADF Copy activities, Lookup, ForEach, Stored Procedure, and parameterized pipeline patterns for reusable ingestion.
  • Performed SSIS-to-ADF migration validation by reconciling row counts, business-rule outputs, transformation results, and exception records between legacy and Azure implementations.
  • Developed complex SQL Server queries, stored procedures, views, functions, and CTEs for extraction, transformation, validation, reconciliation, and business rules.
  • Implemented incremental and full-load strategies using watermarking, parameterization, and optimized data movement.
  • Developed Power BI dashboards and reports for operational, financial, resource utilization, and healthcare KPIs.
  • Configured Logic Apps for workflow notifications, pipeline alerts, data-quality notifications, and exception handling and Optimized ADF, Databricks, Synapse, and SQL workloads through partitioning, parallel processing, query tuning, efficient joins, and caching.

Azure Data Engineer

Trueblue IT Consulting Services Pvt Ltd · Dec 2020 – Jul 2021

  • Designed, developed, and maintained end-to-end ADF pipelines for insurance policy, claims, underwriting, and finance data.
  • Built Azure Databricks workflows for large-scale transformation and enrichment of insurance datasets.
  • Integrated SQL Server and enterprise applications into centralized reporting datasets with data validation and reconciliation.
  • Developed Databricks notebooks for cleansing, standardization, aggregation, and joins across policy, claims, premium, and exposure data.
  • Automated scheduled batch workflows using ADF triggers and parameterized pipelines.
  • Developed SQL Server queries, views, and stored procedures and supported Power BI datasets, semantic models, dashboards, scheduled refreshes, and RLS.
  • Monitored and troubleshot ADF pipelines, Databricks jobs, SQL queries, and Power BI refresh failures in production.

SQL DEVELOPER

Alicanto Consultants Pvt Ltd · Jun 2018 – Aug 2019

  • Designed and maintained SQL Server databases supporting subscriber, billing, network performance, and revenue analytics.
  • Developed and scheduled SSIS packages to extract, transform, and load data from OSS/BSS, CRM, and vendor sources.
  • Implemented data validation, cleansing, and reconciliation logic within SSIS.
  • Built and optimized T-SQL queries, views, and stored procedures for high-volume reporting and analytics.
  • Designed SSRS reports and Power BI dashboards for operational, billing, and management reporting.

Proof-of-Work

No completed sessions yet. Anything RAJARAM finishes shows up here with the evidence behind it.

Proof of Education

Bachelor, Computer Applications

S.V. University · 2016 — 2019

A Proof CV — one profile, kept current, with the proof attached. Back to the portal