Senior ETL Developer / Data Engineer

Job Title

Senior ETL Developer / Data Engineer

Location

Oaks, Pennsylvania (PA)

Job Duration

6+ months

Job Summary

We are seeking an experienced ETL Developer / Data Engineer to design, develop, implement, and maintain enterprise data integration and data transformation solutions. The ideal candidate should have strong hands-on experience with ETL processes, IBM InfoSphere DataStage, Snowflake, DBT (Data Build Tool), and SQL.

The candidate will be responsible for building scalable data pipelines, transforming data from multiple sources, optimizing data workflows, and ensuring data quality and reliability. Experience with Denodo is highly preferred.

Key Responsibilities

• Design, develop, and maintain ETL processes using IBM DataStage.
• Build and optimize data pipelines for extracting, transforming, and loading data from multiple source systems.
• Develop data transformation models and workflows using DBT.
• Work extensively with Snowflake for data warehousing, data integration, and performance optimization.
• Write complex SQL queries, stored procedures, and data transformation logic.
• Integrate data from multiple enterprise applications and databases.
• Implement data validation, reconciliation, and quality checks to ensure data accuracy.
• Troubleshoot ETL failures, performance bottlenecks, and data integration issues.
• Collaborate with data architects, business analysts, and engineering teams to deliver enterprise data solutions.
• Leverage Denodo for data virtualization and enterprise data integration, where applicable.

Required Skills (Must Have)

• ETL: Strong experience in ETL development, data integration, and data transformation.
• IBM DataStage: Hands-on experience developing and maintaining DataStage jobs and workflows.
• Snowflake: Strong experience with Snowflake data warehouse, SQL development, and query optimization.
• DBT: Experience developing DBT models, transformations, and data pipelines.
• SQL: Advanced SQL skills, including complex queries, joins, stored procedures, and performance tuning.

Preferred Skills

• Denodo: Experience with Denodo data virtualization, logical data layers, and integration across multiple data sources.
• Experience with enterprise data warehousing and modern data architecture.
• Knowledge of data modeling and data governance.
• Experience with cloud-based data platforms.

Metasys Technologies/NVISH is an equal opportunity employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identify, national origin, veteran or disability status.