| ETL Architect position at Columbus, IN location REMOTE at Columbus, Ohio, USA |
| Email: [email protected] |
| From: Hari prasad, Smartfolks [email protected] Reply to: [email protected] Hi, Greetings from Smart Folks Inc! My name is Hari Prasad we have a job opportunity for ETL Architect for one of our clients. Please find the Job description below, if you are available and interested, please send us your word copy of your resume with following detail to [email protected]. Role: ETL Architect Work Location & Reporting Address: : Columbus, IN 47201 REMOTE Contract duration (in months): 6-12 Implementation: Infosys Job Details: Must have Skills: ETL Architect + Data Modeller (Snowflake) With 10+ experience with 3 years in snowflake, 2-3 years in Data Modeling (Rich experience) + It will be nice to have experience in Matillion. Must Have Skills 3+ experience in Snowflake database. 10+ years of hands-on relational, dimensional, and/or analytic experience (using RDBMS, dimensional, NoSQL data platform technologies, and ETL and data ingestion protocols). Must have data modeling experience and expertise in SQL Experience with data warehouse, data lake (Azure , AWS), and enterprise big data platforms in multi-data-center contexts required. Good knowledge of metadata management, data modeling, and related tools ERWIN required. Good Hands on any ETL will be a plus. Good communication skill Understanding into Data Modeling terminologies Responsible for Data Profiling tasks, including Granularity checks, Datatypes, Nullability, Anomalies, etc. Detailed Job Description Expertise ins Snowflake Database, designing and extend existing Architecture or Datawarehouse, Design logical and physical Data models, designing load strategy, data archival and designing data staging, transformation, and final layers. Understanding Business requirements and translating the same to Functional Requirements Specifications. Involve in data optimization, suggest improvements in overall data layer strategies and underlying database properties, The candidate will: Be responsible for the development of the conceptual, logical, and physical data models, the implementation of RDBMS, operational data store (ODS), data marts, and data lakes on target platforms (SQL/NoSQL), Star schema, Snowflake schema, Data vault. Also, to reverse engineer existing data models that exist to re-engineer and build common data model. Oversee and govern the expansion of existing data architecture on cloud and the work closely with architects for optimization of data query performance via best practices. The candidate must be able to work independently and collaboratively. Responsibilities Implement business and IT data requirements through new data strategies and designs across all data platforms (relational, dimensional, and NoSQL) and data tools (reporting, visualization, analytics, and machine learning). Work with business and application/solution teams to implement data strategies, build data flows, and develop conceptual/logical/physical data models Define and govern data modeling and design standards, tools, best practices, and related development for enterprise data models. Identify the architecture, infrastructure, and interfaces to data sources, tools supporting automated data loads, security concerns, analytic models, and data visualization. Hands-on modeling, design, configuration, installation, performance tuning. Work proactively and independently to address project requirements and articulate issues/challenges to reduce project delivery risks. Keywords: information technology |
| [email protected] View all |
| Wed Jan 24 23:44:00 UTC 2024 |