Halo Group is a premier provider of IT talent. We place technology experts within
the teams of the world’s leading companies to help them build innovative
businesses that keep them one step closer to their customers and one step
ahead of the competition. We offer a meaningful work environment for
employees, attractive and interesting engagements for consultants, and cutting-edge
digital innovation for our customers.
We delight in helping our customers execute their digital vision. Big projects or
small, Halo Group knows that by combining the highest quality talent with our
unwavering support, we will become an invaluable extension of the team. Halo
Group's experienced consultants in Detroit, Atlanta and Dallas specialize in all
areas of product/project governance, UX/UI, multi-platform applications, quality
assurance/testing, cloud computing, and data analytics.
Since its inception, Halo Group has been recognized for numerous awards, including:
- INC 5000
- Future 50
- 101 Best and Brightest
- Michigan 50 Companies to Watch
- Goldline Research - “Most Dependable Companies”
- Ernst & Young - “Entrepreneur of the Year” Finalist
- 2+ years of software experience with extensive hands on experience on Informatica 8.x and above.
- Strong knowledge in Data warehouse concepts, dimensional modeling, OLAP processing.
- Experience in performance tuning of Informatica mapping.
- Experience in integrating ETL with third party tools.
- Experience in auditing and error handling frameworks using informatica.
- Support ETL cycles including production issue and environment quality issue.
- Prepare technical documentation of product sub systems.
- Performance tune ETL code in a high volume environment.
- Resolved data problem discovered by quality QA and developed solution to the problem.
- Define/improve processes for development and support functions.
- Strong SQL programming skills and strong RDBMS knowledge including the ability to analyze and debug complex SQL queries.
- Ability to work in team environment and client interfacing skills.
- Analytical skills
- Experience and desire to work in a Global delivery environment
** U.S. Citizens and those who are authorized to work independently in the United States are encouraged to apply. We are unable to sponsor at this time.
This is a Full-Time / Permanent job opportunity.
Only US Citizen and Green Card Holder can apply.
** All your information will be kept confidential according to EEO guidelines.
Skills Required
- 2+ years software experience with hands-on Informatica 8.x and above
- Strong knowledge of data warehouse concepts and dimensional modeling
- Experience with OLAP processing
- Experience in performance tuning of Informatica mappings
- Experience integrating ETL with third-party tools
- Experience building auditing and error-handling frameworks in Informatica
- Support ETL cycles including production issue resolution and environment quality issues
- Prepare technical documentation of product subsystems
- Performance tune ETL code in a high-volume environment
- Strong SQL programming skills and strong RDBMS knowledge; ability to analyze and debug complex SQL queries
- Ability to work in a team environment and client interfacing skills
- Analytical skills and experience/desire to work in a global delivery environment
What We Do
Sonoma Consulting Inc. is a national IT consulting and executive search firm founded in 2011 by Mark McGee. The company operates through two business divisions—IT Consulting Services and Executive Search—serving approximately 150 national clients that range from entrepreneurial start-ups to Global Fortune 500 companies. It specializes in harmonizing systems and application or infrastructure development projects.
