Offer summary

Qualifications:

Strong expertise in SSIS and ETL processes., Proficient in SQL and relational databases such as Oracle, SQL Server, and MySQL., Experience with IBM DataStage and various ETL tools., Familiarity with Powershell or similar scripting languages..

Key responsabilities:

Convert Data Stage jobs into SSIS jobs leveraging existing databases.

Troubleshoot ETL issues and optimize performance.

Participate in Agile development and follow the software development life cycle (SDLC).

Provide ongoing updates on project status and ensure accuracy of created reports.

Established in 2004, 3Core System is a certified small minority owned business providing ERP Systems Integration, AMS, IT Consulting and Staff Augmentation Services to Fortune 1000, SMB, and State, Local and Education (SLED) customers. While our System Integration services help organizations achieve digital and cloud transformation objectives, AMS Services help increase the availability of critical services of end user applications. On the other hand, our IT Consulting Services would provide subject matter experts to help you assist with specific project needs and the Staff Augmentation services help you balance workload and achieve budget parameters. >ERP System Integration Services: 3Core Systems is an SAP Silver Partner and authorized service provider offering technical architecture, application design and configuration, integration, testing, data migration and solution adoption services for solutions including SAP SuccessFactors, SAP HCM On-Premises and SAP Business Intelligence>Application Management Services (AMS): We offer post go-live, System Health Check and Optimization, Function Enhancements, Integration Monitoring, Release, and patch services. Our AMS services span across SAP Solutions including ERP (S/4 HANA), Financial Management, Human Capital Management, Data and Analytics, Supply Chain, CRM, and Customer Experince. >IT Consulting and Staffing Augmentation Services: Ever since its inception, 3Core Systems has been offering IT Consulting and Staff Augmentation solutions including temporary, long-term, project based and contract staffing services that could be personalized based on your needs. Our staffing services span across emerging technologies and legacy solutions including but not limited to Artificial Intelligence, Machine Learning, Data Science, Cloud, ERP, CRM, BI/BW/ETL, Database, Web & E-Commerce, UI/UX, Network & Security and Mobile.

Job description

This is a remote position.

Software Developer (DataStage Developer)

Remote Role
Duration 3 - 6 months

The Senior SSIS Developer will perform advanced analysis and development work involving all aspects of converting Data Stage jobs into SSIS jobs leveraging existing oracle, SQL Server and MySQL databases and the existing Stored Procs, functions and views. This position requires strong SSIS experience, along with extensive experience in integrating databases (SQL, PL/SQL) with other systems and applications. The worker will also devise approaches to solving complex problems, provide thought leadership, and provide ongoing updates on project status. The developer will also need to exhibit a high level of skill in data aggregation and analysis using ETL Tools. This position works for section of IT-SEDS (Information Technology – Statewide Education Data System). Work assignments follow a defined software development life cycle (SDLC) process using an Agile-like approach for completing code changes for defined releases. This role works across multiple agency stakeholders to ensure the accuracy and efficacy of created reports, in the service of Texas’s 1200 school districts.

Strong expertise in SSIS and ETL Processes

Proficient in SQL and relational databases (Oracle, SQL Server, MySQL)

Experience with Powershell or similar scripting languages

Experience with IBM DataStage

Experience with various ETL tools, data integration, and data mapping

Ability to troubleshoot ETL issues and optimize performance

Documentation

Dev/Unit Testing

Participate in Agile development

Experience

· Strong expertise in SSIS and ETL Processes

· Proficient in SQL and relational databases (Oracle, SQL Server, MySQL)