| Data Architect (E-TL, DataStage, MAT, SQL, RDBMS)-Dallas -Atlanta Need Locals at Dallas, Texas, USA |
| Email: [email protected] |
| From: Austin varma, Eminencets [email protected] Reply to: [email protected] Data Architect (ETL, DataStage, MAT, SQL, RDBMS) Location: Dallas / Atlanta Client: Impetus / McKesson Keywords: DataStage, Databases, PLSQL, Databricks or Snowflake, ETL. Job Description : The ideal candidate will use DataStage, ADF, Matillion and QLIK, SQL , build data ingestion and ETL pipelines in a hybrid data and analytics environments - Oracle, HANA, DB2 and others into Snowflake Datawarehouse. He/she will follow clients guideline and processes and work closely with their IT and business partners In instances, responsible to document as-is and to-be processes in support of continuous improvement and excellence. 8+ years of hands on experience using DataStage, ADF, Matillion and QLIK (DataStage 11.7.X experience is preferred) 5+ year of hands-on experience using Snowflake and Databricks and building dimensional data models.Solid practical experience in collecting data from API end points like JIRA, ServiceNow and feeding data to downstream systems via Kafka, API and other means. Strong ETL experience in handling large volumes of data in the complex heterogeneous data warehouses, and processing high volume jobs Prior experience in building data ingestion pipeline and data replication into cloud environments hosted on Azure platform. Hands on experience in creating the ETL jobs, performance tuning / optimization Knowledge of Snowflake is added advantage Strong Knowledge in databases such as Oracle,IBM DB2, SAP HANA, and ERP systems (SAP and JDE) 5+ yrs. of experience in SQL, UNIX shell scripting will be added advantage. Knowledge in Snowflake, Tivoli Workflow Scheduler (TWS)/ Maestro and BMC Control-M is added advantage.Having experience in supply chain management and distribution domains is a huge plus. Thanks, and regards. Austin Recruiter 7328607210 Ext: 109 Eminence Technology Solutions LLC Email: [email protected] Website: www.eminencets.com Keywords: information technology |
| [email protected] View all |
| Tue Sep 12 23:35:00 UTC 2023 |