SQL Developer

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: [email protected]

C:2796665837 | T: 5072292946

Serving government agencies for 18 Years