Experience Inc. Jobs

Job Description

An Insight Global client in the Houston area is looking for an ETL Developer to join the Datawarehouse team as a lead consultant. The main project this consultant will be assisting with is the migration from Data Stage to ODI. This person will be responsible for understanding and creating new ODI maps, understanding of modules, topology of ODI, etc. This person will responsible of understanding current jobs and spearheading new jobs and ideas. Additionally, this person needs to have strong SQL skills as well as a strong understanding of Oracle as it relates to databases. Lastly, this person will need strong developmental skills and will report directly to the Director of Auxiliary Services.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com .

To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/ .

Skills and Requirements

8+ years of experience developing ETL jobs using ODI to extract, transform, and load data from various sources into the data warehouse

8+ years of experience performing performance tuning of the data warehouse, ETL jobs, and SQL queries to ensure optimal performance and scalability

Strong SQL analysis skills and experience in database tuning and optimization.

Implementing changes to existing Data Warehouse schema and ETL processes as needed

In depth understanding of ODI Topology and Knowledge Modules

Experience in Converting Datastage ETL Jobs to ODI Mappings

Experience in understanding Datastage jobs and ability to reverse engineer the functionality

Experience working with PeopleSoft HCM/FMS/CS as data source for the Data Warehouse null

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion,sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military oruniformed service member status, or any other status or characteristic protected by applicable laws, regulations, andordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to HR@insightglobal.com.