Technology Lead - Informatica Developer

Familiarity with data warehousing concepts, dimensional modeling, and data governance practices

End-to-end exposure to project phases: initiation, requirement analysis, design, build, testing, UAT, deployment, and warranty/support.

Experience working in Agile/Scrum or Waterfall project environments.

Ability to prepare and review technical design documents, test plans, and deployment plans.

Experience coordinating with cross-functional teams (business, QA, infrastructure, DBA) to ensure on-time, quality delivery.

Familiarity with change management, version control (e.g., Git), and release management practices.

Participate in the complete project life cycle (PLC) — requirement gathering, analysis, design, development, unit testing, UAT support, deployment, and post-go-live support.

Design, develop, and maintain ETL/ELT mappings, workflows, and sessions using Informatica PowerCenter (on-premise) and Cloud Data Integration (CDI-PC).

Build and manage cloud-native data integration pipelines using Informatica Intelligent Data Management Cloud (IDMC), including CDI, CAI, and Mass Ingestion components as applicable.

Analyze business and functional requirements and translate them into technical design documents (Source-to-Target mappings, ETL design specs).

Develop and optimize complex SQL queries, stored procedures, and views for data extraction, transformation, and validation.

Write and maintain UNIX shell scripts for job scheduling, file handling, automation, and workflow orchestration.

Perform data profiling, data quality checks, and error handling within ETL processes.

Conduct performance tuning of mappings, sessions, and SQL queries to improve throughput and reduce processing time.

Collaborate with business analysts, DBAs, QA teams, and project managers throughout all SDLC/PLC phases.

Prepare and maintain technical documentation, including design documents, unit test cases, and deployment/run-books.

Support migration/upgrade activities from PowerCenter to IDMC/Cloud platforms.

Troubleshoot production issues, perform root cause analysis, and implement permanent fixes.

Adhere to coding standards, version control practices, and change management/release processes.

Provide effort estimates, status updates, and risk assessments to project managers and stakeholders.

Experience with cloud data warehouses (Snowflake, or Azure Synapse).

Exposure to Informatica Cloud Application Integration (CAI) and API-based integrations.

Knowledge of Python or other scripting languages for automation.

Experience with CI/CD pipelines for data integration deployments.