ETL Informatica Developer

Company Description Incorporated in 2006; Headquartered in Chantilly, VA. Viedtech has established itself globally with its services and solution excellence. Viedtech offers fast, reliable, cost effective and value added IT and Staffing Services. We constantly strive hard to refine our quality, expand our capabilities, increase our efficiency, and elevate the superior level of customer service by delivering excellent and targeted solutions with professional integrity. Job Description 8-10 Years of experience as Strong ETL- Informatica Intelligent Cloud Services (IICS) along with API experience. Good experience with Informatica cloud migration projects. Good knowledge of SQL - Teradata/Oracle/SQL Server/AWS Redshift Assess requirements for completeness and accuracy Responsible for managing tasks and deadlines for the ETL teams. Requirement gathering and requirement Analysis. Sound concepts of Relational and dimensional data modelling with good DW concept. Good working exposure in Star and Snowflake Schemas Good working exposure in implementing end-to-end Data warehousing solutions using Informatica. Head complex ETL requirements and design. Identify, recommend, and implement ETL process and architecture improvements. Determine if requirements are actionable for ETL team. Sound Informatica Power Center knowledge. Good Knowledge on Power Center jobs implementation along with Sound SCD concepts Good knowledge on defines data collection methods, data models, types, and outlines the transformation process. Understanding concepts of Cloud and good exposure with Amazon Redshift would be an added advantage. Good knowledge of writing shell scripts Ability to design, test, debug and migrate Informatica code. Ability to develop test cases based on test matrix including test data preparation for Data Completeness, Data Transformations, Data quality, Performance, and scalability. Good analytical and problem-solving skills Qualifications Additional Information All your information will be kept confidential according to EEO guidelines.