Senior ETL Developer / Data Engineer

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., * 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.

Database Extract Transform and Load (ETL), Database Extract Transform and Load (ETL), Enterprise Data Integration, Snowflake Schema, SQL (Structured Query Language), IBM WebSphere DataStage, Data Management, Scalable System Development, Data Quality, Data Modeling, 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.