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
ETL Informatica Powercenter experience will be a value add for this role
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