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

Minimum Qualifications

• Bachelor’s Degree or a combination of work experience and education.
• Knowledge in application and software development
• Knowledge of software design and programming principles
• Proficient oral and written communication skills, ability to influence outcomes, and strong attention to detail
• Strong analytical, mathematic, and problem-solving skills
• Strong team player with ability to demonstrate Agile delivery values working both within a team and working independently
• Strategic thinker – can develop a plan to meet a long-term objective

Agile Delivery Values

• Openness – Team and stakeholders agree to be open about all work and challenges 
• Commitment – Personally commit to achieving the goals of the team 
• Respect – Respect your team members to be capable and independent 
• Courage – You have courage to do the right thing and work on tough problems 
• Focus – Everyone focus on the work in the sprint and the goal of the scrum team.  Rise and fall as a team

Physical Demands

• Physical demands include a considerable amount of time sitting and typing/keyboarding, using a computer (e.g., keyboard, mouse, and monitor), or adding machine
• Physical demands with activity or condition may include walking, bending, reaching, standing, squatting, and stooping
• May require occasional lifting/lowering, pushing, carrying, or pulling up to 20lbs

Southern Glazer’s Wine and Spirits provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.