R

RAJARAM

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.

Work style

Remote

Contact details — on requestProof of Work — on request

Experience

S

Azure Data Engineer

Synthima Technologies Pvt Ltd · Aug 2023 – Aug 2026

Not yet confirmed
  • 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.
P

Azure Data Engineer

Pentagram Infotech Pvt Ltd · Jan 2022 – Jun 2023

Not yet confirmed
  • 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.
T

Azure Data Engineer

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

Not yet confirmed
  • 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.
A

SQL DEVELOPER

Alicanto Consultants Pvt Ltd · Jun 2018 – Aug 2019

Not yet confirmed
  • 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.

Skills 0 proven through work

Also works with

Mentoring and Peer CoachingProfessional Skill DevelopmentTransparent CommunicationTaking OwnershipTeamworkRapid LearningSLA AdherenceLow-Latency System OptimizationApplication Performance OptimizationAgile MethodologyStakeholder ManagementCustomer Relationship BuildingData MonitoringKPI AnalysisError HandlingData Discrepancy InvestigationData Repetition PreventionData PreprocessingData Integrity ManagementData ValidationData Merge TechniquesData Pipeline ParameterizationData WatermarkingData LoadingIncremental Data ProcessingCross-Departmental CoordinationTask AutomationAzure Logic Apps UsageAzure Synapse Analytics UsageProcessing Pipeline OptimizationTable Partitioning ImplementationDatabase Index StrategySpark UI UsageTechnical TroubleshootingData ShufflingDatabase Query OptimizationData OptimizationTabular Data Cleaning & ValidationJSON Data HandlingWorking with CSV FilesAzure Data Lake UsageData TransformationSecure Data HandlingAttribute-Based Access ControlData GovernanceData CatalogingReal-Time Data IntegrationAzure Event Grid IntegrationDelta Live Tables UsageLarge Dataset HandlingMedallion Architecture DesignAzure Data Factory Pipeline DevelopmentETL Pipeline DevelopmentMicrosoft Fabric UsagePython DevelopmentPower BISQL ProgrammingPySparkDatabricks UsageData Engineering

Proof of Work

Proof of Work

RAJARAM shares this with people who ask. You'll hear back either way.

Education

Bachelor, Computer Applications

S.V. University · 2016 — 2019

Contact details

Contact details

RAJARAM shares this with people who ask. You'll hear back either way.

Ask about this candidate

AI responses may contain errors. Proof status and source information are provided by Proof of Skill.

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