Kellton Tech - Boston, MA
posted 2 months ago
Full-time
Boston, MA
Professional, Scientific, and Technical Services
About the position
The Applications Developer will support the design, development, and implementation of complex, multi-system applications, focusing on delivering efficient data warehousing solutions. This role involves coding, debugging, testing, and documentation, as well as working with cloud architectures and relational databases.
Responsibilities
- Interpret business requirements and develop Data Warehouse solutions.
- Design models to source data from multiple systems, meeting specific business needs.
- Provide guidance on cloud technologies to team members with varying technical expertise.
- Identify and plan the migration of on-premises data solutions to the cloud.
- Develop Oracle, Snowflake, and IICS ETL scripts; create shell/Python scripts for automation.
- Maintain design documentation using industry standards.
- Monitor data processing, optimize storage performance, and enhance query efficiency in cloud environments.
- Offer expertise in query writing and tuning for analysts and end-users.
- Participate in on-call rotation to ensure system reliability.
Requirements
- 7+ years in database development, including SQL code design, coding, and implementation.
- Experience with Data Warehouse applications on AWS and working with multi-terabyte databases.
- Hands-on experience with Oracle/Snowflake SQL, PL/SQL, and Informatica IICS.
- Familiarity with Airflow, GitHub, and cloud architectures.
- Proficiency in Oracle, Snowflake SQL, and ETL development.
- Strong understanding of version control and GitHub.
- Knowledge of system and database administration, including backup & recovery.
- Strong problem-solving and analytical abilities.
Nice-to-haves
- Experience in a healthcare/claims processing environment is preferred.
- AWS Cloud Certification (e.g., AWS Certified Solutions Architect).
- Snowflake Certification.
- Informatica IICS Certification.
