Senior Snowflake Developer
Experience:
6+ years
English:
Upper-Intermediate
Location:
Rio de Janeiro
Infopulse is looking for a Senior Snowflake Developer in Brazil for a Healthcare Project.
Areas of Responsibility
- Design, develop, test, and deploy ETL (Extract, Transform, Load) processes using SQL Server Integration Services (SSIS)
- Collaborate with business stakeholders and data analysts to gather and understand data integration requirements
- Create and maintain data mappings, data flow diagrams, and documentation to ensure transparent and reproducible ETL processes
- Optimize and tune SSIS packages for performance and scalability
- Troubleshoot and resolve data integration issues, ensuring data accuracy and reliability
- Implement data cleansing, validation, and transformation logic to maintain data quality
- Develop and maintain data migration strategies and processes
- Stay current with SSIS best practices and emerging technologies to ensure our data integration solutions remain efficient and effective
- Work closely with database administrators and other technical teams to ensure data infrastructure and systems support ETL processes
- Participate in code reviews and provide mentorship to junior developers, fostering a culture of continuous improvement
Qualifications
- 6+ Years’ experience in Data Analytics & Business Intelligence projects
- Extensive knowledge of BI concepts (ETL, Dimensional Modeling, Data warehouse Design)
- Experience in creating Data Pipelines using Python/Spark , and using traditional ETL/ETL tools like Informatica, Pentaho
- 2 years’ experience in designing Snowflake
- Experience in designing Columnar Databases like Vertica or RedShift
- Experience in building monitoring & alerting mechanisms for data pipelines
- Working Knowledge in developing Integrations using APIs, such as REST, SOAP, JDBC/ODBC connections
- Strong Analytical and Problem-solving skills, Excellent Written and Verbal Communication skills
- Nice to Have – Experience in implementing Data Streaming process using Kafka or Kinesis and NoSql Databases.