Software Engineer (ETL) - Radial, Inc.
KING OF PRUSSIA, PA
About the Job
Radial, Inc. seeks Software Engineer (ETL) in King of Prussia, PA.
- Job Duties: Understand the customer requirements, analysis, design, development, and implementation into the system, Experience with Snowflake Data warehouse, deep understanding of Snowflake architecture and processing. Automating, configuring and deploying instance on AWS. Write complex SQL scripts using Statistical Aggregate functions and Analytical functions. Design and develop E2E data flow starting from Source databases to hive tables which includes denormalization in Hadoop platform. Use HDFS and Unix Commands for Checking the Validation of files. Work on Snowflake utilities such as Snow SQL, Snow Pipe Tasks, Streams, Time travel, Optimizer, Metadata Manager, data sharing, and stored procedures. Create python reusable scripts and testable, and efficient code. Design, develop, and maintain the ETL processes that load data into the company's data warehouse. Work with business stakeholders to understand their data needs. Develop and implement data quality checks. Troubleshoot and resolve ETL issues. Stay up to date on ETL tools and Cloud technologies. Engage in data analysis and profiling to answer business/functional question. Work in a fast-paced, Agile development environment. Understand functional and non-functional requirements from business users and perform analysis. Monitor the Scheduled Production Jobs through Airflow, Control-M and Autosys Schedulers. Telecommuting permitted.
```{=html}
```
- Minimum Requirements: Bachelor's degree, or foreign equivalent, in Computer Science, Engineering (any), Computer information Systems, or closely related quantitative discipline and two (2) years of experience in the job offered or two (2) years of experience in the field of Software development, data engineering or related occupations.
- Special Skill Requirements:
1. AWS
2. Snowflake
3. Hadoop, Hive, Sqoop.
4. SQL/NoSQL Databases including Oracle, Netezza, Teradata and HBase.
5. Airflow
6. Python
7. AWS Glue
8. IBM info sphere DataStage (ETL)
9. Autosys, Control-M
10. Unix
Any suitable combination of education, training and experience is acceptable.
Apply through the career's website at https://radialcareers.secure.force.com/careers/ with reference to: Job #: JO-2501-10817.
- Job Duties: Understand the customer requirements, analysis, design, development, and implementation into the system, Experience with Snowflake Data warehouse, deep understanding of Snowflake architecture and processing. Automating, configuring and deploying instance on AWS. Write complex SQL scripts using Statistical Aggregate functions and Analytical functions. Design and develop E2E data flow starting from Source databases to hive tables which includes denormalization in Hadoop platform. Use HDFS and Unix Commands for Checking the Validation of files. Work on Snowflake utilities such as Snow SQL, Snow Pipe Tasks, Streams, Time travel, Optimizer, Metadata Manager, data sharing, and stored procedures. Create python reusable scripts and testable, and efficient code. Design, develop, and maintain the ETL processes that load data into the company's data warehouse. Work with business stakeholders to understand their data needs. Develop and implement data quality checks. Troubleshoot and resolve ETL issues. Stay up to date on ETL tools and Cloud technologies. Engage in data analysis and profiling to answer business/functional question. Work in a fast-paced, Agile development environment. Understand functional and non-functional requirements from business users and perform analysis. Monitor the Scheduled Production Jobs through Airflow, Control-M and Autosys Schedulers. Telecommuting permitted.
```{=html}
```
- Minimum Requirements: Bachelor's degree, or foreign equivalent, in Computer Science, Engineering (any), Computer information Systems, or closely related quantitative discipline and two (2) years of experience in the job offered or two (2) years of experience in the field of Software development, data engineering or related occupations.
- Special Skill Requirements:
1. AWS
2. Snowflake
3. Hadoop, Hive, Sqoop.
4. SQL/NoSQL Databases including Oracle, Netezza, Teradata and HBase.
5. Airflow
6. Python
7. AWS Glue
8. IBM info sphere DataStage (ETL)
9. Autosys, Control-M
10. Unix
Any suitable combination of education, training and experience is acceptable.
Apply through the career's website at https://radialcareers.secure.force.com/careers/ with reference to: Job #: JO-2501-10817.
Source : Radial, Inc.