Logo
Eliassen Group

Informatica Consultant

Eliassen Group, Carlsbad, California, United States, 92002

Save Job

Informatica Consultant

Our client, a leader in golf equipment and apparel, has an excellent opportunity for an Informatica Consultant to work on a contract opportunity. Work will be on-site in Carlsbad, CA. The Informatica Consultant will be responsible for designing, developing, and maintaining scalable ELT/ETL pipelines using Informatica Cloud (IICS), integrating APIs, and working with cloud technologies in a fast-paced, agile environment. Due to client requirement, applicants must be willing and able to work on a W2 basis. For our W2 consultants, we offer a great benefits package that includes Medical, Dental, and Vision benefits, 401k with company matching, and life insurance. Rate: $40 - $80 / hr. W2 Responsibilities: Design, develop, and maintain robust ELT/ETL pipelines using Informatica Cloud (IICS). Build and support integrations and APIs leveraging Informatica Cloud. Collaborate with cross-functional teams to gather requirements and deliver data solutions aligned with business goals. Maintain and optimize existing data workflows and systems for performance and reliability. Work with enterprise-level RDBMS such as Oracle and SQL Server to manage and transform data. Develop and maintain data models and support data warehouse architecture. Implement cloud-based solutions using Microsoft Azure, including deployment and monitoring. Utilize messaging systems like Kafka for real-time data processing and integration. Participate in Agile ceremonies and contribute to sprint planning, reviews, and retrospectives. Ensure timely delivery of projects while managing competing priorities in a dynamic environment. Document technical processes and provide support for production systems. Experience Requirements: Informatica Cloud (IICS): Strong hands-on experience in developing and maintaining solutions. ETL/ELT Development: Proven track record of building scalable and reliable data pipelines from scratch. API Integration: Experience in designing and managing APIs and integrations using Informatica. RDBMS Expertise: Proficiency in Oracle and SQL Server, including writing complex queries and performance tuning. Cloud Technologies: Hands-on experience with Microsoft Azure (Data Factory, Blob Storage, etc.). Messaging Systems: Familiarity with Kafka or similar technologies for streaming data. Data Modeling: Solid understanding of data warehouse concepts and dimensional modeling. Agile Methodology: Experience working in Agile teams and delivering in iterative cycles. Communication Skills: Ability to clearly articulate technical concepts to non-technical stakeholders. Organizational Skills: Highly organized with the ability to manage multiple tasks and meet deadlines. Education Requirements: B.S. in Computer Science, Mathematics, or Engineering or equivalent work experience.