ETL with AWS/Remote
.Responsibilities • Manage data analysis and data integration of disparate systems • Build extensible data acquisition and integration solutions to meet the functional and non-functional requirements of the business • Implement processes and logic to extract, transform, and distribute data across one or more data stores from a wide variety of sources • Optimize data integration platform to provide optimal performance under increasing data volumes • Document the data audit, archiving, and restoration processes • Develop quality standards to ensure data quality and integrity across various database systems • Provide problem-solving expertise and complex analysis of data to develop business intelligence integration designs • Work with business users to translate functional specifications into technical designs for implementation and deployment • Convert physical data integration models and other design specifications to source codes • Ensure high quality and optimum performance of data integration systems in order to meet business solutions Experience • 5-6 years experience working with structured query language (SQL) database development, SQL queries, data structures, stored procedure, SQL Server Integration Systems (SSIS), extract transform load (ETL), application programming interface (API) architecture, and microservices • 5-6 years experience in software development lifecycle activities • Experience in financial services/banking • Experience in end-to-end design and build of near-real time and batch data pipelines • Familiarity with delivering data solutions and architecture using Amazon Web Services (AWS) services like Kinesis, Elastic Compute Cloud (EC2), Simple Storage Service (S3), Elastic Map Reduce (EMR), Spark, Athena, Redshift, Lambda, Relational Database Service (RDS), DynamoDB, Glue Catalog, and Athena preferred • Familiarity with data architecture, data integration, data governance, and data lineage concepts • Experience working in Agile environments • Experience with: - Data Integration: SQL; NoSQL(Hadoop, Casandra); Alteryx, Trifacta - Business Intelligence/Reporting Tools: Tableau, Power BI, Excel, JMP, SAS, Statistical Product and Service Solutions (SPSS), Cognos - Databases: Access, Oracle, SQL Server, DB2 Apply tot his job