Senior ETL Developer

Job Title: Senior ETL Developer – Data Services Team

Key Duties

• Plays a lead role in the areas of ETL design, data modeling, and ETL development.

• Facilitates best practice guidelines around all stages of development.

• Provides technical leadership to serve as point of escalation, review, and approval for key issues, significant projects, and decisions.

• Able to work with stakeholders, and translate requirements to design and build a solution that will meet Business needs and integrate seamlessly with the EDW.

• Gain team and stakeholder approval for all designs, and effort estimates.

• Research and analyze current systems, subsystems and interfaces to understand the current or new process flow.

• Document work via Functional and Tech Specs.

• Develop unit tests, performance tests, and take into account security requirements.

• Prepare and participate in design and code reviews.

• Analyzes processes for gaps and weaknesses, building future state models and creating the roadmaps and migration plans to get there.

• Communicate progress and work using the Agile Methodology.

Job-Specific Skills

• Required:

• 5+ years of experience of with Oracle
• 5+ years of experience with Data Warehousing: building relational databases, star schemas
• 5+ years of experience with Data Modeling
• 4+ years of experience with ODI (Oracle Data Integrator Tool) or Informatica IDMC.
• 3+ years of experience with Databricks Lakehouse and/or Delta tables.
• 2+ years of experience in the design, implementation, and support of a Kimball method data warehouse on SQL Server or Oracle
• Strong SQL reading and writing skills
• Business and/or technical background in the areas of Data Integration (ETL), Data Security, and Enterprise Data Warehouse development
• Experience in Change Management, Release Management, and Source Code control practices

Education

• High school diploma or equivalent is required.

• A Bachelor of Arts or a Bachelor of Science degree, with a focus in computer science, systems analysis, or a related area, is preferred.