Job Details

ID #45822201
State Texas
City San antonio
Job type Contract
Salary USD TBD TBD
Source Cerebral Technologies
Showed 2022-09-19
Date 2022-09-19
Deadline 2022-11-17
Category Et cetera
Create resume

Datastage with Snowflake

Texas, San antonio, 78251 San antonio USA

Vacancy expired!

Datastage Developer with Snowflake San Antonio, TX Long Term Contract Should have 8+ years of experience in ETL Design and Development using IBM DataStage Components. Should have worked at least 8 years in DataStage 9.1 or later. Should have extensive knowledge in Python. Should have extensive knowledge in Unix shell scripting. Thorough Understanding of DW principles (Fact, Dimension tables, Dimensional Modelling and Data warehousing concepts). Research, development, document and modification of ETL processes as per data architecture and modeling requirements. Ensure appropriate documentation for all new development and modifications of the ETL processes and jobs. Should have worked either Insurance or Banking domain. Should have extensive working experience with different Data Sources like Netezza, Oracle Databases, snowflake, DB2 etc. Should be very good in writing complex SQL queries. Experience in translating functional or non-functional requirements to system requirements. Exposure to scheduling tools like BMC Control-M. Experience in agile methodologies is desirable. Exposure to Big Data technologies will be an added advantage. End to end understanding of source->ETL->Application layer->Reporting. Must have good Oral, written & presentation skills to interact with business & technical teams on day-to-day basis as it's a client facing role. Should be self-driven and able to run the show with minimal or no assistance. Strong experience on building data pipelines on the cloud, on-prem preferably on AWS Experience with large scale analytical solutions on Snowflake in-depth experience with Snowflake architecture, optimization levers, cost management principles, etc. Strong knowledge in DW Concepts, Dimensional Modeling, SCD2, Data modeling, ETL/ELT, Data, and Information Management. Strong in RDBMS and SQL Knowledge. Expert in Data Integration, Data profiling, Data Quality and Metadata Management, and Data Pipeline. Proficiency in translating high-level business problem statements to detailed technical designs/solutions. Experience in Agile Development and CI/CD

Vacancy expired!

Subscribe Report job