URGENT POSITION|| SQL Developer @CA

Job Description:

Skills Required

• At least ten (10) years of experience working as a reports developer creating and fine-tuning SQL reports from data stored in various relational databases. This experience must include experience designing robust Logical Data Models and stewarding the data design of the solution and ensuring alignment with the larger roadmap goals.
• At least ten (10) years of experience designing, developing, debugging and supporting complex data integration interfaces and processes (including stored procedures, triggers, tables, user defined functions, views, indexes, relational database models) using various tools and technologies including SSIS, SSAS, SSRS, T-SQL and SQL Server technology. This experience must include experience in developing ETL scripts and writing code using the data model, dataflow diagram and technical design specifications.
• At least ten (10) years of experience developing complex SQL queries; developing detailed SQL reporting specifications; aggregating, analyzing, validating, and/or reconciling data from heterogeneous data sources, for example, MS SQL Server, XML files, CSV files, text files, etc.).
• At least ten (10) years of experience demonstrating understanding of SDLC methodologies specific to requirements elicitation and analysis, analyzing business processes, business process modeling, preparing business use cases, logical data modeling, and user interface design for reports.
• At least eight (8) years of experience working with Microsoft products/tools such as Power BI, SQL Server versions 2008, 2012 and 2016, SQL Server Reporting Services, SQL Server Integration Services, etc.

Desirable Technical Qualifications    

• Previous experience with CalSTRS specific Pension Solution System and in-depth knowledge of the Pension Product that is currently being configured and customized for CalSTRS is highly desired.
• Experience developing SQL Reports as part of the data integration solution for a Pension Administration System.
• Strong understanding of SQL Server Replication Services and experienced in setting up replication between a single source and multiple targets.
• Experience developing and designing a business intelligence solution involving a data warehouse utilizing Microsoft tools and technologies available on premise as well as platform as a service in the public cloud.