ETL Developer

Job Description

We are seeking a skilled ETL Developer to design, develop, and optimize ETL (Extract, Transform, Load) processes to support data integration and warehousing solutions. The ideal candidate will have expertise in ETL tools, data modeling, and data pipeline development to ensure the efficient and reliable movement of data across various systems. This role requires close collaboration with data engineers, analysts, and business stakeholders to create data solutions that support decision-making and analytics.

Key Responsibilities:

• Design, develop, and maintain ETL workflows to extract data from multiple sources, transform data according to business rules, and load it into data warehouses or data lakes.
• Collaborate with data architects and stakeholders to define data requirements and create efficient ETL pipelines to meet business needs.
• Optimize ETL processes to improve performance and scalability, handling large datasets efficiently.
• Perform data validation, cleansing, and transformation to ensure data quality and integrity in target systems.
• Monitor, troubleshoot, and resolve issues with ETL processes, ensuring minimal downtime and accuracy of data flows.
• Maintain detailed documentation of ETL workflows, data mappings, and process specifications for future reference.
• Work with the team to implement and adhere to data governance, security, and compliance standards.

Requirements:

• Bachelor’s degree in Computer Science, Information Systems, or a related field.
• 3+ years of experience in ETL development, with strong knowledge of ETL tools (e.g., Informatica, Talend, SSIS).
• Proficiency in SQL and relational database management (e.g., Oracle, SQL Server, PostgreSQL).
• Experience with data warehousing concepts, data modeling, and data integration practices.
• Familiarity with cloud data platforms (e.g., AWS, Azure, Google Cloud) and cloud-based ETL tools.
• Strong problem-solving skills and attention to detail.
• Ability to work collaboratively with technical and business teams to deliver high-quality data solutions.

Preferred Qualifications:

• Experience with big data tools (e.g., Apache Spark, Hadoop).
• Knowledge of Python or other scripting languages for ETL automation.
• Familiarity with data governance and data quality tools.
• Relevant certifications in ETL tools or data engineering (e.g., Informatica Certified Specialist, Microsoft Certified: Azure Data Engineer).