Lead Data Engineer

Role : Lead Data EngineerLocation : Maclean VA (100% Onsite)ContractNOTE : NO GCData Platform, Cloud Migration, ETL/ELTSecondary : AI/ML, PythonRole SummaryLead Data Engineer responsible for designing, migrating, and optimizing enterprise-scale data platforms on Microsoft Azure, with strong hands-on ownership of ETL/ELT pipelines, cloud data warehousing, and data integration across heterogeneous sources.Key ResponsibilitiesLead data migration initiatives to Azure, including on prem to cloud and legacy ETL modernization.Design, build, and maintain scalable ETL/ELT pipelines using Azure Data Factory, Databricks (PySpark), and Informatica (PowerCenter / IICS).Implement end to end data ingestion, transformation, and loading into Azure Data Lake Gen2, Azure SQL, Azure Synapse, and Snowflake.Migrate and refactor existing ETL workflows (Informatica / SSIS) to cloud native Azure architectures.Optimize data pipelines for performance, reliability, and cost efficiency.Ensure data quality, governance, security, and compliance during migration and ongoing operations.Collaborate with architects, business stakeholders, and downstream analytics teams.Required SkillsAzure Migration: Hands on experience with Azure Data Lake (Gen1/Gen2), Azure Data Factory, Azure Databricks, Azure Synapse, Azure SQLETL/ELT: Strong expertise in Informatica PowerCenter, Informatica IICS, ETL design, CDC, SCDs, and batch/stream processingProgramming: Python, PySpark, SQL, PL/SQLDatabases & Warehousing: Oracle, SQL Server,Cloud DevOps: Azure DevOps CI/CD pipelines, Git-based version controlData Modeling: Star schemas, dimensional modelingNice to HaveAI/ML experiencePower BI / semantic modelling exposure