Lead Informatica Developer - SQL/IICS/Power Center (5-10 yrs) (ClickForCareers)

Responsibilities :

- Create and publish processes in IICS Application Integration designer using service connectors like REST, JDBC, File, etc.

- Deliver enhancements on the IICS Application Integration components architecture of API Processes, Service Connectors and process objects.

- Build Service connectors from within Informatica for Real Time IICS integration with client's Cloud applications (e.g. Salesforce).

- Develop API Integrations using IICS and further incorporate and enhance the EPIC SDK calls with the AMS.

- Employ Framework design, building solutions, issue clarification, unit test case preparation and testing.

- Resolve all the technical impediments like requirement dependency, data dependency environments, UAT QA support

- Document technical implementation of the integration solutions, data flows, and key components for broader support.

- Apply best practices of design implementation within the Application Integration Module.

- Communicate project status within standup and Project Management calls.

- Create Process Objects and EPIC SDK actions, similar to other API web service library calls.

- Be Agile and demonstrate the ability to learn new technology and quickly adapt to technology changes.

- Flexibility to occasionally work nights and weekends for deployments.

Qualifications :

- 3 years of hands-on Informatica Power Center/Informatica Intelligent Cloud Service (ICS/IICS) Experience

- 5-6 years of experience in RDMBS (SQL Server), including complex SQL constructs and DDL generation

- Extensive experience working with various data sources (SQL and Oracle database, flat files (csv, delimited), Web API, XML,

- Advanced SQL skills required. Solid understanding of relational databases and business data; ability to write complex SQL queries against a variety of data sources (OLTP, Data Warehouse)

- Comprehensive knowledge of Informatica Architecture - User interface design skills working knowledge of data modeling (conceptual, logical and physical) as well as database design

- 4-year degree preferred in Management Information Systems or equivalent combination of education and experience

Apply Now