About Central Point Partners
Sourced by ZipRecruiter
Industry
It services
Company size
51 - 200 Employees
Headquarters location
Westerville, OH, US
Year founded
2012
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
centralpointpartners.com
Frequently asked questions
Q: What skills or qualities help someone succeed as a SQL ETL Developer?
A: To succeed as a SQL ETL (Extract, Transform, Load) Developer, key technical skills include proficiency in SQL programming languages, such as SQL Server T-SQL or Oracle PL/SQL, as well as experience with ETL tools like Informatica PowerCenter, Microsoft SSIS, or Talend. Additionally, knowledge of data modeling, data warehousing, and database administration is crucial. Soft skills like strong analytical and problem-solving abilities, effective communication, and attention to detail also contribute to success in this role.\n\nThese technical and soft skills support career growth and effectiveness as a SQL ETL Developer by enabling the ability to design, develop, and maintain efficient and scalable data pipelines, collaborate with cross-functional teams, and deliver high-quality data solutions that meet business needs.
Q: What is the career path for a SQL ETL Developer?
A: A SQL ETL (Extract, Transform, Load) Developer's typical career progression involves starting as a Junior ETL Developer, where they focus on building and maintaining data pipelines, then advancing to a Senior ETL Developer or ETL Lead, where they oversee complex data integration projects and lead teams. Key opportunities for skill development include learning data warehousing, business intelligence tools, and programming languages like Python or Java, as well as developing expertise in data governance, security, and compliance. Long-term, SQL ETL Developers may transition into roles like Data Architect, Data Engineer, or even move into management positions, such as Data Management Director or IT Manager.
