Data Engineer -pc and idmc

Data Engineer Experience: 58 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:

1. Design, develop, and optimize ETL workflows using Informatica PowerCenter (PC) and Informatica IDMC.
2. Manage data ingestion processes from diverse data sources such as Salesforce, Oracle databases, PostgreSQL, and MySQL.
3. Implement and maintain ETL processes and data pipelines to ensure efficient data extraction, transformation, and loading.
4. Utilize Snowflake as the data warehouse solution for managing large volumes of structured and unstructured data.
5. Maintain and optimize ETL jobs for performance and reliability, ensuring timely data availability for business users.
6. Support data migration, data integration, and data consolidation efforts.
7. Write and maintain basic Python scripts for data processing and automation tasks.
8. Utilize Unix shell commands for data-related tasks and system management.
9. Troubleshoot and resolve ETL-related issues, ensuring data integrity and availability.
10. Ensure adherence to best practices for data governance and security.

Professional Experience:

1. Informatica Developer

1. Developed ELT processes using PC/IDMC to integrate data into Snowflake.
2. Implemented storage management for Azure Blob and Snowflake, enhancing data security.
3. Worked on basic Python and shell scripting languages.