Lead Informatica Specialist

Job Description

We are seeking an experienced Informatica ETL Specialist to join our team and lead the design, development, and optimization of high-performance ETL solutions using Informatica Cloud (CDI & CAI) . The ideal candidate will have extensive hands-on experience working with data transformation tools, databases, and enterprise applications, with a strong focus on integration, cloud environments, and real-time solutions . You will play a critical role in shaping the data integration strategy and collaborate with cross-functional teams to ensure the seamless exchange of data between multiple applications such as SAP , Salesforce , Callidus Cloud , SQL/Oracle Databases , and various cloud based applications. Key Responsibilities Design, Develop, and Optimize ETL Solutions : Lead the creation, development, and enhancement of ETL solutions using Informatica Cloud (CDI & CAI) , ensuring high-quality data flows and performance. Requirements Gathering : Engage with business stakeholders to gather requirements for data transformations across various enterprise applications such as SAP, Salesforce, Callidus Cloud, SQL and Snowflake Database. Cloud Integration : Provide first and second-level support for real-time app and API integrations within Informatica Cloud (CDI & CAI) , particularly for eCommerce and Pro Portal applications. Leadership and Oversight : Provide direct oversight to contractors and other team members involved in developing and enhancing ETL solutions. Ensure consistency in coding standards, reusable components, and adherence to best practices. Technical Documentation : Write and maintain comprehensive technical documentation for ETL workflows, including system design, data mapping, transformation logic, and user guides. Collaboration & Communication : Work closely with internal teams and external partners to ensure alignment on integration strategies and deliverables. Serve as a liaison to stakeholders regarding system functionality, data mapping, and dependencies. Design and Specifications : Contribute to the creation of functional and system design specifications for new development projects, ensuring alignment with business needs. Business Advisory : Provide subject-matter expertise and advice to business users on the effective use of data integrations, application functionalities, and the optimal load frequencies based on business requirements. Qualifications You Must Have: 5-8 years of application development and implementation experience in medium to large-scale enterprise environments. 4+ years of hands-on experience with Informatica Cloud (CDI & CAI) for ETL processes, with expertise in designing and developing ETL pipelines. 4+ years experience working with enterprise applications , including SAP , Salesforce , SQL , Snowflake , and cloud-based solutions. 3+ years of database design and administration experience, preferably with SQL Server and Snowflake . We Value: Proven track record of working in cloud environments , particularly for real-time integrations and API-based workflows . Strong understanding of data integration techniques and data transformation logic . Exceptional consultative skills , with the ability to engage business stakeholders in defining technical requirements and deliverables. Demonstrated project management capabilities , with the ability to prioritize tasks, meet deadlines, and adapt to changing priorities. Strong verbal and written communication skills , with the ability to communicate effectively across global teams. Self-motivated and able to work independently, as well as within a collaborative team environment. #LI-JR2