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
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.
Similar Jobs
Aerospace • Artificial Intelligence • Cloud • Machine Learning • Software • Cybersecurity • Defense
Supports aerospace engine and APU systems engineering across requirements development, MBSE architecture, integration, verification, and validation. Develops traceable requirements and SysML models, performs functional decomposition and interface definition, supports trade studies and technical reviews, and collaborates with design, software, controls, safety, reliability, test, and certification teams. Contributes to system integration, test planning, requirements traceability, issue investigation, technical documentation, and MBSE process improvement.
Top Skills:
Arp4754AArp4761CameoDo-160Enterprise ArchitectIbm Doors NgJamaMagicdrawPolarionRhapsodySysml
Artificial Intelligence • Consumer Web • Edtech • HR Tech • Information Technology • Software • Conversational AI
Manages multiple customer-facing professional services engagements, including Percipio platform implementations, integrations, and learning delivery projects. Ensures projects meet scope, schedule, budget, quality, and business objectives. Responsibilities include developing project plans, coordinating cross-functional resources, managing risks and changes, tracking progress, communicating status, and overseeing complex customer portfolios. The role requires billable consulting experience, strong virtual collaboration skills, and the ability to manage multiple projects across time zones.
Top Skills:
Learning Content Management Systems (Lcms)Learning Management Systems (Lms)ExcelMicrosoft OutlookMicrosoft PowerpointMicrosoft ProjectMicrosoft TeamsMicrosoft WordPercipioPlatform As A Service (Paas)
Aerospace • Artificial Intelligence • Cloud • Machine Learning • Software • Cybersecurity • Defense
Perform embedded software verification and validation for core platform components. Develop test plans, conduct requirements- and scenario-based testing, execute change impact analyses, resolve technical issues, and support audits. The role involves C/C++ and RTOS verification, emulator and debugger use, stakeholder communication, technical leadership, mentoring engineers, and driving quality, cost, schedule, and process improvements.
Top Skills:
As9100BitbucketCC++DeosDoors NgIcdJIRALauterbachLdraLinuxRtosVectorcast/Cover
What you need to know about the Pune Tech Scene
Once a far-out concept, AI is now a tangible force reshaping industries and economies worldwide. While its adoption will automate some roles, AI has created more jobs than it has displaced, with an expected 97 million new roles to be created in the coming years. This is especially true in cities like Pune, which is emerging as a hub for companies eager to leverage this technology to develop solutions that simplify and improve lives in sectors such as education, healthcare, finance, e-commerce and more.
