Your browser cookies must be enabled in order to apply for this job. Please contact support@jobscore.com if you need further instruction on how to do that.

Database Developer/ETL-29103-NJ

Information Technology | Irving, TX | Full Time

Job Description

8+ years of Oracle 11g or 12c, SQL and/or PL/SQL 5+ years' experienceinETL process developmentwith large record volumes
- 3+ years of OracleData Integrator (ODI)development
- 5+ years of experienceinOracle DDL scripting
- 5+ years of experiencein Oracle PL/SQL packages (DBMS_*, UTL_*)
- 5+ years of experience creating and implementing physical databases from relational and dimensional logical data models
- Expert inOracle SQL Loader
- Experience with Big Data technologies, distributed file systems, Hadoop, HDFS, Hive, Hbase is a plus
- Expeirence in DevOps, Agile Methodologies, CI/CD methods and tools, e.g. JIRA, Jenkins, is a huge plus
- Excellent skills in Cloud development on Cloud Foundry, AWS (Amazon Web Services)
- Extensive experience withdatatransfers and data sharing usingflat files, database links, and web services
- Must be familiar with current version of Oracle 11g or 12c, Advanced SQL and PL/SQL, Application development experience in an Oracle environment,DataModeling/Relational Database Design
- Experience in planning space allocation, creating and managing table spaces, partitioning strategies.
- Database optimization experience with Oracle DBMS and experience using database-monitoring tools
- 4year degree in Computer Science, Information Systems, or equivalent
- Working knowledge ofnetworks is a plus
- Working knowledge of Linux OS and UNIX shell scripting
- Working knowledge of software version control concepts and change management processes
- Working knowledge of ETL processes
- Working knowledge of data modeling concepts both relational and dimensional
- Good understanding of knowledge Hyperion EPM infrastructure
- Deep understanding of automated job scheduling (ESPX, Autosys), version control concepts, and SDLC.
- Understanding of authentication and authorization security concepts
- Understanding of all phases of the Systems Development Life Cycle (SDLC)
- Demonstrated expertise in change management and version controlpractices
- Detailed oriented, resourceful, motivated andcreative
- Flexible, organized and able to handle competing priorities
- Sound, logic based decision making and Quick learner
- Strong verbal and written communication skills
- Workcollaboratively and cross-functionallyas part of a team as well as an independently
- Possess the ability to motivate and maintain effective working relationships with internal and external teams.
- Work proactively and reactively
- Recognize areas of opportunity and make recommendations for improvement
- Assess conflicting priorities and prioritize appropriately
- Communicate at all levels of the organization including IT and customer senior management
- Identify issues to leads and/or management and provide possible solutions
- Provide timely and accurate status on job assignments
- Finance & Telecom background preferred.
- Bachelor's degree or Master's degree in Computer Science or equivalent work experience