Face-to-Face (F2F) Mandatory ETL Developer, Nashville, TN (Locals Only) | W2 Hiring

Role: SSIS ETL Developer (DB2 to Oracle Fusion)
Location: Nashville, TN (Locals Only)
Experience: 10+ Years
Interview: Face-to-Face (F2F) Mandatory

ETL / Data Flow
DB2 → SSIS / ETL Pipeline → Data Transformation & Validation → Oracle Fusion

Job Overview
We are looking for an experienced ETL Developer to support a data integration project involving the migration of data from DB2 to Oracle Fusion.
The ideal candidate should have strong hands-on experience with SSIS, SQL, DB2, data transformation, and ETL pipelines. Experience with Oracle Fusion integration is highly required.

Key Responsibilities

• Develop and maintain ETL pipelines to extract data from DB2.
• Transform data based on business requirements and mapping rules.
• Load and integrate data into Oracle Fusion.
• Design, develop, and optimize SSIS packages or similar ETL workflows.
• Perform data profiling, cleansing, validation, and reconciliation.
• Troubleshoot ETL failures, data discrepancies, and performance issues.
• Work with business and technical teams to understand data mapping and transformation requirements.
• Document ETL processes, data flows, and mapping specifications.
• Monitor production ETL jobs and support scheduled data loads.
• Troubleshoot and resolve production incidents related to ETL and data integration.

Required Skills

• 8+ years of hands-on ETL Development experience
• Strong SQL skills
• Hands-on experience with DB2
• Strong experience with SSIS (SQL Server Integration Services)
• Experience integrating/loading data into Oracle Fusion
• Strong understanding of ETL concepts and data integration
• Experience with data mapping and transformation logic
• Experience with data validation, cleansing, and reconciliation
• Strong troubleshooting and production support skills
• Ability to work independently and collaborate with cross-functional teams
• Experience with other ETL tools such as Informatica, Talend, ODI, or similar platforms.

Important Requirements

⚠️ Onsite in Nashville, TN
⚠️ F2F interview is mandatory
⚠️ Strong SQL + SSIS + DB2 experience is essential
⚠️ Oracle Fusion integration experience is highly important