Vacancy expired!
Job Title: SQL Database Developer Location: NYC Duration: 12+ MonthsCandidate should have 10+ Years of ExperienceThe 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:• Very strong expertise in ETL concepts and source to target data mapping + transformation rule• Very strong experience in developing real-time API based data ingestion and integration solutions using leading iPaaS offerings• Expertise with development of scheduled batch processes for data integration using leading ETL tools• Strong knowledge of Data Warehousing concepts & experience of working in MDM (master data management) / EDL (enterprise data lake) projects• Very strong knowledge of SQL• Extensive hands on experience on MS SQL Server platform• 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• Exposure to data modeling/database design• Curious, relentless with excellent written and verbal communication and interpersonal skillsDesired Skills:• Experience working with BIG data and unstructured data sources (AWS)• Experience with Databricks and Airflow• Experience with both iPaaS and on-prem ETL platforms like Mulesoft, Informatica• Familiarity with Salesforce• Investment Firm industry experience, preferably with the Capital Markets domain
- ID: #49471901
-
State: New York
Newyorkcity
10001
Newyorkcity
USA
- City: Newyorkcity
- Salary: Depends on Experience
- Job type: Contract
- Showed: 2023-03-14
- Deadline: 2023-04-23
- Category: Et cetera