Senior Data & ETL Analyst (Informatica/SQL)

Zoho; Irvine (CA); On-site; USD 90,000 - 130,000; Full time

Job summary

Dataflix is seeking an experienced Business Systems Analyst in Irvine, CA to translate business needs into functional specifications and support data integration and reporting initiatives.

You will gather requirements, analyze data, write source-to-target mappings, and collaborate with stakeholders and data teams to ensure high-quality data solutions and successful UAT and production support.

Qualifications

• 5+ years as a Business Systems Analyst or Data Analyst.
• Strong hands-on Informatica and SQL experience.
• Experience with data analysis, data mapping, and data validation.
• Translate business requirements into functional and technical specifications.
• Experience with ETL, databases, and data warehousing concepts.
• Familiar with SDLC and Agile methodologies.
• Excellent analytical, problem-solving, and communication skills.
• Bachelor's degree in CS/IS/Business or related field.

Responsibilities

• Gather, analyze, and document business and system requirements.
• Collaborate with stakeholders and technical teams to define data and reporting needs.
• Perform data analysis, data validation, and data quality assessments.
• Develop and execute SQL queries to analyze, validate, and reconcile data.
• Create source-to-target mapping documents and business requirements documentation.
• Support ETL and data integration initiatives using Informatica.
• Identify data issues and partner with development teams to implement solutions.
• Participate in testing, user acceptance testing (UAT), and production support activities.
• Prepare project documentation, process flows, and functional specifications.

Skills

Informatica

SQL

Data analysis

Education

Bachelor's degree in Computer Science, Information Systems, Business, or a related field

Job description

Dataflix is seeking an experienced Business Systems Analyst in Irvine, CA to translate business needs into functional specifications and support data integration and reporting initiatives.

You will gather requirements, analyze data, write source-to-target mappings, and collaborate with stakeholders and data teams to ensure high-quality data solutions and successful UAT and production support.