Database Extract Transfer Load Jobs in New York (NOW HIRING)

Job Description

Our client in Roslyn NY has an immediate need for DATABASE DEVELOPER.

Main skills:

ORACLE 11,12, ENTERPRISE EDITION

OLAP

DWH

LONG TERM CONTACT

General Summary:

Provide expertise in many areas of data management including but not limited to data warehousing, data warehouse reporting, data analysis, data architecture and design, data access security, data availability standards and methods, and data integration Ability to provide support for OLAP reporting applications by designing and implementing ETL processes and staging database structures, OLAP database structures including fact and dimension tables, and process flow procedures, based on end-user requirements.

Essential Duties & Responsibilities:

Responsible for designing, developing, and maintaining data warehouse and analytics architecture to meet an enterprise's business analysis and reporting needs.

Works with architects and business partners to fashion out the technical vision for applications in Customer Data Warehouses employing PL/SQL, SQL, Oracle EE database.

Consolidate and optimize available data warehouse infrastructure

Conceive analytics and business intelligence platform architecture for clients, including internal and third-party clients

Design and implement ETL procedures for intake of data from both internal and outside sources; as well as ensure data is verified and quality is checked

Design and implement ETL processes and data architecture to ensure proper functioning of analytics in SAP BI, as well as client's reporting environments and dashboard

Collaborate with business and technology stakeholders in ensuring data warehouse architecture development and utilization

Carry out monitoring, tuning, and database performance analysis

Perform the design and extension of data marts, meta data, and data models

Ensure all data warehouse architecture codes are maintained in a version control system.

Work closely with the Software Development Manager, Programmer/Analyst, and Project Management Office (PMO) to understand business requirements, source to target mappings, data models, and universe designs in order to develop highly efficient and highly scalable ETL processes and Universe data foundation ensuring delivery of business needs in a timely manner

Provides production support for existing ETL and universes

Responsible for learning, applying, refining established ETL development standards

Other duties as assigned.

Qualifications

Education & Qualifications:

Bachelor's degree (B.S.) in computer science or related field plus required experience

Minimum 3 years Data Warehousing/ETL experience

Minimum 2 years experience using Oracle

Demonstrated knowledge of database concepts of data modeling and mapping including normalization, dimensionality, referential integrity, indexes, keys, common dimensions, star and snowflake schemas, master data and metadata (MUST know how to read models and mappings)

Experience in developing ETL processes for Data Warehouse, Data Marts and/or Operational Data Stores, as well as, in operationalization of ETL and all dependent processes

Experience in identifying performance issues, SQL optimization, and designing high performing ETL processes

Must possess a deep understanding of DW and BI concepts in a large organization using multiple applications and various data sources, as well as, knowledge of Data Modeling/ Analysis/Data Integration best practices

Must be able to troubleshoot existing ETL code to resolve issues (e.g. join and performance issues)

Experience working with transactional databases, MS Excel, Web Services, and various other formats as data sources

Demonstrated experience across numerous data warehousing/data integration projects, as well as, the ability to work with other project team members and business users to resolve moderately complex data integration issues

Must possess sound understanding of Software Development Life Cycle (SDLC)

Strong SQL and Oracle PL/SQL skills. Must be able to read and write, and optimize SQL

Proficient in a variety of computer programming languages in order to successfully complete the tasks of the role

Familiarity working with source control tools, GIT preferred

DBA or database development experience (a plus)

Ability to multi-task with minimal supervision

Knowledge of .NET (a plus)

Additional Information

All your information will be kept confidential according to EEO guidelines.