ETL-AWS Developer

Responsibilities

• Good relevant experience in AWS cloud migration/ Python/Glue/Talend/AWS redshift/AWS Lambda skills • AWS Pipeline knowledge to develop ETL preferably using Python/Glue/Talend/ for data movement to Redshift • Strong knowledge on AWS environment and Service knowledge with S3 storage understanding • Strong knowledge multiple cloud technologies including VPC, EC2, S3 • Should have relevant experience of moving data from RDBMS sources to Columnar DB (Redshift) • Good experience with SSIS ETL tool • Extensive knowledge in Deploying SSIS Packages • Expert knowledge of SQL Query, Stored Procedures, functions and views • Financial Services experience will be a strong plus (Good to have) • Knowledge of concepts related to design, implementation and maintenance of data warehouses SQL Server Integration Services, Analysis Services, and Reporting Services. • Experience in creating Loggings, checkpoints and Error handling in SSIS Packages. • Implemented Performance Tuning at various levels (Good to have) • Capture audit information during all phases of the ETL process. • Write and maintain documentation of the ETL processes via process flow diagrams.