Sr. Data Modeler

1 month ago

Chennai, India Photon Full time
What will you do?

What are we looking for?

Data Modeler / Data Analyst§

Job Description :§ 5 + years of experience in Data Modeling & Data Analyst and should have excellent communication and leadership skills. Financial Domain knowledge is plus.§ Should have in depth understanding or executed new concepts like Data Lakehouse and should have worked on Big Data data sources / tools such as Hive , S3 , Trino , HUE , etc§ 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 on-prem and cloud environments .§ 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, ER/Studio, Toad Data Modeler, etc)§ Extensive Data Modeling experience in same or similar bigdata and cloud databases such as Hive, Redshift, Snowflake 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 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§

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 developmentNeed to have overlap with Onsite team till 10-11 am Pacific time , for attending scrum ceremonies or to have onsite interaction .

Location : Offshore

  • Sr Data Engineer

    1 month ago

    Chennai, India W. R. Grace & Co. Full time

    Job DescriptionThe Sr. Data Engineer is part of the India Digital Operations Center and will be responsible for ingesting, cleaning, contextualizing and maintaining architectures across the data lakes and databases that will drive improvement in Grace manufacturing capabilities across the world. The position is responsible for developing data set processes...

  • OIPA Sr. Developer

    2 days ago

    Chennai, India NTT DATA Full time

    Job Description Req ID: 283426 NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.We are currently seeking a OIPA Sr. Developer to join our team in Chennai, Tamil Nādu (IN-TN), India (IN).OIPA Sr....

  • OIPA Sr. Developer

    23 hours ago

    chennai, India NTT DATA Full time

    Job Description Req ID:  283426  NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a OIPA Sr. Developer to join our team in Chennai, Tamil Nādu (IN-TN), India (IN). OIPA...

  • OIPA Sr. Developer

    22 hours ago

    Chennai, India NTT DATA Full time

    Job Description Req ID: 283430 NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.We are currently seeking a OIPA Sr. Developer to join our team in Chennai, Tamil Nādu (IN-TN), India (IN).OIPA Sr....

  • Data Modeler

    6 days ago

    Chennai, India Pi One Technologies (π 1) Full time

    Location: Chennai & Hyderabad Experience: 4 to 5 Years Domain Experience: BankingJob Responsibilities: ➢ Strong functional knowledge of Domain knowledge on Banking products and business processes ➢ Strong knowledge & experience of mapping attributes, profiling from various composite business source system and channels ➢ Problem solving & analytical...

  • Sr Data Engineer

    2 months ago

    chennai, India W. R. Grace & Co. Full time

    Job Description The Sr. Data Engineer is part of the India Digital Operations Center and will be responsible for ingesting, cleaning, contextualizing and maintaining architectures across the data lakes and databases that will drive improvement in Grace manufacturing capabilities across the world. The position is responsible for developing data set processes...

  • OIPA Sr. Developer

    2 days ago

    Chennai, Tamil Nadu, India NTT DATA Services Full time

    Req ID: NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.We are currently seeking a OIPA Sr. Developer to join our team in Chennai, Tamil Nādu (IN-TN), India (IN).OIPA Sr. DeveloperOIPA Support analyst...

  • Data Modeler

    5 days ago

    Chennai, India Pi One Technologies (π 1) Full time

    Location: Chennai & HyderabadExperience: 4 to 5 YearsDomain Experience: Banking Job Responsibilities:➢ Strong functional knowledge of Domain knowledge on Banking products and business processes➢ Strong knowledge & experience of mapping attributes, profiling from various composite business source system and channels➢ Problem solving & analytical skills...

  • Data Modeler

    6 days ago

    Chennai, India Pi One Technologies (π 1) Full time

    Location: Chennai & HyderabadExperience: 4 to 5 YearsDomain Experience: Banking Job Responsibilities:➢ Strong functional knowledge of Domain knowledge on Banking products and business processes➢ Strong knowledge & experience of mapping attributes, profiling from various composite business source system and channels➢ Problem solving & analytical skills...

  • Data Modeler

    6 days ago

    chennai, India Pi One Technologies (π 1) Full time

    Location: Chennai & Hyderabad Experience: 4 to 5 Years Domain Experience: Banking  Job Responsibilities: ➢ Strong functional knowledge of Domain knowledge on Banking products and business processes ➢ Strong knowledge & experience of mapping attributes, profiling from various composite business source system and channels ➢ Problem solving &...

  • Sr Data Engineer

    2 months ago

    Chennai, India W. R. Grace & Co. Full time

    Job DescriptionThe Sr. Data Engineer is part of the India Digital Operations Center and will be responsible for ingesting, cleaning, contextualizing and maintaining architectures across the data lakes and databases that will drive improvement in Grace manufacturing capabilities across the world. The position is responsible for developing data set processes...

  • Data Modeler

    4 weeks ago

    chennai, India Careerconnects Full time

    Proficient in SQL with extensive expertisein handling structured semistructured and unstructureddata.Strong familiarity with data modelingtechniques including Star Schema Snowflake Data Vault andDomainbased data models. Comprehensive understanding of datanormalization and denormalizationprinciples.Experience utilizing datamodeling tools such as Erwin ER/Toad...

  • OIPA Sr. Developer

    3 days ago

    Chennai, India NTT DATA Services Full time

    Req ID: 283426 NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.We are currently seeking a OIPA Sr. Developer to join our team in Chennai, Tamil Nādu (IN-TN), India (IN).OIPA Sr. DeveloperOIPA...

  • OIPA Sr. Developer

    24 hours ago

    chennai, India NTT DATA Services Full time

    Req ID:  283428  NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a OIPA Sr. Developer to join our team in Chennai, Tamil Nādu (IN-TN), India (IN). OIPA Sr. Developer OIPA...

  • OIPA Sr. Developer

    4 hours ago

    Chennai, India NTT DATA Services Full time

    Req ID: 283429 NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.We are currently seeking a OIPA Sr. Developer to join our team in Chennai, Tamil Nādu (IN-TN), India (IN).OIPA Sr. DeveloperOIPA...

  • OIPA Sr. Developer

    2 days ago

    Chennai, India NTT DATA Services Full time

    Req ID: 283428 NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.We are currently seeking a OIPA Sr. Developer to join our team in Chennai, Tamil Nādu (IN-TN), India (IN).OIPA Sr. DeveloperOIPA...

  • OIPA Sr. Developer

    2 days ago

    Chennai, India NTT DATA Services Full time

    Req ID: 283426  NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a OIPA Sr. Developer to join our team in Chennai, Tamil Nādu (IN-TN), India (IN). OIPA Sr....

  • OIPA Sr. Developer

    2 days ago

    Chennai, India NTT DATA Services Full time

    Req ID: 283429  NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a OIPA Sr. Developer to join our team in Chennai, Tamil Nādu (IN-TN), India (IN). OIPA Sr....

  • OIPA Sr. Developer

    2 days ago

    Chennai, India NTT DATA Services Full time

    Req ID: 283428  NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a OIPA Sr. Developer to join our team in Chennai, Tamil Nādu (IN-TN), India (IN). OIPA Sr....

  • OIPA Sr. Developer

    2 days ago

    Chennai, India NTT DATA Services Full time

    Req ID: 283430  NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a OIPA Sr. Developer to join our team in Chennai, Tamil Nādu (IN-TN), India (IN). OIPA Sr....