"Alerted.org

** **Long term*** - Webcam interview Only

** This is a Hybrid role **.

Job Description:

Scope:

The Client is seeking an experienced SQL Developer/Tester with strong database, programming, and analytical skills to actively participate in the following scope of work:

+ Assist with overall SQL Support (development, performance tuning, testing, documentation) related to quarterly projects and other efforts as needed. Activities may include:

+ Development - SQL Development support to include creation of stored procedures or underlying queries. Provide support in the design, development, and implementation of ETL packages with SQL Server Integration Services (SSIS).

+ Performance Tuning - Review existing SQL Queries, Execution Plans, etc. to determine performance enhancements for long running queries.

+ Data Manipulation - Provide alternative options to existing data manipulation techniques. Examples would be converting Excel manipulation activities into SSIS packages that reduce process/cycle time of data preparation.

+ SQL Development Processes - Review existing development processes and provide recommendations on how to enhance core development activities (i.e., Code Promotion, Code Reviews).

+ Testing – Develop test plans and cases and thoroughly test reports and workflows.

Required Skills:

+ Experience in SQL database development and programming. 5 years

+ QA/testing role. 3 years

+ Experience with SQL Server Integration Services. 3 years

+ Experience writing technical documentation (requirements, process maps, etc.). 3 years

+ Excellent communicator and ability to produce clear and concise documentation

+ Demonstrated experience working in a team environment

+ Demonstrated experience working independently with only high-level guidance

Nice to have:

+ Experience with automation tools such as Power Automate. 1 year

Preferred Skills:

+ Experience with data governance best practices/procedures

+ Investment/financial market industry experience