DTS Data Engineer

Role: DTS Data Engineer

Location: NY | LA - Onsite

We are seeking a skilled DTS Data Engineer to design, build, and optimize data pipelines and integration solutions. The ideal candidate will work with large-scale datasets, ensuring smooth data flow across systems and enabling business intelligence and analytics.

Key Responsibilities

• Develop, maintain, and optimize data pipelines using DTS (Data Transformation Services).

• Integrate data from multiple sources into centralized repositories.

• Ensure data quality, consistency, and reliability across systems.

• Collaborate with analysts, developers, and business stakeholders to understand data needs.

• Monitor and troubleshoot data workflows for performance and accuracy.

• Document processes and maintain best practices for data engineering.

Required Skills

• Strong experience with DTS or similar ETL tools.

• Proficiency in SQL and relational databases (e.g., SQL Server, Oracle).

• Knowledge of data warehousing concepts and BI tools.

• Familiarity with cloud platforms (AWS, Azure, or GCP).

• Strong problem-solving and debugging skills.

• Good communication and collaboration abilities.

Preferred Qualifications

• Experience with modern ETL frameworks (SSIS, Informatica, Talend).

• Exposure to big data technologies (Spark, Hadoop).

• Understanding of data governance and security practices.

• Background in scripting languages (Python, Shell).

Best Regards,

Kartik Sana

sana@realtekconsulting.net