Informatica Powercenter Consultant

Teamware Solutions

4 - 6 years

3 - 12 Lacs

bengaluru karnataka india

Posted:9 hours ago| Platform: Foundit logo

Apply

Skills Required

source-to-target mapping

Work Mode

On-site

Job Type

Full Time

Job Description

Job Summary:

The Informatica PowerCenter Consultant is responsible for designing, developing, and managing data integration workflows using Informatica PowerCenter. This role works with business and technical teams to ensure efficient, scalable, and secure ETL processes that support data warehousing and business intelligence initiatives.

Key Responsibilities:

Design, develop, and maintain ETL workflows and mappings using Informatica PowerCenter
Analyze data requirements and source systems to develop efficient data integration solutions
Perform data extraction, transformation, and loading (ETL) from various sources into data warehouses
Optimize ETL jobs for performance, scalability, and reliability
Work closely with business analysts, data modelers, and database teams to meet data requirements
Conduct unit testing, resolve defects, and support deployment activities
Monitor production jobs, troubleshoot issues, and ensure timely data availability
Document ETL processes, technical specifications, and data flow diagrams
Ensure adherence to data governance, quality, and security standards

Required Skills and Qualifications:

Bachelor's degree in Computer Science, Information Technology, or related field
3+ years of experience working with Informatica PowerCenter
Strong expertise in ETL design, development, and performance tuning
Proficient in writing complex SQL queries and working with relational databases
Experience in data analysis, source-to-target mapping, and workflow management
Solid understanding of data warehousing concepts and best practices
Excellent troubleshooting, problem-solving, and communication skills

Preferred Qualifications:

Informatica, PowerCenter certification
Experience with cloud-based data platforms (e.g., AWS, Azure, Snowflake)
Familiarity with data governance, data quality, and metadata management tools
Experience in migrating or upgrading Informatica environments
Exposure to Agile project methodologies and DevOps tools

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

Teamware Solutions

IT Services and IT Consulting

Chennai Tamilnadu

RecommendedJobs for You

Informatica Powercenter Consultant

Teamware Solutions

Please Verify Your Phone or Email

Confirm Action

Informatica Powercenter Consultant