Software Engineer (ETL) - Radial
King of Prussia, PA
About the Job
Software Engineer (ETL)
Job Number: JO-2501-10817
Location (City, State): King of Prussia, PA
Employee Group: Regular
Shift: Day
Travel:
Site Name: King of Prussia 935
Is Remote Eligible: Yes
Pay:
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.
+ 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:
+ AWS
+ Snowflake
+ Hadoop, Hive, Sqoop.
+ SQL/NoSQL Databases including Oracle, Netezza, Teradata and HBase.
+ Airflow
+ Python
+ AWS Glue
+ IBM info sphere DataStage (ETL)
+ Autosys, Control-M
+ Unix
Any suitable combination of education, training and experience is acceptable.
Apply through the career’s website atwith reference to: Job #: JO-2501-10817.
Radial is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.
Radial is committed to ensuring that its online application process provides an equal employment opportunity to all job seekers, including individuals with disabilities. If you believe you need a reasonable accommodation in order to search for a job opening or to submit an application, please contact us by emailing. We will work to assist disabled job seekers whose disability prevents them from being able to apply online.
Job Number: JO-2501-10817
Location (City, State): King of Prussia, PA
Employee Group: Regular
Shift: Day
Travel:
Site Name: King of Prussia 935
Is Remote Eligible: Yes
Pay:
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.
+ 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:
+ AWS
+ Snowflake
+ Hadoop, Hive, Sqoop.
+ SQL/NoSQL Databases including Oracle, Netezza, Teradata and HBase.
+ Airflow
+ Python
+ AWS Glue
+ IBM info sphere DataStage (ETL)
+ Autosys, Control-M
+ Unix
Any suitable combination of education, training and experience is acceptable.
Apply through the career’s website atwith reference to: Job #: JO-2501-10817.
Radial is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.
Radial is committed to ensuring that its online application process provides an equal employment opportunity to all job seekers, including individuals with disabilities. If you believe you need a reasonable accommodation in order to search for a job opening or to submit an application, please contact us by emailing. We will work to assist disabled job seekers whose disability prevents them from being able to apply online.
Source : Radial