Raymond Sabirov
SQL/BI DEVELOPER at State Farm | Expert in SQL, BI, Data Warehousing
- Role
- s Sql Bi Developer at State Farm
- Location
- Loveland, OH, US
- LinkedIn followers
- 500 followers
About Raymond Sabirov
Solution-oriented Business Intelligence and Data Engineer with more than 5 years of…
Experience
s Sql Bi Developer
Nov 2022 — Present · Madison, WI, US
Created and maintained tables, stored procedures, indexes, database check constraints, and business rules using SQL.• Created SQL Server jobs and scheduled them to load data periodically using SQL server Agent.• Excellent knowledge in creating Databases, Tables, Stored Procedures using Window Functions, DDL/DML Triggers, Views, User defined data types, functions, and Indexes using T-SQL.• Created XML Package Configurations, Error Handling using Event Handlers for On Error, On Warning, On-Task Failed event types.• Developed SSIS packages to extract, transform and load data from Oracle and SQL Server databases into Data Warehouse.• Deployed SSIS packages into various Environments (Dev, UAT and Prod) using Deployment Utility.• Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, SAS, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge, and union all.• Have been creating complex Pipelines using ADF V2, Azure Databricks, source being On Prem Servers or flat files / or Cloud Storages such as ADLS Gen2, Blob storage, involving Stored Procs to control pipelines, creating notebooks and doing data transformations• Done ADF source code version control using Azure DevOps or Git• Done Azure services, destination was Synapse Data Warehouse and made ADF source code version control using Azure DevOps or Git• Assisted in implementing Azure Data Factory v2 for a major financial institution by ingesting their risks and control data into Azure data lake store.• Handling Azure Storage like Blob Storage and File Storage• Developed U-SQL Scripts for schematizing the data in Azure Data Lake Analytics• Ability to create scripts using Azure PowerShell during for automation and build process.
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.