Role: Data Integration Engineer/Analyst
Location: Columbus-OH, ( Only Local Profile)
Number of Positions: 3
Experience: 8+ Years
In-person Interview Mandatory

Job description:
Seeking a skilled and motivated Data Integration Engineers to be part of existing dynamic team. The primary responsibility of this role is to lead the end-end process of acquiring, cleansing, transforming, and storing data from external vendors to AWS. The successful candidates will leverage internal tools and SDKs, utilize AWS services such as S3, Athena, and Glue, and integrate with our internal Archival Service Platform for efficient data purging.

Responsibilities:
1. Collaborate with cross-functional teams to understand data requirements and establish seamless connections with external vendors
2. Develop and implement robust data acquisition strategies, ensuring data quality, integrity, and security.
3. Lead the design and implementation of data cleansing and transformation process to align vendor data with internal standards and structures
4. Utilize internal tools and SDKs for efficient data integration and processing, focusing on scalability and performance optimization
5. Implement and manage agents for monitoring, logging, and automation within AWS environments
6. Work with Amazon SNS for efficient notification and communication workflows
7. Work with other AWS services, including S3, Athena, and Glue, to optimize data storage, querying, and processing.
8. Lead the integration efforts with the internal Archival Service Platform for seamless data purging and lifecycle management
9. Collaborate with the data engineering team to continuously improve data integration pipelines, ensuring adaptability to evolving business needs.

Skills and Qualifications:

1. Bachelors degree in Computer Science, Information Technology, or related filed.
2. In-depth knowledge and hands-on experience with ASW services, including SNS, S3, Athena, Glue, and Lambda
3. Expertise in data cleansing, transformation, and enrichment techniques
4. Experience in deploying and managing Apache Kafka
5. Proficient in programing language Java
6. Excellent communication and collaboration skills
7. Strong problem-solving skills and meticulous attention to detail.

Preferred Qualifications:
1. AWS Certification.
2. Advance expertise in Athena queries and optimization.
3. Knowledge of data governance and compliance standards.