Need ETL Developer// PL/SQL Developer// Apex Developer// ArcGIS Developer

Hi,

Hope you are doing well.

We have couple of open positions.

Location: Brooklyn NY

Mode of interview: In-person interview

35 hours per weekly

1. ETL Developer

Develop complex data pipelines to bring data into the Data Lake/Warehouse per business requirements.

Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities.

Proficient in SQL and ETL processes, ETL and DB performance tuning.

Design the architecture to perform data management activities i.e., data extraction, transformation, and load (ETL) to enterprise data warehouse. Implement the data management solutions using SQL, SQL procedures, data management tools like Informatica IICS on Oracle exadata database.

Design the overall architecture to Extract, Transform and Load (ETL) data into data warehouse or data mart and data lake.

Oracle database full life cycle development including data modeling, database architecture, SQL and PL/SQL development, unit testing and support.

Expertise in PL/SQL Programming including Data Types, Cursors, Exception Handling Collections, Merge statements, Analytics Functions, Views, Materialized Views, Table Functions, Stored procedures, Functions and Packages, database triggers, mutating, Dynamic SQLs, External Tables, Performance Tuning, Object Programming, built in functions, joins, aggregate functions, Collections.

Working experience with ETL tool (Preferred - Informatica - IICS)

Develop data models and ER diagrams for existing and new databases.

Passionate about complex data structures and problem solving.

High attention to detail.

Ability to pick up new data tools and concepts quickly.

Maintain and improve already existing processes.

Any Experience in public safety systems is a plus.

2. PL/SQL Developer:

• Oracle database development life cycle, including data modeling, architecture design, SQL/PLSQL development, unit testing, and production support.
• Good exposure of new Oracle version s inbuilt functions and features.
• Create, enhance, and maintain reusable database objects.
• Perform SQL query optimization and tuning to maximize speed and scale.
• Apply working knowledge of Oracle REST Data Services (ORDS) and API Gateway Cloud for database integration and API management.
• Demonstrate deep expertise in PL/SQL programming, covering:

Advanced data types BLOBs CLOBs, cursors, and exception handling. Collections and merge statements
Analytic functions, Index, views, and materialized views. Table functions, stored procedures, functions, and packages. Database triggers and dynamic SQL. External tables and object programming. SQL built-in functions, joins, and aggregate functions. Comprehensive performance tuning techniques

3. Apex Developer

Expert-level knowledge of Apex is required with demonstrated application development experience in the newer versions of Oracle Apex at least version 18.2 or higher. The candidate should also have experience developing Apex applications in large teams with multiple developers working in parallel. Strong knowledge of relevant JavaScript libraries/frameworks typically used and supported by Oracle Apex is also necessary to enable the development of modern UIs. Should also have a strong proficiency in backend database design and development with Oracle 11g/12c or higher including creating packages, procedures, functions, materialized views and complex SQL queries. Must be able to collaborate with DevOps and Server administrators to investigate and troubleshoot errors. Follow architecture team s coding standards and best practices.

MANDATORY SKILLS/EXPERIENCE

• Expert-level knowledge and understanding of Oracle Apex
• Hands-on experience in using HTML and CSS to customize the look & feel and behavior of Oracle Apex applications
• Strong knowledge of APEX Universal Theme and know how to use it for various UI requirements
• Strong understanding of the out-of-the-box CSS available in Oracle Apex and how to utilize them
• Demonstrated experience in newer versions of Oracle Apex at least version 21.3 or above
• Extensive knowledge of JavaScript libraries/frameworks used with Oracle Apex jQuery and Oracle JET
• Proficient in developing and consuming REST APIs and with Oracle Rest Data Services (ORDS)
• Good understanding of the structure of XML, JSON, DOM
• Proficient in Oracle 11g/12c or higher databases
• Oracle Database Design and development (SQL & PL/SQL) with respect to Application Development
• Strong working knowledge in PL/SQL coding and Application Express API
• Strong working skills on integrate with CSS class and JavaScript event inside SQL, and know how to write application process for the JavaScript event to meet functionality requirements
• Good understanding of Views, MVs, dB links and refresh methods
• Experience in creating and remodeling legacy data models for Human Resource Management Systems
• Ability to analyze and resolve complex infrastructure resource and application deployment issues

DESIRABLE SKILLS/EXPERIENCE

• Knowledge of Oracle Forms and Reports and OBIEE reporting tool is a plus
• Knowledge in database migration, performance tuning and optimization in 12c environment
• Good knowledge of ERWIN or another data modelling tool
• Experience in ETL, data load process, delta load process and data migration a plus
• Good knowledge of JSON files development and storage using standards and best practices in Oracle 12c
• Experience in APEX Custom Plug-in development
• Experience in Oracle APEX database installation and troubleshooting
• Proven ability to work creatively and analytically in a problem-solving environment

4. Arc GIS Developer:

MANDATORY SKILLS/EXPERIENCE

• 5+ years of professional experience in software development with a focus on GIS
• ArcGIS Enterprise: Deep understanding of Portal for ArcGIS, GeoEvent Server, ArcGIS Server, and Data Store.
• Application Development: Build and deploy interactive web mapping applications using the ArcGIS Maps SDK for JavaScript and Java, Spring Boot
• Python: Advanced scripting for geoprocessing
• SQL: Proficiency in writing complex spatial joins and queries

DESIRABLE SKILLS/EXPERIENCE

• ArcGIS API for Python: Experience using this for "DevOps for GIS" automating user management, content audits, and cloning environments between Dev, Test, and Production.
• ArcGIS Maps SDK for JavaScript (4.x): Mastery of the 4.x series, particularly creating custom widgets and handling 3D visualizations.
• Web Frameworks: Proficiency in Spring Boot, React, Angular, or Vue.js is highly desirable. Most modern ArcGIS web apps (built with the Maps SDK for JS) are integrated into these frameworks.