Previous Job
Previous
ETL Developer w/ Python and Oracle
Ref No.: 18-02722
Location: Newport Beach, California
Position Type:Contract

Primary responsibilities will include:
  • Designs and builds conceptual, logical and physical dimensional data models and third normal form artifacts.
  • Supports new data development, ensuring consistency and integration with existing data warehouse structure and framework.
· Demonstrate knowledge in writing, understanding and tuning PL/SQL and/or T-SQL is a must
· Understanding of relational database concepts and experience with data modeling is a must
· Highly skilled in OOP design and development, preferably in Python and Perl
  • Develop and maintain data architecture framework and standards.
  • Domain knowledge of Financial Services preferred
  • Serves as Subject Matter Expert in data warehouse concepts (star schema, snowflake schemas, and normalized and de-normalized data models). Analyzes performance statistics and recommend improvements.

Position Requirements:
  • Sophisticated knowledge with Data Architecture (conceptual, logical, physical, transactional, dimensional, and Star/Snowflake modeling).
  • Ability to design and visualize a system's architectural blueprints using UML, ERD, and Data flow diagrams.
  • Expertise in Oracle enterprise relational database with experience in query optimization and performance tuning.
  • Ability to design and participate in application discovery and architecture workshops.
  • Good interpersonal and communication skills are essential, as well as the ability to work well in a team environment.
  • Experience in banking or financial services preferred.

Basic Qualifications:
  • BS/BA degree in Computer Science, Information Systems, Engineering or related fields or equivalent experience
  • 9+ Professional working experience
  • 8+ years relevant work experience in technology environment
  • Experience in Asset Management is a plus
  • Experience in agile development is a plus