Aequor Information Technologies Priivate Limited
Location
Bangalore | India
Job description
Experience: 10+
Notice Period: Immediate to 30days
Location: Bangalore
JD:
ETL Developer (ODI) with OFSAA FSDF Data Model Knowledge
Position Overview:
We are seeking a skilled ETL Developer with expertise in Oracle Data Integrator (ODI) and a strong understanding of the Oracle Financial Services Analytical Applications (OFSAA) Financial Services Data Foundation (FSDF) data model. The successful candidate will be responsible for designing, developing, and optimizing ETL processes that facilitate the seamless integration of financial data, adhering to OFSAA FSDF standards and ensuring data accuracy and reliability.
Key Responsibilities:
ETL Development:
Collaborate with data architects, business analysts, and stakeholders to gather data requirements and translate them into efficient ETL processes using Oracle Data Integrator (ODI).
Leverage your deep understanding of the OFSAA FSDF data model to design ETL workflows that ensure accurate data extraction, transformation, and loading.
Data Integration:
Design, develop, and maintain ETL workflows to extract data from source systems, apply necessary transformations, and load it into the data warehouse or target systems.
Implement data quality checks and validation routines to ensure data integrity and consistency.
Performance Optimization:
Optimize ETL processes for performance, scalability, and reliability, considering factors such as data volume, processing speed, and system resources.
Monitor and fine-tune ETL jobs to identify and address performance bottlenecks.
Collaboration and Documentation:
Collaborate with cross-functional teams to understand business requirements and contribute technical expertise to data integration initiatives.
Document ETL workflows, transformations, and dependencies for future reference and team collaboration.
Quality Assurance:
Conduct thorough testing of ETL processes to ensure data accuracy and integrity throughout the data pipeline.
Work closely with data analysts to validate results and resolve any discrepancies.
Continuous Improvement:
Stay up-to-date with industry best practices, trends, and advancements in ETL development and OFSAA FSDF data model.
Identify opportunities for process optimization and propose solutions to enhance data integration efficiency.
Qualifications and Skills:
Bachelor's or master's degree in Computer Science, Information Systems, or a related field.
Proven experience 10 years as an ETL developer, with expertise in Oracle Data Integrator (ODI).
Strong understanding of the Oracle Financial Services Analytical Applications (OFSAA) Financial Services Data Foundation (FSDF) data model.
Proficiency in SQL, PL/SQL, and ETL scripting languages.
Experience in designing, developing, and maintaining complex ETL workflows.
Familiarity with data warehousing concepts and methodologies.
Excellent problem-solving skills and attention to detail.
Effective communication and collaboration skills.
Develop ODI maps
Develop PL/SQL procedures
Develop Feeder views
Change Release - Prepare release note, change release, oversee released etc.
Support ETL batches
Preferred:
Certification in Oracle Data Integrator (ODI) or related technologies.
Familiarity with financial industry regulations and compliance requirements.
Experience with performance tuning and optimization of ETL processes.
Knowledge of data visualization tools and techniques.
Job tags
Salary
