Data Engineer at Remote, Remote, USA |
Email: [email protected] |
From: vivek, vyzeinc [email protected] Reply to: [email protected] Data Engineer - 100% REMOTE state of Texas (railroad agency in Austin TX) - this is 100% remote - 6 to 12 months Try to submit a Texas candidate . They must meet the minimums on this form and must submit 3 full references if interested (we do not call these references by the way but they must fill them out) This candidate will be using Informatica Cloud to build mass ingestion pipelines or other ELs from an Oracle transaction database(s) to our Snowflake Data Lake. Performs advanced (senior-level) Data Pipeline development work with Informatica Cloud (IICS) including data integration, source-to-target data modeling, Extract-Transaction-Load development, consuming Oracle data connections, RESTful API application-based data connections, targeting Snowflake data connections, designing Snowflake target data lake databases, data warehouse modeling with ELT. Additional duties may include working within Snowflake to create other API-based data ingestion routines and/or setting up Data Sharing of these accumulated data. Dimensional modeling of data may be required in our Data Warehouse to accomplish other objectives like data reporting and improved performance data handling. Development of ETL/ELT data mappings and workflows for data pipeline development with Informatica Cloud Data Integration. Practical experience using and building Informatica Mass Ingestion Pipelines. Demonstrated experience with Oracle Database as a Data Connector source. Expert with Snowflake as a Target database platform. Experience with the Snowflake platform and ecosystem. Knowledge of Snowflake data sharing and Snowpark is a plus. Knowledge of the advantages as well as previous experience working with Informatica push-down optimization Experience with Snowflake database creation, optimization, and architectural advantages. Practical experience with Snowflake SQL. Keywords: Texas |
[email protected] View all |
Fri Mar 15 01:19:00 UTC 2024 |