Data Integration Specialist Analyst Senior Analyst
First seen by Alion on Sep 12, 2026.
Design and develop the ETL and ELT environment processes programs and scripts to acquire data from source systems and apply the data to the tables in the database. This role requires deep understanding of the overall data warehouse architecture.
Requirements
Core Responsibilities
Capture ETL Requirements.
Design develop test support processes for extracting transforming and loading data from source systems to DWH and Data Marts.
Design the processes to meet service level agreements for data timeliness and frequency
Analyze and optimization current solutions physical model optimization query tuning
Mentoring junior members of the team in data integration development best practices
Analyze and improve query and solution performance optimize physical model
Developing project deliverable documentation
Utilize effectively Online Data Processing Tools
Core Competencies:
Performance Excellence
Collab. & Creating Synergy
Agility & Resilience
People Centricity
Technical Competencies
Knowledge of any enterprise relational database (Teradata Oracle IBM)
Professional Knowledge of Two of industrial ETL tool (Informatica DataStage ODI SAS DI or others)
Strong SQL and Shell scripting
Experience in implementing ETL solutions for large enterprisegrade customers
Experience in implementing ETL solutions in Hadoop environment is an advantage
Knowledge of MPP system Teradata is an advantage
Any ETL tools DB certified is an advantage
Experience Unix/Linus OS
Domain Expertise
Bachelors degree in computer science is preferred
Master/ Certificate preferred
Banking experience preferred
Required Experience:
Senior IC