Talent.com
Senior ETL Developer

Senior ETL Developer

KMR Executive SearchFairfield, Connecticut
job_description.job_card.variable_days_ago
serp_jobs.job_preview.job_type
  • serp_jobs.job_card.full_time
job_description.job_card.job_description

Details

Posted : 08-Aug-25

Location : Fairfield, Connecticut

Type : Full Time

Categories :

Technical (Programmer, Developer, Analyst)

Preferred Education :

4 Year Degree

Additional Information :

Hybrid / Remote is allowed.

Essential Functions

ETL Framework Development & Management

  • Design, develop, and maintain high-performance ETL pipeline
  • Ensure data accuracy, consistency, and integrity across different university systems.

Data Warehouse Optimization

  • Monitor and optimize ETL performance, load balancing, and execution times.
  • Work with data architects to enhance the existing cloud data warehouse framework.

    • Data Security & Governance

  • Implement data security best practices in alignment with compliance policies.
  • Ensure proper access control and data masking techniques.

    • Collaboration with Business & IT Teams

  • Work closely with institutional researchers, finance, admissions, and other departments to define and implement data ingestion rules.
  • Assist stakeholders in defining data transformations and modeling requirements.

    • Technology Evaluation & Best Practices

  • Stay current with emerging trends in data engineering, cloud computing, and machine learning.
  • Evaluate and recommend new tools, techniques, and methodologies for data integration.

    • Troubleshooting & Support

  • Monitor ETL jobs, troubleshoot failures, and optimize data pipeline performance.
  • Provide support for production data processes and resolve data inconsistencies.

    • Documentation & Knowledge Sharing

  • Maintain detailed technical documentation for ETL processes and data workflows.
  • Provide training and guidance to junior developers and data analysts.

    • Additional Responsibilities :

  • Participate in data migration and digital transformation initiatives .
  • Collaborate on business intelligence reporting and analytics solutions .
  • Develop and maintain data lineage and metadata management practices .
  • Perform other duties as assigned.
  • 5+ years of experience in data engineering, ETL development, and data integration.
  • 2+ years of experience in an ETL Architect or Lead role, designing scalable data pipelines.
  • Strong experience with cloud-based data warehousing and integration.
  • Proficiency in SQL, relational databases, and data modeling.
  • Hands-on experience in ETL tools such as Informatica (preferred), Talend, or AWS Glue.
  • Experience working with DevOps practices, version control, and CI / CD pipelines.
  • Strong understanding of data security, governance, and compliance.
  • ETL Development & Data Integration – Design and implement ETL workflows for structured and unstructured data.
  • Cloud Platforms – Knowledge of AWS, Azure, or GCP cloud environments.
  • Data Modeling & Performance Optimization – Optimize database design and query performance.
  • Scripting & Automation – Experience with Python, Shell scripting, and automation tools.
  • Business Intelligence & Analytics – Understanding of reporting tools and dashboard integration.
  • Networking & Connectivity – Familiarity with heterogeneous source systems, APIs, and database connectivity.

    • About KMR Executive Search

    serp_jobs.job_alerts.create_a_job

    Etl Developer • Fairfield, Connecticut