Prisma API Developer (.net)

Publicis Groupe•Chicago, IL

24d

About The Position

Publicis Re:Sources is the backbone of Publicis Groupe, the world's most valuable agency group. We are the only full-service, end-to-end shared service organization in the industry, enabling Groupe agencies to do what they do best: innovate and transform for their clients. Formed in 1998 as a small team to service a few Publicis Groupe firms, Publicis Finish Re:Sources has grown to 6,200+ employees globally. We provide technology solutions and business services including finance, accounting, legal, benefits, procurement, tax, real estate, treasury and risk management. We continually transform to keep pace with our ever-changing communications industry and thrive on a spirit of innovation felt around the globe. Learn more about Publicis Re:Sources and the Publicis Groupe agencies we support at http://www.publicisresources.com . The Publicis Re:Sources Guiding Principles define who we are and what we stand for. They reflect the mindset and behaviors that shape how we work, how we support one another, and how we drive progress together. People First, Driving Success Together Problem Solving Mindset Respect Each Other Partner and Collaborate as One Team Commit to Quality and Standards Innovate and Embrace the Future Visa sponsorship is not available for this role including H1B, OPT EAD etc. Overview We are seeking a highly skilled Full Stack .NET Developer with strong experience in Microsoft Azure and SQL Server to design, develop, and maintain scalable web applications. The ideal candidate will have expertise in both front-end and back-end development, cloud deployment, and database management.

Requirements

Minimum experience 6+ yrs
Good knowledge of MS SQL Server Database
Working knowledge of Indexes
Query Optimization Strategies/Approaches
Deep Knowledge of Data Management
Skilled at optimizing large, complicated SQL statements
Good knowledge of table partitioning and replication
Good knowledge of SQL datatypes, Stored Procedures, Functions, Cursors and Triggers including Loops
Experience working within specific domains such as finance, HR, or analytics, with the ability to assess and navigate complex data ecosystems.
Requires hands-on development experience on React, AngularJS, and NodeJS
Proficiency in ETL processes using tools like SSIS, Azure Data Factory, or custom-built pipelines, especially in SQL-heavy environments.
Strong experience in performance tuning and monitoring using tools such as SQL Profiler, Execution Plans, and Indexing strategies to ensure efficient query execution.
Familiarity with Azure DevOps, GitHub Actions, or Jenkins for integrating development workflows and managing deployments.

Responsibilities

Develop and maintain web applications using .NET Framework and .NET Core , including Web APIs .
Design and implement SQL Server databases , ensuring efficient schema design and optimization.
Write and maintain SQL queries , stored procedures , functions , cursors , and triggers , including handling loops and complex logic.
Work with SQL data types and ensure data integrity and performance.
Build and consume REST APIs with a strong understanding of data structures and application architecture.
Collaborate on front-end development using React , AngularJS , and Node.js for dynamic and responsive user interfaces.
Apply in-depth knowledge of the Web Application Life Cycle to deliver robust and scalable solutions.
Deploy and manage applications on Azure Stack , including understanding deployment procedures and cloud best practices.
Perform debugging , troubleshoot issues, and provide analytical solutions to complex problems.
Ensure adherence to design patterns and participate in code reviews to maintain high-quality standards.
Analyze client requirements, propose ideal technical solutions, and contribute to architectural decisions.
Work closely with cross-functional teams to ensure timely delivery and alignment with business objectives.