Software Engineer (ETL) Job at Radial, King of Prussia, PA

RVF0cExjVllobmR4ejc1V0NqUVR4NCt4cVE9PQ==
  • Radial
  • King of Prussia, PA

Job Description

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:
  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 careers/ with reference to: Job #: JO-2501-10817.

Job Tags

Remote job,

Similar Jobs

Aveanna Healthcare

In Home Healthcare LPN: Adult patient (Days) Job at Aveanna Healthcare

 ...! Licensed Practical / Vocational Nurse - LPN/LVN Our local office is looking for a team...  ...024, as ranked by Comparably Why Join Us? Health, Dental, Vision and Company-Paid Life Insurance...  ...Aveanna has a tablet in each patients home allowing for electronic documentation... 

Finalsite

Salesforce Administrator/Developer Job at Finalsite

 ...VISION Finalsite will transform the way school communities engage with their schools. SUMMARY OF THE ROLE The Salesforce Administrator/Developer at Finalsite is a hybrid role that requires a strong understanding of both Salesforce administration and development... 

SGS Société Générale de Surveillance SA

Investment Banking Associate - Equity Capital Markets Job at SGS Société Générale de Surveillance SA

ResponsibilitiesInvestment banking is a core business line of GLBA, responsible for the origination and execution of all investment banking...  ...market updates to the team, including following global capital markets, investor sentiment, and equity fund flows.Act as the... 

Quantix

CDL-A Chemical Tanker Truck Driver Job at Quantix

Quantix Is Currently Hiring CDL-A Chemical Tanker Truck Drivers for our Liquid Division.Minimum Weekly Pay for First 12 Weeks!*CDL-A Truck Driver Advantages Include:~Regional runs~Top earners can make more than $100,000 a year!~Up to $30/hour with an average... 

Enterprise Precast Concrete

Architectural Engineer Job at Enterprise Precast Concrete

 ...Precast Concrete is the nations premier provider of high-quality architectural precast components for a variety of building applications....  ...business growth, we are currently seeking an Architectural Engineer to join our award-winning team. Job Duties: This position...