ETL Informatica Lead
Santhosh MRemoteLEADPosted 49m ago
ETLInformaticaData AnalysisData ProfilingData Quality ValidationData MappingData WarehouseSQLTeradataOracleSQL*ServerAWSEC2S3RedshiftIAMCloudWatchSNSLambdaStored Procedures
About the Role
We are seeking an experienced ETL Informatica Lead for a long-term contract position. This role requires extensive experience in data analysis, ETL development, and working with various database management systems and AWS services.
Key Responsibilities
• Lead ETL development and design of data warehouses
• Perform data analysis, profiling, quality validation, and mapping
• Develop and maintain ETL processes without typical ETL tools
• Utilize SQL to understand data within DBMSs
• Work with AWS services including EC2, S3, Redshift, IAM, CloudWatch, SNS, and Lambda
• Create source to target mappings and document technical designs
Requirements
• 14 to 18 years of overall IT experience
• At least 10 years of experience in Data Analysis, Profiling, Quality Validation, and Mapping
• At least 10 years of experience in ETL development including designing data warehouses
• At least 7 years of experience in using SQL with Teradata, Oracle, and SQL*Server
• At least 4 years of experience in AWS Services
• At least 4 years of experience in Analytical ETL development of Facts/Dimensions with stored procedures
• Proficient in gathering and documenting data requirements