Azure Data WarehouseAmazon RedshiftSnowflakeSSISAb InitioDatastageInformaticaAzure DataFactory
Work Authorization
US Citizen
Green Card
EAD (OPT/CPT/GC/H4)
H1B Work Permit
Preferred Employment
Corp-Corp
W2-Permanent
W2-Contract
Contract to Hire
Employment Type
Consulting/Contract
education qualification
UG :- - Not Required
PG :- - Not Required
Other Information
No of position :- ( 1 )
Post :- 17th Aug 2024
JOB DETAIL
Define and implement the long-term technology strategy and innovations roadmaps across analytics, data engineering, and data platforms
Create standards, design patterns, and best practices for ETL development in an enterprise data warehouse environment.
Oversee the expansion of existing data architecture and data query performance optimization.
Assist with identifying future state architecture (data fabric, active metadata, Data Lake, Data Lakehouse).
Perform current state data model assessments/target data models and gap analysis. Propose new database architecture and support data migration from an existing Legacy system to a new structure
Create source-to-target mapping documents to transform the source data into the target warehouse and test final transformations.
Maintain and create extensions to ODS.
Assist in designing the data warehouse and ensure that data is stored and maintained in consistent formats.
Counsel with Analysts and Subject Matter Experts on specific topics in order to accurately capture existing business rules/principles.
Establish data modeling naming standards, abbreviations, guidelines, and best practices.
Develop and maintain conceptual, physical, and logical data models.
Drive best practice solutions for data in a collaborative environment.
Provide insight and strategies for data architecture solutions.
Coordinate with a Solutions Architect to find the best data solution and workflows to support projects.
Lead architectural design and strategy discussions.
Familiarity with various ETL tools including MS SSIS and Ab Initio.
Familiarity with ETL transformations between data stored in MS SQL Server Management Studio, Azure SQL Database, Oracle databases and ServiceNow.
Experience with scripting languages, Bash, PowerShell, Google Script and some C# and Python.
Familiarity with AppWorx workload automation
Extensive work with data profiling.
Extensive work with data modeling both dimensional and non-dimensional data in 3NF.
Experience in conceptual, logical, physical data modeling
Stay current with the latest technologies and trends.