Design, develop, and maintain complex ETL workflows using Informatica PowerCenter; extract/transform data from Oracle EBS R12; implement OBIA/DAC configurations; optimize ETL performance; write and tune SQL/stored procedures; enforce data quality, reconcile data, troubleshoot ETL failures, and document solutions while collaborating with DBAs, BI developers, and business stakeholders.
Summary:
We are seeking a highly skilled ETL Informatica Developer with over 4 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:
- 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.
Pre-Requisites / Skills / Experience Requirements:
Top Skills
Informatica Powercenter,Sql,Oracle E-Business Suite R12,Oracle Business Intelligence Applications (Obia),Data Warehouse Administration Console (Dac),Oracle,Stored Procedures,Triggers,Etl,Data Warehousing
Similar Jobs
Healthtech • Logistics • Pharmaceutical
Serve as HR technology systems administrator (Workday/HRIS) for time & attendance and related modules; partner with HR, Payroll, Finance and vendors; manage data integrity, SOX audit support, testing, releases, training, Tier 2 support, and process improvements.
Top Skills:
Workday,Hris,Hrms,Time Keeping,Time Tracking,Time Off,Absence Management,Payroll Systems,Talent Management,Kronos,Microsoft Word,Microsoft Excel,Microsoft Access,Sharepoint,Powerpoint,Xml,Xslt,Telephony,Case Management,Knowledge Management,Complex Reporting Tools
Healthtech • Logistics • Pharmaceutical
Provide user support for HR technology, troubleshoot issues, manage user access, and support project work related to Workday and other systems. Create reports and ensure compliance with SOX regulations.
Top Skills:
KronosMS OfficeSharepointWorkday
Healthtech • Logistics • Pharmaceutical
Perform data analysis and develop BI dashboards and visualizations to reveal trends and support profitable business decisions. Support BI solution delivery, reporting prioritization, data management standards, and project financial tracking. Validate data accuracy, investigate inconsistencies, and communicate requirements to stakeholders to inform strategic planning.
Top Skills:
AlteryxMS OfficePower BIQliksenseRdbmsSQLTableau
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.
