Job Description
We are seeking a highly skilled Senior Data Solutions Engineer to join our team.
· The successful candidate will be responsible for designing, developing, and maintaining data solutions for data generation, collection, and processing.
· This role involves creating data pipelines, ensuring data quality, and implementing ETL processes to migrate and deploy data across systems.
· As an SME in Data Migrations, the candidate must have advanced proficiency in Data Access, Data Engineering, Data Pipelines, and Data Processing.
Key Responsibilities
Design and Develop Data Solutions:
Create robust data solutions for data generation, collection, and processing.
Create Data Pipelines:
Develop and maintain efficient data pipelines ensuring high data quality.
Implement ETL Processes:
Migrate and deploy data across systems using ETL processes.
Collaborate with Cross-Functional Teams:
Work closely with different teams to ensure the successful implementation of data solutions.
Required Qualifications
SSIS Experience:
At least 3 years of experience using SQL Server Integration Services (SSIS).
MS SQL Proficiency:
Minimum 3 years of experience with MS SQL, including T-SQL, Tables, Stored Procedures, Triggers, Indexes, and Optimization.
Data Migration Projects:
Experience working on at least 2 data migration projects.
ETL Tool Expertise:
At least 8+ years of experience with any ETL tool (Talend, Informatica).
Requirement Gathering:
Experience in gathering requirements and creating data mapping documents.
AWS Cloud Experience:
At least 2 years of experience in AWS Cloud.
SSIS on AWS:
Experience working with SSIS on AWS Cloud and SQL Server RDS.
Code Migration and Deployment:
Experience in code migration and code deployment.
Data Modelling:
Experience in creating data models and ER-Diagrams.
Python Coding:
Proficiency in Python coding.
Skills
Advanced Proficiency: Data Migrations, Data Access, Data Engineering.
Intermediate Proficiency: Data Pipelines, Data Processing.
Collaboration and Communication: Strong communication and collaboration skills to work with cross-functional teams.
Problem-Solving: Strong problem-solving and troubleshooting skills.
Salesforce Data Migration: Experience in migrating data to Salesforce.
Salesforce Data Loader: Experience in using Salesforce Data Loader.
GCC Experience: Experience in Government Commercial Cloud (GCC).
SSIS Code Promotion Pipelines: Experience in building SSIS code promotion pipelines.