- Lead the conversion of IBM DataStage jobs to SSIS.
- Develop, optimize, and maintain ETL processes for data integration.
- Work with SQL-based relational databases, including Oracle, SQL Server, and MySQL.
- Troubleshoot ETL issues and optimize performance.
- Develop and maintain technical documentation.
- Conduct development and unit testing.
- Actively participate in Agile development processes.
- Provide thought leadership and recommendations for best practices in ETL development.
III. Candidate Skills and Qualifications
- Seven (7) years of experience in SSIS and ETL processes.
- Seven (7) years of proficiency in SQL and relational databases, including Oracle, SQL Server, and MySQL.
- Seven (7) years of experience with various ETL tools, data integration, and data mapping.
- Seven (7) years of experience troubleshooting ETL issues and optimizing performance.
- Seven (7) years of development and unit testing experience.
- Seven (7) years of experience working in Agile development methodologies.
- Five (5) years of experience with PowerShell or similar scripting languages.
- Five (5) years of experience with IBM DataStage