Job Description :
The Senior ETL Developer will:
Design complex data movement, manipulation, and delivery solutions from multiple sources systems into our Operational Data Stores, Data Warehouse through to our Data marts.
Collaborate with Business Analysts, Architects and Development teams to analyze and design appropriate Business Intelligence solutions while balancing delivery priorities, development efforts and problem resolutions.
Contribute to the design and development of complex BI solutions accounting for data movement, manipulation, delivery, and presentation using the latest technologies from Oracle, SAP Business Objects, and MicroStrategy.
Leverage technology such as Oracle 12c database, Oracle GoldenGate, PL/SQL and SAP Data Services to manipulate and deliver data organized to support near real time data analytic capabilities for use by decision makers in Ad Sales, Finance, Programming, Production Operations and other areas. As a Senior Developer, you will be responsible for:
Partner with our Development team to understand application data models, create ETL designs, detailed technical specifications and develop ETL code with optimized queries and calculations to produce data management solutions meeting our business partners'' needs.
Design and construct data solutions for efficient and reliable data accessibility.
Design and construct data transformation and data movement solutions into 3NF and Dimensional data stores.
Performance test and optimize all developed solutions.
Support quality assurance and release management of ETL code.
Troubleshoot support tickets for operational issues.

Basic Qualifications
Must have professional work experience with the following:
- 5+ years of experience working as an Oracle database developer (Oracle Database 11g or greater),
- 5+ years of working in a data warehousing environment,
PL/SQL ETL development and database performance tuning, and 3NF ODS/DW structures.
- Ability to develop, implement and maintain standards established by the Architecture and Development teams.
- Robust data analysis and root cause analysis skills.
- Independent thinker and self-motivated.
- Data movement architectural patterns, and a thorough understanding of system development lifecycles.
- Experience in data modeling, data mapping, and data architecture; Enterprise Job Scheduler software
- A thorough understanding of system development lifecycles
- An ability to work in an agile environment.

Preferred Qualifications:
Exposure with the below technologies and/or skills will be considered a plus: Oracle 12c, Oracle GoldenGate 12c, SAP Data Services 4.2

Client : Intelliswift Software Inc.