Sr. ETL Developer

Atria Group LLC; Des Moines (IA); On-site; USD 85,000 - 110,000; Full time

Job summary

Atria Group LLC is seeking a skilled Informatica Developer with over 5 years of experience in ETL process development and deployment within Unix and Oracle environments. The role involves analyzing metadata, creating complex SQL queries, and working in an Agile setup. Strong communication skills and the ability to work independently are essential for collaboration with clients and team members.

Qualifications

• 5+ years of experience in Informatica development.
• Experience in Unix and Oracle 11g environments.
• Strong communication skills to work with clients.

Responsibilities

• Developing and deploying Informatica in Unix and Oracle environments.
• Architecting ETL solutions and data conversion strategies.
• Gathering requirements and performing data QA activities.

Skills

Informatica Mappings

SQL Queries

Agile Environment

Data QA

Communication Skills

Job description

We specialize in Staffing, Consulting, Software Development, and Training along with IT services to small to medium size companies. AG's primary objective is to help companies maximize their IT resources and meet the ever-changing IT needs and challenges.

In addition, AG offers enterprise resource planning and enterprise application integration, supply-chain management, e-commerce solutions, and B2B public exchanges and B2B process integration solutions. Our company provides application analysis, design, development and programming, software engineering, systems development, testing, integration, and implementation, and management consulting services to various clients – including governmental agencies and private companies – throughout the United States and India.

We provide these services in multiple computing environments and use technologies such as client/server architecture, object-oriented programming languages and tools, distributed database management systems, state-of-the-art networking, and communications infrastructures. Our honest and realistic approach to recruiting dictates that AG does not entice or lure engineers from their employers. We represent only high caliber technical professionals who have committed to making a change required by career.

Job Description

Responsibilities:

• 5+ years of experience in development, maintenance, and enhancement of Informatica Mappings, Work-flows, and processes.
• Experience in developing and deploying Informatica in Unix and Oracle 11g database environment.
• Ability to analyze and retrieve metadata from Informatica repository.
• Ability to architect an ETL solution and data conversion strategy.
• Project experience with developing complex SQL queries.
• Project experience with dimensional data modeling.
• Experience working in an Agile environment.
• Ability to perform requirements gathering, development, and data QA activities as needed.
• Strong communication skills to work with clients, business users, and team members.
• Ability to work independently once guidance and goals are provided.