This site uses cookies. To find out more, see our Cookies Policy

ETL Developer in Greenville, SC at MDI Group

Date Posted: 6/10/2019

Job Snapshot

  • Employee Type:
    Full-Time
  • Job Type:
  • Experience:
    At least 3 year(s)
  • Date Posted:
    6/10/2019

Job Description


ETL Developer
Direct Hire
Mauldin, SC

The SQL Database Developer participates in technical design, development and implementation of database requirements.  Key development activities include ETL development and SQL programming (i.e., SQL stored procedures, triggers, etc.) This individual supports and adheres to the Database Development Life Cycle, including scoping, estimating, developing project plans, and progress reporting.  This individual supports the organization and coordination of data integrity improvement processes.
The SQL Database Developer has the ability to work fairly independently with strong decision-making skills and verbal communication skills.  He/she has the ability to comprehend and translate requirements into application design and development models as well as execute them to create deliverables.  He/she has the ability to research and follow through on reported data issues.  This individual can work independently or as part of a team in application development or problem resolution situations.

Responsibilities:
Database Development - 70% 

  • Design, code, test, and implement programs and scripts.
  • Write scripts and commands for data manipulation.
  • Write and debug SQL (including stored procedures, triggers, etc.)
  • Automate data extraction, analysis, and report generation.
  • Demonstrate expertise in data extraction of company systems.
  • Compile and organize data to meet business request, including ad-hoc reports.
  • Plan and conduct data warehouse unit system tests, monitor results and take corrective action as appropriate. 

Support & Data Analysis - 20%

  • Support data environment by obtaining extensive knowledge of databases and the sources of the information contained therein. 
  • Help maintain and administer business intelligence platform.
  • Monitor scheduled ETL jobs-research and determine problems that arise. Troubleshoot, debug and resolve issues.
  • Support processes associated with development, maintenance and publishing metadata.
  • Document procedures, programs, databases, etc.
  • Work with the business to identify and understand reporting and analytic requirements.
  • Work with subject matter experts to evaluate current data quality, identify possible metrics to measure quality over time, implement metric collection and review process.
  • Advise management on the consistency, reliability, and validity of data.

Database Architecture & Design - 10%

  • Design logical and physical database models for data warehouse applications.
  • Map data warehouse models to desired reporting capability.

Qualifications:

  • 5+ years of cumulative IT experience.
  • 3+ years of cumulative experience with SSIS ETL software tool.
  • Expert T-SQL development skills including query optimization, stored procedures, views, functions                              
  • Develop automated database applications, when possible, using the applicable database tools
  • Experience with database development, design and data modeling in a data warehouse environment. 
  • Understand and be able to perform administrative duties associate with metadata, data reconciliation, and data quality
  • Ability to research data problems reported by customers
  • Proven track record of working with desperate data sources and combining them into one single ETL and high end reporting solutions
  • Analyze business requirements for database design, and implement changes to database as necessary
  • Have general Database administration tasks ability such as developing Microsoft SQL Server database objects, database server implementations, code deployments, backups, creation of DB authentication principals, system and query performance tuning in addition to disaster recovery  

Preferred Experience:

  • Bachelor’s Degree preferably in Computer Science or equivalent work experience
  • Experience with application development (C#, HTML, JavaScript, CSS)
  • Experience with the ASP.NET MVC Architecture
  • Experience with Entity framework
  • Experience with IIS/Windows Server
  • Proficiency in excel related technologies a big bonus
  • Programming experience- 3 years minimum in the job related development platform Microsoft SQL

A GREAT PLACE FOR GREAT PEOPLE TO WORK

Search IT Jobs