Diverse Lynx
ETL Developer
Diverse Lynx, Raleigh, North Carolina, United States, 27601
ETL Developer (10+ years minimum)Location: Raleigh, NC JOB DESCRIPTION (JD)We are searching for a skilled ETL Developer to join our team and play a key role in designing, developing, and implementing data warehouse solutions. You will leverage your expertise in ETL/data warehouse development and experience with Informatica tools to build and maintain high-quality data pipelines. Responsibilities Design, develop, and implement complex ETL processes using SAP BODS or related ETL tools (Informatica PowerCenter/DataStage) Utilize Informatica Intelligent Cloud Services (IICS) for application and data integration, data quality management, and Salesforce connectivity Collaborate with stakeholders to understand data requirements and translate them into effective data warehouse solutions Write complex SQL queries with nested joins and derived tables Design and implement data warehouse schemas to ensure data consistency and efficiency Experience working in Agile, Scrum, or Kanban methodologies Qualifications A minimum of 10 years of experience in ETL/data warehouse development Minimum 2-3 years of hands-on experience with Informatica Intelligent Cloud Services (IICS) components Proficiency in SAP BODS or related ETL tools (Informatica PowerCenter/DataStage) Strong understanding of data quality principles and techniques (plus if applicable) Experience developing application integrations using SOAP/REST APIs In-depth knowledge of Oracle database administration Experience designing data warehouse schemas Preferred Skills Experience with Master Data Management and Data Governance