• US Citizen

• Green Card

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 12th Oct 2022

Seasoned and passionate Data Management Professional with 10+ years of experience in developing Data Architecture solutions and Database designs.
n  Hands on experience in designing Conceptual, Logical and Physical data models using ERwin, ER/Studio, Oracle Data Modeler etc.
n  Hands on experience with both 3NF modelling and Dimensional modelling methodologies.
n  Significant experience working with both Agile and Waterfall software development methodologies.
n  Comprehensive understanding of Business process analysis and SDLC, including analysis, design, development, testing and implementation of software applications.
n  Knowledge and experience in Data Profiling using SQL, ETL/ELT Methodologies, Data Governance procedures, Master Data Management, Data Modelling best practices for Data Quality etc.
n  Experience in implementing Kimball data warehouse best practices like Star Schema, Enterprise Bus Matrix and Conformed Dimensions in multiple projects.
n  Hands-on experience with multiple platforms like Azure SQL Server, Oracle, Teradata.
n  Trained in various technologies like Snowflake, PostgreSQL, Anaplan, Tableau, Power BI, MongoDB etc.
n  Excellent Communication, Analytical, Interpersonal skills; expert at Multi-tasking and managing multiple projects simultaneously.
• Experience in domains like Retail, Supply Chain, CPG, Manufacturing, Healthcare, Airlines and Finance.


Day to Day major tasks:

• Create STM (Source to Target Mapping) document for NetOxygen and Alkami sources.
• Liaise with vendors regarding data availability and discuss queries related to the STM.
• Create SQL validation scripts to validate the data moving from Acquisition layer to Integration layer.
• Profile the incoming data while creating the pseudo code that is added to the STM.
• Create various documents to assist in the tracking of deliverables as and when assigned by PM.
 
Current job tech stack is as follows,
• SQL using SQL Server Management Studio
• MS office
• Leankit (Kanban tool) – It’s a very easy tool so no prior experience is required.
• Alteryx – Source to Acquisition data validation workflows are created using Alteryx. Having someone with this skillset would be preferable but not mandatory.