ETL Developer
Direct responsibility for the design, maintenance, and support of Data Warehouse Systems.  The developer requires a high level of analytical and creative skills and an in-depth knowledge of database structure, data warehouse configuration, methodology, design, and modeling.  The developer’s typical duties includes but not limited to designing and building data warehouses,   designing ETL processes and procedures using tools such as InfoSphere,  performing analysis, SQL scripting, Unix Scripting tuning and optimization on very large (multi-terabyte) databases, working with lead application developers to design and develop database objects and structures according to project specifications, addressing data quality issues with users, analyzing organizational data requirements and reviewing/Understanding logical and physical Data Flow Diagrams and Entity Relationship Diagrams using tools such as Visio and Erwin. Must be able to work with and within a cross-functional development, QA and production team. Responsibilities include the following:Reviewing and understanding complex database structures and maps.Solid understanding of both relational and dimensional database structuresLocal Installation and configuration of InfoSphere Data Integration suiteTroubleshooting InfoSphere Data Integration componentsProject migrations to/from various environmentsDevelop and troubleshoot UNIX scriptsSetup database connectivity to various database environmentsMonitor environments according to security requirementsMonitor jobs for performance issues and troubleshootingDevelop, enhance, and support best practices and standards for data integrationProvide performance tuning insight to project teamsMentor developers on data integration best practices and standardsPerform design and code reviews for the projects to ensure alignment with best practices and standards
Title: ETL Developer
Salary: None
Description: Direct responsibility for the design, maintenance, and support of Data Warehouse Systems.  The developer requires a high level of analytical and creative skills and an in-depth knowledge of database structure, data warehouse configuration, methodology, design, and modeling.  The developer’s typical duties includes but not limited to designing and building data warehouses,   designing ETL processes and procedures using tools such as InfoSphere,  performing analysis, SQL scripting, Unix Scripting tuning and optimization on very large (multi-terabyte) databases, working with lead application developers to design and develop database objects and structures according to project specifications, addressing data quality issues with users, analyzing organizational data requirements and reviewing/Understanding logical and physical Data Flow Diagrams and Entity Relationship Diagrams using tools such as Visio and Erwin. Must be able to work with and within a cross-functional development, QA and production team. Responsibilities include the following:Reviewing and understanding complex database structures and maps.Solid understanding of both relational and dimensional database structuresLocal Installation and configuration of InfoSphere Data Integration suiteTroubleshooting InfoSphere Data Integration componentsProject migrations to/from various environmentsDevelop and troubleshoot UNIX scriptsSetup database connectivity to various database environmentsMonitor environments according to security requirementsMonitor jobs for performance issues and troubleshootingDevelop, enhance, and support best practices and standards for data integrationProvide performance tuning insight to project teamsMentor developers on data integration best practices and standardsPerform design and code reviews for the projects to ensure alignment with best practices and standards
Requirements: Mid-Senior level experience, None education
Fraudulent: No