What are the responsibilities and job description for the SQL & ETL Developer position at Central Point Partners?
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
Salary : $95,000