Jr. Informatica Developer

Sonoma Consulting Inc.; Owings Mills (MD); On-site; USD 80,000 - 100,000; Full time

Job summary

A premier IT consulting firm in Owings Mills, Maryland, seeks an experienced ETL Developer. This role emphasizes strong expertise in Informatica and SQL skills, with a focus on data warehousing and performance tuning. Ideal candidates will have at least 2 years in a related field and be comfortable resolving complex data issues. U.S. Citizens and Green Card Holders are encouraged to apply, as this is a full-time, permanent position with no sponsorship available.

Qualifications

• 2+ years of software experience with Informatica 8.x and above.
• Strong knowledge in data warehouse concepts and OLAP processing.
• Experience in performance tuning of Informatica mapping.
• Experience in integrating ETL with third party tools.
• Ability to analyze and debug complex SQL queries.
• Experience and desire to work in a Global delivery environment.

Skills

Informatica 8.x and above

Data warehouse concepts

OLAP processing

Performance tuning of Informatica mapping

Integrating ETL with third party tools

Strong SQL programming skills

RDBMS knowledge

Analytical skills

Client interfacing skills

Ability to work in team environment

Job description

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

Qualifications

• 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

Additional Information

** 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 andGreen Card Holder can apply. All your information will be kept confidential according to EEO guidelines.