Sign in

SQL Developer (652231)

Company:
Placement Services USA, Inc.
Location:
Edison, NJ
Salary:
Not provided
Posted:
January 25, 2023

Posted By Premium Recruiter

Description:

Design and develop ETL architecture, pipelines, and data warehouse to handle big data. Conduct data migration from SQL server to Databricks, Azure cloud, Dynamic 365, and other technologies. Create SQL equivalent Databricks tables with Databricks-specific data types via automated scripts. Lead development of stored procedures and SSIS packages to synchronize tables. Unit test all procedures and move code from development to production. Perform data transfer, for change tracking in SQL Server. Develop Insert-Update and Delete procedures to transfer data in incremental updates. Add custom logic for incremental updates for special tables where change tracking cannot be enabled. Reporting and dashboard development; implement dashboards and reports for stakeholders in tools such as Power BI and Tableau. Conduct data model updates and redesigns. Design and write code of stored procedures for implementing the business logic of handling purchase, refund, adjustment, chargeback, and other transactional data. Perform manual data validation to ensure data integrity and test the accuracy of procedures.

Travel to unanticipated client locations approximately 30%, as required. May telecommute from any location within the U.S.

Master’s degree (or foreign equivalent) in Computer Information Systems, Management Information Systems, or a related field PLUS demonstrable knowledge of: data modeling (hierarchical, network, relational); data definition and data manipulation using SQL; database administration and query optimization; connecting client-side interfaces (web applications) to server-side databases; data visualization (reporting and dashboards), and; data warehouse design using Snowflake and Star schema. Required experience and knowledge may be gained prior to or concurrent with a Master’s degree.

Please copy and paste your resume in the email body do not send attachments, we cannot open them and email them at candidates at placementservicesusa.com with reference #652231 in the subject line.

Thank you.

Apply