Candidate must possess strong technical, analytical, problem-solving, and time management skills. Attention to detail and creative problem solving is required. History of working independently with little direction is essential.

Key Responsibilities:
• Custom development and maintenance of ODI and SSIS interfaces
• Document designs, specifications and flow diagrams to assist in efficient problem analysis, development and support
• Produce test plans and load test conditions that for all sites affected by software alterations
• Perform UAT on software to ensure changes function for affected business processes and reporting
• Communicate clearly and effectively with business users and technical teams through all phases of the development life cycle
• Deploy managed releases of application solutions
• Research and troubleshoot reported problems and conduct ongoing maintenance and development
• Maintain knowledge on the latest ETL technology and best practices
• Experience with large data sets, product integrations, and performance enhancements

• 3 years of experience with ODI, SSIS or similar ETL technologies
• Experience with development using the following technologies:
o ODI – Multiple source/target systems such as Oracle DB, SQL Server, XML, Flat files, Excel documents. Working with various customized KMs (knowledge modules) for multiple source/target systems.
o SSIS – Multiple source/target systems above
o SQL Server
o Oracle, DB2, MS SQL databases
o Control-M
o Linux – Shell scripts
• Strong analysis, problem-solving, and debugging skills essential
• Strong written and verbal communication skills
• Skilled in the use of Microsoft Office applications (i.e., Word, Excel, Visio, Power Point)
• Track record of balancing multiple priorities simultaneously with the ability to adapt to the changing needs of the business while meeting deadline
• IBM DataStage v11.5
• Experience with Microsoft SQL Server Integration Services (SSIS)
• Database knowledge (SQL Server / Netezza / mySQL)
• SQL based tools (SQL Developer / TOAD / Aginity)
• Experience developing and executing software validation scripts
• Experience in technical writing and documentation