Overview
On Site
Depends on Experience
Accepts corp to corp applications
Contract - W2
Able to Provide Sponsorship
Skills
Data Integration
ETL
Web Applications
PL/SQL
SQL
Scripting
Job Details
Position Title:
Systems Analyst ETL Developer
Position Overview:
The Systems Analyst will be responsible for supporting the design, development, automation, and implementation of a scalable data integration hub using agile methodologies. The role requires strong expertise in ETL processes, data transformation using SQL, and automation tools like Informatica IICS/PowerCenter, working within an agile development team.
Position Description:
- Understands business objectives and technical problems, identifies alternative solutions, and conducts cost/benefit analysis.
- Analyzes user requirements, procedures, and existing systems to improve or automate processes.
- Works with users to gather input/output requirements and operational needs.
- Documents user needs, program functions, and system modifications.
- Reviews system capabilities, specifications, and constraints to assess feasibility.
Key Responsibilities:
- Acquire and integrate data from diverse sources.
- Develop complex SQL scripts to support data transformation and dimensional modeling.
- Design and develop ETL pipelines using Informatica IICS or PowerCenter.
- Build Oracle views and materialized views for analytics use cases.
- Participate in agile ceremonies (sprint planning, review, retro, etc.).
- Collaborate closely with architects and data engineers on solution design.
- Conduct testing (unit, integration, load, stress) and validation of data workflows.
- Maintain and enhance Java-based web applications providing Tableau dashboards.
- Develop mockups and work with stakeholders for UI validation.
- Maintain technical documentation, including specifications and diagrams.
- Participate in requirements analysis and translate business needs into technical solutions.
- Interpret evolving business requirements and propose system enhancements.
- Support configuration and implementation of development tools.
- Perform other related duties as assigned.
Preferred Skills & Tools:
- Advanced SQL (Oracle PL/SQL preferred)
- Informatica IICS / PowerCenter
- Agile methodology (Scrum/Kanban)
- Tableau and Java web application support
- Strong analytical, documentation, and collaboration skills
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.