Snowflake Developer

Dexian; Providence (RI); On-site; USD 140,000 - 210,000; Full time

Job summary

Dexian is seeking a Snowflake Developer to design and optimize data pipelines and Snowflake database solutions at our Smithfield, RI site. You will work with Oracle, PostgreSQL, and NoSQL systems, leveraging AWS services to implement end-to-end data processing and analytics.

The role requires 8+ years in database design, 3+ years in Snowflake, and strong Python/Java development. Collaboration with cross-functional teams and CI/CD practices are essential in our fast-paced environment.

Qualifications

• 8+ years in database design and development (Oracle/PostgreSQL, NoSQL).
• 5+ years in ETL/ELT tools (Informatica or SnapLogic).
• 3+ years in Snowflake development.
• Strong Python and Java development experience.

Responsibilities

• Design, develop, and maintain scalable data pipelines and ETL/ELT solutions using Informatica PowerCenter and/or SnapLogic.
• Develop and optimize Snowflake database solutions, including complex SQL queries, stored procedures, data transformations, and performance tuning.
• Write and optimize complex SQL and Oracle PL/SQL queries, procedures, functions, and database objects.
• Develop Python scripts and applications for data processing, transformation, integration, and automation.
• Design and implement logical and physical data models to support enterprise data warehouse solutions.
• Work with relational and NoSQL databases, including Oracle, PostgreSQL, DynamoDB, and Aerospike.
• Leverage AWS services such as S3, EMR, EC2, Lambda, Athena, and CloudFormation for cloud-based data processing and integration.
• Develop and support distributed data processing solutions using technologies such as Kafka, Kinesis, SNS, and SQS.
• Collaborate with application, architecture, and data engineering teams to design and implement end-to-end solutions.
• Ensure data quality, performance, scalability, and reliability of critical applications and data pipelines.
• Work with CI/CD tools and DevOps practices to support application deployment and release management.

Skills

Snowflake development

SQL/PLSQL

Python

Data Modeling

Oracle/PostgreSQL

AWS (S3/EC2/Lambda/Athena)

Kafka/Kinesis/SNS/SQS

Java/Spring Boot

CI/CD (Jenkins)

API design (Swagger)

Tools

Informatica PowerCenter

SnapLogic

Job description

Title : Snowflake Developer

Location: Smithfield RI

Key Responsibilities

• Design, develop, and maintain scalable data pipelines and ETL/ELT solutions using Informatica PowerCenter and/or SnapLogic.
• Develop and optimize Snowflake database solutions, including complex SQL queries, stored procedures, data transformations, and performance tuning.
• Write and optimize complex SQL and Oracle PL/SQL queries, procedures, functions, and database objects.
• Develop Python scripts and applications for data processing, transformation, integration, and automation.
• Design and implement logical and physical data models to support enterprise data warehouse solutions.
• Work with relational and NoSQL databases, including Oracle, PostgreSQL, DynamoDB, and Aerospike.
• Leverage AWS services such as S3, EMR, EC2, Lambda, Athena, and CloudFormation for cloud-based data processing and integration.
• Develop and support distributed data processing solutions using technologies such as Kafka, Kinesis, SNS, and SQS.
• Collaborate with application, architecture, and data engineering teams to design and implement end-to-end solutions.
• Ensure data quality, performance, scalability, and reliability of critical applications and data pipelines.
• Work with CI/CD tools and DevOps practices to support application deployment and release management.

Required Technical Skills

• Strong hands-on experience in Snowflake development and data warehousing.
• Strong proficiency in SQL and Oracle PL/SQL.
• Experience with ETL/ELT tools - Informatica PowerCenter and/or SnapLogic.
• Strong programming experience in Python.
• Experience in Data Modeling, database design, and development.
• Strong experience with relational databases such as Oracle and PostgreSQL.
• Working experience with AWS services: S3, EMR, EC2, Lambda, Athena, and CloudFormation.
• Experience with messaging technologies such as Kafka, Kinesis, SNS, and SQS.

Experience Requirements

• 8+ years of proven experience in database design and development using Oracle / PostgreSQL, NoSQL databases (DynamoDB, Aerospike).
• 6+ years of proven experience at programming in languages like SQL, R, or Python.
• 5+ years of strong experience in ETL/ELT tools: Informatica or Snaplogic.
• 4+ years of proven experience using AWS services S3, EMR, EC2, Lambda, Athena, CFT
• 3+ years of strong experience in Snowflake.
• 3+ years of strong experience in Python, Java application development using Spring Boot.
• 3+ years of experience in messaging technologies (Kafka, Kinesis, SNS, SQS).
• Good working knowledge in using Data Visualization tools - Tableau/Qlik/Power BI.
• Strong knowledge in Java, J2EE, Spring MVC, Spring Core, Python.
• Designing, developing, and implementing business rules using Drools Rules Engine is a plus
• Strong understanding of CI/CD tools such as Jenkins, Artifactory, Deploying applications in DevOps environment
• Deep understanding of API design, including versioning, API documentation (Swagger).
• Understanding of developing highly scalable distributed systems using Open-source technologies.
• Good Understanding of E2E ALM tools like JIRA, gitStash, FishEye, Crucible, Maven, Jenkins, uDeploy.
• Comfortable with Code Quality/Coverage tools (Sonar).
• Solid understanding of public/private cloud capabilities including compute, storage and scaling will be desirable.
• Ability to deal with ambiguity and work in fast paced environment.
• Ability to think out of box and design end-to-end solutions.
• Passion and intellectual curiosity to learn new technologies and business areas.
• Deep experience supporting critical applications quickly.
• Excellent interpersonal skills, both through written and verbal channels.
• Strong collaboration skills to work with multiple teams in the organization.

Dexian stands at the forefront of Talent + Technology solutions with a presence spanning more than 70 locations worldwide and a team exceeding 10,000 professionals. As one of the largest technology and professional staffing companies and one of the largest minority-owned staffing companies in the United States, Dexian combines over 30 years of industry expertise with cutting-edge technologies to deliver comprehensive global services and support.

Dexian connects the right talent and the right technology with the right organizations to deliver trajectory-changing results that help everyone achieve their ambitions and goals. To learn more, please visit https://dexian.com/.

Dexian is an Equal Opportunity Employer that recruits and hires qualified candidates without regard to race, religion, sex, sexual orientation, gender identity, age, national origin, ancestry, citizenship, disability, or veteran status.