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 connectivityCollaborate with stakeholders to understand data requirements and translate them into effective data warehouse solutionsWrite complex SQL queries with nested joins and derived tablesDesign and implement data warehouse schemas to ensure data consistency and efficiencyExperience working in Agile, Scrum, or Kanban methodologies
Qualifications
A minimum of 10 years of experience in ETL/data warehouse developmentMinimum 2-3 years of hands-on experience with Informatica Intelligent Cloud Services (IICS) componentsProficiency 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 APIsIn-depth knowledge of Oracle database administrationExperience designing data warehouse schemas
Preferred Skills
Experience with Master Data Management and Data Governance
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 connectivityCollaborate with stakeholders to understand data requirements and translate them into effective data warehouse solutionsWrite complex SQL queries with nested joins and derived tablesDesign and implement data warehouse schemas to ensure data consistency and efficiencyExperience working in Agile, Scrum, or Kanban methodologies
Qualifications
A minimum of 10 years of experience in ETL/data warehouse developmentMinimum 2-3 years of hands-on experience with Informatica Intelligent Cloud Services (IICS) componentsProficiency 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 APIsIn-depth knowledge of Oracle database administrationExperience designing data warehouse schemas
Preferred Skills
Experience with Master Data Management and Data Governance