What are the responsibilities and job description for the ETL Developer (SSIS) position at Seneca Resources?
Key Responsibilities:
- Convert IBM DataStage jobs into SSIS jobs, integrating with Oracle, SQL Server, and MySQL databases.
- Design, develop, and optimize ETL processes for data aggregation and transformation.
- Troubleshoot ETL issues, improve performance, and ensure data integrity.
- Utilize PowerShell or similar scripting languages for automation and process optimization.
- Work with various ETL tools for data mapping and integration.
- Create and maintain technical documentation.
- Conduct unit testing and validate data workflows.
- Participate in Agile development to support continuous improvement.
Required Experience:
- 7 years – Strong expertise in SSIS and ETL processes.
- 7 years – Proficiency in SQL and relational databases (Oracle, SQL Server, MySQL).
- 7 years – Experience with various ETL tools, data integration, and data mapping.
- 7 years – Ability to troubleshoot ETL issues and optimize performance.
- 7 years – Experience with Dev/Unit Testing.
- 7 years – Experience working in an Agile development environment.
- 5 years – Experience with PowerShell or similar scripting languages.
- 5 years – Experience with IBM DataStage.
