SQL ETL Specialist: Data Warehousing & BI Analytics

HCLTech; Jersey City (NJ); On-site; USD 90,000 - 130,000; Full time

Job summary

HCL Technologies Limited in Jersey City is seeking an MS SQL Technical Specialist to design, develop, and maintain ETL processes that support data integration and data warehousing. You will work closely with data analysts, data scientists, and stakeholders to ensure data is accurately processed and readily available for analysis.

Key tasks include designing and maintaining ETL processes, developing SQL databases and queries, and optimizing performance for scalable data solutions.

Qualifications

• Proven experience as an SQL ETL Developer or similar role.
• Strong proficiency in SQL and data warehousing concepts.
• Experience with ETL tools (SSIS, Informatica, Talend).
• Knowledge of databases (SQL Server, Oracle, MySQL).

Responsibilities

• Design, develop, and maintain ETL processes to support data integration and warehousing.
• Develop and optimize SQL queries, stored procedures, functions, and triggers.
• Monitor ETL performance and ensure data accuracy and integrity.
• Collaborate with data analysts/scientists to meet data requirements.
• Document data flows and participate in code reviews to ensure best practices.

Skills

SQL

ETL

Data Warehousing

Data Modeling

Problem Solving

Communication

Team Collaboration

Tools

SSIS

Informatica

Talend

Tableau

Power BI

Job description

HCL Technologies Limited in Jersey City is seeking an MS SQL Technical Specialist to design, develop, and maintain ETL processes that support data integration and data warehousing. You will work closely with data analysts, data scientists, and stakeholders to ensure data is accurately processed and readily available for analysis.

Key tasks include designing and maintaining ETL processes, developing SQL databases and queries, and optimizing performance for scalable data solutions.