Data Modeler SCD Dimensional Modeling Oracle and Data Warehousing

Software Requirements:

• Proficiency in data modeling tools such as Erwin.
• Strong knowledge of SQL and database design principles.
• Experience with Oracle databases and cloud data platforms.
• Familiarity with data warehouse development and SCD dimensional modeling.
• Understanding of data architecture and metadata management standards.

Overall Responsibilities:

• Design and implement data models for large data warehouses.
• Translate business and technical requirements into conceptual and physical data models.
• Collaborate with business analysts and development teams to create data flows and document data catalogs mappings and transformations.
• Standardize data architecture and enforce metadata management practices.
• Engage in code and change management reviews to ensure compliance with data standards.
• Support data migration projects and ensure data integrity across systems.

Technical Skills:

Categorywise:

Data Modeling:

• Proficiency in data modeling tools such as Erwin.
• Experience in designing and implementing SCD dimensional models.

Database and SQL:

• Strong knowledge of SQL and database design principles.
• Handson experience with Oracle databases.

Data Warehouse Development:

• Familiarity with data warehouse development processes.
• Experience in data migration projects.

Data Architecture:

• Ability to standardize data architecture and enforce metadata management practices.
• Understanding of cloud data platforms and their integration with existing systems.

Experience:

• Minimum of 5 years of experience in data modeling and data warehouse development.
• Proven experience in designing and implementing data models for largescale data warehouses.
• Experience with data migration projects and ensuring data integrity across systems.
• Demonstrated experience in working with business analysts and development teams to translate requirements into data models.

DaytoDay Activities:

• Design and implement data models based on business and technical requirements.
• Collaborate with business analysts and development teams to create data flows and document data catalogs mappings and transformations.
• Standardize data architecture and enforce metadata management practices.
• Engage in code and change management reviews to ensure compliance with data standards.
• Support data migration projects and ensure data integrity across systems.
• Stay updated with emerging technologies and industry trends in data modeling and data management.

Qualifications:

• Bachelors degree in Computer Science Information Technology or a related field.
• Relevant certifications in data modeling or database management are a plus.

Soft Skills:

• Excellent communication and interpersonal skills.
• Strong presentation skills and the ability to articulate complex data concepts to nontechnical stakeholders.
• Strong problemsolving and analytical skills.
• Ability to work effectively in a fastpaced dynamic environment.
• High attention to detail and a commitment to delivering highquality work.
• Ability to prioritize tasks and manage time effectively.
• Collaborative and teamoriented mindset.

SYNECHRONS DIVERSITY & INCLUSION STATEMENT

Diversity & Inclusion are fundamental to our culture and Synechron is proud to be an equal opportunity workplace and is an affirmative action employer. Our Diversity Equity and Inclusion (DEI) initiative Same Difference is committed to fostering an inclusive culture promoting equality diversity and an environment that is respectful to all. We strongly believe that a diverse workforce helps build stronger successful businesses as a global company. We encourage applicants from across diverse backgrounds race ethnicities religion age marital status gender sexual orientations or disabilities to apply. We empower our global workforce by offering flexible workplace arrangements mentoring internal mobility learning and development programs and more.

All employment decisions at Synechron are based on business needs job requirements and individual qualifications without regard to the applicants gender gender identity sexual orientation race ethnicity disabled or veteran status or any other characteristic protected by law.

Candidate Application Notice