Informatica Analyst

Sonsoft Inc; Owings Mills (MD); On-site; USD 70,000 - 90,000; Full time

Job summary

A growing technology firm in Owings Mills, Maryland, is seeking a Software Developer with experience in Informatica and data warehousing. The ideal candidate should have at least 2 years of software experience, a bachelor’s degree or equivalent, and strong SQL skills. Key responsibilities include supporting ETL cycles, performance tuning of ETL code, and preparing technical documentation. This is a full-time, permanent position for U.S. citizens and authorized workers only.

Qualifications

• 2+ years of software experience with hands on experience on Informatica 8.x and above.
• Strong knowledge in Data warehouse concepts and dimensional modeling.
• Ability to analyze and debug complex SQL queries.

Responsibilities

• Support ETL cycles including production and environment quality issues.
• Prepare technical documentation of product subsystems.
• Define/improve processes for development and support functions.

Skills

Informatica

Data warehouse concepts

SQL programming

RDBMS knowledge

Performance tuning

ETL integration

Audit frameworks

Education

Bachelor’s degree or foreign equivalent

3 years of progressive experience in lieu of education

Job description

SonSoft Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. SonSoft Inc is growing at a steady pace specializing in the fields of Software Development, Software Consultancy, and Information Technology Enabled Services.

Job Description

• 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.
• Experience and desire to work in a Global delivery environment

Qualifications

• Bachelor’s degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education.
• At least 2 years of experience within the Information Technologies.

Additional Information

Connect with me athttps://www.linkedin.com/in/mir-hasham-ali/ (For Direct Clients Requirements)

** 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.

Note:-

• This is aFull-Time & Permanent job opportunity for you.
• Only US Citizen, Green Card Holder & GC-EAD can apply.
• No OPT-EAD, H1B, H4-EAD, L2-EAD & TN candidates, please.
• Please mention your Visa Status in your email or resume.

** All your information will be kept confidential according to EEO guidelines.