What are the responsibilities and job description for the ETL / Data Warehousing Consultant (Informatica IICS & SSIS) position at CoStrategix?
*IMMEDIATE HIRING NEED*
Summary
We are seeking two highly experienced ETL / Data Warehousing Consultants to join a critical data modernization project for a leading national service brand headquartered in downtown Cincinnati.
In this role, you will be responsible for rewriting and optimizing existing data movement (ETL) code to transition from legacy data sources to a new architecture. You will work closely with the corporate data team to ensure the integrity of the data warehouse while implementing high-performance queries and modern cloud-integration workflows.
Key Responsibilities
- ETL Development: Rewrite existing ETL code to load data from new sources into established data warehouse tables.
- Cloud Integration: Utilize Informatica Intelligent Cloud Services (IICS)—specifically the Data Integration module—to manage and execute data flows.
- SSIS Management: Create and modify SQL Server Integration Services (SSIS) packages and jobs using Microsoft Visual Studio.
- SQL Optimization: Develop, execute, and fine-tune complex SQL queries to ensure maximum efficiency in data extraction and analysis.
- Collaboration: Work on-premise daily with the corporate data team to align on project requirements and technical logic.
Required Skills & Experience
- 8 years of experience in Data Warehousing and ETL development.
- Direct Experience with Informatica IICS: Proven expertise in the IICS Data Integration module is mandatory. (Note: Informatica PowerCenter experience alone will not be considered.)
- Proficiency in SSIS: Extensive experience creating and maintaining SSIS packages within the Microsoft Visual Studio environment.
- Advanced SQL: High-level proficiency in writing and optimizing SQL queries for various databases.
- On-Site Availability: Ability to work on-site at the corporate headquarters in downtown Cincinnati, OH, every day.
About CoStrategix
We make CoStrategix an awesome place to work, offering a total rewards package that includes comprehensive benefits starting on day one. Benefits include medical, dental, vision, disability, and life insurance, as well as an EAP and 401(k) retirement plan. We are a flexible hybrid workplace committed to a culture of curiosity, collaboration, learning, self-improvement, and, above all, fun. We have been named a finalist for the Cincinnati Business Courier's Best Places to Work Awards for 4 consecutive years.
Do the Right Thing. Always.
At CoStrategix, we are passionate about our core values. Diversity, equity & inclusion (DE&I) are part of our core values Every Gixer (employee) has an opportunity for success regardless of their race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. Creating an environment where everyone, from any background, can do their best work is the right thing to do.