loanDNA, a division of Consolidated Analytics, is redefining how the U.S. mortgage market manages the entire loan lifecycle. We combine the precision of AI with the expertise of human intelligence. As a fast-growing mortgage technology company, we’re building smarter, faster, and more transparent solutions that transform how lenders process, underwrite, and manage risk.

Our Center of Excellence in Chennai is at the forefront of this transformation, driving innovation, automation, and insight across the mortgage ecosystem. Joining now means getting in on the ground floor of a breakthrough platform reshaping the future of mortgage operations.

About the role

• We are seeking an experienced Snowflake Developer with a minimum of 5 years of hands-on experience in Snowflake development, integration, migration, and deployment. The ideal candidate will be responsible for designing, implementing, and optimizing Snowflake solutions, ensuring efficient data architecture, and supporting our data-driven decision-making processes.

• Design, develop, and optimize complex data models, tables, views, and stored procedures within the Snowflake environment.
• Implement data ingestion, transformation, and loading processes using Snowflake features such as Snowpipe, streams, and tasks.
• Develop and maintain Snowflake scripts and SQL-based ETL/ELT processes.

• Lead and execute data migration projects, including the transition from legacy databases or data warehouses to Snowflake.
• Integrate Snowflake with various data sources and third-party tools, ensuring seamless data flow and connectivity. o Collaborate with cross-functional teams to ensure data consistency, quality, and accuracy across systems.

• Monitor and optimize Snowflake performance, including query tuning, workload management, and resource optimization.
• Implement and manage data partitioning, clustering, and indexing strategies to improve performance and scalability.
• Regularly review and refine Snowflake security models, including access controls and encryption.

• Develop and manage CI/CD pipelines for Snowflake deployments, ensuring smooth and automated release processes.
• Perform regular maintenance, upgrades, and troubleshooting within the Snowflake environment.
• Ensure data compliance with organizational policies and industry regulations, including GDPR, HIPAA, etc.

• Work closely with data architects, analysts, and other stakeholders to translate business requirements into technical solutions.
• Create and maintain detailed documentation of Snowflake environments, data f lows, and ETL/ELT processes.
• Provide mentorship and guidance to junior developers and team members.

• o Minimum of 5 years of hands-on experience with Snowflake development, including data modeling, ETL/ELT, and SQL scripting.
• o Strong experience in data integration, migration, and deployment within the Snowflake environment.
• o Proficiency in SQL, Python, or other relevant programming languages.
• o Experience with data warehousing concepts, including star schema, snowflake schema, and OLAP.
• o Familiarity with Snowflake’s features such as Snowpipe, Time Travel, Streams, and Tasks.

• Experience with cloud platforms such as AWS, Azure, or Google Cloud, and their integration with Snowflake.
• Proficiency in data integration tools like Matillion, Talend, Informatica, or similar.
• Familiarity with CI/CD tools such as Jenkins, GitLab, or Azure DevOps.

• Strong analytical and problem-solving skills.
• Excellent communication and collaboration abilities.
• Ability to work independently and as part of a team in a fast-paced environment.
• Preferred Qualifications:

• Snowflake Certification or equivalent certifications in cloud data warehousing.
• Experience: Experience with additional data platforms like Redshift, BigQuery, or similar.
• Knowledge: Understanding of data governance, data security, and compliance standards.