Wednesday, 14 January 2015

Data Warehouse Modeler / ETL Developer

Location - Bloomfield, CT
Duration - >12 months

Job Description

·         Build and support ETL mapping/workflows
·         Define transformation rules for source to target mappings and develop the software components to support the transformation
·         Interact with Business Intelligence Lead, other staff, and other program technical staff as needed to ensure proposed development strategy and implementation meets programs objectives
·         Develop ETL's using Oracle ODI for Data Extraction, Data Mapping and Data Conversion
·         Ensure all software developed for migration of production data is developed, controlled, and tested to the same quality level as production software
·         Proven experience of building high performing physical and logical models that work with OBIA and OBIEE
·         Good understating of ETL/ELT methodologies using Oracle Data Integrator, DataStage, Informatica, or other Enterprise ETL Tool.
·         Proven experience of working with business partners/data modelers/architects in building consensus, socializing data solutions/designs
Mandatory Skills:
·         OLAP  Logical and Physical Data Model
·         Teradata and its Utilities (BTEQ, Fasltoad, MultiLoad, FastExport, TPUMP , TPT)
·         Background + experience on ODI, Data Stage, Informatica ETL tools
·         Experience in OBIA / OBIEE BI Reporting tools
·         Over 10 years of IT experience and over 5 years of experience on TERADATA development and OLAP operation with TERADATA database
·         Proven track record in planning, building, and managing successful large-scale Data Warehouse
·         Strong analytical skills

·         Bachelor's degree in Computer Science, Information Systems, Electrical Engineering or related field preferred.
·         Eight plus years of related responsible experience in large corporate systems environments working with large and complex data warehouse systems.
·         Must have at least 5 years of hands-on experience working with Teradata in multi terabytes environment.
·         Must have at least 5 years of experience in writing complex ETL packages.
·         Must have at least 5 years of hands on experience in database and SQL performance tuning.
·         Extensive hands-on technical knowledge of Oracle ODI -Data Warehouse Architecture, ETL, Oracle, mainframe and Teradata databases.