Software Developer 2 (Fully Remote) Must be a US Citizen or Green Card Holder
No 3rd Parties Please
Convert Data Stage Jobs to SSIS Jobs
Successfully migrate all existing Data Stage jobs to SSIS, ensuring seamless integration with Oracle, SQL Server, and MySQL databases.
Leverage existing stored procedures, functions, and views during the conversion process.
Enhance ETL Processes
Utilize strong SSIS and ETL expertise to improve data aggregation and analysis.
Optimize ETL performance and troubleshoot any issues that arise.
Integrate Databases with Other Systems
Ensure smooth integration of SQL, PL/SQL databases with various systems and applications.
Utilize Powershell or similar scripting languages to support integration efforts.
Provide Thought Leadership
Devise innovative approaches to solve complex data integration problems.
Share knowledge and best practices with the team to foster continuous improvement.
Project Status Updates
Provide regular updates on project status to stakeholders.
Ensure transparency and clear communication throughout the project lifecycle.
Adhere to SDLC and Agile Practices
Follow the defined software development life cycle (SDLC) process.
Participate actively in Agile development practices to complete code changes for defined releases.
Collaborate with Stakeholders
Work closely with multiple agency stakeholders to ensure the accuracy and efficacy of created reports.
Support the educational needs of districts through accurate datareporting.
Documentation and Testing
Maintain thorough documentation of all development work.
Conduct development and unit testing to ensure high-quality deliverables.
Years Required / Preferred Experience
7 Required Strong expertise in SSIS and ETL Processes
7 Required Proficient in SQL and relational databases (Oracle, SQL Server, MySQL)
7 Required Experience with various ETL tools, data integration, and data mapping
7 Required Ability to troubleshoot ETL issues and optimize performance
7 Required Dev/Unit Testing
7 Required Agile Development
5 Required Experience with Powershell or similar scripting languages
5 Required Experience with IBM DataStage