Database Developer

Location: Quincy MA
Duration: 12 Months with possible extension

Hours/week: 37.5

Only locals

Applications Developer will be responsible for providing analytical support for conceptualization development and implementation of complex systems of multiple interlinked programs. Indepth 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 objectoriented 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 problemsolving abilities. The work schedule for this position is Monday through Friday 8:00AM to 4:00PM EST. This position would be expected to follow a hybrid model of reporting to work that combines in office workdays and work from home days as needed.

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 onpremises 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 oncall 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 multiterabyte 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