What are the responsibilities and job description for the ETL Developer + Snowflake position at MEDuvi LLC?
37.5 hour work week and Hybrid 2 days onsite
DETAILED LIST OF JOB DUTIES AND RESPONSIBILITIES:
Preferred Knowledge, Skills & Abilities:
Education and Certifications:
-
EEO Statement. We welcome all applicants and qualified individuals, who will receive consideration for employment without regard to their race, color, religion, national origin, sex, sexual orientation, gender identity, protected veteran status or disability.
DETAILED LIST OF JOB DUTIES AND RESPONSIBILITIES:
- Understand and translate business requirements into Data Warehouse solutions.
- Create data models and designs to meet specific business needs that require sourcing data from multiple source systems.
- Has the ability to mentor other technical staff in cloud technologies at all levels of understanding and can adjust the message accordingly.
- Assists in identifying, planning, and migration of on-premises data solutions suitable for migration to the cloud.
- Code Oracle, Snowflake or IICS ETL scripts that will transform data from an operational database and populate to various targets.
- Document design using industry standards.
- Capable of monitoring and optimizing data processing and storage performance with cloud environments. This includes identifying bottlenecks, tuning and optimizing queries, and recommending architectural changes to improve efficiency.
- Provide query writing support and tuning expertise to analysts and end users.
- Develop shell/Python scripts for production job automation.
- Work in a 24x7 environment which requires on-call rotation.
Preferred Knowledge, Skills & Abilities:
- 5 years of experience in database development including analyzing, designing, documenting, coding, testing, and implementing primarily SQL code.
- Thorough knowledge of Data Warehouse applications on AWS.
- Experience working with Airflow.
- Exceptional Oracle/Snowflake SQL skills
- Hands on experience with Cloud architectures.
- Strong problem solving and analytical skills.
- Proficiency in Informatica IICS
- Understand the concepts of version control and use of GitHub.
- Experience working with a large, multi-terabyte data warehouse.
- BS in Computer Science or related degree, or equivalent experience
- Medicaid or other healthcare or claims processing experience
- Experienced in Oracle SQL skills and PL/SQL skills.
- Experience with Perl, system administration, database administration, storage architectures, backup & recovery, and networking.
Education and Certifications:
- BS in Computer Science, Information Technology or an equivalent combination of education and work experience required.
- Amazon Web Services (AWS) Cloud Certification and AWS Certified Solutions Preferred
- Snowflake Certification Preferred
- Informatica IICS Certification Preferred
-
EEO Statement. We welcome all applicants and qualified individuals, who will receive consideration for employment without regard to their race, color, religion, national origin, sex, sexual orientation, gender identity, protected veteran status or disability.
Salary : $132,000
ETL Developer
Puma -
Somerville, MA
ETL Developer
PUMA Group -
Somerville, MA
ETL Developer
HouseWorks Home Care -
Woburn, MA
