ETL Consultant-Network Solutions in Atlanta, GA at Windstream

Date Posted: 8/9/2018

Job Snapshot

Job Description

Job ID:18002805

This ETL Developer (Engineer II) position in Network Business Intelligence - Engineering Applications (NBI-Apps) will be working in a fun, challenging, fast-paced environment to develop Extract-Transform-Load (ETL) processes which enable the engineering arm of Windstream to function more efficiently and effectively. We are looking for an ETL developer responsible for implementing the programmatic collection and consolidation of data from Windstream systems into an Engineering department RDBMS. Examples of the data categories included include network topology and performance, OSS, financial, parts/purchasing, and billing. All major vendors of RDBMS systems are in use at Windstream. Your primary focus will be development of Extract-Transform-Load logic using CloverETL, Python scripting, and Hadoop data integration and processing packages in addition to migration of legacy scripted solutions to these paradigms.  Also included will be database development in DDL/DML (primarily Oracle), and operational support of the ETL software infrastructure and processes. On top of the Oracle database development skills and the ETL tool experience, experience with software development is essential.

 
Job Responsibilities:
  • Development of Extract-Transform-Load logic using CloverETL and Python languages and systems to support business intelligence needs.
  • Migration of legacy scripted solutions to our newer ecosystem of tools (CloverETL, Python).
  • Database development in DDL and DML (primarily Oracle).
  • Building reusable code and libraries for future use.
  • Manage work through Agile tools/methodology, collaborative repositories, issue tracking platforms, and wikis.
  • Manage projects through to completion.
  • Effective communications in person and using JIRA, Confluence, email, and chat tools.
  • Effective collaboration in a dynamic team environment.
  • Independent project execution with minimal oversight.
 
Essential Skills:
  • Extract-Transform-Load methodologies and patterns.
  • Oracle database development including SQL, DDL, and DML.
  • Javlin CloverETL development and deployment.  Experience with comparable ETL tools (Informatica, Alteryx, MS DTS) will be considered.
  • Programming in the Bash and Python languages.  Experience with comparable languages (Perl, TCL, NodeJS) will be considered.
  • Proficiency with code versioning tools, such as Git.
  • Data retrieval from files, web-based APIs, and RDBMS (Oracle, MySQL, MsSQL).
  • Experience working with large, disparate data sets.
  • Web Service technologies and APIs (REST, RPC, SOAP, etc.)
  • Data exchange formats: delimited, fixed-format, XML, JSON, and YAML.
  • Drive to succeed and improve personally, and in ability to add value to the role, team, and company.
  • Self-starter, relentlessly curious, resourceful, collaborative, and inventive.
  • Good team player and communicator.
  • Highly organized and meticulous.
  • Positive attitude and the desire to solve problems in elegant and creative ways.
Desired Skills:
  • Apache Hadoop platform experience – Ambari, Pig, Hive, Hbase, Spark, etc.
  • Database warehousing and performance tuning experience helpful.
  • Java development experience.
  • Familiarity with command line operating systems and shells (Linux, Cisco IOS).
  • Network programming concepts: IPv4, sockets, SSL, port-forwarding.
  • Unix/Linux administration.
  • User experience with JIRA and Confluence.
  • Tableau visualization experience.

Job Requirements

Minimum Requirements: College degree in Engineering or a related field and 5-7 years professional level experience with 0-2 years supervisory experience for roles with supervision; or 9+ years professional level related Engineering/Technical experience with 0-2 years supervisory experience for roles with supervision; or an equivalent combination of education and professional level related Engineering/Technical experience required.

EEO Statement: Employment at Windstream is subject to post offer, pre-employment drug testing. Equal Opportunity Employer including minority/female/disability/veteran; Without regard to

CHECK OUT OUR SIMILAR JOBS

  1. Developer Jobs
  2. DBA Jobs