Logo
Datalensinc

SQL Server ETL Developer

Datalensinc, King of Prussia, Pennsylvania, United States,


General Role Description:Developer will be working on activities involving the collection and loading of data into a data warehouse. As part of the data warehouse team, the SQL Server BI Developer will collect data from transactional databases and external datasets for loading into a data warehouse. The person will work with product owners and business analysts to locate and map source data.Responsibilities:Design and implement processes to stage, standardize, and load data from multiple sourcesDevelop source-to-target mappings and profile data for integrity or standardization issuesCoordinate with team members to implement data load routines and scheduled ETL jobsDevelop queries and stored procedures as necessary for more complex processingRequired skills and experience include:5+ years working with Microsoft SQL Server with strong Transact SQL experienceStrong background developing ETL using SQL Server Integration ServicesExperience with Business Intelligence Markup Language (BIML) a plusExperience with PowerBI import and direct query a plusPerformance tuning and query optimizationExperience with data cleansing and standardizationMaster and reference data managementAttention to detail and ability to work with a variety of data formats (relational, flat-file, JSON)

#J-18808-Ljbffr