The Data Developer role is responsible for supporting Business Intelligence and Reporting initiatives. Main responsibilities are creating data structures for reporting systems and developing data exchanges and integrations between various platforms. Important aspect of this role is optimizing existing and new data processes
Basic Requirements:
- Expert knowledge of SQL
- Extensive hands on experience on MS SQL Server platform (this includes SSIS with SQLServer)
- Deep understanding of RDBMS concepts
- Hands on experience developing stored procedures, functions and scripts
- Expertise in database/query performance optimization (Indexing, query tuning, troubleshooting performance problems)
- Expertise in developing ETL and batch processes to support data movement
- Experience in performing source to target data mapping exercises
- Strong knowledge of Data Warehousing concepts
- Exposure to data modeling/database design
- Curious, relentless with excellent written and verbal communication and interpersonal skills
Desired Skills
- Experience developing/deploying reports on SSRS/Cognos/PowerBI platform
- Experience working with BIG data and unstructured data sources (AWS)
- Experience with streaming data pipelines (Streamsets, Kafka)
- Financial Services industry experience
- Familiarity with Salesforce