ETL Developer in Charlotte, NC at Sonic Automotive

Date Posted: 8/18/2019

Job Snapshot

  • Employee Type:
    Full-Time
  • Location:
    4401 Colwick Road
    Charlotte, NC
  • Job Type:
  • Experience:
    Not Specified
  • Date Posted:
    8/18/2019

Job Description

Come be a part of Sonic Automotive’s growing IT team.  We are currently looking for ETL Developers to be responsible for the development for all extract, transform, load (ETL) code designed to load the data warehouse, and for any data integration with any non-warehouse data sources or any third party vendors.  Multiple roles are available.

 
Responsibilities: 
•      Work with business partners, data quality analysts, Business Intelligence (BI) developers and Database Administrators (DBA’s) to ensure that ETL code produces the required results and that all code is successfully tested and promoted to the production environment.
•      Make recommendations for schema changes based on new information acquired throughout the development process.
•      Contribute to ETL and database architecture discussions as relates to ETL activities and processes.
Qualifications:
•      Bachelor’s degree in Business Administration, Computer Science, Computer Information Systems, Management Information Systems, or foreign equivalent (must have 3 years of experience) or Associate’s degree in Business Administration, Computer Science, Computer Information Systems, Management Information Systems, or foreign equivalent (must have 5 years of experience)
•      Three (3) years of experience as a Programmer Analyst or Software Developer, including 3 years developing and implementing ETL code. 
•      Three years of the required experience must include:
•      Microsoft RDBMS and data management tools, including SQL Server Management Studio and SQL Server Integration Services 2008;
•      Creating efficient queries, views, indexes, stored procedures and functions within SQL Server 2008 or later;
•      Pragmatic Works tools BIxPress and BI Documenter;
•      Designing and implementing SSIS control flow and data flow tasks, variables, script components and other SSIS functionality support data integration projects;
•      ETL Data warehousing architecture using SSIS to load Kimball star schema fact and dimension tables, including the design and implementation of Slowly Changing Dimensions (SCD);
•      Using SSIS to load and integrate data from disparate source formats including flat files, XML files, REST Services and Web services;
•      Using SSIS to load and integrate data to and from ftp sites into staging tables and various DataMart’s;
•      Creating and using Source to Target mapping documentation for design and load of DataMart’s to support Data Warehousing and BI Reporting initiatives;
•      Translating verbal and written business requirements into code;
•      Transferring knowledge of ETL processes to DBA’s prior to the promotion of ETL code to production, and delivering scripts and documentation of all objects and processes;
•      Troubleshooting and supporting ETL issues escalated beyond the DBA team, especially relating to SSIS ETL Package changes.


 

Find Your Job.