Company Details

Data Engineer

Job ID

: 22383

Location

: Los Angeles, CA, USA

Salary

: Not Specified

Job Views

: 203

Posted

: 08-06-2019

Key Skills

Informatica Cloud

Job Description

Responsibilities and Duties

  • Strong analytic skills related to working with structured and unstructured datasets.
  • Build processes supporting data transformation, data structures, metadata, dependency and workload management.
  • Create complex SQL queries and perform ad-hoc and exploratory data analysis
  • Involved in profiling and understanding the data set received from various sourcesĀ 
  • Help drive optimization, testing and tooling to improve data quality
  • Investigate data anomalies and perform Root Cause Analysis (RCA)
  • Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
  • Build data models, dictionaries, and other database documentation across multiple applications
  • Discover new dimensions and uses for existing data for improve existing platform capabilities.
  • Work and interact with functional and integration teams on architecture and design
  • Develop, maintain, and enhance Informatica Cloud Mappings, Task Flows, and processes (Data Synchronization, Data replication)
  • Knowledge of RDBMS platforms Oracle and Snowflake

Qualifications and Skills

  • Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.
  • A successful history of manipulating, processing and extracting value from large disconnected datasets.
  • Must have strong experience with Informatica Cloud (ICS)
  • Best practices Informatica Cloud development skills
  • Knowledge of Informatica Cloud issues with workarounds to resolve
  • Snowflake data warehouse experience (preferred)
  • Experience with Oracle Cloud Aps, Oracle Transportation and Logfire (preferred)
  • Strong written and verbal communication skills and client stakeholder management.
  • Ability to effectively work in team environment with multiple skill set levels.
  • Experience working with and managing Offshore teams.

Advanced Search