Overview
On Site
Depends on Experience
Contract - Independent
Contract - W2
Contract - 6 Month(s)
Skills
Informatica PowerCenter
Job Details
Job Title: Informatica PowerCenter Developer
Location: Waltham, MA (On-site)
Job Type: Contract
Experience Level: Mid-Senior
Experience Required: 7+ years
Pay Rate: $62/hour
Relocation Assistance: Not Available
Industry: Information Technology and Services
Education: Bachelor s Degree (required)
Key Skills:
- Informatica PowerCenter
- PL/SQL
- ETL Development
- Data Warehousing Concepts
- Performance Tuning
- PCS
Job Description:
Tata Consultancy Services (TCS) is seeking a highly skilled and experienced Informatica PowerCenter Developer for an on-site opportunity in Waltham, MA. The ideal candidate will have extensive experience in designing and developing ETL solutions using Informatica PowerCenter, with strong hands-on expertise in PL/SQL and a solid understanding of data warehousing concepts.
Responsibilities:
- Develop and maintain ETL mappings using Informatica PowerCenter.
- Translate business requirements and ETL specifications into robust ETL solutions.
- Perform data extraction, transformation, and loading from various source systems including flat files and relational databases.
- Use transformations such as Source Qualifier, Aggregator, Expression, Router, Filter, Sequence Generator, and Update Strategy to build complex data flows.
- Conduct performance tuning of Informatica mappings to ensure optimized data loads.
- Collaborate with business analysts and data architects to deliver high-quality data solutions.
- Troubleshoot issues in existing ETL processes and perform root cause analysis.
Qualifications:
- 7+ years of hands-on experience with Informatica PowerCenter.
- Strong experience in PL/SQL development and optimization.
- Solid understanding of Data Warehousing principles and architecture.
- Proven experience with performance tuning and troubleshooting Informatica mappings.
- Strong communication and documentation skills.
- Bachelor's degree in Computer Science, Information Technology, or a related field.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.