No. of Resource:- 01
Availability:- Immediate
Location:- Dubai
Industry:- Real Estate
Email:- hr@staffconnect.ae
WhatsApp:- +971 529421270
Job Summary
Experienced Informatica PC and IDMC Developer with 5+ years in data engineering. Skilled in designing end-to-end data pipelines using PC/IDMC for effective migration and transformation across cloud platforms. The ideal candidate will have in-depth knowledge of Informatica PowerCenter and IDMC. A strong foundation in Data Warehousing concepts and proficiency in Snowflake and SQL is essential. Strong team player with agile experience, delivering timely, high-impact data solutions.
Technical Skills
• Tools Informatica Cloud Data Integration, Informatica PowerCenter
• Data Warehousing Snowflake, DataLake
• Programming SQL, Python, Shell Scripting
• Data Management Storage management, quality monitoring, governance
• Modeling Dimensional modeling, star/snowflake schema
Core Competencies
• Design, develop, and optimize ETL workflows using Informatica PowerCenter (PC) and Informatica IDMC.
• Manage data ingestion processes from diverse data sources such as Salesforce, Oracle databases, PostgreSQL, and MySQL.
• Implement and maintain ETL processes and data pipelines to ensure efficient data extraction, transformation, and loading.
• Utilize Snowflake as the data warehouse solution for managing large volumes of structured and unstructured data.
• Maintain and optimize ETL jobs for performance and reliability, ensuring timely data availability for business users.
• Support data migration, data integration, and data consolidation efforts.
• Write and maintain basic Python scripts for data processing and automation tasks.
• Utilize Unix shell commands for data-related tasks and system management.
• Troubleshoot and resolve ETL-related issues, ensuring data integrity and availability.
• Ensure adherence to best practices for data governance and security.
Professional Experience:
• Informatica Developer Experience: 5-8 Years
• Developed ELT processes using PC/IDMC to integrate data into Snowflake.
• Implemented storage management for Azure Blob and Snowflake, enhancing data security.
• Worked on basis Python and shell scripting languages