Etl Developer - Pl/Sql

Infotek Consulting is looking for a senior ETL Developer

Finance and risk teams, data ingestion and pre-staging work Project: Support development of FRDP LZ/Pre-stg ingestion pipelines – support regulatory reporting – in the middle of the project; sourcing big data ingestion

Candidate Value Proposition: The successful candidate will have the opportunity to gain exposure to finance and risk teams for a big bank, exposure to different stakeholders, work with big data including open source applications.

Typical Day in Role:

• Act as a technical lead for the data initiative. Deliverable includes: mapping specification, data model, design, creating complex ELT pipelines, conducting unit tests, deployment using devops.

• Working with the business analysts to translate the business requirements and functional specifications into an application design appropriate to meet the business and operational/IT needs

• Work with Quality Assurance (QA) to code, test, and debug extensions/tools integration services

• Analysis, design and development work on complex data pipelines

• Ensuring compliance with architecture framework and system standards, and Agile Development Methodology

• Software Development Lifecycle (SDLC) end-to-end Agile/scrum and Waterfall methodologies

• Primarily working at data ingestion for batch and real time processing Candidate

Requirements/Must Have Skills:

1) 8+ years’ experience as a developer

2) 5+ years’ designing, building, automating and optimizing complex data ETL/ELT processes

3) 8+ years’ creating data assets (denormalized) from highly normalized Oracle database, and load the data asset to another type of DBMS (MS SQL, PostgreSQL, etc.) using demonstrated advanced SQL skills (PL/SQL, TSQL) as well as performance tuning

4) 5+ years’ scripting languages (Java, Python, Unix shell)

5) 5+ years’ experience with data warehousing design and development with focus on extracting, transforming data coming from various data sources and loading into star/snowflake schemas

Nice-To-Have Skills:

1) Familiar with one or more ETL/ELT tools (DataStage, Talend, NiFi, Spark,)

2) Working knowledge of issue tracking system JIRA, Azure DevOps

3) Using Git hub for version control and data model changes

4) Cloud technologies (Azure, Google, AWS)

5) Oracle Exadata 6) Experience from FI/banking an asset