Position: SQL Developer
Location: Los Angeles, CA
Duration: 12 months
Required Skills
Five (5) years of SQL Server Integration/Reporting Services (SSIS/SSRS) version 2012 and above - expertise is a must. Proficiency in the development of complex technical solutions and scripts using SSIS/ SQL Server
Expertise in Microsoft Business Intelligence Services like SQL Server Integration Services, SQL Server Analysis Services and designing reports using SQL Server Reporting Services
Experience in designing ETL packages dealing with different data sources (SQL Server, Oracle, Flat Files, XMLs, Salesforce, Workday, Teradata, AS400 etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
Experience in developing, monitoring, and deploying of SSIS packages. Experience in migrating the packages from on-Prem to the cloud will be added advantage
Experience in design and Development of matrix, tabular, Parameterized, Drill down and Drill through reports, cross tab reports, Sub Reports, Summary, Reports and charts using variables and expressions
Experience in generating reports using SSRS from OLTP and OLAP data sources and deployment on server.
Experience with Event Handlers and Error Handling in SSIS packages
Managing Package Configurations, Logging, Checkpoints and User Defined Variables for SSIS Packages.
Experience in configuration of report server and report manager scheduling, give permissions to a different level of users in SQL Server Reporting Services (SSRS)
Strong expertise in Creating Stored Procedures, User-Defined Functions, Triggers, Indexes, Views, User Profiles using Transact SQL.
Experience in optimizing Stored Procedures and long-running SQL queries using indexing strategies and query optimization techniques.
Experience in creating Jobs, Alerts, SQL Mail Agent, Database Mail and Scheduled DTS and SSIS Packages
Good verbal and written communication skills
Graduation from a recognized college or university with a bachelor's degree, preferably in Computer Science, Information Technology, or a related field.
Thanks & Regards
Rajeev
West Advanced Technologies, Inc
E: rajeev.g2@wati.com
C:2796665837 | T: 5072292946
Serving government agencies for 18 Years