Avatar for Concent Software Solutions
IT solutions aligning tech with business goals, driving digital transformation

Informatica IICS Developer

  • Santa Ana
  • |Contract
Posted: 1 week ago
Job Location
Santa Ana
Remote Work Policy

In office - WFH flexibility

Visa Sponsorship

Not Available

RelocationAllowed
Skills
Cloud Storage
XML
Authentication
JSON
Orchestration
Relational Databases
REST APIs
Enterprise Applications
Data Validation
Monitoring
Stored procedures
Deduplication
OAuth 2.0
Exception Handling
Reconciliation
Dimensional Modeling
Flat Files
ETL Design
SQL Queries
Query Performance Tuning
Pagination
Azure Synapse Analytics
Error Handling
Window Functions
Source-to-Target Mapping
Slowly Changing Dimensions
Fact and Dimension Tables
ELT Design
REST API Integrations
Data Quality Checks
Complex Joins
Cloud Data Integration (CDI)
Cloud Application Integration (CAI)
Retries
Data Loading Processes
Dedicated SQL Pools
Incremental Loading
Informatica Intelligent Data Management Cloud (IDMC/IICS)
Distributed Tables
Deletion Handling

About the job

Informatica ( IDMC/IICS ) 2520 Red Hill Ave. Santa Ana, CA 92705 HybridW2 preferred Role OverviewWe are seeking an ETL Developer with strong experience in Informatica Intelligent Data Management Cloud (IDMC/IICS), including Cloud Data Integration (CDI) and Cloud Application Integration (CAI), along with Azure Synapse Analytics. This role will develop and support data pipelines, application integrations, and data warehouse solutions for enterprise reporting and business operations.Key ResponsibilitiesDesign, develop, and maintain ETL/ELT pipelines using Informatica CDI to integrate data from databases, enterprise applications, APIs, and files.Build mappings, mapping tasks, reusable components, and taskflows for full and incremental data loads.Develop CAI processes, service connectors, and REST API integrations, including authentication, orchestration, error handling, and monitoring.Develop and optimize Azure Synapse SQL queries, stored procedures, and data loading processes.Implement data warehouse solutions, including fact and dimension tables, slowly changing dimensions, deduplication, and deletion handling.Perform source-to-target mapping, data validation, reconciliation, and data quality checks.Troubleshoot production failures, resolve data discrepancies, and improve integration performance.Collaborate with business analysts, application teams, and reporting teams to translate requirements into technical solutions.Maintain technical documentation, test plans, deployment instructions, and operational support procedures.Required QualificationsHands-on experience developing integrations using Informatica IDMC/IICS, with strong expertise in both CDI and CAI.Strong experience with Azure Synapse Analytics, particularly dedicated SQL pools, distributed tables, and query performance tuning.Advanced SQL skills, including complex joins, window functions, stored procedures, and troubleshooting.Experience with REST APIs, JSON/XML, OAuth 2.0, pagination, retries, and exception handling.Strong understanding of data warehousing, dimensional modeling, incremental loading, and ETL/ELT design.Experience integrating relational databases, cloud storage, flat files, and enterprise applications.Ability to investigate production issues independently and communicate clearly with technical and business teams.

About the company

Concent Software Solutions company logo
IT solutions aligning tech with business goals, driving digital transformation51-200 Employees
Learn more about Concent Software Solutions image