What are the responsibilities and job description for the SQL Data Developer position at Expleo?
Overview
Trissential’s a trusted partner for end-to-end quality services and management consulting for digital transformation. As a part of our parent company Expleo, we’re a global organization partnering with major corporations and leading non-profits in over 30 countries. Guided by our mission and values, Trissential puts people at the heart of our organization.
Come join an experience. Add your talent to a team of forward-thinking game changers that make an impact by driving innovative solutions.
Trissential is currently seeking a Microsoft SQL Server Developer for complete SQL end-to-end development work supporting data management including data movement between internal and external systems to join our dynamic team Remotely.
Responsibilities
The SQL Server Developer will work as part of the Office and Management Analysis (OMA) team to provide the following services:
- Design, build, and maintain SQL databases including queries, triggers, tables, stored procedures, functions, views, user profiles, data dictionaries and data integrity.
- Design and maintain source to target mapping and prepare implementation documents to support processes to refresh the target database with data from multiple sources.
- Reverse engineer existing source databases to understand the data design and perform detailed source data analysis.
- Design, build and maintain SSIS/SSDT packages to load data from various sources, as well as generate output extracts to external entities.
- Create and maintain database objects, enforce constraints, and create validation rules around data maintained in MS SQL databases for custom functionality.
- Develop and maintain the production notification process to efficiently track and report the status of automated jobs.
- Tune existing SQL code for improved performance.
- Provide guidance and direction to less experienced staff in resolution of escalated issues and/or complex production problems.
- Interact and coordinate with the business teams as part of requirements gathering and analysis and conduct design review meetings.
Qualifications
- 5 years of progressive hands-on experience in the use of Microsoft SQL Server and on various SQL Server Services like Integration Services (SSIS), Data Tool (SSDT) for Visual Studio, Analysis Services (SSAS), and Reporting Services (SSRS).
- Excellent T-SQL development skills to write complex queries involving multiple tables, develop and maintain stored procedures, triggers, user defined functions, views, user profiles, data dictionaries and data integrity.
- Experience with logical and physical data modeling and database design.
#LI-Remote
