Informatica PowerCenter ETL Developer – Oracle BI Stack

4 days ago


Thoraipakkam Chennai Tamil Nadu, India Ilan Tech Solutions Private Limited Full time ₹ 9,00,000 - ₹ 11,42,670 per year

We're Hiring Immediate Joiner – Informatica Powercenter ETL Developer – Oracle BI Stack

Location: Chennai (Onsite/Remote – based on project needs)

Experience: 4+ Years

Job Description:

We are looking for an experienced ETL and reporting Developer with strong hands-on experience in Informatica PowerCenter and Power BI to join our team on a contractual basis. The ideal candidate will have a solid background in Informatica powercenter data integration, transformation, and data warehousing, with the ability to work across multiple data sources and platforms.

Key Responsibilities:

  • Design, develop, and maintain ETL workflows using Informatica PowerCenter and report development in Power BI is a value add.
  • Process data from various heterogeneous sources (e.g., SQL, flat files) into centralized data warehouses.
  • Perform data validation, Extraction, transformation logic implementation, and quality checks to ensure data accuracy.
  • Collaborate with business analysts to gather requirements and deliver actionable insights.
  • Implement error handling and logging for monitoring ETL pipelines and ensuring uninterrupted data flow.
  • Support data migration and integration projects, including on-prem to cloud transitions.
  • Create documentation and reports related to data processing, execution status, and discrepancies.
  • Experience with at least one Oracle module (Finance, SCM, or Projects) is required, particularly in the context of integrating or connecting Oracle as a source system

Primary Skills:

  • ETL Development using Informatica (PowerCenter)
  • Building reports in Power BI (or experience with similar BI tools)
  • Strong in SQL/PLSQL, data validation, and data quality concepts

Good to Have:

  • Experience with OBIEE, cloud platforms (e.g., Google Cloud), or Python scripting

Who Can Apply?

  • Professionals with 4+ years of Informatica ETL Powercenter experience
  • Candidates open to work in Chennai
  • Strong Oracle BI stack background preferred

Job Types: Full-time, Permanent, Freelance, Volunteer

Pay: ₹75, ₹95,522.44 per month

Benefits:

  • Food provided
  • Health insurance
  • Provident Fund

Application Question(s):

  • What is your Current CTC?
  • What is your Expected CTC?
  • Are you currently serving your notice period? If yes, please mention your last working day or confirm if you are available for immediate joining.
  • Mention your Overall Experience in Informatica PowerCenter ETL with Oracle BI Stack?

Work Location: In person



  • Bengaluru, Chennai, Hyderabad, India ti Steps Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Job Summary:We are seeking an experienced Informatica Consultant to design, develop, and implement ETL (Extract, Transform, Load) and data integration solutions using Informatica PowerCenter and related tools. The role involves working closely with business stakeholders, data architects, and developers to ensure accurate, efficient, and scalable data...


  • Chennai, Tamil Nadu, India Diverse Lynx Full time

    Hiring for Informatica Power center- Hyderabad Design develop and implement scalable and high-performance ETL workflows using Informatica PowerCenter Extract transform and load data from various sources including flat files relational databases APIs etc Understand business requirements and translate them into technical specifications and data solutions...


  • tamil nadu, India Tata Consultancy Services Full time

    TCS Hiring !!! Role: Oracle DBA +Oracle Goldengate Exp: 5-10 Years Location: Chennai/Hyderabad/Ahmedabad/Kolkata JD Database Administration 1. Design, implement, and manage Oracle databases to meet business requirements. 2. Ensure database performance, security, and availability. 3. Troubleshoot database issues and provide timely resolution. 4. Develop and...


  • tamil nadu, India Tata Consultancy Services Full time

    TCS Hiring !!!Role: Oracle DBA +Oracle GoldengateExp: 5-10 YearsLocation: Chennai/Hyderabad/Ahmedabad/KolkataJDDatabase Administration 1. Design, implement, and manage Oracle databases to meet business requirements. 2. Ensure database performance, security, and availability. 3. Troubleshoot database issues and provide timely resolution. 4. Develop and...


  • Chennai, India Kumaran Systems Full time

    Job Description Job Responsibilities: - Create and execute workflows for data processing and ETL pipelines. - Work with flat files, data feeds, and job schedulers. - Understand and analyze business data flows. - Perform data conversion from Informatica PowerCenter to Databricks. - Support ETL pipelines and integrate with Azure Data Factory. - Collaborate...


  • Bengaluru, Chennai, Hyderabad, India Venpa Staffing Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    We are seeking a highly skilled Informatica Administrator to manage, maintain, and optimize our Informatica environments. The ideal candidate will be responsible for the installation, configuration, monitoring, and troubleshooting of Informatica services and related infrastructure, ensuring high availability and performance.Roles & ResponsibilitiesInstall,...


  • Chennai, India Kumaran Systems Full time

    Job Description Key Responsibilities: - Lead and manage Informatica, DataStage, and Databricks environments, teams, and projects. - Provide technical guidance and ensure best practices in ETL design, data quality, and performance optimization. - Manage code reviews, testing, deployment, and change management processes. - Hands-on involvement with ETL tools...


  • Chennai, India Tata Consultancy Services Full time

    TCS Hiring !!!Role: Oracle DBA +Oracle GoldengateExp: 5-10 YearsLocation: Chennai/Hyderabad/Ahmedabad/KolkataJDDatabase Administration1. Design, implement, and manage Oracle databases to meet business requirements.2. Ensure database performance, security, and availability.3. Troubleshoot database issues and provide timely resolution.4. Develop and implement...


  • Chennai, India Tata Consultancy Services Full time

    TCS Hiring !!!Role: Oracle DBA +Oracle GoldengateExp: 5-10 YearsLocation: Chennai/Hyderabad/Ahmedabad/KolkataJDDatabase Administration1. Design, implement, and manage Oracle databases to meet business requirements.2. Ensure database performance, security, and availability.3. Troubleshoot database issues and provide timely resolution.4. Develop and implement...


  • Chennai, India Tata Consultancy Services Full time

    TCS Hiring !!!Role: Oracle DBA +Oracle GoldengateExp: 5-10 YearsLocation: Chennai/Hyderabad/Ahmedabad/KolkataJDDatabase Administration1. Design, implement, and manage Oracle databases to meet business requirements.2. Ensure database performance, security, and availability.3. Troubleshoot database issues and provide timely resolution.4. Develop and implement...