Job Description
A client in the Cincinnati area is looking to hire an Informatica Developer to support the data warehousing team. This individual will be rewriting existing data movement code (ETL Code) to load data from a new data source to existing data warehouse tables. The individual will work onsite downtown in Cincinnati, OH.
Day‑to‑Day Responsibilities
- Rewrite existing ETL/data movement code to integrate new data sources into established data warehouse tables.
- Develop, optimize, and troubleshoot SQL queries for data extraction and analysis.
- Build, modify, and maintain SSIS packages and scheduled jobs.
- Use Informatica IICS Data Integration for data movement and transformation tasks.
- Collaborate closely with the internal data warehousing team on‑site.
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/.
Required Skills & Experience
- 4-6 years of Informatica IICS experience within the Data Integration Module
- 4-6 years of SQL experience building and optimizing SQL queries to extract and analyze data
- Experience/knowledge of SQL Server Integration Services (SSIS) packages
- Experience rewriting existing ETL code to load data from new source into existing data warehouse tables
Benefit packages for this role will start on the 1st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.