Informatica ETL Developer

Direct message the job poster from n Search Global Senior Managing Consultant at n Search Global Pte Ltd Responsibilities: Design ETL workflows, mappings, and transformations using Informatica Power Center Define data mappings, data flow diagrams, and transformation logic Extract data from various source systems, such as databases, files, APIs, and web services Implement efficient and reliable data extraction processes.Transform, clean, and enrich data as it moves through the ETL pipeline; Apply data quality rules and data validation during transformation Load transformed data into target systems, including data warehouses, data marts, and databases; Ensure data loading processes are optimized for performance Develop ETL mappings, workflows, and scripts in Informatica Power Center; Write SQL queries and scripts for data manipulation and transformation.Implementation of Data Pipelines to Big Data platform using Informatica ETLRequirements: Proficiency in Informatica Power Center for ETL development, including designing, developing, and debugging mappings, sessions, and workflows. Experience in optimizing ETL processes for better performance Ability to extract, transform, and load data from various sources such as databases, flat files, and cloud-based systems Expertise in SQL for writing complex queries, stored procedures, and performance tuning. Knowledge of relational database systems like Oracle, SQL Server, or My SQLDeep understanding of data warehousing principles, including star and snowflake schemas, slowly changing dimensions (SCD), and fact and dimension tables Experience in designing end-to-end ETL workflows that handle data extraction, transformation, and loading with minimal latency Knowledge of data quality management and governance principles. Familiarity with data profiling tools and processes to ensure data accuracy and consistency Proficiency in scripting languages like Shell Scripting, Python, or Perl for automation and ETL integration tasks Experience with cloud platforms and tools for data integration, such as Informatica Cloud, AWS Glue, or Azure Data Factory, is an advantage Seniority level Seniority level Associate Employment type Employment type Contract Job function Job function Information Technology Industries Information Technology & Services, IT Services and IT Consulting, and Data Infrastructure and Analytics Referrals increase your chances of interviewing at n Search Global by 2x Get notified about new Informatica Developer jobs in Dubai, Dubai, United Arab Emirates.Dubai, Dubai, United Arab Emirates 15 hours ago Dubai, Dubai, United Arab Emirates 1 year ago Dubai, Dubai, United Arab Emirates 15 hours ago Software Development Engineer in Test (SDET)Global Village, Dubai, United Arab Emirates 2 months ago Senior Software Engineer - Fin IQ (Techno-Functional)Quality Assurance /Test Engineer (Arabic Speaker)Global Village, Dubai, United Arab Emirates 6 months ago We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr