ETL DEVELOPER

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.