ETL Developer

Description

Desired Skills effectively troubleshoot, debug and problem solve complex issueseffective verbal and written communication skillsexperience in an ETL tool across multiple platformsunderstanding of data warehouse concepts, including star schemasproficient in SQLable to mentor less experienced associatesstrong analytical and organizational skillsable to multitask and effectively perform multiple assignmentspreparation of technical specification documentationconducting requirements analysis, schema design, database object creation, testing, and maintenanceability to demonstrate leadership qualities.Experience Ideal candidates have one or more years of ETL development experience; Data Stage is preferred, but Informatica experience will also be consideredexperience with multiplatform environments and languages, including OS/390, Windows Server, AIX, UNIX, Linux and Korn Shell scriptingexperience with DB2 UDB and Utilitiesexperience in multidimensional data modeling, such as star schemas, snowflakes, normalized and denormalized models, handling slowchanging dimensions/attributesexperience designing and developing exception handling, data standardization procedures and quality assurance controlsexperience implementing and refining required business transformation rules and logicexperience analyzing source systems for data profiling and creation of source to target mapping specsIBM Information Server (DataStage)progressive experience in conceptual, logical, physical data modeling; design, development and delivery of data centric IT solutions, including relational databases, data warehouses, ETL/ELT processes and reporting applications within the financial industryHadoopinsurance experience preferredOLAP and reporting tool technologies such as SSRS