Business Systems Analyst III
The Judge Group Inc.

Job Info

Location: Newport Beach, CA
Description: Our client is currently seeking a Business Systems Analyst III

This job will have the following responsibilities:

    • ETL Developer resource is responsible for developing complex ETL/models in data ware housing environment, involving technical design, development, testing, Resource should have ability to create and debug Informatica code base & have prior experience working on Informatica and relational database frameworks. Resource should be detailed and be accountable for migrations across environments.
    • Resource should test and identify data anomalies/data patterns in huge data sets.
    • Resource should have critical thinking to ensure all assumptions, constraints, behaviors are well thought through - and have good communication skills.
    • Resource should have prior work experience in data ware house involving millions of rows transformation.
    • Insurance Domain experience.
    • Agile Development Dataware house. Experience (involving manipulation/transformation of millions of rows with optimal methods).
    • Good SQL &PL/SQL knowledge.
    • Good Analytical skills, debugging and critical thinking.
    • Knowledge of these specific applications: SQL, PL/SQL Informatica TOAD Unix Shell Scripts.
    • Assist in creating, optimizing and maintaining investment management data flows and integrations between multiple systems, including ePAM and data warehouse
    • Actively participate in data analysis and modeling and mapping to align equivalent data in legacy and new systems
    • Similarly assist in creating and maintaining reporting for investment data using Business Intelligence (BI) tools while also providing reporting oversight to ensure robust data availability, accuracy efficiency across multiple divisions and business needs

Qualifications & Requirements:
    • Experience with ETL tools (Informatica preferred)
    • Experience working with databases - queries, stored procedures, views (Oracle preferred)
    • Experience working reporting tools (Business Objects preferred)
    • Need to possess excellent analytical skills to quickly analyze and debug data discrepancies.
    • Data analysis required as a major part to communicate with QA team and vendors.
    • Experience with financial data


    Must Have
    • ETL experience using Informatica Power Center
    • Oracle
    • SQL

    Nice To Have
    • Agile Methodology
    • azure Dev Ops

This job and many more are available through The Judge Group. Find us on the web at

More IT jobs

McLean, Virginia
Posted about 2 hours ago

Waystar, Inc
Kansas City, Missouri
Posted about 2 hours ago

Earth Networks
Germantown, Maryland
Posted about 1 hour ago

Job Alerts

Provide an email, zip code for jobs, and/or job category to subscribe to job alerts. Learn more now.

*By subscribing, you agree to our Terms and Privacy Policy.

Share this job with the community

Click a community link below, and then social share the Business Systems Analyst III job.

African American Job Search Logo
Asian Job Search Logo
Disabled Job Seekers Logo
Hispanic Job Exchange Logo
LGBT Job Search Logo
Seniors to Work Logo
US Diversity Job Search Logo
Veteran Job Center Logo