ETL Developer

Job Description

Roles and Responsibilities

• Develop, implement, and maintain ETL processes using IBM InfoSphere DataStage and Cognos Data Manager.
• Design and optimize relational database structures to support business intelligence and reporting needs.
• Conduct requirements analysis and translate business requirements into technical specifications.
• Perform logical and physical data modeling to enhance data integration and reporting capabilities.
• Utilize technical testing techniques and tools to ensure data accuracy and reliability.
• Collaborate with business stakeholders to provide technical solutions that address organizational needs.
• Produce comprehensive technical documentation and reports to support data management processes.
• Troubleshoot and resolve data-related issues using SQL Server and other relevant tools.
• Work with IBM Cognos Business Intelligence Technologies (Report Studio, Framework Manager, Transformer, and Query Studio) to develop and maintain reporting solutions.
• Ensure data integrity, security, and compliance with organizational policies.
• Provide mentorship and guidance to junior team members in data management best practices.

Qualifications and Skills

Education

Nice-to-Haves