: Los Angeles, CA, USA
: Not Specified
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.
Contract - Corp-to-Corp
Contract to Hire - W2
Contract - W2
Share This Job
Inabia Software & Consulting
Allied Informatics, Inc.