Senior ETL Developer

Title: Senior ETL Developer

Location: Orlando, FL

Duration: Full Time

Roles & RESPONSIBILITIES:

-Work closely with key stakeholders and other project team members to understand and prioritize functional requirements and information needs. Participate in the development of functional requirements and design specifications as appropriate.

-Develop, create and document technical specifications and designs from which applications and/or technical solutions can be developed that satisfy documented business /functional requirements; envision potential future requirements and business needs to ensure solutions are flexible and extensible.

-Design and implement robust, efficient extract, transform, and load applications and processes to load data and supporting metadata into the Enterprise Data Warehouse using Informatica and other tools and languages; this includes implementation of parsing rules to assure selection of accurate data, transformation of data into the required format and structure to support the business requirements, loading the transformed data into the target database and the associated metadata, and where applicable, aggregations of data.

-Ensure that all code / technical configurations and other work products are thoroughly unit-tested prior to delivery. Participate in system/integration testing as appropriate. Perform code reviews and other QA steps as requested.

-Responsible for the ongoing operational stability and maintenance of the ETL/ELT processes, systems, and data, ensuring they are properly monitored and audited to provide data integrity, accuracy and timeliness of delivery. This includes being on call to support production systems.

-Work closely with Data Architect/Modeler, Business Analysts and BI Developers to understand requirements and use technology and best practices to develop ETL processes in support of the requirements, validating that they meet business and technical specifications.

-Lead small projects, documenting programs and systems according to published standards.

-Proactively identify and communicate potential problems and issues to project team members/leaders, including identifying alternatives and recommending/implementing solutions as appropriate.

-Ensure accurate project status and work estimates (ETCs) are always reported /communicated to project leaders/managers in a timely fashion. Develop detailed project and task estimates as needed.

-Effectively communicate with stakeholders throughout the project lifecycle. Ensure issues are analyzed, discussed and resolved in a timely manner.

-Consistently enhance skills and job knowledge by researching new relevant technologies and software products and trends; reading professional publications; maintaining personal networks; participating in professional organizations.

REQUIRED TECHNICAL SKILLS:

-5+ years programing/analysis experience

-Minimum of 3 years’ experience with developing complex ETL integrations in a large organization (Informatica preferred)

-Minimum 3 years’ experience programming in SQL

-Minimum 2 years’ experience coding in Python

-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

-Experience working on Snowflake

-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

REQUIRED EDUCATION:

-BS / BA in MIS, Computer Science, Business, Mathematics or Engineering

OTHER KEY QUALIFICATIONS:

-Ability to work independently, take ownership of tasks and follow through to implementation/resolution

-Strong verbal and written communication skills with an ability to express complex technical concepts in business terms and complex business concepts in technical terms

-Ability to prioritize and multi-task across numerous work streams

-Highly developed analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems in order to effectively develop technical solutions to their requirements

PREFERRED SKILLS AND EXPERIENCE:

-Experience with PL/SQL Developer

-Working experience with revision control systems, Linux platform, Shell scripting, and big data

-Microsoft Azure, Databricks, Spark SQL, cloud technologies and tools

-Understanding of SDKs and Rest API calls

-Experience with customer/guest data and systems; knowledge of restaurant business