Application Developer - Compu-Vision Consulting Inc.
Quincy, MA 02111
About the Job
Duration: 6 months
Location: Hybrid - Local candidates only (QUINCY, MA)
JOB OVERVIEW:
The 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. The primary work location for this role will be Quincy, Massachusetts 02171. 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 inoffice 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 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