AmbitionBox
Search
Jobs
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
All Filters
2 3i People Jobs
Application Systems Analyst/Programmer IV
3i People
posted 5d ago
Job Role Insights
Flexible timing
Key skills for the job
Job Description
- Perform analysis of HAL data system as needed, which may include reviewing documentation and analyzing current HAL system/ environment, including data models, schemas and tables, data dictionaries, ETL s, system and database management processes, data quality, security, queries, reporting environment.
- Work with client project team members (PM, BAs, DBAs, data analysts, architects), HAL management and HAL users to identify/ determine business/technical requirements.
- Gather and document detailed system, data and integration requirements for HAL system improvements (e.g. changes to ETL code, business rules, HAL tables, new or updated client Medicaid claim code grouping categories, etc.)
- Design, develop and implement new ETL code/ packages.
- Migrate existing ETL process built in legacy SAS coding to Microsoft Structured Query Language ( SQL ) stack language/ stored procedures, by:
- Woking with various program areas and business teams to make code as modular as possible.
- Reviewing and analyzing existing ETL SAS programming code to update to new SQL language/ procedures
- Developing new SQL stack / stored procedures programming code to create new ETL processes.
- Test, troubleshoot and implement the new ETL code in the HAL test and production environments.
Required skills and experience:
- SQL programming
- Advanced data analysis skills.
- Experience using Microsoft DevOps or other code management tools.
In addition, the ideal candidate will have skills and experience in:
- Experience with SAS data management.
- Good communication skills
- Full-time professional work experience in Information Technology.
Employment Type: Full Time, Permanent
Read full job description What people at 3i People are saying
What 3i People employees are saying about work life
based on 4 employees
Flexible timing
Monday to Friday
Night Shift
3i People Benefits
View more benefits
Compare 3i People with
Team Lease
Compare
Quess
Compare
Iksula
Compare
Randstad
Compare
ManpowerGroup
Compare
Kelly Services
Compare
Adecco Group
Compare
Gi Group
Compare
Allegis Group
Compare
Mafoi Randstad
Compare
TCS
Compare
Accenture
Compare
Wipro
Compare
Cognizant
Compare
Capgemini
Compare
Infosys
Compare
HCLTech
Compare
Tech Mahindra
Compare
Genpact
Compare
IBM
Compare
Similar Jobs for you
Share an Interview