Quick Overview
Job Description
Role: ETL Python Developer
Location: Nashville, TN (Onsite)
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
Similar jobs
- RK
Lead Fullstack Ruby Developer
NewRKMC Inc.
Minneapolis, MN🇺🇸Hybrid7 hours agoRubyAWSGitHub ActionsTechnology - VI
Full-Stack Software Engineer with Security Clearance
NewViasat, Inc.
La Canada Flintridge, CA🇺🇸$117k - $185k/yrHybridYesterdayDockerMicroservicesNext.js+15Technology - DR
Mid-Level Full Stack Web Developer (MTS-2) with Security Clearance
NewDraper
Cambridge, MA🇺🇸$75k - $156k/yrOn-siteYesterdayAgileTechnology - RM
Full Stack Developer with Security Clearance
RMentras
Alexandria, VA🇺🇸On-site5 days agoDockerOracleSQL+13Technology - IC
ServiceNow Developer (ITSM, ITOM, Scoped App) - Remote with Security Clearance
NewICF Consulting Group, Inc.
Reston, VA🇺🇸$81.5k - $167.6k/yrRemoteYesterdayCSSJavaScriptREST+2Technology - BO
Flight Simulation Software Engineer (Associate, Experienced, and Senior)
NewBoeing
Daytona Beach, Florida🇺🇸$92.7k - $125.3k/yrHybrid43 minutes agoAgileC#C+++2Technology