Share this Job

Intermediate Integration Developer Job

DATE: Jun 23, 2019

CITY: Columbus, OH, US, 43219

Company: DSW

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


At DSW, we believe in the power of shoes. We understand shoes bring out something great from within, and since 1991 we've been helping everyone feel the rush of finding that perfect pair. So when you work for DSW, you become a part of all that. A family whose core values are comprised of passion, accountability, collaboration, and humility. You become one of us, You become a Shoe Lover!


Intermediate ETL / Informatica Developer


The Intermediate 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


DSW believes that all persons are entitled to equal employment opportunities. We do not discriminate against any protected class including race, color, religion, religious creed, gender, sex, national origin, age, physical disability, mental disability, medical condition (defined as genetic information or impairments related to cancer), ancestry, marital status, family care leave, military and veteran status, citizenship status, sexual orientation, gender identity, gender expression, genetic information, or based on any protected category under federal, state, or local laws. DSW also makes reasonable accommodations for qualified applicants and associates with disabilities unless doing so creates an undue hardship, in accordance with all legal requirements. Any applicant requiring a reasonable accommodation during the application process or applicant who requires an accommodation to perform the essential functions of the job should request for accommodations by asking to speak with a Store Manager, District Manager, and Regional Manager, or by contacting Human Resources at DSW will work with the individual to attempt to identify a reasonable accommodation that will not impose an undue hardship on DSW.


Nearest Major Market: Columbus

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