Snowflake ETL Developer

Saama (A Carlyle Portfolio Company) focuses on the specific needs of pharmaceutical & biotech companies, delivering transformative business outcomes. The combination of Saama’s AI research, advanced technical & analytics capabilities, domain expertise across the drug development & commercialization life cycle, and successful product co-development approach has made Saama a trusted partner and thought leader in the life sciences industry. If you possess a solutions mindset, strong management skills, and commitment to be part of a tremendous journey, join our growing, global team. See what Saama can do for your career and your journey.

Responsibilities:Bachelors or Masters in IT, Computer, Software or related field.6 years of Data Warehousing experience with 2 years of Snowflake concepts with implementation/hands-on experienceExperience in following best practices to maintain code versioning through GitHub, understanding of CI/CDStrong SQL, PL\SQL skillsExperience/Understanding of Unix and python scriptingGood to have - Streamsets knowledge & Data Vault knowledgeAble to communicate well with client and understand requirements.P&C Insurance domain experience is nice to haveProficient and Prior experience in ELT\ETL tools is mustParticipate in Design discussion with the Data modeler and architect teamParticipate in Data Modelling sessions and develop Data Mapping specifications for the relevant processesPrepare high level and detailed design documents for necessary processesDesign and develop the system components for the extract/transform or conversion of data from source systems to the target application(s)Analyze the system capabilities and requirements through Storing and manipulating data inputsDevelop processes to handle Audit, Balancing, Reconciliation, and Error handling programs through the use of extract development tools or custom developed proceduresIdentify components that require performance optimization and provide inputs for optimization of relevant jobs for optimal performance Analyze user needs and system requirements to determine feasibility of design within available constraintsDesign and document jobs for the required scheduling toolsPerform internal design review and code reviewDesign and document data flow and explain to internal and external teams based on the needInteract with client regularly, meet them to present work.Having hands on experience or basic knowledge on Agile Scrum methodology

Work EnvironmentThis job operates in a professional office environment. This role routinely uses standard office equipment, including but not limited to, computers, phones, and photocopiers.

Physical DemandsThis position requires the frequent and repetitive use of a computer, keyboard, and mouse. Hand and finger dexterity is required.

Other DutiesPlease note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.

EEOSaama Technologies, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, and transfer, leaves of absence, compensation, and training.

Key Skills

• Python