Apply to this job

Back to search

Posted October 27th

Developer ETL Informatica

Dallas, Texas


Southern Glazer's Wine & Spirits logo

Employer

Southern Glazer's Wine & Spirits

Industry

Distributor

View Full Profile

Posted October 27th

Developer ETL Informatica

Dallas, Texas

Overview

The ETL Developer’s role is to design, develop, maintain and enhance interfaces and connectivity to the ONESource ecosystem by coding with a technical language to meet business requirements and business objectives. This can include taking technical specifications and developing an application or integration of data between applications, testing, as well as, completing the appropriate technical documentation. The ETL Developer will use best practices in software development and adhere to SGWS development standards, as well as, focus on quality and innovation. The ETL Developer may also be responsible for delivering support to end users in the organization for specific code, including troubleshooting code.

Specialized Skills and Technologies

  • Experience in Informatica Power Center, Power Exchange (ETL Tools)
  • Data Warehouse techniques
  • Strong SQL skills (Redshift)
  • Experience in cloud platforms like Azure or AWS
  • Experience in Hadoop (HDFS)
  • Knowledge of UNIX/Linux, shell scripting, Java
  • Experience developing Application Programming Interfaces (API's) will be a plus

Primary Responsibilities

  • Design, develop, implement, and support software applications
  • Drive technical validity of solution.
  • Develop user documentation as well as in-code documentation to explain designs and participate/support user training
  • Structure requirements to facilitate automation of acceptance tests 
  • Develop routines and procedures for data delivery/ingestion
  • In conjunction with DMG group, develop routines and procedures that provide data quality checks and balances on data delivery/ingestion
  • Collaborate across the BI / Analytics, DMG, EIA and ONESource teams to establish standards, reusable data models and best practices for delivery/ingestion of data from/to ONESource - This includes Publish/Subscription and API options
  • Obtain any certifications needed to effectively support applications in scope 
  • Support the development of business and technical process documentation and training materials
  • Structure requirements to facilitate automation of acceptance tests
  • Provide support for software applications under area of responsibility
  • Drive Behavior-Driven-Design (BDD) process
  • Perform other job-related duties as assigned

Location
Dallas, Texas