IBM Infosphere DataStage Developer

Our client is an American multinational shipping & receiving and supply chain management company founded in 1907. Operating in more than 220 countries and territories, they are committed to moving the world forward by delivering what matters. Beginning as a small messenger service and a $100 loan, they now have more than 500,000 users around the globe. They are a transportation and logistics leader, offering innovative solutions to customers, big and small. They understand and appreciate their responsibility to help build safer, stronger and more resilient communities founded on justice and economic opportunity for all, supported by a healthy, sustainable global environment.

Responsibilities:

• Design, develop, and implement ETL processes using IBM InfoSphere DataStage to extract data from various source systems, transform it according to business rules, and load it into target data warehouses and data marts.  
• Develop and maintain DataStage jobs, sequences, and workflows, ensuring optimal performance and scalability.
• Troubleshoot and resolve data integration issues, working closely with data analysts and other stakeholders.
• Write and execute complex SQL queries to analyze data, profile data sources, and validate ETL processes.
• Collaborate with business analysts and data architects to understand data requirements and translate them into technical specifications.  
• Participate in the full software development lifecycle, including requirements gathering, design, development, testing, deployment, and documentation.  
• Ensure adherence to data governance policies and standards.
• Monitor ETL processes and proactively identify and address potential performance bottlenecks.
• Contribute to the development and maintenance of technical documentation, including design specifications, mapping documents, and operational procedures.

Requirements:

• Minimum of 3 to 5 years of hands-on experience in designing, developing, and implementing ETL solutions using IBM InfoSphere DataStage.
• Strong understanding of ETL concepts, methodologies, and best practices.
• Proficiency in writing complex SQL queries and working with relational databases, preferably Oracle.
• Experience with data modeling concepts (e.g., dimensional modeling, star schema, snowflake schema).
• Familiarity with Linux operating systems and basic Linux commands is a plus.
• Exposure to OBIEE (Oracle Business Intelligence Enterprise Edition) or other business intelligence tools is a plus.
• Excellent written and verbal communication skills, with the ability to effectively communicate technical concepts to both technical and non-technical audiences.  
• Excellent analytical skills and technical skills, with a strong attention to detail and problem-solving abilities.
• Bachelor's degree in Computer Science or equivalent in education and work experience.