"The demand for seasoned .NET experts who can bridge data pipelines, cloud services, and modern UI frameworks is soaring as government agencies modernize legacy systems. This role offers a unique chance to shape enterprise\u2011grade applications while working in a hybrid environment with cutting\u2011edge Azure and SharePoint technologies. If you thrive on Agile delivery and complex data integration, this position could be a career\u2011defining move.\n\n# Job Summary\nWe are seeking a .NET Subject Matter Expert to lead the design, development, and maintenance of web\u2011based solutions for the DC Department of Employment Services. The role blends front\u2011end and back\u2011end development, ETL data workflows, and cloud/SharePoint integration within an Agile Scrum framework.\n\n# Top 3 Critical Skills Table\n| Skill | Why it's critical | Mastery Level |\n|-------|-------------------|--------------|\n| .NET Framework (ASP.NET MVC 5, C#) | Core platform for building enterprise web applications that meet agency standards. | Senior |\n| ETL Development | Enables reliable data ingestion, transformation, and reporting across large, complex datasets. | Senior |\n| Azure & SharePoint | Provides the cloud infrastructure and collaboration layer essential for modernizing legacy systems. | Mid |\n\n# Interview Preparation\n1. **Describe how you would design an ETL pipeline that extracts data from on\u2011prem SQL Server, transforms it, and loads it into Azure SQL Database.**\n *What the interviewer is looking for*: Understanding of data movement tools (SSIS, Azure Data Factory), performance tuning, and error handling.\n2. **Explain the differences between ASP.NET MVC 5 and ASP.NET Core and when you would choose one over the other.**\n *What the interviewer is looking for*: Knowledge of framework evolution, compatibility concerns, and deployment considerations.\n3. **How do you implement secure authentication and authorization for a SharePoint\u2011integrated web app hosted in Azure?**\n *What the interviewer is looking for*: Familiarity with Azure AD, OAuth, SharePoint permissions, and best\u2011practice security patterns.\n4. **Walk us through your approach to writing efficient stored procedures for time\u2011sensitive reporting.**\n *What the interviewer is looking for*: SQL performance optimization, indexing strategies, and handling concurrency.\n5. **What Agile ceremonies do you consider essential for a high\u2011performing development team, and how do you ensure they add value?**\n *What the interviewer is looking for*: Insight into Scrum rituals, continuous improvement, and stakeholder communication.\n\n# Resume Optimization\n- .NET Framework\n- ASP.NET MVC 5\n- C#\n- VB.Net\n- JavaScript\n- ETL Development\n- Azure\n- SharePoint\n- SQL Server\n- Agile/Scrum\n\n# Application Strategy\nWhen reaching out to the recruiter, send a concise email that opens with a friendly greeting, attaches your updated resume, and clearly highlights your top relevant skills. Make sure to mention related skills you possess, such as .NET development, ETL design, and Azure/SharePoint integration, and reference specific projects where you applied these technologies to solve business problems.\n\n# Career Roadmap\n| Current Role | Typical Experience | Core Focus | Next Position |\n|--------------|--------------------|------------|---------------|\n| .NET SME | 3\u20115 years .NET, ETL, Azure | System design, integration, and delivery | Senior .NET Architect |\n| Senior .NET Architect | 6\u20119 years leading large projects | Enterprise architecture, cloud strategy | IT Solutions Director |\n| IT Solutions Director | 10+ years cross\u2011functional leadership | Strategic IT planning, portfolio management | Chief Technology Officer (CTO) |\n"