Talent.com
3i Infotech - Matillion Developer - ETL & Data Pipeline
3i Infotech - Matillion Developer - ETL & Data Pipeline3i Infotech Limited • Chennai
3i Infotech - Matillion Developer - ETL & Data Pipeline

3i Infotech - Matillion Developer - ETL & Data Pipeline

3i Infotech Limited • Chennai
30+ days ago
Job description

Position : Matillion Developer Banking Domain (Snowflake)

Type : Full-Time

Experience : 6+ years

Location : Noida, Chennai, Bangalore, Mumbai & Hyderabad

Job Summary :

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.

Job Description :

ELT Development and Data Pipeline Optimization :

  • 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.
  • Implement advanced Snowflake features, including Time Travel, Zero-Copy Cloning, Streams, and Tasks, to ensure pipeline efficiency, data governance, and version control.
  • 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.
  • Ensure all data integration processes adhere to established data warehousing principles (e.g., Kimball, Inmon) and dimensional modeling techniques within the Snowflake structure.

Financial Data Domain and Compliance :

  • Work extensively with specialized Banking / Financial Data structures, including transactional data, regulatory reporting data, customer master data, compliance logs, and market risk metrics.
  • Develop and maintain data quality checks and validation routines within Matillion to ensure the integrity and accuracy of all financial data loaded into Snowflake.
  • 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.).
  • 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.
  • Engineering Practices and Collaboration :

  • Collaborate closely with Data Analysts, Data Scientists, and Business Teams to translate complex business requirements and reporting needs into efficient, maintainable data solutions.
  • 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.
  • Perform technical performance tuning across the end-to-end data flow, focusing on optimizing Matillion job execution times and minimizing Snowflake compute resource consumption.
  • Act as a self-motivated technical resource, exhibiting strong customer service orientation and effectively collaborating with global teams and clients to meet demanding SLAs.
  • Required Skills & Qualifications :

  • Experience : Mandatory 6+ years in Data Engineering / ETL development, with 4+ years dedicated to Matillion and Snowflake.
  • Core Technologies : Expert proficiency in Matillion ETL and Snowflake data warehousing features, including performance tuning and advanced SQL.
  • Domain : Strong working understanding of banking / financial data structures and the associated regulatory and compliance requirements.
  • Engineering Practice : Mandatory familiarity with Git for version control, CI / CD, and concepts related to cloud platforms (AWS, Azure).
  • Education : Graduate degree, preferably B.Tech / MCA in Computer Science, or equivalent field experience, along with industry-recognized certifications in Data Management.
  • Preferred Skills :

  • Certification : Snowflake Certifications (SnowPro Core) or Matillion Certifications.
  • Cloud Platform : Hands-on experience with specific cloud storage and compute services (AWS S3 / EC2, Azure Blob / Virtual Machines).
  • Programming : Proficiency in scripting languages such as Python for custom Matillion components or data manipulation tasks outside of SQL.
  • Reporting Integration : Experience integrating Snowflake with business intelligence tools (Tableau, Power BI) for final data consumption.
  • Agile Tooling : Experience using JIRA or Azure DevOps for managing data engineering project backlogs and tasks.
  • (ref : hirist.tech)

    Create a job alert for this search

    Etl Developer • Chennai

    Related jobs
    Senior Big Data Developer - ETL

    Senior Big Data Developer - ETL

    MOURITech • Chennai
    Looking for a Senior Big Data Developer to design, build, and optimize data pipelines and analytics solutions.Candidates with prior exposure to the Ericsson Wallet Platform will be given preference...Show more
    Last updated: 30+ days ago • Promoted
    Reltio Lead / Architect

    Reltio Lead / Architect

    Mastech Digital • chennai, tamil nadu, in
    Chennai / Bangalore / Hyderabad / Noida / Remote with quarterly visit.LPA (Depending on level of expertise).Immediate joiner / Currently serving notice / Notice is less than 60 days.We are looking for a hands...Show more
    Last updated: 30+ days ago • Promoted
    Informatica BDM Developer - ETL

    Informatica BDM Developer - ETL

    D4insight Pvt Ltd • Chennai
    Key Responsibilities : - Design, develop, and implement ETL workflows using Informatica BDM for large-scale data integra...Show more
    Last updated: 30+ days ago • Promoted
    Senior Python Data Engineer – ETL & Pipeline Development (5 to 12 yrs)

    Senior Python Data Engineer – ETL & Pipeline Development (5 to 12 yrs)

    AIMLEAP • Chennai, IN
    Senior Python Data Engineer – ETL & Pipeline Development.Remote (WFH) / Bangalore / India.Tech / MCA / Computer Science / IT. IT / Data / AI / LegalTech / Enterprise Solutions.ETL pipelines and data...Show more
    Last updated: 2 days ago • Promoted
    Actimize Developer

    Actimize Developer

    Matrix USA • chennai, tamil nadu, in
    We are seeking a talented Actimize and ETL Developer to join our dynamic development team.The ideal candidate will have a strong background in ETL development, system customization, and implementat...Show more
    Last updated: 22 days ago • Promoted
    Informatica IDMC Developer

    Informatica IDMC Developer

    Tata Consultancy Services • Chennai, India
    TATA Consultancy Services is hiring for Informatica IDMC Developer.Desired experience range : 4 to 8 years.Job locations : Bangalore, Chennai, Hyderabad. Data Project Lifecycle administration – onboar...Show more
    Last updated: 11 days ago • Promoted
    Ionixx Technologies - ETL Developer - Talend / Snowflake DB

    Ionixx Technologies - ETL Developer - Talend / Snowflake DB

    Ionixx Technologies • Chennai
    Job Description : Position : ETL Developer (Talend and Snowflake) Experience Level : 8+ Years Location : Chennai (Remote) ...Show more
    Last updated: 30+ days ago • Promoted
    ETL Developer - Data Analytics

    ETL Developer - Data Analytics

    XANDER CONSULTING AND ADVISORY PRIVATE LIMITED • Chennai
    Description : Seeking an experienced ETL Developer to design, build, and maintain data pipelines and integrations across...Show more
    Last updated: 30+ days ago • Promoted
    Data Platform Tech Lead

    Data Platform Tech Lead

    IMR Soft LLC • Chennai, Tamil Nadu, India
    Years ) | Chennai Only | 28 LPA |.Data Engineering (8 Years), Data Build Tool (DBT – Recent 2 Years).Looking for a Data Engineering Lead with extensive experience in ETL and Data Pipeline developme...Show more
    Last updated: 20 hours ago • Promoted • New!
    Reveille Technologies - ETL Developer - Informatica / Power Center

    Reveille Technologies - ETL Developer - Informatica / Power Center

    Reveille Technologies • Chennai
    Description : We are seeking passionate, experienced, and highly skilled ETL (Extract, Transform, Load) and SQL Developers to join our dyn...Show more
    Last updated: 30+ days ago • Promoted
    Data Integration Developer (Level 1)

    Data Integration Developer (Level 1)

    Blutic • Chennai, IN
    Data Integration Developer (Level 1).ETL processes and reports using.This entry-level role is ideal for developers looking to grow their skills in enterprise data solutions while contributing to cr...Show more
    Last updated: 12 days ago • Promoted
    TVS Next - Azure Data Lead - ETL / SQL / DataLake

    TVS Next - Azure Data Lead - ETL / SQL / DataLake

    TVS NEXT LIMITED • Chennai
    What youll do : - Lead the design, development, and maintenance of scalable data pipelines and lakehouse architectures using Azure Databricks (PySpark, SQL).Architec...Show more
    Last updated: 30+ days ago • Promoted
    Lead Data Engineer - ETL / Python

    Lead Data Engineer - ETL / Python

    Cynosure Corporate Solutions • Chennai
    Description : About The Role : We are seeking a highly skilled and experienced Senior / Lead Data Engineer to design, develop, and maintain scala...Show more
    Last updated: 30+ days ago • Promoted
    Data Integration Developer (Level 2)

    Data Integration Developer (Level 2)

    Blutic • Chennai, IN
    Data Integration Developer (Level 2).ETL processes, reports, and database solutions using.This role requires solid technical skills to implement solutions, optimize code, and collaborate effectivel...Show more
    Last updated: 22 days ago • Promoted
    ETL Developer

    ETL Developer

    Programmers.io • chennai, tamil nadu, in
    Shift Timings : General Shift (12 : 00 PM IST till 9 : 00 PM or 9 : 30 PM IST).Location : PAN India-Remote Until Office Resume, Work from Home. Experience required : 5 to 8 years.Design, develop, and maintai...Show more
    Last updated: 19 days ago • Promoted
    Senior Python Developer (Programming)

    Senior Python Developer (Programming)

    Jobseekerspage.com • chennai, tamil nadu, in
    HIRING - SENIOR PYTHON DEVELOPER.Senior Python Developer (Programming).We are seeking an experienced Python Developer with strong programming skills (not scripting) to develop and optimize data con...Show more
    Last updated: 5 days ago • Promoted
    ETL Developer - Azure Data Integration

    ETL Developer - Azure Data Integration

    HEXAWARE TECHNOLOGIES LIMITED • Chennai
    Description : We are seeking an experienced ETL Developer with deep expertise in Azure Data Integration technologies.The ideal candidate will play a key role in desig...Show more
    Last updated: 21 days ago • Promoted
    Data Architect - ETL

    Data Architect - ETL

    Talent Integrators • Chennai
    Job Description : We are seeking an experienced Data Architect Consultant to design, implement, and manage robust data architectures for government and enterprise-lev...Show more
    Last updated: 7 days ago • Promoted