TalentBurst
Applications Developer
TalentBurst, Quincy, Massachusetts, us, 02171
Position: Database Developer ( Oracle, Snowflake / IICS)Location: Quincy, MA (Hybrid)Duration: 8+ Months with long term possible extensionWeekly hours - 37.5
The Applications Developer will be responsible for providing analytical support for conceptualization, development, and implementation of complex systems of multiple inter-linked programsIn-depth knowledge of all phases of client/server applications technologyResponsible for the analysis, design, coding, debugging, testing and documentation of computer programsBroad experience in programming graphical user interfaces (GUI)Extensive knowledge and skill with object-oriented programming, relational database structures and cloud engineeringMay also act as team or project leader on major applications projectsThe 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 environmentsThis 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 skillsHands on experience with Cloud architectures
Strong problem solving and analytical skills
Proficiency in Informatica IICSUnderstand 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 experienceMedicaid or other healthcare or claims processing experienceExperienced in Oracle SQL skills and PL/SQL skills
Experience with Perl, system administration, database administration, storage architectures, backup & recovery, and networkingEducation & 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 PreferredSnowflake Certification PreferredInformatica IICS Certification Preferred
The Applications Developer will be responsible for providing analytical support for conceptualization, development, and implementation of complex systems of multiple inter-linked programsIn-depth knowledge of all phases of client/server applications technologyResponsible for the analysis, design, coding, debugging, testing and documentation of computer programsBroad experience in programming graphical user interfaces (GUI)Extensive knowledge and skill with object-oriented programming, relational database structures and cloud engineeringMay also act as team or project leader on major applications projectsThe 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 environmentsThis 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 skillsHands on experience with Cloud architectures
Strong problem solving and analytical skills
Proficiency in Informatica IICSUnderstand 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 experienceMedicaid or other healthcare or claims processing experienceExperienced in Oracle SQL skills and PL/SQL skills
Experience with Perl, system administration, database administration, storage architectures, backup & recovery, and networkingEducation & 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 PreferredSnowflake Certification PreferredInformatica IICS Certification Preferred