Role: Teradata Architect
Location: Hartford, CT or Minneapolis, MN (Onsite 100%)
Duration: 6+ Months
Job Description:
Detailed Job Summary:
Need DB2 to Teradata Migration exp atleast 2-3 migration
• Teradata Architect with hands on experience in developing solutions to develop and manage Enterprise Data Warehouse for customer business need.
• Excellent hands-on knowledge on Teradata tools and technologies for the solution implementation. Technical architect involved in requirement gathering, Analysis, Technical solution designing and architecture and Implementation of DWH using Teradata, ETL and ELT methods
• At least one project experience on Migration experience from legacy warehouse to Teradata
• Interact with customers and their business users to gather requirements to develop and to clarify program objectives for their Teradata Datawarehouse and Business Intelligence
• Create technical solution design documentation based on the customer requirements and develop specific program/code to satisfy the business needs
• Create processes based on Teradata Solution Methodology (TSM) and standards for implementing the Teradata database and ETL/ ELT architecture accordingly
• Create Mapping design documents from source to logical and logical to physical model. Worked on mapping source systems with PDM (Physical data model)
• Analysis and design of ETL process flow documentation and Technical Specification documentation. Creating high level design documents for individual mapping customization
• Designing ETL/Semantic layer architecture and development of Teradata Views, Macros, Stored procedures, Join Indexes. Advanced hands on experience on Teradata Database Administration, performance improvement activities, System administration, SQL tuning activities
• Experience and understanding of Physical Data Model and perform activities like Physical design and implementation of database objects. Worked on DDL conversions, DDL creation from physical data model using Erwin, adding new entities, attributes, building relationships, creating PI/PPI's based on data profiling, DDL generation and deployment of database objects. Performed activities like Create Tables, Views, macros, Stored Procedures
• Develop Semantic Views on Teradata and Extract BI Reports using TPT and UNIX Shell scripts
• Data Analysis and Correction & Performance Tuning on Teradata database
• Work on performance tuning of SQL scripts using explain plan technology and analyzing the data distribution among AMPs and index usage, optimizing stored procedures for faster execution, using Analytic and OLAP functions in semantic layer views for faster data retrieval
• Involved with complete lifecycle of the project execution starting from Solution designing, Architecture build, ETL estimations, work allocation, tracking, development, unit testing, SIT, UAT, Production implementation and Operations support and contribute to the custom development of certain key modules
• Engage in change and impact analysis; effort estimations and tracking, conduct quality reviews and walk throughs
• Coordinating application development for multiple projects/modules, assist in troubleshooting and resolving issues related to database objects, ETL/ELT code
• Identify modifications needed in existing applications to meet changing user requirements, also work towards enhancing existing processes for better performance and standardization
Preferred Experience Required to perform the Role:
• Must have 15+ years of experience in implementing data warehouses using Teradata database technology with at least 1 migration project experience
• Thorough Knowledge of data warehousing methodologies
• Should possess excellent problem-solving skills with demonstrated experience managing and resolving work requests, change requests and incidents
• Demonstrated knowledge of Teradata tools and utilities and other Teradata technologies
Teradata Architect- US • Hartford, CT, United States
A data solutions company is seeking an experienced Data Architect in Windsor, CT, to support data strategies and deliver designs for complex projects.The ideal candidate will possess over 10 years ... Show more
Associate Dentist – Hebron, CT.We are a modern, primarily fee-for-service private practice located in Hebron, CT.Our office is equipped with the latest technology including an intraoral scanner, di... Show more
Amelia, United States; Atlanta, United States; Hartford, United States; New York, United States; Princeton, United States; .We're looking for an Azure Cloud Architect who thrives on design and co... Show more
Presidio, Where Teamwork and Innovation Shape the Future.AtPresidio, we're at the forefront of a global technology revolution, transforming industries throughcutting-edge digital solutions and next... Show more
Played BI / OLAP architect role for at least two end to end large engagements.Build reporting and meta-data models in IBM Cognos Framework Manager to support strategic data initiatives.Good underst... Show more
Amelia, United States; Hartford, United States; Princeton, United States; .We are seeking an experienced Data Architect / Data Modeler with strong industry standards knowledge and a solid foundat... Show more
E*Pro Consulting service offerings include contingent staff augmentation of IT professionals, permanent recruiting, and temp-to-hire.In addition, our industry expertise and knowledge within financi... Show more
Location: Hartford, CT or Minneapolis, MN (Onsite 100%).Need DB2 to Teradata Migration exp atleast 2-3 migration.Teradata Architect with hands on experience in developing solutions to develop and m... Show more
A leading insurance provider is seeking a Director/AVP, Data Architect to design and manage enterprise data platforms pivotal for decision-making in actuarial operations.The role involves building ... Show more
The ideal candidate should have expertise in Spark Optimization, AWS DevOps, AWS Glue Studio, AWS Glue ETL, AWS Glue Catalog, Amazon S3, and Apache Spark.This role involves optimizing data processe... Show more
Currently, we leverage machine learning, natural language processing, predictive analytics, and generative AI to enhance customer experience, and improve operational efficiency.This includes utiliz... Show more
CompHealth exists to make the locums process easier.Not only will we search for jobs that fit your interests, we'll be here to handle all the details like credentialing, housing, travel arrangement... Show more
The Data Architect is responsible for designing, implementing, and maintaining the organization’s data infrastructure to ensure optimal data management, integration, accessibility, and security.Thi... Show more
A leading financial institution is seeking a skilled AI Data Architect to drive the design and implementation of enterprise-wide data architectures.This hybrid role involves collaborating with dive... Show more
In our ‘always on’ world, we believe it’s essential to have a genuine connection with the work you do.At Aurora Networks, we strive for the highest quality in our products.The Systems Integration a... Show more
Strong hands-on experience with Epic systems, including:.Hyperspace or Hyperdrive environments.Clarity and Caboodle data models.Experience with modern data engineering tools and platforms:.DBT (dat... Show more
A leading technology firm in agriculture seeks a Data Architect to design and implement enterprise data architecture.This role involves developing modern data architectures and supporting AI/ML wor... Show more
Sunrise Systems Inc is seeking a senior Databricks Architect/Admin in Hartford, CT (Hybrid) to design and optimize enterprise data platforms.In this role, you will manage the Databricks platform, d... Show more
Bankruptcy Court - District of CT is looking for a Principal Software Development Engineer in Hartford, CT.This full-time role involves leading the design and development of high-performance, cloud... Show more
WHEN YOU WORK FOR US, WE WORK FOR YOU.Wallingford, CT, United States.Minimum years of relevant experience in healthcare:.BCLS/BLS - American Heart Association/CRT, RRT Elig/RRT.Competitive weekly p... Show more
