Oracle Data Engineer -10 Years Experience (F2F Interview)

Role: Data Engineer- Oracle Location NYC, NY-Onsite Duration 6+ Months Visa Independent Effective communication and interpersonal skills for the purpose of understanding complex technical issues and solutions Requirement 10+ years of Oracle Database Development Experience through all development life cycle phases Advanced knowledge in Oracle PL/SQL – coding, analysis, design and creation of custom packages, stored procedures, functions, and triggers Advanced knowledge of Oracle Scheduler integration for on-demand requirements Advanced ability to analyze and create high performance SQL queries over very large datasets Advanced knowledge in Dynamic SQL and BULK Collection methodologies Advanced capability in ETL functions using External tables, Oracle’s UTL\_FILE package, and SQL Loader Advanced capability in DDL and DML scripting Advanced capability in LINUX shell scripting Advanced capability in Database development IDE; Quest Toad for Oracle or other Advanced capability in AWS Workspace development environment Beginner level GitLab code repositories; SourceTree or other git tools Ability to collaborate with team members, Product Managers, subject matter experts, and other teams to refine requirements and translate into functional software using standardized coding techniques and conventions Advanced problem-solving and analytical skills Beginner+ understanding of development life cycle phases, CI/CD, DevOps, unit & integration testing, documentation and solution delivery in cloud systems Nice To Have Item Knowledge of the industry standard CWR specification is a big plus Experience working with Globalscape EFT Advanced Workflow scripting Experience working with Crystal Reports UI PHP Object-oriented programming experience Knowledge of AWS technology