Kforce has a client that is seeking a Senior Application Developer - Microsoft SQL/SSIS in Plano, TX.
Overview:
The Senior Application Developer will be responsible for design, development, testing, and implementation of a set enterprise level data warehouse systems and solutions. This involves leading projects from a technical development perspective including oversight over junior SQL developers. This role requires following strict Software Development Life Cycle development and implementation guidelines. Responsibilities also include technical leadership and effective communication, conducting peer code review and suggesting remediation path, supporting business needs with ad-hoc needs requests, and organizing and presenting data to multiple levels of management.
Responsibilities:
Senior Application Developer will facilitate data retrieval and manipulation through implementation of views, stored procedures, triggers, and cursors
Design and develop ETLs to move data across internal servers utilizing input variables for easier deployment to different environments
Design and develop ETLs to move data across external SFTP utilizing input variables for easier deployment to different environments
Apply ETL error handling and package logging that stores results into SQL tables for ease of troubleshooting
As a Senior Application Developer, you will optimize query performance by modifying existing queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing tables objects
Optimize query performance tuning by reading executing plans, maintaining indexes, database refactoring (making code more efficient and maintainable)
Deploy SSIS packages for ETL using Integration Catalog utilizing input variables for easier deployment to different environments
Architect ETL enhancements to increase the performance data warehouse using query manager and optimizer
REQUIREMENTS:
5+ years of MS SQL database and SQL Information Services knowledge and development experience
Knowledgeable of cloud services such as Snowflake, Amazon AWS, and Microsoft Azure
Ability to design, code, test, debug, package and deploy quality, scalable and well documented SQL solutions
Experience with SSIS, Informatica or other ETL tools
Programming experience with emphasis on designing complex SQL queries and business components
Ability to collaborate with other developers, business analysts, project managers, business users, vendors, and management
Team player with strong communication and interpersonal skills, possess a high degree of self-motivation and ability to work independently with minimal supervision
Proven track record at delivering timely and accurate information in a fast-paced environment
Strong business acumen and ability to interface with executive management
Financial Services and, if possible, mortgage industry experience preferred
Kforce is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.