Sr. Data Architect

Arka Infotech Inc; Portsmouth (NH); On-site; USD 125,000 - 170,000; Full time

Job summary

Arka Infotech Inc. in Portsmouth, NH seeks a Senior Data Architect to lead data warehouse design and implementation on a 6++ month contract. Requires Oracle DB, PL/SQL, Cognos, SAP Data Services ETL, and ERP Oracle E-Business Suite experience.

Ideal candidates have 9+ years in data warehousing, strong communication, and business acumen; retail/manufacturing domain experience is a plus.

Qualifications

• 9 years of data warehouse experience with at least 5 years in physical and dimensional data modeling, process modeling, and data mart/warehouse design.
• Oracle database concepts including performance optimization strategies.
• Experience using Oracle Change Data Capture publish/subscribe functionality.
• Experience using Oracle utilities to research and troubleshoot data issues.
• Experience using SAP Data Services ETL tool suite.
• Designing, developing and testing PL/SQL scripts for ETL development.
• Excellent written and communication skills.

Skills

Oracle Database

PL/SQL

Data Warehousing

Data Modeling

Oracle CDC

Oracle Utilities

ERP Oracle EBS

Data Quality

Communication Skills

Education

BS Degree

Tools

SAP Data Services

Job description

Senior Data Architect

Location: Portsmouth, NH

Duration: 6++ Months

SKILLS / QUALIFICATIONS

• 9 years of relevant data warehouse experience including at least 5 year experience in:
• Physical and dimensional data modeling, process modeling and data mart / warehouse design
• Oracle database concepts including performance optimization strategies
• Experience using Oracle Change Data Capture publish / subscribe functionality
• Experience using Oracle utilities to research and troubleshoot data issues
• Experience using SAP Data Services ETL tool suite
• Designing, developing and testing PL/SQL scripts for ETL development
• Strong business acumen, preferably with experience working in a consumer product goods retail environment and / or in a manufacturing environment
• ERP software experience, preferably with Oracle E-Business Suite
• Excellent written and communication skills

MUST HAVE

• Oracle Database, PL/SQL
• Cognos
• SAP Data Services ETL Tool

Qualifications

BS Degree

Additional Information

• MUST HAVE
• Oracle Database, PL/SQL
• Cognos
• SAP Data Services ETL Tool