Title: IBM DataStage and SSIS Developer
Location: Onsite In Orlando, FL/ Las Vegas, NV
Duration: 6-12 Months (High Possibility of Extension)
Interview: 2-3 Video Interviews
Overview
We are seeking a highly skilled IBM DataStage and SSIS Developer to join our team. The ideal candidate will have extensive experience in designing, developing, and maintaining data processing workflows and integrations using IBM DataStage and SQL Server Integration Services (SSIS). This role requires a deep understanding of data warehousing, ETL processes, and cloud-based data solutions.
Responsibilities
- Design and Development:
- Support and develop and maintain ETL processes using IBM DataStage.
- Extract data from various sources, transform it according to business requirements, and load it into target systems.
- Has to work with SQL to find the potential data losses/data inconsistency.
- Should have excellent analytical skills to debug and find the failures.
- Data Integration:
- Support the integration of data from different sources into a unified data warehouse. Should be able to quickly debug and fix the high priority production issues.
- Ensure data quality, consistency, and reliability throughout the ETL processes.
- Performance Optimization:
- Optimize ETL jobs for performance and efficiency.
- Implement best practices for performance tuning, error handling, and monitoring.
- Collaboration:
- Work closely with support/dev team to understand data problems, job failures and work on fixes/RCA and deliver solutions that meet business needs.
- Participate in code reviews and provide feedback to ensure high code quality and adherence to best practices.
- Train team members on DataStage.
- Maintenance and Troubleshooting:
- Monitor and maintain ETL processes to ensure reliability and data integrity.
- Troubleshoot and resolve issues in data workflows and integrations.
- Should be able to deep dive and debug the solution.
- Documentation:
- Create and maintain technical documentation for data processes, architecture, and workflows.
Qualifications
- Education:
- Bachelor’s degree in Computer Science, Information Technology, or related field.
- Experience:
- Minimum of 5-7 years of experience in ETL development using Data stage and SSIS.
- Extensive experience with IDM DataStage.
- Technical Skills:
- Proficiency in IBM DataStage.
- Hands on experience with SSIS
- DataBricks will be plus point.
- Familiarity with data warehousing concepts and technologies.
- Soft Skills:
- Strong problem-solving skills and attention to detail.
- Excellent communication and collaboration skills.
- Ability to work independently and in a team environment.
Work Timings
- EST Work hours
- Should be available for On-call support if needed on weekends or odd hours.
