ETL MDM Data Developer - NYC, NY. - onsite - Hybrid at NYC, New York, USA |
Email: harry@dvgts.com |
https://jobs.nvoids.com/job_details.jsp?id=311266&uid= From: Harry Mino, DVG TECH SOLUTIONS harry@dvgts.com Reply to: harry@dvgts.com Position: ETL MDM Data Developer. Location: NYC NY(onsite)(Hybrid). Experience: 8+ Years Duration: 12+ Months Visa: H-1B Transfers/H4-EAD/L2EAD/GC/USC The CRM & Analytics team is a highly strategic and cross-functional team responsible for leading the firms global digitalization effort. This initiative, spanning all client-facing business units and corporate functions, will drive innovation and strategic change through technology, data science, and deep analytics. The team partners with key business leaders and industry experts to build transformational technology to drive revenue, maximize efficiency, and optimize the allocation of resources. The CRM & Analytics team is at the forefront of Jefferies cloud initiative, leveraging best-in-class cloud-based technologies to replace legacy on-premises solutions to provide intelligent trend insights, actionable opportunities, decision support, and transparency into all client and business-related activities. Position Overview: 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. Required Qualifications: Very strong expertise in ETL concepts and source to target data mapping + transformation rules 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 skills. Preferred Qualifications / Desired 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 Keywords: green card microsoft New York https://jobs.nvoids.com/job_details.jsp?id=311266&uid= |
harry@dvgts.com View All |
06:12 PM 27-Jan-23 |