ETL Developer

Sterling Search Partners is helping a growing client with its search for an ETL Developer. The ETL Developer is responsible for designing, building, and maintaining data pipelines that extract, transform, and load data from various sources into enterprise data warehouses and analytics platforms. This role ensures data accuracy, reliability, and accessibility to support business intelligence, reporting, and decision-making.

*******C2C is not an option for this position

Key Responsibilities

• Design, develop, test, and deploy ETL workflows using tools such as Informatica, Talend, SSIS, Azure Data Factory, or similar.
• Build and maintain data pipelines that integrate data from databases, APIs, flat files, cloud storage, and other systems.
• Develop and optimize SQL queries, stored procedures, and transformation logic.
• Maintain and enhance data models, data warehouse structures, and metadata.
• Ensure data quality, integrity, and consistency across systems.
• Monitor data loads, resolve failures, and troubleshoot performance issues.
• Collaborate with data architects, analysts, and stakeholders to understand business requirements.
• Create and maintain technical documentation for ETL processes.
• Support data governance, security, and compliance best practices.
• Automate repetitive data integration tasks and improve pipeline performance.

Requirements

• Bachelor's degree in Computer Science, Information Systems, Engineering, or equivalent experience.
• Strong experience with ETL tools (Informatica, SSIS, Talend, ADF, Databricks, etc.).
• Proficiency in SQL, relational databases (SQL Server, Oracle, MySQL, PostgreSQL), and data warehousing concepts.
• Experience with cloud data platforms (Azure, AWS, GCP) is highly desirable.
• Strong understanding of data modeling (star schema, snowflake, OLAP, OLTP).
• Ability to debug, optimize, and tune ETL workflows and SQL queries.
• Experience with scripting languages (Python, Bash, PowerShell) is a plus.
• Knowledge of data governance, security, and compliance standards.
• Excellent analytical, communication, and problem-solving skills.