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
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Define and maintain the future-state business architecture for regulatory reporting within the Finance controllership value stream. Translate Finance strategy and regulatory needs into capabilities, services, processes, and target operating models. Represent business requirements in technology, data, and AI architecture forums; support delivery planning, governance, stakeholder alignment, process standardization, and continuous improvement. Ensure architecture traceability, data consistency, controls, measurable outcomes, and effective exception management.
Cloud • Information Technology • Productivity • Security • Software • App development • Automation
Lead product security initiatives across the software development lifecycle. Conduct threat modeling and security assessments, review cloud application designs, build security automation and detection controls, support cloud incident response, and guide engineering teams on secure development. The role also requires identifying AI/LLM risks, collaborating with technical and non-technical stakeholders, improving security processes, and mentoring security practitioners.
Top Skills:
Agentic AiAi/LlmApplication SecurityAWSAzureCloud SecurityGCPGoJavaPythonSaaSWeb Applications
Cloud • Information Technology • Productivity • Security • Software • App development • Automation
Build scalable, high-quality full-stack and frontend systems with effective AI integration. Design user interfaces, architect platforms, debug across the stack, and drive projects from technical design through launch and operations. Collaborate with cross-functional teams, lead code reviews, resolve complex issues, document solutions, and mentor engineers. The role emphasizes large-scale frontend development, testing, observability, system integration, and durable software engineering practices.
Top Skills:
AgileAngularjsChaiCSSCypressHTML5Javascript (Es6)JestMochaReactVue
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.
