Required Skills

Snowflake (Cloud DB) Oracle Netezza MS SQL Server 2012+ DB2

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 :- 19th Dec 2023

JOB DETAIL

Analyze 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 modeling activities
Design and implement ETL processes for data transactions related to Enterprise Data
Warehouse, Operational Data Store (ODS), and other data structures to support our
Business Intelligence operations
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.
Required Skills:10+ Yrs Relevant IT software experience (Technical) in ETL Datastage
or any other cloud based ETL Tool development Experience with databases likeSnowflake (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
Desired Skills: Familiar with Snowflake (Cloud DB), DBT, Kafka, Python, UNIX,
Windows, File transfer utilities, process flow creation, ETL technologies, Hadoop
Good to have Skills: 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

Company Information