Required Skills

Data Architect

Work Authorization

  • US Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

  • H1B Work Permit

Preferred Employment

  • Corp-Corp

  • W2-Permanent

  • W2-Contract

  • Contract to Hire

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 13th Sep 2023

JOB DETAIL

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 client’s 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.

 

Company Information