Informatica Developer

American CyberSystems
Pennington, United States of America
6 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Junior
Compensation
$ 141K

Job location

Pennington, United States of America

Tech stack

Unit Testing
CA Workload Automation Ae
Cloud Computing
Cloud Database
Databases
Data Governance
Data Integration
ETL
Relational Databases
Software Debugging
Data Intelligence
Shell
Microsoft SQL Server
Performance Tuning
Scrum
Reference Data
Standard Sql
Salesforce
Software Engineering
SQL Databases
Data Streaming
Enterprise Software Applications
Informatica Cloud
Data Management

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).

About the company

ABOUT INNOVA SOLUTIONS: Founded in 1998 and headquartered in Atlanta, Georgia, Innova Solutions employs approximately 50,000 professionals worldwide and reports an annual revenue approaching $3 Billion. Through our global delivery centers across North America, Asia, and Europe, we deliver strategic technology and business transformation solutions to our clients, enabling them to operate as leaders within their fields. Recent Recognitions: * Named One of America's Best Employers for New Grads by Forbes (2024 * Named One of the Best Companies to Work for by U.S. News & World Report (Private Companies List, 2024-2025) * One of the Largest IT Staffing Firms in the US - Ranked #3 by Staffing Industry Analysts (SIA, 2024) * One of the Largest Staffing Firms in the US - Ranked #13 by Staffing Industry Analysts (SIA, 2024; includes Innova Solutions, Volt, & HireGenics) * Named One of the Top Ten Private Companies in Atlanta by the Atlanta Business Chronicle (2023) * One of the Largest Certified Minority Business Enterprises (MBEs) in the United States (NMSDC, 2024) * AWS Advanced Tier Services Partner with 100+ certifications Website: https://www.innovasolutions.com, employment opportunities. Innova Solutions (HireGenics/Volt) does not discriminate against applicants based on citizenship status, immigration status, or national origin, in accordance with 8 U.S.C. § 1324b. The company will consider for employment qualified applicants with arrest and conviction records in a manner that complies with the San Francisco Fair Chance Ordinance, the Los Angeles Fair Chance Initiative for Hiring Ordinance, and other applicable laws. By applying for this job, you agree to receive calls, AI-generated calls, text messages, or emails from Innova Solutions and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy at Privacy Policy - innovasolutions.

Apply for this position