3i Infotech Matillion Developer ETL & Data Pipeline

Job description

<p><p><b>Position :</b> Matillion Developer Banking Domain (Snowflake)<br/><br/><b>Type :</b> Full-Time<br/><b><br/>Experience </b>: 6+ years<br/><br/>Location : Noida, Chennai, Bangalore, Mumbai & Hyderabad<br/><br/><b>Job Summary :</b><br/><br/>We are seeking an experienced Matillion Developer with a minimum of 6 years in data engineering, possessing strong expertise in Snowflake data warehousing and specific domain knowledge within the Banking/Financial Services sector.

This full-time role involves designing, developing, and maintaining scalable and high-performance ELT pipelines using the Matillion ETL tool.

The developer will be crucial in ensuring data accuracy, security, and regulatory compliance while collaborating with global teams to deliver real-time financial data solutions.<br/><br/><b>Job Description :</b><br/><br/>ELT Development and Data Pipeline Optimization :<br/><br/>- Design, develop, and meticulously optimize complex ELT (Extract, Load, Transform) workflows and jobs primarily using the Matillion ETL platform, leveraging its native integration capabilities with Snowflake.<br/><br/>- Implement advanced Snowflake features, including Time Travel, Zero-Copy Cloning, Streams, and Tasks, to ensure pipeline efficiency, data governance, and version control.<br/><br/>- Write and optimize highly performant SQL queries, stored procedures, and User-Defined Functions (UDFs) directly within the Snowflake environment to execute complex data transformations and business logic.<br/><br/>- Ensure all data integration processes adhere to established data warehousing principles (e.g., Kimball, Inmon) and dimensional modeling techniques within the Snowflake structure.<br/><br/>Financial Data Domain and Compliance :<br/><br/>- Work extensively with specialized Banking/Financial Data structures, including transactional data, regulatory reporting data, customer master data, compliance logs, and market risk metrics.<br/><br/>- Develop and maintain data quality checks and validation routines within Matillion to ensure the integrity and accuracy of all financial data loaded into Snowflake.<br/><br/>- Implement granular security measures in the data pipelines, ensuring compliance with strict financial regulations and policies related to data security and privacy (e.g., PII, GDPR, etc.).<br/><br/>- Support cloud-based data integration efforts, ensuring connectivity and security standards are met, particularly across Azure and AWS cloud environments where source systems or data lakes reside.<br/><br/>Engineering Practices and Collaboration :<br/><br/>- Collaborate closely with Data Analysts, Data Scientists, and Business Teams to translate complex business requirements and reporting needs into efficient, maintainable data solutions.<br/><br/>- Ensure the continuous delivery of pipeline code by adhering to version control practices using Git and contributing to the automation of the data deployment lifecycle via CI/CD pipelines.<br/><br/>- Perform technical performance tuning across the end-to-end data flow, focusing on optimizing Matillion job execution times and minimizing Snowflake compute resource consumption.<br/><br/>- Act as a self-motivated technical resource, exhibiting strong customer service orientation and effectively collaborating with global teams and clients to meet demanding SLAs.<br/><br/><b>Required Skills & Qualifications :</b><br/><br/>- Experience : Mandatory 6+ years in Data Engineering / ETL development, with 4+ years dedicated to Matillion and Snowflake.<br/><br/>- Core Technologies : Expert proficiency in Matillion ETL and Snowflake data warehousing features, including performance tuning and advanced SQL.<br/><br/>- Domain : Strong working understanding of banking/financial data structures and the associated regulatory and compliance requirements.<br/><br/>- Engineering Practice : Mandatory familiarity with Git for version control, CI/CD, and concepts related to cloud platforms (AWS, Azure).<br/><br/>- Education : Graduate degree, preferably B.Tech/MCA in Computer Science, or equivalent field experience, along with industry-recognized certifications in Data Management.<br/><br/><b>Preferred Skills :</b><br/><br/>- Certification : Snowflake Certifications (SnowPro Core) or Matillion Certifications.<br/><br/>- Cloud Platform : Hands-on experience with specific cloud storage and compute services (AWS S3/EC2, Azure Blob/Virtual Machines).<br/><br/>- Programming : Proficiency in scripting languages such as Python for custom Matillion components or data manipulation tasks outside of SQL.<br/><br/>- Reporting Integration : Experience integrating Snowflake with business intelligence tools (Tableau, Power BI) for final data consumption.<br/><br/>- Agile Tooling : Experience using JIRA or Azure DevOps for managing data engineering project backlogs and tasks.</p><br/></p> (ref:hirist.tech)

Required Skill Profession

Computer Occupations