Application Developer- Informatica

Design and develop ETL/ELT workflows using Informatica IDMC.

Develop reusable mappings, mapping tasks, and taskflows.

Configure source and target connections.

Implement transformation and business rules.

Build parameter-driven and reusable integration components.

Maintain existing IDMC pipelines and workflows.

Develop complex SQL queries for data processing and reporting.

Create and maintain stored procedures and database objects.

Perform joins, aggregations, data validation, and reconciliation.

Optimize SQL queries for better performance.

Troubleshoot database and query-related issues.

Integrate data between different source and target systems.

Perform data extraction, transformation, validation, and loading.

Implement data quality checks and reconciliation controls.

Manage rejected records, duplicate data, and missing values.

Ensure accuracy, completeness, and consistency of data.

Support error handling, recovery, and restart processes.

Prepare unit test scenarios and test data.

Perform unit testing and integration testing.

Validate record counts, business rules, and transformation results.

Support system integration testing and user acceptance testing.

Resolve defects identified during testing.

Monitor IDMC jobs and pipeline performance.

Optimize mappings, taskflows, SQL queries, and database operations.

Analyze failed jobs and data processing errors.

Perform root cause analysis for recurring issues.

Recommend corrective and preventive actions.

Support code migration across development, testing, and production environments.

Follow project release and change management processes.

Monitor production data pipelines.

Resolve incidents and production data issues.

Coordinate with dependent teams during deployments.

Provide timely status updates for critical issues.

Follow data security, privacy, and governance standards.

Maintain mapping documents and technical design documents.

Prepare operational and deployment documents.

Document configurations, dependencies, and support procedures.

Support knowledge transfer to project and support teams.

Work closely with business analysts, data architects, application teams, and testing teams.

Participate in technical discussions and design reviews.

Provide effort estimates for assigned activities.

Communicate delivery risks and dependencies in advance.

Complete assigned work within agreed timelines and quality standards.

Informatica Intelligent Data Management Cloud – IDMC

SQL, Python

Oracle, SQL Server, PostgreSQL, or similar relational databases

ETL, ELT, Data Integration, Data Warehousing

Data Validation, Data Quality, Reconciliation and Error Handling