What are the responsibilities and job description for the SSIS ETL Developer position at SOLTECH?
Overview:
Our client is looking for an ETL SSIS Software Engineer to add to their Enterprise team. This role will be responsible for designing, developing, and maintaining ETL processes using SQL Server Integration Services to extract, transform, and load data from various sources into their data warehouse or data lake.
Job Details:
- Understand business requirements and perform technical implementations using enterprise applications expertise.
- Design, develop, and maintain ETL processes using SQL Server Integration Services (SSIS) for on-premises and hybrid environments.
- Develop and optimize SSIS packages for data extraction, transformation, and loading (ETL) across various sources.
- Implement error handling, logging, and auditing mechanisms to monitor and troubleshoot SSIS packages for data quality and integrity.
- Build integrations between systems, ensuring smooth data flow and transformation between platforms.
- Work in an Agile environment with daily standups, collaborating with internal stakeholders to understand enterprise-wide data needs.
- Maintain a 50/50 balance between new development and sustaining existing processes.
- Ensure performance tuning and optimization of ETL processes to meet scalability and efficiency requirements.
- Provide troubleshooting and support for development, testing, and production environments.
- Maintain professional and technical documentation, best practices, and knowledge sharing.
Requirements:
- 3-5 years of strong ETL/SSIS experience
- Expertise in SSIS, T-SQL, and SQL
- Experience building integrations between systems and developing SSIS workflows.
- Strong understanding of master data concepts and enterprise application structures.
- Agile development experience and ability to work within a structured team environment.
- Knowledge of internal-facing applications and enterprise data flows.
- Strong problem-solving and analytical skills with excellent communication abilities.
- Experience with Python for scripting and automation.
- Familiarity with AWS and Cloud-based data solutions
- Knowledge of Data Warehousing principles and best practices.
- Exposure to enterprise systems like QAD and SAP.
- Understanding of integration platforms such as Boomi.
Location:
This role is based in Duluth, GA with a hybrid schedule - onsite three days a week.
About SOLTECH
SOLTECH is a leading national technology company based in Atlanta. Driven by a steadfast commitment to integrity, strong company values, and customer centricity, SOLTECH has achieved national recognition and success.
For more than 25 years, SOLTECH has been part of the thriving technology community, and has been recognized by The Atlanta Journal-Constitution as a Top Workplace, as well as one of the Best & Brightest Companies To Work For In The Nation. With a team of exceptional engineers, designers, and strategists, SOLTECH has consistently delivered cutting-edge custom software applications, technology consulting services, and IT staffing solutions that address complex business challenges.
Join us on our quest to make the world a better place by bringing to life innovative software solutions that make our lives easier, safer, healthier, and more productive.
If you are an IT professional searching for your next career opportunity, we look forward to matching your expertise and interests with a position where you can thrive. Learn more about SOLTECH careers at https://soltech.net/working-for-soltech/
SOLTECH has a fundamental belief in the importance of good human relations and in the dignity of each individual. Here at SOLTECH, equal employment opportunity is more than just a legal phrase, it is a matter of principle, a commitment to our people, and something we are proud to practice. As an equal opportunity employer, we will consider you without regard to your race, color, age, sex, sexual orientation, gender identity, religion, marital status, national origin, disability, or veteran status.
