ETL Developer

  • Dillard's
  • Little Rock, AR, USA
  • 05/16/2019
Full time Information Technology

Job Description

In this position, you will be responsible for architecting the Business Intelligence/Data Warehouse Information Management processes.  This includes development and support of ETL (Extract/Transform/Load) scripts and DataStage jobs required to extract, transform, cleanse, and move data to be loaded into the data warehouse.  You will support and manage this environment through a focus on problem determination and resolution, data modeling, data management, data integration and performance tuning.

ROLES and RESPONSIBILITIES

  • Design and develop ETL architecture solutions
  • Work with the Business Intelligence (BI) Analysts, BI Technical Architects, BI Solutions Architects, User Services and other programming teams regularly to establish understanding of source data and determine requirements
  • Troubleshoot and tune complex SQL
  • Utilize Infosphere DataStage, various scripting languages, SQL, querying tools and optimizer tools
  • Develop data validation processes to ensure data quality
  • Participate in on call rotation in support of ETL process flows that run daily

REQUIRED SKILLS

  • Authorization to work in the United States without sponsorship
  • Ability to work onsite at Corporate Headquarters in Little Rock, AR
  • Possess strong troubleshooting and diagnostic skills
  • Possess advanced SQL skills
  • Proactively seek opportunities for improvement and make constructive suggestions for change to existing processes or procedures
  • Remain on the forefront of emerging industry best practices
  • Work well in a collaborative team environment
  • Highly motivated self-starter with good communication skills
  • Have working knowledge of Business Intelligence concepts and Data Warehousing methodologies and best practices
  • Have exposure to InfoSphere DataStage or a similar ETL tool
  • Experience programming in Python, Korn shell or other scripting languages