Job Description
About The Company:
iLink is a Global Software Solution Provider and Systems Integrator, delivers next-generation technology solutions to help clients solve complex business challenges, improve organizational effectiveness, increase business productivity, realize sustainable enterprise value and transform your business inside-out. iLink integrates software systems and develops custom applications, components, and frameworks on the latest platforms for IT departments, commercial accounts, application services providers (ASP) and independent software vendors (ISV). iLink solutions are used in a broad range of industries and functions, including healthcare, telecom, government, oil and gas, education, and life sciences. iLink's expertise includes Cloud Computing & Application Modernization, Data Management & Analytics, Enterprise Mobility, Portal, collaboration & Social Employee Engagement, Embedded Systems and User Experience design etc.
What makes iLink Systems' offerings unique is the fact that we use pre-created frameworks, designed to accelerate software development and implementation of business processes for our clients. iLink has over 60 frameworks (solution accelerators), both industry-specific and horizontal, that can be easily customized and enhanced to meet your current business challenges.
Requirements
Summary:
The desired profile should have hands-on experience in designing, establishing, and maintaining data management and storing systems. Skilled in collecting, processing, cleaning, and deploying large datasets, understanding ER data models, and integrating with multiple data sources. Efficient in analyzing, communicating, and proposing different ways of building Data Warehouses, Data Lakes, End-to-End Pipelines, and Big Data solutions to clients, either in batch or streaming strategies.
Technical Proficiencies:
-
SQL:
Data Definition Language, Data Manipulation Language, Intermediate/advanced queries for analytical purpose, Subqueries, CTEs, Data types, Joins with business rules applied, Grouping and Aggregates for business metrics, Indexing and optimizing queries for efficient ETL process, Stored Procedures for transforming and preparing data, SSMS, DBeaver
SSRS/Power BI:
- Design and develop ETL processes using SQL Server Integration Services (SSIS) to extract, transform, and load data from various source systems into target databases.
- Experience in SQL queries, SQL Server Reporting Services (SSRS).
- Create, configure, and deploy SSIS packages, including data flow tasks, control flow tasks, and event handlers.
- Perform data source integration from diverse platforms, such as relational databases, flat files, web services, and cloud-based storage
- Strong knowledge in Power BI
- Optimize data integration processes for performance, identifying and resolving bottlenecks, and utilizing best practices.
- Provide expertise in troubleshooting and resolving data integration issues, ensuring data accuracy and consistency.
Benefits
- Competitive salaries
- Medical, Dental, Vision Insurance
- Disability, Life & AD&D Insurance
- 401K With Generous Company Match
- Paid Vacation and Personal Leave
- Pre-Paid Commute Options
- Employee Referral Bonuses
- Performance Based Bonuses
- Flexible Work Options & Fun Culture
- Continuing Education Reimbursements
- In-House Technology Training
What We Do
iLink Digital, a CMMI Level 3 and ISO 9001:2015 Certified Global Software Solution Provider and Systems Integrator, delivers next-generation technology solutions to help clients solve complex business challenges, improve organizational effectiveness, increase business productivity, realize sustainable enterprise value and transform your business inside-out. iLink integrates software systems and develops custom applications, components, and frameworks on the latest platforms for IT departments, commercial accounts, application services providers (ASP) and independent software vendors (ISV). iLink solutions are used in a broad range of industries and functions, including healthcare, telecom, government, oil and gas, education, and life sciences. iLink’s expertise includes Cloud Computing & Application Modernization, Data Management & Analytics, Enterprise Mobility, Portal, collaboration & Social Employee Engagement, Embedded Systems and User Experience design etc.
What makes iLink Digital's offerings unique is the fact that we use pre-created frameworks, designed to accelerate software development and implementation of business processes for our clients. iLink has over 60 frameworks (solution accelerators), both industry-specific and horizontal, that can be easily customized and enhanced to meet your current business challenges.