The Role
Build repeatable ETL processes that import, transform, cleanse, and validate data from CSV files and APIs into SQL Server. Develop resilient C#/.NET services, Azure Functions, and console utilities integrating with platforms such as Salesforce. Implement asynchronous processing, authentication, retry logic, Entity Framework Core, LINQ, testing, and CI/CD pipelines. Develop React interfaces, maintain reporting datasets and KPI queries, and document data flows and quality issues.
Summary Generated by Built In
Data Import, ETL & SQL
- Design repeatable processes to import data from CSV files and external APIs into SQL Server tables, then transform and cleanse it into production tables.
- Write and maintain SQL stored procedures (SPs) for data migration and transformation, using parameters and variables so the same procedure can be reused across data sources, environments, or business units (LOBs).
- Ensure stored procedures and .NET import tools are safely re-runnable (idempotent) handling duplicates, missing data, and partial failures without corrupting data.
API & Third-Party Integrations
- Build and maintain .NET services that integrate with third-party APIs (e.g., Salesforce) for data enrichment and synchronization.
- Handle authentication flows (OAuth client credentials, Bearer tokens) and design request/response models that map cleanly to C# classes.
.NET Application Development
- Design and build .NET / C# applications — Azure Functions (isolated worker model) and console utilities — that call external APIs, process data in bulk, and write results to SQL Server.
- Use dependency injection, configuration binding (appsettings.json, User Secrets, Azure App Configuration, Key Vault), and structured logging as standard patterns across all new services.
- Implement asynchronous, concurrent processing (async/await, SemaphoreSlim-based bounded concurrency) to handle bulk data volumes efficiently without overwhelming downstream APIs.
- Build resilient HTTP client code: authentication (OAuth/Bearer tokens), retry logic with backoff for transient failures, and proper error handling so a single bad record does not break an entire batch run.
- Work with Entity Framework Core and LINQ queries for reading and writing application data in SQL Server.
- Write and maintain unit and integration tests for data-processing logic.
React – Front End
- Strong experience in React.js, JavaScript/TypeScript, and front-end best practices, with the ability to build responsive, scalable, and high-performance user interfaces.
- Develop and maintain web applications using React.js; build reusable UI components and front-end libraries for future use.
- Collaborate with backend developers to deliver high-quality, end-to-end solutions.
Data Quality, DevOps & Documentation
- Validate data accuracy after each import/migration run (row counts, key-field checks, spot-checks against source data).
- Use Git for version control (branching, pull requests) and Azure DevOps YAML pipelines for CI/CD (build, test, multi-environment deployment).
- Document data flows, mapping logic, and known data quality issues for the rest of the team.
Reporting & KPIs
- Build and maintain KPI queries/views and reporting datasets to support business and operational dashboards.
- Work with stakeholders to translate reporting requirements into reliable, well-documented SQL views or stored procedures.
Data Import, ETL & SQL
- Design repeatable processes to import data from CSV files and external APIs into SQL Server tables, then transform and cleanse it into production tables.
- Write and maintain SQL stored procedures (SPs) for data migration and transformation, using parameters and variables so the same procedure can be reused across data sources, environments, or business units (LOBs).
- Ensure stored procedures and .NET import tools are safely re-runnable (idempotent) handling duplicates, missing data, and partial failures without corrupting data.
API & Third-Party Integrations
- Build and maintain .NET services that integrate with third-party APIs (e.g., Salesforce) for data enrichment and synchronization.
- Handle authentication flows (OAuth client credentials, Bearer tokens) and design request/response models that map cleanly to C# classes.
.NET Application Development
- Design and build .NET / C# applications — Azure Functions (isolated worker model) and console utilities — that call external APIs, process data in bulk, and write results to SQL Server.
- Use dependency injection, configuration binding (appsettings.json, User Secrets, Azure App Configuration, Key Vault), and structured logging as standard patterns across all new services.
- Implement asynchronous, concurrent processing (async/await, SemaphoreSlim-based bounded concurrency) to handle bulk data volumes efficiently without overwhelming downstream APIs.
- Build resilient HTTP client code: authentication (OAuth/Bearer tokens), retry logic with backoff for transient failures, and proper error handling so a single bad record does not break an entire batch run.
- Work with Entity Framework Core and LINQ queries for reading and writing application data in SQL Server.
- Write and maintain unit and integration tests for data-processing logic.
React – Front End
- Strong experience in React.js, JavaScript/TypeScript, and front-end best practices, with the ability to build responsive, scalable, and high-performance user interfaces.
- Develop and maintain web applications using React.js; build reusable UI components and front-end libraries for future use.
- Collaborate with backend developers to deliver high-quality, end-to-end solutions.
Data Quality, DevOps & Documentation
- Validate data accuracy after each import/migration run (row counts, key-field checks, spot-checks against source data).
- Use Git for version control (branching, pull requests) and Azure DevOps YAML pipelines for CI/CD (build, test, multi-environment deployment).
- Document data flows, mapping logic, and known data quality issues for the rest of the team.
Reporting & KPIs
- Build and maintain KPI queries/views and reporting datasets to support business and operational dashboards.
- Work with stakeholders to translate reporting requirements into reliable, well-documented SQL views or stored procedures.
Data Import, ETL & SQL
- Design repeatable processes to import data from CSV files and external APIs into SQL Server tables, then transform and cleanse it into production tables.
- Write and maintain SQL stored procedures (SPs) for data migration and transformation, using parameters and variables so the same procedure can be reused across data sources, environments, or business units (LOBs).
- Ensure stored procedures and .NET import tools are safely re-runnable (idempotent) handling duplicates, missing data, and partial failures without corrupting data.
API & Third-Party Integrations
- Build and maintain .NET services that integrate with third-party APIs (e.g., Salesforce) for data enrichment and synchronization.
- Handle authentication flows (OAuth client credentials, Bearer tokens) and design request/response models that map cleanly to C# classes.
.NET Application Development
- Design and build .NET / C# applications — Azure Functions (isolated worker model) and console utilities — that call external APIs, process data in bulk, and write results to SQL Server.
- Use dependency injection, configuration binding (appsettings.json, User Secrets, Azure App Configuration, Key Vault), and structured logging as standard patterns across all new services.
- Implement asynchronous, concurrent processing (async/await, SemaphoreSlim-based bounded concurrency) to handle bulk data volumes efficiently without overwhelming downstream APIs.
- Build resilient HTTP client code: authentication (OAuth/Bearer tokens), retry logic with backoff for transient failures, and proper error handling so a single bad record does not break an entire batch run.
- Work with Entity Framework Core and LINQ queries for reading and writing application data in SQL Server.
- Write and maintain unit and integration tests for data-processing logic.
React – Front End
- Strong experience in React.js, JavaScript/TypeScript, and front-end best practices, with the ability to build responsive, scalable, and high-performance user interfaces.
- Develop and maintain web applications using React.js; build reusable UI components and front-end libraries for future use.
- Collaborate with backend developers to deliver high-quality, end-to-end solutions.
Data Quality, DevOps & Documentation
- Validate data accuracy after each import/migration run (row counts, key-field checks, spot-checks against source data).
- Use Git for version control (branching, pull requests) and Azure DevOps YAML pipelines for CI/CD (build, test, multi-environment deployment).
- Document data flows, mapping logic, and known data quality issues for the rest of the team.
Reporting & KPIs
- Build and maintain KPI queries/views and reporting datasets to support business and operational dashboards.
- Work with stakeholders to translate reporting requirements into reliable, well-documented SQL views or stored procedures.
Skills Required
- Design repeatable processes to import, transform, cleanse, and validate data from CSV files and external APIs into SQL Server
- Write reusable, idempotent SQL stored procedures for data migration and transformation
- Build and maintain .NET services integrating with third-party APIs such as Salesforce
- Implement OAuth client credentials and Bearer token authentication
- Design and build C#/.NET applications, Azure Functions, and console utilities
- Use dependency injection, configuration binding, structured logging, Azure App Configuration, and Key Vault
- Implement asynchronous and concurrent processing using async/await and bounded concurrency
- Build resilient HTTP clients with retry logic, backoff, and error handling
- Use Entity Framework Core and LINQ with SQL Server
- Write and maintain unit and integration tests
- Strong experience with React.js, JavaScript or TypeScript, and front-end best practices
- Develop reusable, responsive React UI components and libraries
- Use Git and Azure DevOps YAML pipelines for CI/CD
- Validate import and migration data accuracy using row counts, key-field checks, and source-data comparisons
- Document data flows, mapping logic, and data quality issues
- Build KPI queries, SQL views, stored procedures, and reporting datasets
EXL Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about EXL and has not been reviewed or approved by EXL.
-
Healthcare Strength — Medical plan options include HSA, HRA, and PPO choices, with additional health-related programs such as disability coverage and an employee assistance program. Feedback suggests these options provide meaningful flexibility and coverage breadth for many roles.
-
Leave & Time Off Breadth — Up to 20 days of paid time off, plus federal holidays and paid sick and safe time, are highlighted. Feedback suggests this leave structure is a notable benefit alongside core compensation.
-
Retirement Support — A traditional and Roth 401(k) with up to a 3% company match and full vesting after one year is described. Feedback suggests this match and vesting timeline help bolster long-term savings.
EXL Insights
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Choosing a digital partner is about more than capabilities — it’s about collaboration and character. Unrealistic overhauls and off-the-shelf products ignore what matters most — your unique needs, culture, goals, and your legacy data and technology environments. At EXL, our collaboration is built on ongoing listening and learning to adapt our methodologies. We’re your business evolution partner—tailoring solutions that make the most of data to make better business decisions and drive more intelligence into your increasingly digital operations. Whether your goals are scaling the use of AI and digital, redesign operating models, or driving better and faster decisions, we’re here to partner with you to help you gain—and maintain—competitive advantage with efficient, sustainable models at scale. Our expertise in transformation, data science, and change management helps make your business more efficient and effective, improve customer relationships and enhance revenue growth. Instead of focusing on multi-year, resource- and time-intensive platform designs or migrations, we look deeper at your entire value chain to integrate strategies with impact. We use our specialization in analytics, digital interventions, and operations management—alongside deep industry expertise — to deliver solutions that help you outperform the competition. At EXL, it’s all about outcomes—your outcomes—and delivering success on your terms. Share your goals with us and together, we’ll optimize how you leverage data to drive your business forward. For more information, visit www.exlservice.com.
.png){kind=logo}
