ETL Architect

Excellent communication and interpersonal skills.

Developing and implementing an overall organizational ETL & data strategy that is in line with business processes.

Ensuring data consistency and accuracy through data validation and cleansing techniques

Working together with cross-functional teams to identify and address data-related issues.

Preserve and present data classifications that support the application layer and align with business requirements.

Proficient in data integration and ETL tools, such as Informatica IICS.

Able to understand and document the data flow between the various source system.

Design, develop, and maintain ETL/ELT pipelines using Informatica Intelligent Cloud Services (IICS).

Build scalable and efficient data integration solutions for cloud and on-premise systems.

Develop and optimize data models, transformations, mappings, and workflows in Snowflake.

Implement data ingestion pipelines from APIs, databases, flat files, and cloud platforms.

Perform data cleansing, transformation, validation, and enrichment activities.

Create and optimize SQL queries, stored procedures, and Snowflake objects.

Monitor and troubleshoot ETL jobs, workflows, and data pipeline failures.

Collaborate with business analysts, architects, and stakeholders to gather requirements.

Ensure data quality, governance, and security standards are maintained.

Experience in Integration ways for both synchronous and a synchronous Integration.

Good exposure of IICS Administration concepts and user management.

Application and data architecture are aligned and is tied to company global strategy.

Create global strategy for data management and governance Liaison between the application team and customer ELT team.