What are the responsibilities and job description for the Oracle Developer with ETL position at ICONMA?
7-10 years’ experience in Oracle Exadata, SQL, PL/SQL
Implement ETL solutions for large volume of data by applying various data warehouse modeling techniques like Star Schema, Data partitioning, Data compression, Direct path loads etc. and that maximizes re-usable components and services that incorporate versioning, reconciliation and exception handling
2-3 years’ experience in SQL Performance tuning. Perform application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, AUTOTRACE and AWR Reports.
Should have a clear understanding of Oracle Server Process Architecture and memory structures PGA (Program Global Areas) SGA (System Global Areas) to optimize memory usage.
Knowledge about Oracle VPD
Expertise in performance profiling, ability to identify performance improvements and memory optimizations
Strong coding, debugging, and analytical skills
Knowledge about Oracle architecture and process
Knowledge of computer science data structures and algorithms
Experience with Analytic reporting tools like Tableau
Experience working in regulatory projects is strongly desirable
Experience working in Containers
Knowledge about Python and Apache Airflow
Maintain high standard and follow best practices by re-factoring existing code to enhance readability, performance and general structure
Experience in CICD, Jenkins, Git
Experience working in Agile teams
As an equal opportunity employer, ICONMA provides an employment environment that supports and encourages the abilities of all persons without regard to race, color, religion, gender, sexual orientation, gender identity or express, ethnicity, national origin, age, disability status, political affiliation, genetics, marital status, protected veteran status, or any other characteristic protected by federal, state, or local laws.
Keep a pulse on the job market with advanced job matching technology.
If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution.
Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right.
Surveys & Data Sets
What is the career path for a Oracle Developer with ETL?
Sign up to receive alerts about other jobs on the Oracle Developer with ETL career path by checking the boxes next to the positions that interest you.
