SQL Developer

Company: Incept Data Solutions, Inc.
Location: Reston
Posted on: February 19, 2021

Job Description:

SQL Developer (SSIS/SSAS/SSRS)
Seeking a highly skilled SQL Developer to support a Fortune 500 technology company offering high-end solutions in systems engineering and integration. You'll be surrounded by a supportive working environment and people who'll recognize your potential and encourage you to flourish. You'll be challenged to always do your best and be rewarded for your hard work and contributions.
REMOTE (currently)US Citizens are encouraged to apply.
Responsibilities
-- Be responsible for business and functional requirements gathering, a review of existing business model, systems configurations and operating methodologies as well as understanding evolving business needs.-- Design and Develop the complex ETL packages using Full/Incremental Load strategy-- Create an ETL design/Framework and implementation checks in SSIS packages.-- Understand functional side of Business requirements.-- Troubleshoot issues related to package debugging, performance, configuration, and migration.-- Tune and optimize ETL batch jobs for performance and throughput.-- Conform to SSIS workflow and mapping standards so that development is done in a consistent manner across all development resources.-- Develop ETL workflows and mappings using SSIS with good experience in complex package development.-- Assist with troubleshooting ETL batch job issues in production, Prep rod, QA and UAT.-- Create data load mappings, import/export methods, Incremental /Full load data from Source systems to various targets.-- Setup up the SSIS packages.-- Tabular Models (Cubes) - design & development.-- Data Analysis Expressions (DAX)-- Automate data extractions, loads and consolidations (when applicable) using batches or PowerShell scripts.-- Understand End-To-End data flow between various data sources and SSIS packages.-- Should be able to analyze and optimize SQL queries and provide tuning recommendations to SSIS jobs, time/CPU consuming queries if situation arises.-- Design and develop ETL (MSBI) code for efficient and scalable data transformations in the Enterprise Data Warehouse-- Extend and maintain the EDW/Mart data layers - Type I, II, III SCD dimensions and facts.-- Work closely team members such as Data Analysts, QA and other ETL engineers to develop and release new capabilities as well as research technical requirements and resolve issues?-- Troubleshoot and resolve technical issues with data migration and transformation using MSSQL, SSIS, SSAS, SSRS-- Ensure the quality, completeness, security, privacy, and integrity of data.
Qualifications
-- Bachelor's Degree or equivalent experience in Computer Science-- 5-7 Years work experience in the IT industry within a large technology team-- Bachelor's degree in relevant technical field, (Information Technology, Computer Science, Software, Engineering, or related technical discipline), or equivalent combination of training and work experience.-- Minimum 3-5 years' experience with Oracle MS SQL Server-- Experience with MS SQL Server 2005/2008/2012/2016 including T-SQL/PL-SQL programming and scripting.-- 5+years' experience with MSBI coding-- Experience in EDW design principles such as: requirements analysis, data mapping, transformations, SCD Type II, Star Schema, snowflake schema. -- Knowledge on MS Power BI tool along with profound knowledge on query writing-- Strong systems skills especially in implementation, maintenance, enhancement, and documentation

Keywords: Incept Data Solutions, Inc., Reston , SQL Developer, IT / Software / Systems , Reston, Virginia