Applications Analyst 2

Posted:
2/17/2026, 8:28:57 PM

Location(s):
Karnataka, India ⋅ Humanabad, Karnataka, India

Experience Level(s):
Mid Level

Field(s):
Data & Analytics

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:

Viavi Solutions

Website: https://www.viavisolutions.com/

Headquarter Location: Chandler, Arizona, United States

Employee Count: 1001-5000

Year Founded: 2015

IPO Status: Public

Last Funding Type: Post-IPO Equity

Industries: Aerospace ⋅ Automotive ⋅ Computer ⋅ Consumer Electronics ⋅ Hardware ⋅ Industrial ⋅ Military ⋅ Mobile ⋅ Software ⋅ Telecommunications