Data Architect
Posted on :
22-05-2024
Employer Active
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
Job Locations: CHENNAI DTA GLOBAL INFOCITY Required Experience: 10 15 Years Skills : Data modelling datawarehouse Data Migration Data Architecture Big Data
Roles & Responsibilities:
- Participate in JAD workshops and/or business requirements sessions to understand capture and detail data modeling requirements
- Analyze client landscape and architectures to find the best data sources needed for the business requirements
- Determine appropriate data architecture suitable for the business requirements
- Perform detailed data analysis on source data profile data identify data cardinality granularity and data quality issues
- Define enterprise abbreviation and data modeling naming standards
- Design data quality and cleansing rules based on profiling results to increase quality of data
- Create data flow architecture across multiple zones (raw refined curated BI zones)
- Design conceptual logical and physical data models across all data zones based on business needs
- Create Data Dictionary & DDLs for the created Data Model
- Create normalized and/or denormalized structures to manage usability and performance
- Design source to target mapping documents with transformation rules to ingest data from source tables to target environment across all the data zones
- Create security document to assign database access to users accordingly
- Design partitioning and CDC strategy across various subject areas and data zones based on business needs
- Work with business ETL and BI teams to identify and design data models for KPIs
- Design test cases for data modeling requirements
- Create and deliver Data Model (Conceptual logical & physical) DDL Data Architecture document Data Dictionary and Design document with Security Rules CDC Strategy Data Quality/Cleansing Rules & S2T Mapping document with transformation rules
- Support stakeholders ETL & BI teams during data pipeline development
- Participate in onshore/nearshore/offshore calls as required to support the data pipeline development
Skills required:
- 15 years of experience in Data Architecture and Data Modeling and should have excellent communication and leadership skills
- Should have in depth understanding or executed new concepts like Data Lakehouse and should have worked on data sources such as SAP and Salesforce
- Should have done Data Modeling for Fortune 100 organizations and databases atleast 10 TB in size
- Should have done complex (100 entities/tables) Data Modeling programs in both onprem and cloud environments (any cloud is ok)
- Experience in designing normalized denormalized relational dimensional star and snowflake schemas for cloud big data and on prem databases using any one of these data modeling tools (Erwin R1 Sybase Power Designer DBSchema ER/Studio Toad Data Modeler etc)
- Extensive Data Modeling experience in same or similar bigdata and cloud databases such as Hive Athena Redshift Snowflake Synapse Analytics Azure SQL and on prem databases such as Oracle SQL Server and DB2
- Should have led Data Model workshops with business and technology stakeholders
- Should have written complex SQL queries for data analysis generated deployed and altered DDL
- Should have implemented Bill Inmon and Ralph Kimball methodologies to design data warehouses
- Should have worked atleast 4 projects using Agile/SAFe methodology
- Should have in depth understanding on Data Warehousing Data Analysis Data Profiling Master Data Management (MDM) Data Quality Data Lineage Data Dictionary Data Mapping Data Policy and Data Governance
- Should have cross global location experience and been part of a team of atleast 20 members in a global delivery model
- Should have knowledge on Microservices & Service Oriented Architecture
- Should have experience in gathering business requirements by collaborating with business users stakeholders and SMEs
- Should have experience in working with product managers project managers business users applications development team members DBA teams and Data Governance team on a daily basis to analyze requirements design development and deployment technical solutions
Employment Type
Full Time
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
