Need - IBM Infosphere Data Stage with DBT Snowflake - San Antonio, TX (Onsite)

Overview

On Site
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - 12 Month(s)
No Travel Required

Skills

Apache Hadoop
Apache Kafka
BMC Control-M
Cloud Computing
Computer Hardware
Data Modeling
Data Warehouse
Database
Datastage
ELT
Extract
Transform
Load
GRID
IBM DB2
IBM InfoSphere
IBM InfoSphere DataStage
Linux
Microsoft IIS
Microsoft SQL Server
Microsoft Windows
Netezza
Oracle
Process Flow
Python
SAS
SQL
Scheduling
Snow Flake Schema
Unix

Job Details

The following requirement is open with our client.

Title : IBM Infosphere Data Stage with DBT Snowflake

Location : San Antonio, TX (Onsite)

Duration : 12 Months

Rate : OPEN

Visa Status : H1B

Relevant Experience (in Yrs.) : 10+

Job Description:

  • Analyse requirements and existing resources to Propose, create ETL designs and database objects.
  • Work with project and business analyst leads in order to develop and clarify in-depth technical requirements including logical and physical data modelling activities.
  • Design and implement ETL Pipelines for data transactions related to Bank Data.
  • Develops, enhances, debugs, supports, maintains and tests software applications that support business units or supporting functions using IBM Infosphere Data Stage ETL or any other cloud based ETL tool both ETL and ELT approaches.
  • These application program solutions may involve diverse development platforms, software, hardware, technologies and tools.
  • Must have hands-on on Snowflake development environment with all SQL operations.
  • Must be aware of ELT approach as well.
  • Participates in the design, development and implementation of complex applications, often using IBM Infosphere Information Server (IIS) products like Data Stage, Quality Stage on a Linux Grid environment. Control-M/Scheduling tools.
  • 10+ Yrs Relevant IT software experience (Technical) in ETL DataStage or any other cloud based ETL Tool development
  • Experience with databases like Snowflake (Cloud DB), Oracle, Netezza, MS SQL Server 2012+, DB2 and MS Access
  • Experience with job automation & scheduling software (Control-M)
  • Strong ability to write SQL queries
  • Familiar with Snowflake (Cloud DB), DBT, Kafka, Python, UNIX, Windows, File transfer utilities, process flow creation, ETL technologies, Hadoop
  • SAS, Snow-Pro Certified.
  • Strong SQL, Strong conceptual understanding of core DW Concepts including different approaches/methodologies. dbt (data build tool) experience is an added advantage

Thanks & regards,
Bhavithanjali..
Technical Recruiter | ASCII Group, LLC
Office:
Email:
38345 W. 10 Mile Rd, Ste.#365; Farmington, MI 48335

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.