The Role
Designs, develops, and deploys Informatica PowerCenter ETL processes for data migration, transformation, and warehousing. Responsibilities include creating data integration strategies, writing and optimizing SQL and PL/SQL, monitoring and troubleshooting pipelines, ensuring data quality, documenting technical solutions, collaborating on requirements, and conducting code reviews. The role supports large-scale enterprise data environments and requires strong knowledge of data modeling, database architecture, and data warehousing.
Summary Generated by Built In
Summary
We are seeking a highly skilled Informatica ETL Developer to join our IT Services team. In this pivotal role, you will architect, design, and implement robust data integration solutions that drive business intelligence and operational efficiency. The ideal candidate will leverage their extensive experience to optimize data workflows, ensure data quality, and support complex analytical requirements. This position is critical for maintaining the integrity of our data infrastructure and enabling seamless data flow across various enterprise systems.
Responsibilities
- Design, develop, and deploy scalable ETL processes using Informatica PowerCenter to facilitate data migration and transformation.
- Architect efficient data integration strategies that align with organizational data governance policies and performance standards.
- Write, test, and debug complex SQL and PL/SQL queries to extract, transform, and load data from diverse sources into data warehouses.
- Collaborate with cross-functional teams to gather business requirements and translate them into technical specifications for data solutions.
- Monitor and troubleshoot ETL jobs, ensuring high availability and resolving performance bottlenecks in data pipelines.
- Document technical designs, data flow diagrams, and process documentation to support knowledge transfer and system maintenance.
- Conduct code reviews and implement best practices to enhance the reliability and maintainability of ETL frameworks.
Requirements
Requirements
- Minimum of 5 years of hands-on experience in ETL development within the IT Services sector.
- Proven expertise in Informatica ETL development, including mapping creation, workflow design, and transformation logic.
- Strong proficiency in SQL and PL/SQL for database manipulation, query optimization, and stored procedure development.
- Demonstrated ability to design and execute comprehensive ETL strategies for large-scale data environments.
- Solid understanding of data modeling concepts, database architecture, and data warehousing principles.
- Excellent problem-solving skills with the ability to analyze complex data issues and deliver effective solutions.
- Strong communication skills with the capacity to work collaboratively in a dynamic team environment.
Skills Required
- Minimum 5 years of hands-on ETL development experience within the IT Services sector
- Expertise in Informatica ETL development, including mapping creation, workflow design, and transformation logic
- Strong proficiency in SQL and PL/SQL for database manipulation, query optimization, and stored procedure development
- Experience designing and executing comprehensive ETL strategies for large-scale data environments
- Understanding of data modeling, database architecture, and data warehousing principles
- Strong problem-solving skills for analyzing complex data issues and delivering solutions
- Strong communication and collaboration skills
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Vrinda International is a Chandigarh-based recruitment and education consultancy connecting job seekers and employers through domestic and international IT and non-IT hiring. It also supports students with overseas university admissions, visa applications, education guidance, and test preparation for IELTS, PTE, and other programs. Its tech-enabled talent portal provides job matching and career pathways across India and global markets, alongside staffing partnerships.
