Software Developer
Apply NowCompany: Lumen Solutions Group, Inc.
Location: Austin, TX 78745
Description:
Senior SSIS Developer
We are seeking a highly skilled Senior SSIS Developer to lead advanced analysis and development efforts in converting DataStage jobs into SSIS jobs. This role requires leveraging existing Oracle, SQL Server, and MySQL databases while utilizing existing stored procedures, functions, and views. The ideal candidate will have extensive experience with SSIS, ETL processes, and database integration.
This position involves solving complex data transformation challenges, providing thought leadership, and delivering project updates. The developer must demonstrate expertise in data aggregation and analysis using ETL tools while working within the IT-SEDS (Information Technology - Statewide Education Data System) team. The work follows a structured Software Development Life Cycle (SDLC) with an Agile-like approach to releases and requires collaboration with multiple agency stakeholders to ensure accurate and effective reporting for Texas's 1,200 school districts.
Key Responsibilities:
Required Skills and Qualifications:
Years Required/Preferred Experience 7 Required Strong expertise in SSIS and ETL processes. 7 Required Proficiency in SQL and relational databases (Oracle, SQL Server, MySQL). 7 Required Experience with various ETL tools, data integration, and data mapping. 7 Required bility to troubleshoot ETL issues and optimize performance. 7 Required Experience in development and unit testing. 7 Required Experience working within Agile development methodologies. 5 Required Proficiency in PowerShell or similar scripting languages. 5 Required Experience with IBM DataStage.
***Lumen and / or its clients will not provide equipment (Laptop, monitor, etc.) to the selected contractor. The contractor must have their own equipment. Access to a virtual desktop set up (software) will be provided by Lumen's client, allowing the user access to the required systems and technology.***
Lumen Solutions Group Inc. is an Equal Opportunity Employer and does not discriminate in employment on the basis of Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans.
We are seeking a highly skilled Senior SSIS Developer to lead advanced analysis and development efforts in converting DataStage jobs into SSIS jobs. This role requires leveraging existing Oracle, SQL Server, and MySQL databases while utilizing existing stored procedures, functions, and views. The ideal candidate will have extensive experience with SSIS, ETL processes, and database integration.
This position involves solving complex data transformation challenges, providing thought leadership, and delivering project updates. The developer must demonstrate expertise in data aggregation and analysis using ETL tools while working within the IT-SEDS (Information Technology - Statewide Education Data System) team. The work follows a structured Software Development Life Cycle (SDLC) with an Agile-like approach to releases and requires collaboration with multiple agency stakeholders to ensure accurate and effective reporting for Texas's 1,200 school districts.
Key Responsibilities:
- Lead the migration of DataStage jobs to SSIS.
- Develop, optimize, and maintain ETL processes.
- Integrate SQL, PL/SQL databases with various systems and applications.
- Troubleshoot and resolve ETL performance issues.
- Document processes and solutions effectively.
- Perform development and unit testing.
- Participate in Agile development cycles.
Required Skills and Qualifications:
Years Required/Preferred Experience 7 Required Strong expertise in SSIS and ETL processes. 7 Required Proficiency in SQL and relational databases (Oracle, SQL Server, MySQL). 7 Required Experience with various ETL tools, data integration, and data mapping. 7 Required bility to troubleshoot ETL issues and optimize performance. 7 Required Experience in development and unit testing. 7 Required Experience working within Agile development methodologies. 5 Required Proficiency in PowerShell or similar scripting languages. 5 Required Experience with IBM DataStage.
***Lumen and / or its clients will not provide equipment (Laptop, monitor, etc.) to the selected contractor. The contractor must have their own equipment. Access to a virtual desktop set up (software) will be provided by Lumen's client, allowing the user access to the required systems and technology.***
Lumen Solutions Group Inc. is an Equal Opportunity Employer and does not discriminate in employment on the basis of Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans.