Applications Analyst 2
VIAVI
0 - 3 years
Pune
Posted: 25/02/2026
Job Description
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:
About Company
Viavi Solutions Inc. is a global provider of network testing, monitoring, and assurance solutions, headquartered in Milpitas, California. The company offers a range of products and services designed to support network operators, service providers, and enterprises in optimizing their network performance, security, and service quality. Viavi's solutions are used in areas such as 5G, fiber optics, wireless, and cloud networking. The company provides network testing tools, performance monitoring, and troubleshooting solutions for both physical and virtual networks. Viavi is also known for its expertise in optical networking and its role in advancing technologies related to network automation, performance visibility, and cybersecurity.
Services you might be interested in
Improve Your Resume Today
Boost your chances with professional resume services!
Get expert-reviewed, ATS-optimized resumes tailored for your experience level. Start your journey now.
