• Us Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 5th Oct 2021

·         Experience in AWS and  Databases

·         Extensive experience in Data Modeling, Data Analysis for Online Transaction Processing OLTP , Data Warehousing OLAP /Business Intelligence BI applications.

·         Expert in Transactional/Dimensional Data Modeling.

·         Experience in Financial domain.

·         Expertise in Enterprise Data Warehouse, sources system analysis, Forward Engineering as well as Reverse Engineering using data modeling tools.

·         Experience in modeling OLTP and OLAP using tools like Erwin , E-R Studio or other modelling tools.

·         Experience in  Kimball/Inmon data warehouse Philosophies. Experienced in Normalization/De-normalization techniques for optimum performance in OLTP and OLAP environments.

·         Experience in Software Development Life Cycle SDLC 

·         Experience working on creating models for Redshift and other Analytical databases.

·         Developing  ETL mapping and scripts.

·         Experience in Data Extraction/Transformation/Loading ETL , Data Conversion and Data Migration.

·         Expert in using Agile Data Modeling methodologies.

·         Efficient in data mart design and creation of cubes using dimensional data modeling and identifying Facts and Dimensions, Star Schema and Snowflake Schema.

·         Good in Data warehouse loads, determining hierarchies, building various logics to handle Slowly Changing Dimensions.

·         Experience in dealing with different data sources ranging from flat files, Excel, Oracle, Sybase, SQL server. Experience in data cleansing, data transformation, data mapping from source to target database