APPLICATIONS DEVELOPER

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.

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 x environment which requires on-call rotation.

QUALFICATIONS : Preferred Knowledge, Skills & Abilities :

• 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 :