Power Platform Developer

Sonata Software; Bengaluru; On-site; INR 1,200,000 - 2,200,000; Full time

Job summary

Sonata Software is seeking a seasoned Power Platform Architect to design end-to-end Power Platform solutions. You will define architecture, data models, integration, security, and deployment strategies, evaluating Canvas vs Model-Driven Apps and ensuring governance and enterprise alignment.

You will lead hands-on development across Canvas Apps, Model-Driven Apps, Power Automate, and Dataverse, optimize performance, and mentor developers while collaborating with stakeholders and project teams.

Qualifications

• Strong practical experience in Microsoft Power Automate cloud flows.
• Experience with Microsoft Dataverse data modeling.
• Proficiency in Power Fx and application logic.
• Experience with AI Builder integration with Power Platform.

Responsibilities

• Design end-to-end Power Platform solutions based on requirements.
• Define architectures, data models, and deployment strategies.
• Lead architecture reviews and mentor developers.
• Develop Canvas and Model-Driven Apps; optimize performance.
• Integrate with SQL Server and external systems.

Skills

Power Apps Development

Power Automate

Canvas App

Model Driven App

SQL

Dataverse

Tools

Copilot

SharePoint

Job description

Primary Skills: Power Apps Development, Power Automate, Canvas App, Model Driven App, SQL, Dataverse.

Secondary skills: Copilot, Share point and any programming language.

Notice Period: Immediate

A. Solution Architecture and Technical Design

• Design end-to-end Power Platform solutions based on business and technical requirements.
• Define application architecture, data models, integration patterns, security, and deployment strategies.
• Evaluate Canvas Apps versus Model-Driven Apps and recommend the appropriate approach.
• Design scalable solutions using Dataverse, SQL Server, and other enterprise data sources.
• Establish reusable components, development standards, and architectural best practices.
• Identify technical risks, dependencies, performance bottlenecks, and opportunities for optimization.
• Ensure solutions align with enterprise architecture, security, and governance standards.

B. Hands-on Power Apps Development

• Design and develop Canvas Apps using Power Fx, responsive layouts, reusable components, and advanced controls.
• Build Model-Driven Apps using Dataverse tables, forms, views, dashboards, business rules, and business process flows.
• Implement application logic, validations, navigation, and role-based experiences.
• Optimize application performance, delegation, data retrieval, and user experience.
• Troubleshoot complex application issues and provide technical guidance to developers.
• Build proof of concepts and technical prototypes to validate architecture decisions.

C. Power Automate and Workflow Automation

• Design and develop cloud flows for business process automation and system integration.
• Implement automated, instant, and scheduled flows, approvals, notifications, and multi-step workflows.
• Integrate Power Automate with Power Apps, Dataverse, SQL Server, SharePoint, Microsoft 365, and external systems.
• Implement reusable automation patterns, child flows, and appropriate error-handling mechanisms.
• Troubleshoot flow failures, connection issues, performance problems, and integration errors.
• Define best practices for flow design, reliability, maintainability, and operational support.

D. Dataverse Architecture and Data Modeling

• Design Dataverse data models, tables, columns, relationships, and business rules.
• Define appropriate security roles, teams, business units, and record‑level access.
• Optimize data structures and relationships for performance and maintainability.
• Implement auditing, data validation, and appropriate data management practices.
• Design integration patterns between Dataverse, SQL Server, and other enterprise systems.
• Evaluate data storage and licensing implications when selecting architectural approaches.

E. AI Builder and AI‑powered Solutions

• Design and implement solutions using Microsoft AI Builder capabilities.
• Evaluate suitable AI Builder models for document processing, information extraction, classification, and prediction use cases.
• Integrate AI Builder with Power Apps, Power Automate, and Dataverse.
• Design automated document processing and data extraction workflows.
• Evaluate model accuracy, validation requirements, exception handling, and human review processes.
• Assess AI feasibility, consumption considerations, and expected business value.

F. SQL Server and Enterprise Integration

• Design integrations between Power Platform applications and SQL Server.
• Work with tables, views, stored procedures, queries, and relational data models.
• Optimize SQL queries and data access patterns for application performance.
• Understand connector requirements, authentication, permissions, and gateway considerations where applicable.
• Design secure and maintainable integration patterns between Power Platform and enterprise systems.
• Troubleshoot data connectivity, performance, and integration issues.

G. Microsoft Copilot Studio - Added Advantage

• Design and develop AI‑powered agents using Microsoft Copilot Studio.
• Configure knowledge sources, topics, actions, and generative answers.
• Integrate agents with Power Automate, Dataverse, SharePoint, and enterprise applications.
• Evaluate agent use cases and identify opportunities for AI‑led business process automation.
• Apply appropriate security, data‑access, testing, and responsible AI practices.

H. ALM, Governance, and DevOps

• Establish application lifecycle management practices across development, test, and production environments.
• Design solution packaging and deployment strategies using managed and unmanaged solutions.
• Configure environment variables and connection references.
• Define development standards, version control practices, and CI/CD approaches using Azure DevOps or GitHub where appropriate.
• Establish governance practices covering environments, connectors, DLP policies, security, and monitoring.
• Guide teams on release management, testing, documentation, and production readiness.

I. Technical Leadership and Stakeholder Management

• Engage with business stakeholders to understand requirements and translate them into technical solutions.
• Lead architecture reviews, design discussions, and technical decision‑making.
• Mentor developers and conduct design and code reviews.
• Work with project managers, business analysts, QA teams, and enterprise architects.
• Support effort estimation, technical feasibility assessments, and delivery planning.
• Communicate architectural decisions, risks, and recommendations clearly to technical and non‑technical stakeholders.

3. Mandatory Technical Skills

Candidates must demonstrate strong practical experience in:

• Microsoft Power Automate cloud flows.
• Microsoft Dataverse architecture and data modeling.
• Power Fx and application logic.
• AI Builder and its integration with Power Platform.
• SQL Server, relational data modeling, and query optimization.
• Power Platform solutions, ALM, and environment management.
• Security, access control, integrations, troubleshooting, and performance optimization.
• End-to-end solution architecture and hands‑on implementation.

4. Good‑to‑Have Skills

• Microsoft Copilot Studio and AI agent development.
• Azure services, Azure Functions, and Azure Logic Apps.
• REST APIs, custom connectors, and Microsoft Graph API.
• Power Platform CLI and PowerShell.
• Azure DevOps or GitHub‑based CI/CD.
• Power Pages and Power Apps Component Framework (PCF).
• Generative AI, Azure AI Foundry, and enterprise AI integration patterns.
• Enterprise Power Platform governance and Center of Excellence practices.

5. Experience and Qualifications

• 8-12 years of overall software development or solution delivery experience preferred.
• Strong experience designing and implementing enterprise Power Platform solutions.
• Proven experience across Canvas Apps, Model-Driven Apps, Power Automate, and Dataverse.
• Practical experience integrating SQL Server and implementing AI Builder use cases.
• Demonstrated ability to make architecture decisions and implement them hands‑on.
• Experience leading technical teams, conducting design reviews, and mentoring developers.

Strong communication, problem‑solving, and stakeholder‑management skills.