Application Developer

This role is critical in ensuring business continuity for mission-critical systems, while supporting integrations, improving data quality, and maintaining performance as part of ongoing modernization efforts., Application Maintenance & Support

• Maintain and support CA Plex-based applications across multiple environments
• Troubleshoot production issues, defects, and data anomalies
• Perform root cause analysis and implement long-term fixes
• Provide support for critical system issues as needed

Enhancements & Business Logic Updates

• Design and implement enhancements within the CA Plex model

• Modify: *

• Business rules
• Screens and workflows
• Batch processes and reports
• Ensure updates align with business and regulatory requirements

CA Plex Development

• Work within the CA Plex development environment to update objects and functions
• Regenerate and deploy application components
• Maintain integrity of model-driven architecture

Database & Data Management

• Develop and optimize SQL Server (T-SQL) queries and stored procedures
• Perform data corrections and data integrity checks
• Tune performance for large-scale datasets

System Integration Support

• Maintain integrations with internal and external systems
• Support transition from legacy interfaces to API-based integrations
• Ensure data consistency across systems

Reporting & Data Support

• Develop queries and data extracts for reporting
• Support data feeds into data warehouse environments
• Collaborate with analytics teams to ensure data accuracy

Collaboration & Documentation

• Work with business users and technical teams to deliver solutions
• Document system changes, business rules, and technical processes
• Support knowledge transfer to internal teams

Work Requirement: No SC residency required. Candidate must reside in lower 48 states (Continental US) and comfortable working EST time zone hours., · 12+ years of application development experience

· 7+ years of experience with CA Plex or similar 4GL/model-driven environments

· 7+ years of experience with SQL Server / T-SQL

· 7+ years of experience maintaining legacy or enterprise systems

· Strong debugging, troubleshooting, and problem-solving skills

Preferred Skills:

· Experience with data warehouse architecture (star/snowflake schema)

· Knowledge of Power BI backend optimization

· Familiarity with .NET data access patterns

· Experience with Always On Availability Groups

· Exposure to Azure DevOps

· Familiarity with security tools (e.g., WAF solutions)

· Experience working with large-scale legacy data environments

Education:

Bachelor’s Degree in Computer Science, Information Systems, or equivalent experience, Application Programming Interface (API), Case Management, Computer Science, Data Management, Data Quality, Data Sets, Data Warehousing, Debugging Skills, DevOps, Fourth Generation Language, Identify Issues, Information Technology & Information Systems, Knowledge Transfer, Microsoft .NET, Microsoft SQL Server, Microsoft Transact-SQL (T-SQL), Microsoft Windows Azure, Performance Tuning/Optimization, Power BI, Problem Solving Skills, Quality Management, Regulatory Requirements, Root Cause Analysis, Snowflake Schema, Software Development, Star Schema, Stored Procedures, System Integration (SI), Technical Delivery