Snowrelic Inc
SQL Developer
Snowrelic Inc - Jacksonville, Florida, United States, 32290
Work at Snowrelic Inc
Overview
- View job
Overview
Get AI-powered advice on this job and more exclusive features.
SQL Developer and SSIS (SQL Server Integration Services) typically involves working with Oracle databases using SQL Developer and performing ETL (Extract, Transform, Load) operations with SSIS, which is a Microsoft SQL Server tool.
Roles And Responsibilities
SQL Developer Tasks:
Writing and optimizing SQL queries for Oracle databases. Designing and maintaining database schemas, stored procedures, functions, and triggers. Data modeling and database design. Data analysis and reporting.
SSIS Tasks
Building ETL packages to extract data from various sources (including Oracle databases). Transforming data to fit target schema requirements. Loading data into SQL Server or other target systems. Automating data workflows and managing SSIS packages.
Working Together
Connecting SSIS To Oracle Via SQL Developer Knowledge
Although SQL Developer is primarily for Oracle, SSIS can connect directly to Oracle databases using its Oracle connectors.
Setting Up SSIS For Oracle Data Sources
Use the Oracle Provider for OLE DB or ODBC Driver to connect to Oracle. In SSIS, add an Oracle connection manager, configure it with the Oracle server details, and authenticate. Use Data Flow Tasks to perform data extraction, transformation, and loading.
Data Migration/Integration
You might use SQL Developer for designing Oracle queries and procedures. Use SSIS for batch processing, automation, and integrating data between Oracle and SQL Server or other systems.
Tools You'll Use
SQL Developer
To develop and test Oracle SQL queries, PL/SQL procedures, and database objects.
Ssis
To design and manage workflows for data movement and transformation.
Skills Needed
Strong knowledge of SQL and PL/SQL (Oracle) Familiarity with SSIS package design and execution Understanding of data warehousing concepts Knowledge of database connectivity and drivers (Oracle OLE DB, ODBC) Basic scripting skills (e.g., .NET, PowerShell) can be helpful Seniority level
Seniority level
Entry level Employment type
Employment type
Full-time Job function
Job function
Information Technology Industries
IT Services and IT Consulting Referrals increase your chances of interviewing at Snowrelic Inc by 2x Get notified about new SQL Developer jobs in
Jacksonville, FL . Metro Jacksonville $115,000.00-$130,000.00 3 weeks ago Senior Full Stack Developer (.NET/React)
Customer Tech - Salesforce Developer - Senior - Tech Consulting - Location Open
Jacksonville, FL $101,500.00-$186,000.00 1 day ago Customer Tech- Salesforce Technical Architect - Manager - Tech Consulting - Open Location
Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr
Roles And Responsibilities
SQL Developer Tasks:
Writing and optimizing SQL queries for Oracle databases. Designing and maintaining database schemas, stored procedures, functions, and triggers. Data modeling and database design. Data analysis and reporting.
SSIS Tasks
Building ETL packages to extract data from various sources (including Oracle databases). Transforming data to fit target schema requirements. Loading data into SQL Server or other target systems. Automating data workflows and managing SSIS packages.
Working Together
Connecting SSIS To Oracle Via SQL Developer Knowledge
Although SQL Developer is primarily for Oracle, SSIS can connect directly to Oracle databases using its Oracle connectors.
Setting Up SSIS For Oracle Data Sources
Use the Oracle Provider for OLE DB or ODBC Driver to connect to Oracle. In SSIS, add an Oracle connection manager, configure it with the Oracle server details, and authenticate. Use Data Flow Tasks to perform data extraction, transformation, and loading.
Data Migration/Integration
You might use SQL Developer for designing Oracle queries and procedures. Use SSIS for batch processing, automation, and integrating data between Oracle and SQL Server or other systems.
Tools You'll Use
SQL Developer
To develop and test Oracle SQL queries, PL/SQL procedures, and database objects.
Ssis
To design and manage workflows for data movement and transformation.
Skills Needed
Strong knowledge of SQL and PL/SQL (Oracle) Familiarity with SSIS package design and execution Understanding of data warehousing concepts Knowledge of database connectivity and drivers (Oracle OLE DB, ODBC) Basic scripting skills (e.g., .NET, PowerShell) can be helpful Seniority level
Seniority level
Entry level Employment type
Employment type
Full-time Job function
Job function
Information Technology Industries
IT Services and IT Consulting Referrals increase your chances of interviewing at Snowrelic Inc by 2x Get notified about new SQL Developer jobs in
Jacksonville, FL . Metro Jacksonville $115,000.00-$130,000.00 3 weeks ago Senior Full Stack Developer (.NET/React)
Customer Tech - Salesforce Developer - Senior - Tech Consulting - Location Open
Jacksonville, FL $101,500.00-$186,000.00 1 day ago Customer Tech- Salesforce Technical Architect - Manager - Tech Consulting - Open Location
Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr