Informatica Cloud AWS Architect

Snowflake, nosql, EMR, redshift, big data, DWH, ETL, Architect, Informatica, IICS, Informatica Cloud
Full Time
Depends on Experience
Travel not required

Job Description

Position: Informatica Cloud AWS Architect

Location: Plano TX

Job Description:

  • Data Architect having work experience in modern technologies AWS Cloud, Informatica Cloud and Snowflake.
  • Must have worked on Data warehousing projects and involved in supporting data modelling activities as part of building the data warehouse.
  • Exposure to cloud integration/cloud DWH implementation. (Snowflake, Redshift, etc)
  • Exposure to NoSQL and Big Data concepts
  • Experience of MS-SQL server development
  • Experience of ETL Tools such as Talend, Informatica etc. and visualization tools such as Tableau.
  • Experience of working in Multivendor Cloud based application tailored environment.
  • Experience of working in loosely coupled system interaction using micro services.
  • Experience in Performance Tuning of ETL scripts to reduce the CPU time/load timing
  • Data Architect needs to be able to have an end-to-end vision, and to see how a logical design will translate into one or more physical Databases, and design how the Data will flow through the successive Stages involved.
  • He/she will need to be able to address issues of Data Migration (Validation, Clean-up and Mapping), Data Warehouse implementation, and will need to understand the importance of Data Dictionaries, additionally provides advanced technical support in the research, experimentation, business analysis and use of systems technology including architecture, integration capabilities and database management.
  • Providing technical and data leadership to the application development group, IT and the enterprise including being conversant with and cognizant of the future direction of systems, how that direction will impact the enterprise, and how future and current systems can be exploited for the benefit of the enterprise.
  • Collaborate with IT teams and management to devise a data strategy that addresses industry requirements
  • Build an inventory of data needed to implement the architecture
  • Identify and evaluate current data management technologies
  • Create a fluid, end-to-end vision for how data will flow through an organization
  • Develop data models for database structures
  • Design, document, construct and deploy database architectures and applications (e.g. large relational databases)
  • Integrate technical functionality (e.g. scalability, security, performance, data recovery, reliability, etc.)
  • Implement measures to ensure data accuracy and accessibility
  • Constantly monitor, refine and report on the performance of data management systems
  • Meld new systems with existing warehouse structures
  • Produce and enforce database development standards
  • Maintain a corporate repository of all data architecture artifacts and procedures
Dice Id : hexaware
Position Id : 6649690
Originally Posted : 2 months ago
Have a Job? Post it

Similar Positions

AWS ETL Engineer
  • CPS Comtech
  • Plano, TX
Opening for AWS ETL Engineer - VA, TX
  • Aptuity Solutions, Inc
  • Plano, TX
Java Microservices Lead
  • Nityo Infotech Corporation
  • Dallas, TX