Description

ETL Developer.

ONSITE: times/week (Tuesday + Thursdays, and other ad hoc day as needed)

Contract Duration: 01/27/2025 to 06/27/2025 – 6 months

Program needs ETL Developer. Implementation is planned for Jun-2025. CCaaS Program – Contact centre as a service project/program – this role will be working with Campaign management team – manage control monitor the flow of campaigns that go out to different channels (scotia online, mobile, contact center)

Candidate Value Proposition:

The successful candidate will have the opportunity to understand how campaigns are managed and launched in a banking environment.

Typical Day in Role:

• Work as ETL Developer in AIX environment

• Tech stack: Oracle Data Integrator (ODI)

• Analyze highly complex business requirements; generate technical specifications to design or redesign complex software components and applications.

• Act as an expert technical resource for modeling, simulation and analysis efforts. Leverage industry best practices to design, test, implement and support a solution.

• Assure quality security and compliance requirements are met for supported area. Be flexible and thrive in an evolving environment.

• Adapt to change quickly and adjust work accordingly in a positive manner.

• Interacting with team leads, QA testing team, business

• Collaborative environment

Candidate Requirements/Must Have Skills:

1) 5+ years’ experience as an ETL Developer

2) 3+ years in AIX environment

3) 3+ years’ experience with Oracle databases

4) 3+ years’ experience of ETL development using Oracle Data Integrator (ODI)

Nice-To-Have Skills:

1) Experience with these ETL tools:

- Microsoft SQL server Integration Services (SSIS)

- DataStage from IBM

- Informatica

2) Experience with SQL Loader and SQL blocks

3) Exposure to large highly matrixed organizations

Soft Skills Required:

• Strong communication skills

• Team player, collaborative mindset

• Attention to detail

Education:

Bachelor's degree in a technical field such as computer science, computer engineering or related field

Best is a strong ETL developer who has recent experience working with Oracle and ODI in an AIX environment