SQL & ETL Developer (Mid level, 5-7 years)

Central Point Partners
  • Columbus, OH
    30+ days ago

    Job Description

    SQL & ETL Developer - (Mid level, 5-7 years)

    Job Summary
    We are seeking a seasoned Programmer/Analyst with strong SQL and ETL development expertise to join our team. The ideal candidate will have at least 5 years of experience in application development and support, with a focus on MS SQL Server and SSIS-based ETL processes. This role also requires hands-on experience in production support, ensuring the reliability and performance of critical financial applications.

    Key Responsibilities
    • Design, develop, and maintain complex SQL queries, stored procedures, and database objects
    • Build and optimize ETL workflows using SSIS to support data integration and transformation
    • Monitor and support production jobs, troubleshoot issues, and ensure timely resolution
    • Collaborate with business and technical teams to gather requirements and deliver solutions
    • Perform root cause analysis and implement preventive measures for recurring issues
    • Participate in performance tuning and optimization of database systems
    • Document technical processes and maintain system knowledge base

    Required Qualifications
    • 7+ years of experience in application development and support
    • Proficiency in MS SQL Server, including T-SQL, performance tuning, and query optimization
    • 5+ years of hands-on experience with ETL development using SSIS
    • 1+ year of Python
    • Batch and Groovy Scripting
    • Knowledge of AWS
    • Strong understanding of relational database design and data modeling
    • Experience in production support, including incident management and job monitoring
    • Excellent problem-solving and communication skills
    • Bachelor's degree in Computer Science, Information Systems, or related field or equivalent professional experience.

    Preferred Skills
    • Experience with scheduling tools (e.g., Zena, Control-M, or similar)
    • 2+ years experience with C#
    • 1+ year experience in VB.net
    • Familiarity with version control systems like GitHub
    • Exposure to cloud platforms (e.g., AWS or Azure)
    • Knowledge of ServiceNow or similar ITSM tools

    Numbers & Facts

    LocationColumbus, OH

    Skills

    • Amazon Web Services (AWS)unmatched
    • Analysis Skillsunmatched
    • Cloud Computingunmatched
    • Communication Skillsunmatched
    • Computer Programmingunmatched
    • Computer Scienceunmatched
    • Data Modelingunmatched
    • Database Designunmatched
    • Database Extract Transform and Load (ETL)unmatched
    • Database Optimizationunmatched
    • Database Technologyunmatched
    • Finance Softwareunmatched
    • GitHubunmatched
    • Groovy Programming Languageunmatched
    • IT Service Management (ITSM)unmatched
    • Identify Issuesunmatched
    • Incident Managementunmatched
    • Information Technology & Information Systemsunmatched
    • Knowledge Baseunmatched
    • Microsoft C# (C Sharp)unmatched
    • Microsoft SQL Serverunmatched
    • Microsoft Transact-SQL (T-SQL)unmatched
    • Microsoft Visual Basic.NETunmatched
    • Microsoft Windows Azureunmatched
    • Performance Tuning/Optimizationunmatched
    • Problem Solving Skillsunmatched
    • Production Controlunmatched
    • Production Supportunmatched
    • Python Programming/Scripting Languageunmatched
    • Query Optimizationunmatched
    • Requirements Managementunmatched
    • Root Cause Analysisunmatched
    • SQL (Structured Query Language)unmatched
    • SQL Server Integration Services (SSIS)unmatched
    • Scripting (Scripting Languages)unmatched
    • ServiceNowunmatched
    • Software Developmentunmatched
    • Source Code/Configuration Management (SCM)unmatched
    • Stored Proceduresunmatched
    • Systems Maintenanceunmatched
    • Technical Writingunmatched
    • Time Managementunmatched

    Be found by employers

    5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

    Level up your application

    Professional resume templates

    Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

    Free resume templates

    Free resume builder

    Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

    Free resume builder