EDW Cloud Programmer/Analyst

01 Dec 2024

Vacancy expired!

Enterprise Data Warehouse (EDW) Programmer/Analyst

Location: Orlando, FL

JOB OVERVIEW:The Sr. Programmer Analyst - EDW will provide technical expertise in designing and implementing data integrations for data warehouse/business intelligence solutions leveraging Extract, Transform and Load (ETL/ELT) tools such as Informatica. Create technical design specifications from business/functional requirements. Work with internal stakeholders to clarify data integration and system requirements as appropriate. Configure, program/create ETL solutions and unit test development work to ensure quality. Work within the SDLC methodology and adhere to technical architecture standards. Proactively identify potential problems and issues and actively communicate and manage issues to resolution. Work closely with multiple functional areas to understand data and assist in data architecture design. Provide assistance to IT and business users to effectively understand and leverage data and make it available to the business in a useful, usable format. Begin to use and explore Cloud ELT tools and development. Support replication of the on-premise Data Warehouse to the Cloud, and gain expertise and understanding of Snowflake cloud data warehouse.

REQUIRED TECHNICAL SKILLS:
  • 5+ years programing/analysis experience
  • Minimum of 3 years’ experience with developing complex ETL integrations in a large organization (Cloud ETLs IICS/Talend preferred)
  • Minimum 3 years’ experience programming in SQL
  • Extensive experience in extract, transform and load, data profiling, data quality, metadata management and data intake for large complex data systems
  • Demonstrated ability to analyze, verify, and document the accuracy of the developed ETL code through self-directed testing
  • Hands on experience with Informatica and/or cloud ELT technologies, including demonstrated strong SQL coding skills
  • A strong familiarity with general DBMS concepts
  • Knowledge of best practices through relevant experience across data-related disciplines and technologies particularly for enterprise wide data architectures and data warehousing/BI
  • Ability to prepare design documentation to express necessary details for review and ongoing maintenance
  • Resolve end user reporting problems through collaboration with both technical and functional personnel in a team environment
Education: At least a Bachelor’s Degree (or equivalent experience) in Computer Science, Software/Electronics Engineering, Information Systems or closely related field is required.

  • ID: #23694644
  • State: Florida Orlando 32801 Orlando USA
  • City: Orlando
  • Salary: $120,000 - $125,000
  • Job type: Permanent
  • Showed: 2021-12-01
  • Deadline: 2022-01-28
  • Category: Et cetera