Required Skills


Work Authorization

  • US Citizen

  • Green Card

Preferred Employment

  • Corp-Corp

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 1st Jun 2022


This role is responsible for building Relational and Dimensional Models for Integration Layer, Semantic Layer & Audit Layer. (proficiency in Kimball). Design and Build Conceptual, Logical, Physical Data Models and Create Physical Data Structures (DDLs). Create Source to Target Data Mapping rules with the business transformation rules by discussing with business users. Extensive experience in Solution design, Data architecture, Data modeling, Data integration and Business Analytics design and development.



* Build RelationalandDimensionalModels for Integration Layer, Semantic Layer & Audit Layer. (proficiency in Kimball)

* Building Industry based Reference Data Models for Large Banks

* Design and BuildConceptual, Logical, Physical Data Modelsand Create Physical Data Structures (DDLs).

* CreateSource to Target Data Mappingrules with the business transformation rules by discussing with business users.

* Extensive experience in managing cross functional teams, leading the development, gathering Business Requirements, Analysis, Design, and Implementations of various functionalities of Data Warehouse, Business Intelligence, ERP applications and Big Data- Hadoop Solutions.

* Expert in Agile Data Warehouse, Enterprise Architecture using Industry model Framework Methodology, Data Modeling using E/R and Dimension Models, Conceptual, Logical and Physical Models for large scale DW and DL implementations.

* Expertise in the design of the Conceptual, Subject area Logical and Physical Data Models using Erwin and/or ER Studio Suite.

* Experience in Data model design frameworks and techniques pioneered by Ralph Kimball and Bill Inman.

* Experience in Industry Financial or/and Insurance Data Models: Teradata FSLDM and IBM BDW data Model Frame works and Insurance ACORD framework and capability models.

* Experience in Master Data management, Metadata Management solutions and Data Governess Policies and Procedures.

* Worked on Big data projects involved Hadoop technologies and Data Lake reference architecture and Frameworks.

* Optional - Worked on Cassandra Data Modeling, NoSQL Architecture, policies, and procedures.

* Experience in understanding the Business requirements and translating them into detailed design along with Technical specifications.

* A plus - Exposure to software engineering techniques like Micro services, Event Driven Architecture, using event streaming technologies like Kafka.

* Worked closely with cross functional teams to effectively co-ordinate, manage Business user expectations and adhere to organizational architectural standards and policies.

* Experience in Data Lake framework, Data Ingestion and Processing Analyze various sources and develop the code to ingest the data into Hadoop Data Lake.

* Good experience in Big Data Hadoop solution implementation for Operational Reporting and Analytics using HIVE, SPARK & SPARK SQL, Sqoop and other Hadoop eco system projects.

* Good exposer and experience on Cloud based data stores- AWS Cloud on Big data specialty Redshift, S3 etc.

* Expert in Agile software development and release management using Scrum Process. Hands on Experience with Agile software development Tools such as JIRA.

* Manage stakeholder expectations with continuous engagement through status reports, proactive communication on new opportunities and issues.

* Design solution architecture, conducts analysis and development of applications and proof of concepts

* Acts as subject matter expert related to the effective use of analytical or BI methodologies, particularly those related to decision tree, time series data, forecasting, or data visualization and dashboard design.

* Build different design patterns, data architecture, Cloud technology stack (AWS/Azure)

* Continuous learning and keep track of the latest developments in business/ technical advancements

* Demonstrate the compassion to lead and bring value to the architecture portfolio


12 + years IT experience, with focus on Data Modeling, Data solutioning

Deep functional


Company Information