Informatica Developer

Key Responsibilities: Analyze and reverse-engineer existing Informatica workflows, mappings, sessions, and dependencies. Assess the complexity, design patterns, and data flow logic of current ETL processes. Document ETL logic, data transformations, source/target systems, and business rules in a structured format. Export and catalog Informatica assets for migration planning. Collaborate with cloud architects and data engineers to define migration strategy to Azure Databricks. Identify reusable components and opportunities for optimization in the target architecture. Provide technical leadership and guidance to migration teams. Participate in migration planning, estimation, and risk assessment. Ensure documentation is comprehensive, accurate, and aligned with enterprise standards.

Required Skills & Qualifications: 5+ years of experience in Informatica PowerCenter ETL development. Proven experience in analyzing and documenting complex ETL workflows. Strong SQL and data profiling skills. Familiarity with Azure ecosystem, especially Azure Data Factory, Azure Databricks, and Delta Lake. Experience in data warehousing and data modeling concepts. Excellent written and verbal communication skills. Ability to work independently and lead technical discussions.

Preferred Qualifications: Experience in cloud migration projects (Informatica to Azure). Informatica and Azure certifications. Exposure to Agile methodologies and DevOps practices. Knowledge of Python or PySpark for Databricks development.