Lead Data Modeler Redshift

15 hours ago

haryana, India ADI Group Full time

Role Description: Data ModelerThe ideal candidate is a hands-on SQL, familiar with DB fundamentals, should have good exposure using Erwin. Theymust be at ease working in an agile environment with little supervision. The person should be a self-motivatedperson with a passion for problem solving and continuous learning.Designation: Lead Data Modeler (4A): 6 - 9 YearsOffice Days - 3 days (Flexible) /Office Days Hybrid, 3 daysLocation Gurgaon, Pune , Bangalore, Chennai , HyderabadRole and responsibilitiesPerform as Data design/modeling lead to support the system designing and construction in data layer andapplication systems.Understand the current database system with business operation demands and technical capability.Develop data models and related designs, from the data architecture concept, logical, to physical data models forapplication database.Providing expertise in data modeling tools and techniques for designing data models for applications and relatedsystems.Assure that the modeling complies with the data modeling standards (normalization, data validation)Working closely with business stakeholders, as well as potential users of the information system to define and analyze data requirements needed to support the business processes within the scope of corresponding information systems in organizations.Ensure compliance with technical processes and standards.Identify, communicate, and mitigate Risks, Assumptions, Issues, and Decisions throughout the full lifecycle.Technical skills requirementsThe candidate must demonstrate proficiency in,Strong Data Modelling Skills in designing, creating and maintaining conceptual, logical, and physical data model. Must have a strong understanding of Data modeling principles (3nf/dimensional), methods and techniques. 8 years data modeling experience preferably in Pharma or life sciences industry, ERStudio or similarexperience. Experience with Data Governance tools, enterprise data management solutions, Modeling bestpractices, and MDM. Good knowledge on data profiling, integrating, and modeling data from different source systems. Experience in translating/mapping relational data models into XML and Schemas Should have hands-on experience in relational, dimensional, and analytic data modeling using RDBMS, dimensional, SQL, PL/SQL, NoSQL data platform technologies, and ETL and data ingestion protocols. Should have strong knowledge in creating the data model for OLAP and OLTP systems. Strong knowledge of Database Architecture, normalization concepts, and NFR requirements Good Hands-on expertise in data modeling tools (e.g. Power Designer, Erwin, ER/Studio) Hands-on expertise in creating Conceptual, Logical Data models and Physical data models Using ERWIN/ERStudio. Experience with data warehouse, Data Lake, and enterprise big data platforms. Experience on RDBMS platforms (e.g. Redshift, SQL Server, Oracle, Teradata, Snowflake, Postgres) Must have hands-on experience on implementing data models on AWS Redshift along with other AWS cloud solutions services including S3, Glacier, RDS, Athena, DynamoDB etc. Experience working with extracting business rules to develop transformations, data lineage, metadata, and data catalogue.Nice-to-have skills Azure Cloud certification Unix or Shell scripting Strong delivery background across the delivery of high-value, business-facing technical projects in major organizationsQualifications B.Tech./M.Tech. or BCA/MCA degree from a reputed university

  • Aws Redshift Database Administrator

    1 week ago

    Gurugram, Haryana, India NTT DATA Full time

    **Req ID**: 305843 We are currently seeking a AWS Redshift Database Administrator to join our team in NOIDA, Uttar Pradesh (IN-UP), India (IN). **Job Title: AWS Redshift Database Administrator** **Job Overview**: This position may require on-call availability and might require working during non-business hours and on weekends in case of emergencies or...

  • Database Administrator

    2 weeks ago

    Gurugram, Haryana, India United Airlines Full time

    **Description**: United's Digital Technology team designs, develops, and maintains massively scaling technology solutions brought to life with innovative architectures, data analytics, and digital solutions. **Our Values**: At United Airlines, we believe that inclusion propels innovation and is the foundation of all that we do. Our Shared Purpose:...

  • [Urgent Search] Database Admin

    2 weeks ago

    Gurgaon, Haryana, India United Airlines Full time

    United s Digital Technology team is comprised of many talented individuals all working together with cutting-edge technology to build the best airline in the history of aviation Our team designs develops and maintains massively scaling technology solutions brought to life with innovative architectures data analytics and digital solutions Job overview and...

  • Data Modeler

    6 days ago

    Gurgaon District, Haryana, India XL Catlin Full time

    **Flexible Work Eligible**: None **DISCOVER your opportunity** AXA XL recognizes data and information as critical business assets, both in terms of managing risk and enabling new business opportunities. This data should not only be high quality, but also actionable - enabling AXA XL’s executive leadership team to maximize benefits and facilitate...

  • Data Modeler

    2 days ago

    Gurugram, Haryana, India CALLISTOFUSION Full time

    Hi, We have a 6-month contract (with the possibility of extension) for the **Data Modeler** for location **Gurugram Haryana (On-site)**. Please find below the job description for the same: **Job Title: Data Modeler** **Location: Gurugram Haryana (On-site)** **Duration: 6-month contract (with the possibility of extension)** **Annual Salary Expectation:...

  • Data Lead

    3 days ago

    Gurgaon, Haryana, India Eptura Full time

    Data Lead - Data Engineering Department Engineering Employment Type Full Time Location India Description Shape the Future of Work with Eptura At Eptura we re not just another tech company-we re a global leader transforming the way people workplaces and assets connect Our innovative worktech solutions empower 25 million users across 115 countries to thrive in...

  • Lead Data Engineer

    23 hours ago

    haryana, India Talent Worx Full time

    Talworx is an emerging recruitment consulting and services firm , we are hiring for our Fintech Product based client, In this role, you will be working with a team or teams of enthusiastic members supporting our critical technology systems and guiding our business partners & end users with industry best practices, solution design, and creating long term...

  • Data Scientist

    1 week ago

    Gurugram, Haryana, India UNITY Systems Full time

    **Job Title**: ADS Associate - Data Analyst | Machine Learning | Big Data **Job Type**: Full-Time **Location**: Bangalore/Pune/Gurgaon **Industry**: Technology, Data Science, Business Intelligence **About the Role** We are seeking a **data-driven and technically skilled ADS Associate** to join our growing analytics team. This role is perfect for...

  • Data Scientist

    4 days ago

    Gurgaon District, Haryana, India Global Employees Full time

    Bachelor's/Master's degree in Economics, Mathematics, Computer Science/engineering, or related Analytics fields. - 4+ years of experience in Advanced Analytics/Predictive Modeling, with client management experience. - Experience in HR Analytics is advantageous. - Proficient in Python and various modeling techniques, including machine learning and statistical...

  • Associate - Data Strategist

    2 weeks ago

    Gurugram, Haryana, India CashKaro Full time

    **Company Overview**: **CashKaro** is India’s #1 cashback platform, trusted by over 25 million users! We drive more sales for Amazon, Flipkart, Myntra, and Ajio than any other paid channels, including Google and Meta. Backed by legendary investor Ratan Tata and a recent $16 million boost from Affle, we’re on a rocket ship journey—already surpassing...