About this opportunity
Syntricate Technologies lists this ODI Production Support Analyst opportunity in bloomfield, Connecticut. Review the employer’s description below for duties, qualifications and application requirements.
Job description
Job TitleRequired Skills: 6+ Year experienceDWH support experience using ODI.Should have experience in developing ETL processes - ETL control tables, error logging, auditing etc.Should be able to implement reusability, parameterization, workflow design, etc.Knowledge of ODI Master and work repositorySetting up topology, building objects in Designer, Monitoring Operator, different type of KMs, Agents etc using ODI mappings, error handling, automation using ODI, Load plans, Migration of ObjectsDesign and develop complex mappings, Process Flows and ETL scriptsMust be well versed and hands-on in using and customizing Knowledge Modules (KM)Experience of performance tuning of mappingsAbility to design ETL unit test cases and debug ETL MappingsExpertise in developing Load Plans, Scheduling JobsAbility to design data quality and reconciliation framework using ODIIntegrate ODI with multiple Source / TargetExperience on Error recycling / management using ODI, PL/SQLExperience in SQL tuning and optimization using explain plan and Sql trace files.Strong knowledge of ELT/ETL concepts, design and codingPartitioning and Indexing strategy for optimal performance
Worksite address
bloomfield, CT, 06002, US
Who can apply
Review the original listing for work authorization, qualifications and employer requirements.