ETL Developer

Key Responsibilities:

• Design, develop, and optimize robust ETL pipelines to source, transform, and load data from Snowflake for business intelligence and CRM applications.
• Integrate data with Salesforce, ensuring data is accessible, reliable, and aligned with business requirements.
• Collaborate with data architects, Salesforce developers, and business stakeholders to understand integration needs and ensure high-quality data flow.
• Implement data cleansing, transformation, and enrichment processes to support analytics and reporting.
• Monitor and troubleshoot ETL jobs to ensure timely and accurate data delivery.
• Work with large-scale datasets and ensure data governance, privacy, and security standards are maintained.
• Contribute to the design of Snowflake data models and help optimize performance using best practices for partitioning, clustering, and caching.
• Develop and maintain technical documentation related to data mappings, workflows, and job schedules.
• Partner with QA to ensure proper testing and validation of ETL jobs and integrated systems.

Required Skills and Experience:

• 5+ years of experience in ETL development, with a focus on Snowflake as a data warehouse.
• Proficient in SQL, stored procedures, and performance tuning within Snowflake.
• Hands-on experience with ETL tools such as Informatica, Talend, dbt, Matillion, or custom Python-based pipelines.
• Working knowledge of Salesforce data model (objects, fields, relationships, and APIs).
• Experience designing data integrations between Snowflake and Salesforce, either via middleware, APIs, or direct ETL jobs.
• Strong understanding of data modeling, especially in a data warehouse environment (star/snowflake schema).
• Familiarity with financial services data and compliance requirements (preferred).
• Experience with job scheduling tools (Airflow, Control-M, etc.).
• Solid understanding of CI/CD pipelines, version control (e.g., Git), and deployment strategies for data workflows.
• Strong analytical and problem-solving skills; ability to work independently in a remote team setting.

Preferred Qualifications:

• Snowflake SnowPro certification is a plus.
• Salesforce certifications or hands-on Salesforce development/integration experience is highly desirable.
• Experience with cloud platforms (AWS, Azure, or GCP) and cloud-native data tools.
• Prior experience in banking, wealth management, or fintech is strongly preferred