DataStage & Snowflake Developer

Role Overview: You will be responsible for implementing ETL pipelines within and outside of a data warehouse using Python and Snowflake's Snow SQL. Working closely with end users, you will gather data requirements, perform complex data mapping, and develop/maintain ETL programs to support the enterprise data warehouse. Additionally, you will develop SQL scripts to load data from source systems and ensure correct data loading in target tables through the ELT process. Your role will also involve developing scripts using Unix, Python, etc. for loading, extracting, and transforming data. You will assist in resolving production issues in Data Warehouses such as reloading data, transformations, and translations, and develop Database Design and Reporting Design based on Business Intelligence and Reporting requirements. Key Responsibilities: - Implement ETL pipelines using Python and Snowflake's Snow SQL - Gather data requirements from end users and perform complex data mapping - Develop and maintain ETL programs to support the enterprise data warehouse - Create SQL scripts to load data from source systems and verify correct data loading in target tables - Develop scripts using Unix, Python, etc. for loading, extracting, and transforming data - Assist with resolving production issues in Data Warehouses - Develop Database Design and Reporting Design based on Business Intelligence and Reporting requirements Qualifications Required: - 4+ years of relevant experience in Datastage and Snowflake - Proficiency in SQL - Knowledge of ETL processes for data transfers and storage - Scripting skills using Python - Exposure to job scheduling/monitoring environments (e.g., Control-M) - Familiarity with Big Data tools such as Hadoop and Spark - Cloud migration experience is a plus Note: The job description does not include any additional details about the company.,