Sr. ETL Developer (DataStage, DataManager) to design, develop, and maintain data warehouse and analytics architecture

Our valued client is looking for a Sr. ETL Developer (DataStage, DataManager) to design, develop, and maintain data warehouse and analytics architecture.

*This is a remote position (Eastern Time Zone)

**There is a requirement for the successful candidate to work weekends and holidays (on rotation) from 9:00am to 11:00am and be available on-call during this period for incidents that may arise

Tasks include:

• Provide support to the organization’s business requirements in the application and consumption of information from the Enterprise Data Warehouse (EDW) or from other source systems
• Work with architects and business partners to fashion out the technical vision for applications in the Data Warehouse
• Ensure the functionality, security, availability and accuracy of the information within the Data Warehouse environment. The ETL developer will mainly work with DataStage and DataManager tools
• Design, maintain, and provide support for Data Warehouse systems and related DataMarts
• Translate business requirements into viable technical solutions by coordinating with Product Owner, Business stakeholders as well as other relevant SMEs
• Identify risks, impacts and dependencies while assessing new requirements to optimize delivery
• Design data integration/ETL jobs using DataStage and its foundation tools in a SQL Server and Windows environment
• Design and modify ETL logic using DataManager
• Participate in the testing of developed technical solutions
• Participate in the investigation and resolution of complex Data Warehouse issues
• Proactively identify opportunities for process, systems, and other efficiency improvements
• Work towards the team’s effectiveness through personal style

Must have:

• Reliability level security clearance
• Bachelor's degree in business administration, information technology, or a related field with at least 8 years of experience
• 5 years of experience with IBM's ETL tool - IBM Infosphere DataStage tool
• 5 years of proven experience with the IBM Cognos DataManager
• 5 years of proven experience with SQL