Develop and implement ETL solutions using Informatica PowerCenter, optimize performance, collaborate with teams, and ensure data quality.
Summary:
We are seeking a highly skilled ETL Informatica Developer with 3 to 5 years of primary experience in designing, developing, and implementing ETL solutions using Informatica PowerCenter.Duties & Responsibilities:
Key Responsibilities
- ETL Development: Design, develop, and maintain complex ETL workflows, mappings, and transformations using Informatica PowerCenter to support data integration and data warehousing initiatives.
- Data Integration: Collaborate with business users to understand data requirements.
- Performance Optimization: Optimize ETL processes for performance, scalability, and reliability, including tuning mappings, sessions, and workflows.
- SQL Development: Write and optimize complex SQL queries, stored procedures, and triggers to support ETL processes and data validation.
- Oracle EBS R12 Support: Extract and transform data from Oracle E-Business Suite (EBS) R12 modules, ensuring accurate integration with downstream systems.
- Data Quality: Implement data quality checks, error handling, and reconciliation processes to ensure data accuracy and consistency.
- Collaboration: Work closely with cross-functional teams, including database administrators, BI developers, and business stakeholders, to deliver end-to-end data solutions.
- Documentation: Create and maintain technical documentation for ETL processes, data models, and system integrations.
- Troubleshooting: Identify and resolve ETL job failures, performance bottlenecks, and data issues in a timely manner.
- Mentorship: Provide guidance and mentorship to junior developers on Informatica best practices and data integration techniques.
Required Qualifications
- Experience:
- 3 to 5 years of hands-on experience with Informatica PowerCenter (version 9.x or higher) in designing and implementing ETL solutions.
- Strong secondary experience with SQL for querying, data manipulation, and performance tuning in relational databases (e.g., Oracle, SQL Server).
- Technical Skills:
- Expertise in Informatica PowerCenter components (Designer, Workflow Manager, Workflow Monitor, Repository Manager).
- Proficiency in writing complex SQL queries, PL/SQL, and stored procedures.
- Familiarity with Oracle EBS R12 table structures.
- Experience with data warehousing concepts, dimensional modeling, and star/snowflake schemas.
- Understanding of data integration best practices, including incremental loading, change data capture (CDC), and Slowly Changing Dimensions (SCD).
- Soft Skills:
- Strong analytical and problem-solving skills.
- Excellent communication and collaboration abilities.
- Ability to work independently and manage multiple priorities in a fast-paced environment.
- Education:
- Bachelor’s degree in computer science, Information Technology, or a related field (or equivalent experience).
- Bachelor’s degree in computer science, Information Technology, or a related field (or equivalent experience).
- Certifications (preferred):
- Informatica PowerCenter Developer Certification.
Pre-Requisites / Skills / Experience Requirements:
Top Skills
Informatica Powercenter
Oracle
SQL
SQL Server
Similar Jobs
Artificial Intelligence • Cloud • HR Tech • Information Technology • Productivity • Software • Automation
The Key Account Director will develop sales strategies, manage client relationships, and achieve sales quotas for CRM & Industry solutions, driving growth for ServiceNow.
Top Skills:
AICRMCustomer Service ManagementEnterprise Resource PlanningSalesforce Automation
Artificial Intelligence • Cloud • HR Tech • Information Technology • Productivity • Software • Automation
The Key Account Director will develop sales strategies, manage client relationships, close sales opportunities, and oversee the CRM & Industry Solutions market success, particularly in the BFSI sector.
Top Skills:
AICRMCustomer Service ManagementEnterprise Resource PlanningSalesforce Automation
Artificial Intelligence • Cloud • HR Tech • Information Technology • Productivity • Software • Automation
The CRM Account Executive manages client relationships and sales strategies for ServiceNow's CRM solutions, aiming to achieve sales quotas and ensure customer satisfaction.
Top Skills:
AICRMCustomer Service ManagementEnterprise Resource PlanningSales Force Automation
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.
