Data Engineer

Experience: 5-8 Years

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
• 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