ETL Architect

We are HCLTech, one of the fastest-growing large tech companies in the world and home to 222,000+ people across 60 countries, supercharging progress through industry-leading capabilities centered around Digital, Engineering and Cloud. ( )

The driving force behind that work, our people, are diverse, creative, and passionate, raising the bar for excellence on a regular basis. We, in turn, work hard to bring out the best in them as we strive to help them find their spark and become the best version of themselves that they can be. If all this sounds like an environment you ll thrive in, then you re in the right place.

We are looking for a highly talented and self- motivated ETL Architect to join us on our journey in advancing the technological world through innovation and creativity.

Job Title: ETL Architect

Job ID: 2291312

Position Type: Full-time

Location: Providence, Rhode Island

Required Skills:

Snowflake, Matillion
Data Analytics
Data Architecture
Microsoft PowerBI
AWS/Azure/Google Cloud Platform Cloud

10+ years of experience with expertise around Data architecture for medium to complex Data Analytics projects, Data Architecture & Design, Metadata and business glossary management, and data quality.
Experience in creating Data Flow Diagrams (DFD).
Experience in designing the logical and physical data models for the Datawarehouse as per business requirements.
In-depth knowledge of Azure/AWS/Google Cloud Platform Cloud capabilities and services and how those relate to the development activities.
Handson experience with Snowflake, Mattilion, DataStage.
Good understanding of DevOps and Data pipeline automation platforms.
Familiarity with legal and regulatory requirements relevant to cloud data architecture, such as SOX, PCI, HIPAA, and Data Protection (GDPR, DPDP 2023)
Familiarity with cryptographic algorithms and security protocols.
Skilled in designing and building distributed systems for processing large data volumes.
Excellent communication, presentation, and interpersonal skills are essential.
Responsibilities:
Lead and/or assist in designing and developing cloud-based data systems, tailoring solutions to meet business requirements.
Develop comprehensive architecture solution roadmaps seamlessly integrating business processes and technologies.
Design, develop and enforce standards for data storage, processing, and governance across all environments.
Work closely with enterprise and application architects to align the data engineering team to the overall company SDLC standards, practices, and data access patterns.
Develop, document, and maintain overall view of data platform architecture, data acquisition, data quality, and data retention.
Provide guidance in administration of ETL jobs including developing best practices
Provide formal and informal training for data engineers, platform engineers and ETL developers.
Maintain knowledge of emerging technologies and architectures.

Qualifications & Experience

Minimum Requirements

Academic qualifications/Level of Education:

Preferably an undergraduate / associate level degree / diploma from an accredited institution, in Computer Science / Statistics / Applied Mathematics / EE / Electronics or, any equivalent technical field of study. Applications are also invited from candidates with major in Software Engineering / Information Technology / Management Information Systems.

Desired Qualifications

Pay Range:

Base Salary: $130000 - $135000 per annum

In addition, this position qualifies for benefits like health insurance, paid time off (PTO), 401(K). Exact compensation may vary based on skills, experience, education, and/or to comply with federal or state law.

How You ll Grow

At HCLTech, we offer continuous opportunities for you to find your spark and grow with us. We want you to be happy and satisfied with your role and to really learn what type of work sparks your brilliance the best. Throughout your time with us, we offer transparent communication with senior-level employees, learning and career development programs at every level, and opportunities to experiment in different roles or even pivot industries. We believe that you should be in control of your career with unlimited opportunities to find the role that fits you best.

Equality & Opportunity for All

Representing 165 nationalities across the globe, we pride ourselves on being an equal opportunity employer, committed to providing equal employment opportunities to all applicants and employees regardless of race, religion, sex, color, age, national origin, pregnancy, sexual orientation, physical disability or genetic information, military or veteran status, or any other protected classification, in accordance with federal, state, and/or local law.