Description

You will design and implement end-to-end ETL processes to support data warehousing and integration needs.

Responsibilities

• Build ETL workflows using Informatica PowerCenter and IDQ to extract, transform, and load data in batch and real time.
• Execute data migration, conversion, and cleansing processes from flat files and relational databases.
• Develop Snowflake objects including databases, tables, schemas, stages, file formats, and pipes.
• Lead requirements gathering sessions with business SMEs to develop user stories, process flows, and functional specifications.
• Conduct data profiling and analysis to ensure data quality and metadata management.

Required Skills

• 12+ years of experience in ETL development and application development projects.
• Expertise in Informatica PowerCenter and Informatica Data Quality (IDQ).
• Proficiency with Informatica Designer tools, specifically Mapping and Workflow Designer.
• Advanced SQL skills for writing complex queries across multiple source tables and views.
• Hands-on experience with Snowflake database architecture and object creation.
• Deep understanding of Data Migration, Data Integration, and Data Cleansing.
• Experience in Data Profiling, Data Conversion, and Data Quality management.
• Ability to lead requirement teams and manage conceptual and interaction design activities.
• Proven ability to produce technical documentation, including data flows and gap analysis.

Key Skills

Education

Any Gradute