Informatica Developer
Role details
Job location
Tech stack
Job description
- The Informatica Developer is responsible for designing, developing, and supporting cloud-based data integration and master data management solutions between Salesforce and enterprise systems.
- This role ensures high-quality, trusted, and governed data flows using PowerCenter/Informatica Intelligent Data Management Cloud (IDMC), including MDM, Data Integration, and data quality components.
- The developer works closely with business stakeholders, architects, and Agile delivery teams to translate business and data requirements into scalable, secure, and performant integration solutions., * Design, develop, and implement Salesforce integrations using Informatica IDMC, including Data Integration.
- Gather and analyze business, data, and integration requirements, and translate them into technical solutions aligned with enterprise architecture standards.
- Implement cloud-based data integration solutions across Salesforce and downstream/upstream systems, ensuring reliability and scalability.
- Investigate, analyze, and resolve data quality issues such as inaccuracies, duplicates, and incompleteness; proactively communicate findings to business and design teams.
- Support Agile implementation teams throughout the development lifecycle, including sprint planning, development, testing, and deployments.
- Develop and support Informatica mappings and workflows to move, transform, and synchronize data between Salesforce and enterprise databases.
- Perform debugging, troubleshooting, enhancements, unit testing, and performance optimization of integration and MDM solutions.
- Write and execute complex queries to validate data, support analysis, and ensure data is accessible, consistent, and performant.
- Ensure solutions comply with data governance, security, and compliance requirements, especially in a cloud-based IDMC environment.
- Build and maintain MDM mappings, hierarchies, match/merge rules, and integration pipelines to support master and reference data use cases.
Primary Skill
- Informatica
- Secondary Skill
- Salesforce
Requirements
- Informatica, UNIX shell scripting, Power Center, SQL experience,.
- 5 + years of Software Development Lifecycle analysis experience.
- 5 + years of Informatica ETL development experience using PowerCenter 10.x and PowerExchange / Informatica Cloud (IDMC).
- 5 + years of experience with ETL tuning and performance 4 + years of strong SQL experience with relational databases.
- 5 + years of experience with UNIX shell scripting 3 + years of experience with Autosys.
- 1 - 2 years of Salesforce integration experience will be ideal
Desired Qualifications
- PowerCenter to IDMC Migration
- Informatica
- MS SQL Server
- Salesforce
Benefits & conditions
Pay Range*: $64/Hr on w2 to $68/HR on W2 *Pay range offered to a successful candidate will be based on several factors, including the candidate's education, work experience, work location, specific job duties, certifications, etc.
Benefits: Innova Solutions offers benefits( based on eligibility) that include the following: Medical & pharmacy coverage, Dental/vision insurance, 401(k), Health saving account (HSA) and Flexible spending account (FSA), Life Insurance, Pet Insurance, Short term and Long term Disability, Accident & Critical illness coverage, Pre-paid legal & ID theft protection, Sick time, and other types of paid leaves (as required by law), Employee Assistance Program (EAP).