Cardinal Integrated Monmouth Junction , NJ 08852
Posted 1 week ago
Position : Sr. SQL Developer
Duration : 6 Months +
Location: Doylestown, PA - (Remote is fine, but will need to travel few times to Office)
Full Job Description:
This contract position will play a critical role supporting. Primary responsibilities will be to analyze, design, develop, implement and maintain technical solutions SSIS and SSRS.
As a SQL Developer, you will:
Design, code and test programs using the Microsoft SQL Server platform.
Create business logic, reports, exports and other data related output.
Learn continuously, manage your work independently and seek guidance from senior developers when needed.
Use best practice coding standards in a fast-paced and agile environment.
Work in a team environment that includes collaborating with Product Owners, Stakeholders, and Software Developers.
Qualifications
Bachelor's degree or higher in technology field or related field preferred
3-5 years of practical experience with SSIS, SQL, SSRS
Practical experience with Microsoft SQLmServer platform, and Transact SQL stored procedures and triggers
Experience with SSIS development and SSRS reports (preferred)
Interest in working with complex data sets and analytic technologies such as Power BI
Ability to create Functions/Views/Stored Procs
Experience with complex queries including use of CTEs, table variables, merge and dynamic SQL
Experience with complex business logic including applying logic to transforms that falls outside of basic schema formatting conversion
Experience executing SSIS packages via SQL Server Job Agent
Experience using all components available in SSIS including sorts, derived values, data conversion, multicast, merge, union, variables,parameters, package DB connections, project DB connections, flat file connections, excel connections and SMTP connections, expressions and file system tasks.
Cardinal Integrated