Position: Database Developer ( Oracle, Snowflake / IICS)
Location: Quincy, MA (Hybrid)
Duration: 8+ Months with long term possible extension
Weekly hours - 37.5The Applications Developer will be responsible for providing analytical support for conceptualization, development, and implementation of complex systems of multiple inter-linked programs
In-depth knowledge of all phases of client/server applications technology
Responsible for the analysis, design, coding, debugging, testing and documentation of computer programs
Broad experience in programming graphical user interfaces (GUI)
Extensive knowledge and skill with object-oriented programming, relational database structures and cloud engineering
May also act as team or project leader on major applications projects
The ideal candidate must demonstrate confidence, creativity, and keen problem-solving abilities.
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
Qualifications:
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 & 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
