ETL Developer - Diverse Lynx

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