Summary:
Position Overview
We are seeking a highly skilled Senior ETL Informatica Developer with over 12 years of primary experience in designing, developing, and implementing ETL solutions using Informatica PowerCenter. The ideal candidate will have secondary expertise in SQL, Oracle E-Business Suite (EBS) R12, and Oracle Business Intelligence Applications (OBIA). This role requires a deep understanding of data integration, data warehousing, and business intelligence to support complex data transformation and reporting needs.
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 analysts and data architects to understand data requirements and ensure seamless data flow between source and target systems.
- 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.
- OBIA Implementation: Configure and customize Oracle Business Intelligence Applications (OBIA) to deliver actionable insights, including DAC (Data Warehouse Administration Console) setup and execution.
- 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:
- 12+ 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).
- 5+ years of experience working with Oracle E-Business Suite (EBS) R12, including data extraction from EBS modules (e.g., Financials, Supply Chain, HR).
- 3+ years of experience with Oracle Business Intelligence Applications (OBIA), including configuration, customization, and DAC scheduling.
- 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 and APIs for data extraction.
- Knowledge of OBIA architecture, including pre-built ETL mappings and BI dashboards.
- 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).
Pre-Requisites / Skills / Experience Requirements: