Share this Job

ALREADY AN ASSOCIATE?

You must apply through our internal portal: 
click here

Summer 2023 Internship - ETL Developer Internship (Remote)

DATE:  Nov 19, 2022
CITY:  Columbus
BRAND:  Designer Brands
REQ #:  138329
LOCATION NAME:  Home Office, Columbus - East 5th
DEPARTMENT:  Information Technology

The Designer Brands 2023 Summer Internship Program is an elite group of university students who will be part of a robust, 10-week program with the opportunity to work, learn and immerse themselves in the day-to-day operations of their function. The program will consist of hands-on experience, skill-building, cross-functional collaboration, and networking to support professional development.

 

Requirements:

  • Must be able to work 40 hours/week for the duration of the program (June-August)
  • Must be currently enrolled in an undergraduate (rising Juniors and Seniors) or graduate program

 

Benefits for Interns:

  • Competitive hourly wages
  • Hybrid or remote work model, depending on function
  • Merchandise discount at DSW and Vince Camuto

 

 

Our IT Systems Integration (ETL Development) team has an internship opportunity available for Summer 2023. At the end of the program, the interns will have a better understanding of the IT function within Designer Brands.

 

Responsibilities

 

  • 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 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 and stored procedures
  • Self-manage time and task priorities and of other developers on the project

 

Qualifications

  • Minimal experience in Informatica development. 
    • Informatica development experience includes the ability to understand reusability, parameterization, workflow design, etc.
  • Scripting skills (shell or perl)
  • Minimal understanding of Informatica PowerCenter
  • Previous GCP/Big Query and/or Oracle database experience preferred
  • Possess a hunger for knowledge
  • Have a proactive and deliberative mindset towards success
  • Knowledge of Retail Industry a plus
  • Strong communication, organization, and analytical skills
  • Collaborate with team members on new projects and ideas
  • Possess ability to communicate clearly with project team
  • Highly motivated – requires minimal supervision

 

 

ALREADY AN ASSOCIATE?

You must apply through our internal portal: 
click here

Why Choose A Career with Designer Brands?

Empowering associates and building strong teams poised to disrupt the retail and footwear landscape through positive change is at the core of who we are at Designer Brands.

  • Invested in helping our associates learn, develop, achieve and grow into strong leaders
  • Shared commitment to creating a culture fueled by engagement, excitement, optimism and fun
  • Dedicated to giving back and community involvement 

About Designer Brands:

Designer Brands Inc. is one of North America’s largest designers, producers and retailers of footwear and accessories. 

  • Designer Brands Inc. 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. 

 

 

 

 

 

 

 

 

 

 

 


Nearest Major Market: Columbus

Job Segment: Summer Internship, Intern, Data Analyst, Database, SQL, Entry Level, Data, Technology