Job Title

Job Description: Junior Informatica ETL IDC Developer with Python KnowledgePosition: Junior Informatica ETL IDC DeveloperExperience: 1 – 4 yearsLocation: RemoteEmployment Type: Full-timeJob SummaryWe are seeking a Junior Informatica ETL IDC Developer with 1-4 years of experience in designing, developing, and maintaining ETL workflows using Informatica PowerCenter and Informatica Intelligent Cloud Services (IICS/IDMC). The ideal candidate should have basic Python scripting skills to enhance automation, data processing, and cloud integrations.This role involves working closely with data engineers, analysts, and business teams to ensure seamless data integration, transformation, and loading into data warehouses/lakes.Key ResponsibilitiesETL Development & Maintenance:Design, develop, and test Informatica PowerCenter mappings, workflows, and sessions.Work with Informatica Cloud (IICS/IDMC) for cloud-based ETL solutions (CDI, Mass Ingestion).Optimize ETL jobs for performance and scalability.Python Scripting for Automation & Enhancements:Use Python (Pandas, NumPy, PySpark) for advanced data transformations and validations.Automate file processing, logging, and error handling using Python scripts.Integrate Python with Informatica workflows for custom logic.Data Integration & Cloud ETL:Extract and load data from SQL databases, flat files, APIs, and SaaS applications.Work with AWS S3, Snowflake, Redshift, or BigQuery for cloud data warehousing.Assist in real-time data pipeline development using Kafka, REST APIs.Troubleshooting & Performance Tuning:Debug and fix ETL job failures.Optimize SQL queries and mappings for efficiency.Collaboration & Documentation:Work with cross-functional teams to gather requirements.Document ETL processes, data flows, and mappings.Required Skills & Qualifications1-4 years of hands-on experience in Informatica PowerCenter (Mappings, Workflows, Sessions).Exposure to Informatica Intelligent Cloud Services (IICS/IDMC) is a plus.Basic Python scripting skills (Pandas, NumPy, file handling, API calls).SQL proficiency (Joins, Aggregations, Stored Procedures).Familiarity with cloud platforms (AWS/Azure/GCP) & data warehouses (Snowflake, Redshift).Understanding of ETL best practices, data modeling, and SCDs.Knowledge of scheduling tools (Autosys, Control-M) is a bonus.Preferred QualificationsInformatica Cloud Certification (IICS/IDMC).Experience with PySpark for big data processing.Knowledge of CI/CD pipelines (Git, Jenkins, Airflow).Why Join Us?✅ Opportunity to work on cutting-edge cloud ETL & data integration projects.✅ Career growth into Senior ETL Developer, Cloud Data Engineer, or Data Architect.✅ Exposure to Python automation, AI/ML in ETL, and modern data stacks.How to Apply?Interested candidates can share their resume to hr@