ETL Developer II

Company: Geodis
Location: Nashville
Posted on: May 6, 2021

Job Description:

The ETL Developer II is responsible for developing and deploying enterprise data warehouse solutions, data visualizations and reports. The Extract Transform and Load (ETL) Developer II is an individual contributor but will work closely with Architects to develop against specified standards and best practices. GEODIS is one of the world's largest leading Supply Chain Operators! At GEODIS, we create with you an infinite amount of career opportunities. As a GEODIAN, you will work hands on with products from hundreds of customers in different industries - retail, healthcare, technology, and more - all within our warehouse distribution centers located globally. No matter what position you're in - you will find yourself contributing to the development and success of your career and our customers. Primary Duties:

• Develop data warehouse solutions per the given business requirements.
• Develop and/or enhances database schemas to fulfill the business requirements.
• Develop Extract Transform and Load (ETL) processes for ingesting data to the data Warehouse.
• Provide support to the enterprise solutions.
• Other duties as required and assigned by supervisor. Requirements: Education and Experience:
  • Bachelor's degree in Computer Science or a related field from a 4-year college or university
  • Minimum 5 years' experience implementing Data Warehouses in a commercial environment.
  • Experience with dimensional modeling, star schemas, and RDBMS.
  • Strong knowledge in writing queries with PL/SQL or T-SQL.
  • Experience with Unix environment, installation of softwares in Unix environment.
  • Experience with Programming languages like Python or Scala.
  • Experience with Apache Spark or Apache Flink.
  • Experience with an ETL tool like Oracle Data Integrator (ODI) or Informatica.
  • Experience in azure cloud is preferred.
  • Experience with document databases/NoSQL databases are preferred.
  • Experience with streamsets data collector is preferred. Essential Skills:
    • Ability to read and interpret technical documents and others such as safety rules, operating and maintenance instructions, and procedure manual.
    • Ability to think strategically and evaluate options for a short, medium- and long-term delivery
    • Ability to translate business and feature requirements into technical specifications
    • Ability to read, analyze, and interpret financial reports, technical procedures, or governmental regulations, safety rules, operating and maintenance instructions, and procedure manual
    • Ability to write reports, business correspondence, and technical procedure manuals
    • Ability to effectively present information and respond to questions from groups of managers, customers, and co-workers
    • Ability to solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists
    • Ability to interpret a variety of instructions furnished in written, oral, diagram, or schedule form
    • Ability to scope, execute and deliver projects in a timely and cost-effective manner Environment: While performing the duties of this job, the employee is regularly required to sit, use hands to finger, handle, or feel; reach with hands and arms; stoop, kneel, crouch, or crawl and talk or hear. Specific vision abilities required by this job include close vision, peripheral vision and ability to adjust focus. The employee must occasionally lift and/or move up to 25 pounds. The employee is regularly exposed to ambient lighting and temperate climate conditions. [1]The following statements are intended to describe the general nature and level of work being performed. They are not intended to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified. [2] Job Duties as documented in this job description are considered "Essential Functions" and have been created by the standards of the Equal Employment Opportunity Commission (EEOC). The standards of the Americans with Disabilities Act (1990) require that employees be able to perform "Essential Functions" of the job with or without reasonable accommodation. Reasonable accommodations may be made to enable individuals with disabilities to perform the "Essential Functions".

Keywords: Geodis, Nashville , ETL Developer II, IT / Software / Systems , Nashville, Tennessee