Previous Job
Previous
Data Engineer
Ref No.: 19-11275
Location: San Francisco, California
Interview Type: Phone + Onsite interview
PN: Please source local candidates only as there will be an onsite interview and the client will not reimburse travel expense.

Job Scope: Preferred Requirements:
Preferred degree: Computer Science or Information Systems
  • 5 to 9+ years of experience developing and supporting moderate to complex data warehouses or data marts: Strong Experience in Installing and/or Upgrading Informatica;
  • ETL Tools (Informatica, MS SQL Server DTS, etc.);
  • Data Modeling - Dimensional and Normalized Relational;
  • SQL (MS SQL Server, Oracle, etc.);
  • Business Intelligence Tool (Business Objects, Tableau, Microstrategy, JasperSoft);
  • OLAP & Data Mining; Operating System Environment basic knowledge (Windows, Unix, etc.);
  • HTML; JavaScript; Python; Spark, Hive, SQL and other Hadoop framework components; Flume-Kafka integration; AWS Cloud; experience in Informatica Data Quality (IDQ).
Qualification:
  • The Information Technology organization is hiring a Data Warehouse Developer.
  • The Data Warehouse Developer is responsible for developing, testing, implementing, debugging, and supporting computer software used to create data warehouse applications.
  • This includes data design, database architecture, metadata and repository creation, identification and resolution of information flow, content issues, and transformation of business requirements, troubleshooting problems and tuning existing warehouse applications.
  • We are looking for the Data Warehouse Developer to be customer focused, drive for success, put an emphasis on teamwork, effective communication, innovation and flexibility and adaptability.
  • Data Warehouse Application Developers are responsible for detailed technical design, development, and support of software applications using existing or new technology platforms.
  • They formulate concepts and develop solutions using defined user requirements and are able to interpret requirements and work with the customer to clarify requirements as needed.
  • They design, code, test, and document enhancements to existing systems of high complexity and scope, working with common application designs and specifications, utilizing industry and System standard procedures, products and methodologies, and execute performance and stress testing, as necessary.
Essential Job Responsibilities (include but are not limited to the following):
  • Develop software from user requirements
  • Solution Architecture
  • Data modeling
  • High-Level data movement (staging and processing)
  • Research data sources
  • Profile/Analyze source data
  • Staging and Dimensional table creation
  • Security modeling
  • Develop ETL
  • Code, in the ETL tool, the extraction, transformation and loading of data from source systems to the data warehouse
  • Create OLAP data Cubes
  • Implement user interface design using style sheets and gifs as provided by creative design from Analyst
  • Translate creative design into code
  • Work with Analyst Role as needed for Preliminary Use Cases
  • Expand/Implement Requirements
  • Create prototypes
  • Code software following standard design patterns.
Position Requirements: Qualifications/Education:
  • Education and Experience: 5 to 9+ years of relevant work experience Bachelor's degree or equivalent experience