Share this Job

Senior Integration Developer Job

DATE: Aug 12, 2019

CITY: Columbus, OH, US, 43219

Company: DSW

Req #: 89090 
Location Name: Home Office, Columbus 
Department: Information Technology 


Designer Brands Inc. is one of North America’s largest designers, producers and retailers of footwear and accessories. The company operates a portfolio of retail concepts in nearly 1,000 locations under the DSW Designer Shoe Warehouse, The Shoe Company, and Shoe Warehouse brands and operates leased locations in the U.S through its Affiliated Business Group. Designer Brands designs and produces footwear and accessories through Camuto Group, a leading manufacturer selling in more than 5,400 doors worldwide. The Camuto Group owns licensing rights for the Jessica Simpson® footwear business, and footwear and handbag licenses for Lucky Brand® and Max Studio®. In partnership with a joint venture with Authentic Brands Group, Designer Brands also owns a stake in Vince Camuto®, Louise et Cie®, Sole Society®, CC Corso Como®, Enzo Angiolini® and others. More information can be found at



The SR. ETL Developer is responsible for creating custom integration workflows using Informatica.  Works with other teams to negotiate a solution and get results.  They will resolve production issues with limited support, troubleshoot and resolve application data and technical integration issues. The position reports to Senior Manager, Integration with no direct reports.  Must possess the ability to:




  • Build, review and analyze the ETL requirements
  • Design, develop, implement and assist in validating ETL processes
  • Create and execute unit test plans based on system and validation requirements
  • Troubleshoot, optimize and tune ETL processes
  • Document all ETL related work per company's methodology
  • Maintain existing code and fix bugs when needed
  • Ensure all timeline of loading/validating data are met
  • Develop mapping / sessions / workflows
  • Determine the structure of data; experience in data analysis
  • Self-manage time and task priorities to meet project timelines and identify potential project risks
  • Handle multiple work related tasks
  • Write and optimize SQL code (TERADATA 12.x AND ORACLE, 11 or 12 a MUST) and stored procedures
  • Self-manage time and task priorities and of other developers on the project
  • 24x7 On-Call Support Rotation


Job Requirements

  • 3-4 years of experience in Informatica development. 
    • Informatica development experience includes the ability to understand reusability, parameterization, workflow design, etc.
  • 5 years IT experience
  • Strong scripting skills(shell or perl or Python)
  • Strong understanding of Informatica Powercenter 10.x
  • Retail experience preferred
  • Previous Teradata database experience preferred
  • Previous Oracle 11 or 12 database experience
  • Bachelor’s Degree strongly preferred




Nearest Major Market: Columbus

Job Segment: Database, Business Intelligence, Data Warehouse, Oracle, Warehouse, Technology, Manufacturing