Senior Data Modeler (In-Person Interview)

Tasks: • Understand and translate business needs into data models supporting long-term solutions for different systems. • Work with the Application Development teams (ex: Pega Applications) to implement data strategies, build data flows and develop conceptual data models. • Create logical and physical data models using best practices to ensure high data quality and reduced redundancy. • Optimize and update logical and physical data models to support Data Initiative project for different phases of implementation. • Develop best practices for standard naming conventions and coding practices to ensure consistency of data models. • Recommend opportunities for reuse of data models in new environments. • Perform reverse engineering of physical data models from databases like DB2 and SQL scripts. • Evaluate data models and physical databases for variances and discrepancies across the different source systems . • Analyze data-related system integration challenges and propose appropriate solutions and develop the model according to Standards. • Work with all IT teams like System Analysts, Engineers, Programmers, BI and others on project limitations and capabilities, performance requirements and interfaces. • Review modifications to existing software to improve efficiency and performance. Qualifications: • Candidate should have over all 8+ years of Data Modelling experience. • Minimum 4 years of overall experience and 3 years into Bigdata Technologies • Strong work experience in Data modeling and usage of data modeling tools. • Exposure with Snowflake’s Cloud Data Warehouse, if possible • He/she should be well versed in understanding relational data, dimensional data, unstructured data, and master data. • Should have recent data management trend skills such as developing data lake model along with traditional modelling practices like snowflake and star. • They should know modeling techniques latest that are adapted for data warehousing and analytical structures. • Able to build logical data model and translate logical model into physical database. • They must be able to compare actual project procedures to the specified standards and procedures. • They should be able to demonstrate expertise with the most recent and relevant technologies in the data modelling implementation. • They must have excellent communication skills and possess the ability to collaborate with internal and external groups including vendors. • They must have the ability of working independently and with minimal supervision Skills: • 8+ years of experience in Data Modeling for Databases like DB2, AWS’ Redshift, Dynamo DB, Postgres, SQL Server, Pega Application. • Data modeling software (6 years) • AWS and Other Cloud systems experience is must. • Strong SQL and data profiling skills in various relational databases. • Analyzing source databases, source data, source database referential integrity and profiling source data (8 years) • Database tuning techniques (minimum 4 years) • Experience in building Data Lakes for both structured and unstructured data (2 years)