Diverse Lynx
ODI Senior Support Analyst
Diverse Lynx, Columbus, Indiana, United States, 47201
Role: ODI Senior Support AnalystLocation: Columbus, IN (Onsite)Duration: Full-Time
Job Description:
Experience in working with multiple source technologies like Oracle, SQL Server, Excel files, delimited files, RESTAPI and some exposure with Unix shell and Python scripting.Proficiency with working in Oracle 12c or higher environment, SQL and PL/SQL (packages, stored procedures, triggers).Proficiency in data modelling concepts, terminology, and architecture. Knowledge of dimensional modeling.Experience working with multiple source/target systems such as Oracle, XML files, Json ,flat files and excel documents.Expertise in ODI customization, migration between environments and load plan generation.Develop ETL mappings, workflows, and packages using ODI to integrate data from multiple sourcesHands on experience of minimum 10 years in ODI support and development.Develop and Support ODI packages.Re-use existing mappingsShould have the combination of ODI Support and Admin Capabilities in installation of agents etc.Enhancements to the existing ODI scenarios & ContextsJob scheduling , Exception handlingSupporting new integrations across on-premises and cloud integrations.Strong Oracle SQL expertiseSolid understanding of ETL conceptsExperience in logical data modeling and data transformation.Strong communication skills. The ability to work in a collaborative and energetic environment with other technology.Possesses extensive knowledge of and hands-on experience with oracle data integrator or other ETL tools.Deep understanding on the driver installations and ODI installations.Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.
Job Description:
Experience in working with multiple source technologies like Oracle, SQL Server, Excel files, delimited files, RESTAPI and some exposure with Unix shell and Python scripting.Proficiency with working in Oracle 12c or higher environment, SQL and PL/SQL (packages, stored procedures, triggers).Proficiency in data modelling concepts, terminology, and architecture. Knowledge of dimensional modeling.Experience working with multiple source/target systems such as Oracle, XML files, Json ,flat files and excel documents.Expertise in ODI customization, migration between environments and load plan generation.Develop ETL mappings, workflows, and packages using ODI to integrate data from multiple sourcesHands on experience of minimum 10 years in ODI support and development.Develop and Support ODI packages.Re-use existing mappingsShould have the combination of ODI Support and Admin Capabilities in installation of agents etc.Enhancements to the existing ODI scenarios & ContextsJob scheduling , Exception handlingSupporting new integrations across on-premises and cloud integrations.Strong Oracle SQL expertiseSolid understanding of ETL conceptsExperience in logical data modeling and data transformation.Strong communication skills. The ability to work in a collaborative and energetic environment with other technology.Possesses extensive knowledge of and hands-on experience with oracle data integrator or other ETL tools.Deep understanding on the driver installations and ODI installations.Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.