Senior Technical Architect (IN)

HCLTech

Fresher India Full Time Work from office
HCLTech logo
Posted : today
Actively hiring

Job description

This role is central to designing, developing, and maintaining robust data models that underpin critical business processes and analytical endeavors. The primary objective is to ensure data architecture is structured, consistent, and optimized for peak performance, scalability, and effective reporting.

Ensuring data integrity, consistency, and quality across all systems is paramount. The position involves translating intricate business requirements into well-defined data structures and meticulously documenting these through data dictionaries, schemas, and ER diagrams.

Responsibilities

Key duties include architecting conceptual, logical, and physical data models, and analyzing business needs to create appropriate data structures.

Responsibilities also involve developing and maintaining data dictionaries, schemas, and ER diagrams, while ensuring data quality and consistency.

The role requires optimizing database performance through efficient design, supporting data warehousing and BI solutions, and collaborating with various stakeholders including business teams, analysts, and developers.

Maintaining comprehensive documentation, adhering to data standards, and performing impact analysis for schema modifications are also integral parts of the job.

Qualifications

A strong grasp of core data modeling principles, including ER modeling, normalization, and dimensional modeling, is essential.

Candidates must possess hands-on experience with relational databases such as Oracle, SQL Server, or MySQL, alongside proven proficiency in SQL.

Experience utilizing data modeling tools like Erwin, ER/Studio, or PowerDesigner is required, as is a solid understanding of data warehousing concepts like star and snowflake schemas, and familiarity with ETL processes.

Ideal candidates will also demonstrate excellent analytical and problem-solving capabilities, meticulous attention to detail, effective communication skills for stakeholder interaction, and the ability to thrive in cross-functional team environments.

Essential Skills

Data ModelingER ModelingNormalizationDimensional ModelingOracle DatabaseSQL ServerMySQLSQLErwinER/StudioPowerDesignerData WarehousingStar SchemaSnowflake SchemaETL

Good to Have

Apache HadoopApache SparkMicrosoft AzureAWSPower BITableauData GovernanceMetadata Management

Highlights

  • Actively hiring

More Details

RoleSenior Technical Architect (IN)
DepartmentData Engineering
Employment TypeFull Time, Work from office

About the Company

HCLTech logo

HCLTech

IT Consulting

Senior Technical Architect (IN) at HCLTech | SkillMX | SkillMX