FIND PERSONALIZED JOBS
Sign up to Zippia and discover your career options with your personalized career search.
Sorry, we can't find that. Please try a different city or state.

SQL Developer

This job has expired and is no longer available.
APPLY NOW
Apply Now
×
FIND
PERSONALIZED JOBS

Sorry, we can't find that. Please try a different city or state.

CONTENT HAS
BEEN UNLOCKED
Close this window to view unlocked content
or
find interesting jobs in

Log In

Log In to Save

Sign Up to Save

Sign Up to Dismiss

Sign Up

SIGN UP TO UNLOCK CONTENT

or

The email and password you specified are invalid. Please, try again.

Email and password are mandatory

Forgot Password?

Don't have an account? Sign Up

reset password

Enter your email address and we will send you a link to reset your password.

Back to Log In

Log In

Log In to Save

Sign Up to Save

Sign Up to Dismiss

Sign up to save the job and get personalized job recommendations.

Sign up to dismiss the job and get personalized job recommendations.

or

The email and password you specified are invalid. Please, try again.

Email and password are mandatory

Already have an account? Log in

reset password

Enter your email address and we will send you a link to reset your password.

Back to Log In

Company Saved

Answer a few questions and view jobs at that match your preferences.

Where do you want to work?

Job Saved

See your Saved Jobs now

or

find more interesting jobs in

Job Dismissed

Find better matching jobs in

Your search has been saved!

Top 50 SQL Developer Skills

Below we've compiled a list of the most important skills for a SQL Developer. We ranked the top skills based on the percentage of SQL Developer resumes they appeared on. For example, 15.1% of SQL Developer resumes contained Database as a skill. Let's find out what skills a SQL Developer actually needs in order to be successful in the workplace.

These are the most important skills for a SQL Developer:

1. Database

demand arrow
high Demand
Here's how Database is used in SQL Developer jobs:
  • Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance.
  • Configured and monitored database application.
  • Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
  • Worked with respective Database Administrators in Performance Tuning for in-efficient queries, CPU consumed Queries and Long-running Queries.
  • Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
  • Involved in testing the database for queries that were generated and handled the performance issues effectively.
  • Developed E-R diagrams (logical and physical using Erwin) mapping the data into database objects.
  • Designed and created SQL Databases, tables, indexes, and views based on user requirements.
  • Created databases, loaded initialization data, generated users, and assigned roles and access.
  • Created database fact/dimension tables, views, stored procedures, functions and triggers as required.
  • Created user defined data types and added them to model database for future purpose.
  • Created/Updated database objects like tables, views, stored procedures, function, packages.
  • Used MS Access for smaller databases to create the tables and generate the reports.
  • Performed Database testing & maintaining the data by using the procedures.
  • Implemented the developed database into SQL Server 2005 using T-SQL.
  • Maintained the referential integrity of the database.
  • Involved in the maintenance of the database.
  • Involved in tuning the database.
  • Developed and modified applications, authored database procedures and triggers for data processing Created entry forms/reports for various modules.
  • Used Sql Developer tool for pulling the data from database.

Show More

56 Database Jobs

No jobs at selected location

2. SQL

demand arrow
high Demand
Here's how SQL is used in SQL Developer jobs:
  • Worked on performance monitor counters for monitoring SQL Server environment.
  • Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary.
  • Created number of jobs, alerts and operators to be paged or emailed in case of failure for SQL 2000.
  • Worked with Client/Server tools such as SQL Server Enterprise Manager and Query Analyzer to administer the SQL Server.
  • Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
  • Worked closely with development team in writing tuned SQL queries to improve loan search application performance.
  • Scheduled SQL Server Agent Jobs to run every day to update changes in the base tables.
  • Developed reports using SQL Server Reporting Services and utilizing complex SQL queries and stored procedures.
  • Designed and developed tables, view, stored procedures and triggers in MS SQL Server.
  • Worked on optimizing the existing SQL queries and improved the performance of the system.
  • Worked on Deployment of packages into Production servers and managed scheduled SQL jobs.
  • Worked with the application developers and provide necessary SQL Scripts using T-SQL.
  • Test the Installation of SQL Server and implemented different security modes.
  • Designed complex SQL queries to view the data from front-end.
  • Installed SQL Server Management tools using SQL Server Setup Program.
  • Worked on performance tuning of T-SQL queries and Stored Procedures.
  • Created stored procedures, Cursors, Joins in T-SQL.
  • Monitor connections, locks and performance of SQL server.
  • Worked on performance of reports using SQL Profiler.
  • Tuned the SQL queries using SQL profiler.

Show More

115 SQL Jobs

No jobs at selected location

3. Ssis

demand arrow
high Demand
Here's how Ssis is used in SQL Developer jobs:
  • Involved in integrating different Database Applications using SSIS packages.
  • Published migrated data using SSIS, DTS Wizard Tool through data flow tasks, look up transformations and script tasks.
  • Designed, developed and implemented ETL framework using SSIS, stored procedures, functions for extractions into SQL Server.
  • Used SSIS to populate data from various data sources, creating packages for different data loading operations for applications.
  • Designed and implemented the underlying extract-transform-load (ETL) structure in SSIS to support the new IT services reporting.
  • Developed SSIS packages using looping, data formatting, check points, error handing, email notification etc.
  • Involved in implementing SSIS package security, checkpoints, protecting packages, executing, monitoring and managing them.
  • Involved in SQL 2008 Upgrade Project for deploying SSIS 2005 to 2008 DTSX packages ensuring the Consistency Level.
  • Supported Production Environment with schedule the packages and make the package dynamic with parameters in SSIS Catalog Database.
  • Implemented Distributed Transaction Control for the SSIS packages and event handlers to keep track of error logs.
  • Performed data cleansing by creating tables to eliminate the dirty data using SSIS.
  • Experienced in creating complex SSIS and DTS packages for SAS ETL purposes.
  • Prepared the complete data mapping for all the migrated jobs using SSIS.
  • Implemented complicated Transformations to be used in SSIS packages.
  • Experience in creating SSIS Packages.
  • Imported data from MS Access, MS Excel and Text Files to SQL server using SSIS.
  • Implemented Error-Handling using TRY and CATCH blocks in SQL Scripts and tuning using counters in SSIS.
  • Experience in Error Handling using TRY and CATCH blocks and performance-tuning using counters in SSIS.
  • Used bcp utility inside SSIS packages to import and export bulk data across servers.
  • Assisted the Frontend, QA and Production Teams.

Show More

29 Ssis Jobs

No jobs at selected location

4. T-Sql

demand arrow
high Demand
Here's how T-Sql is used in SQL Developer jobs:
  • Filtered bad data from legacy system using into complex T-SQL statements, and implemented various constraint and triggers for data consistency.
  • Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports.
  • Involved in performance tuning of T-SQL Queries and focused on index tuning, query optimization and partitioning.
  • Designed, coded, tested and debugged custom queries using Microsoft T-SQL and SQL Reporting Services.
  • Design and develop T-SQL solutions for reporting, data gathering, and application back ends.
  • Write T-SQL statements for retrieval of data and involved in performance tuning of TSQL queries.
  • Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
  • Generated server side T-SQL scripts for data manipulation and validation and created various snapshots.
  • Generated T-SQL scripts for Data retrieval, Manipulation & Validation for various applications.
  • Developed various T-SQL stored procedures, triggers based on the requirement.
  • Developed database triggers and stored procedures using T-SQL cursors and tables.
  • Reviewed many T-SQL issues using management studio for better performance.
  • Involved in performance tuning and Database optimization of T-SQL queries.
  • Involved in performance tuning of T-SQL queries and Stored Procedures.
  • Developed Transact-SQL scripts to enforce business rules.
  • Created functions, stored procedures, triggers and constraints using T-SQL Monitoring & tuning SQL scripts by performance monitoring.
  • Developed complex programs in T-SQL, writing Stored Procedures, Triggers and Queries with best execution plan.
  • Provide 24/7 Support for SQL Server 2000/05 environment Develop T-SQL against SQL Server 2000/05 database.
  • Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
  • Design and develop T-SQL procedures, query performance tunings and SSIS packages.

Show More

5. Windows XP

demand arrow
high Demand
Here's how Windows XP is used in SQL Developer jobs:
  • Participate in corporate transition from Windows XP to Windows 7.
  • Installed and Configured SQL Server 2005 on development server for designing and testing.Environment: SQL Server 2005, Windows XP/2000/98/95.
  • Involved in end user Environment: SQL, PL/SQL, SQL*Loader, Windows XP, UNIX

Show More

Job type you want
Full Time
Part Time
Internship
Temporary

6. Ssrs

demand arrow
high Demand
Here's how Ssrs is used in SQL Developer jobs:
  • Scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
  • Scheduled daily and weekly reports using SSRS subscriptions to the Sales managers and various other users.
  • Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
  • Converted the existing reports to SSRS without any change in the output of the report.
  • Created, deployed and managed reports using SQL Server Reporting Services (SSRS).
  • Enhanced the existing reporting functionality by using the advanced features of SSRS.
  • Deployed the converted SSRS reports on the client's work station.
  • Designed reports utilizing SQL Server Reporting Services (SSRS).
  • Created SSRS report according to user requirements and technical standards.
  • Performed automation to generate and distribute the reports using SSRS.
  • Created queries for generating drill down reports in SSRS 2005.
  • Migrated Excel based manual report into SSRS reports.
  • Involved in designing of reports using SSRS.
  • Designed and developed complex SSRS reports.
  • Designed and developed various types of reports using SSRS and rendered them in front end applications like Excel and .net.
  • Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
  • Create Report for upper management using SSRS, Schedule and Organized Requirement Meetings.
  • Design and Develop SSRS reports and efficient SSIS packages to support reporting functionalities.
  • Worked with report parameters and performed Parameterized and cascading parameterized reports using SSRS.
  • Generated Drill down, Drill through, Matrix Reports, parameterized reports, cascading parameterized Reports using SSRS.

Show More

13 Ssrs Jobs

No jobs at selected location

7. Business Requirements

demand arrow
high Demand
Here's how Business Requirements is used in SQL Developer jobs:
  • Project includes analysis of complex business requirements, creating and modifying complex stored procedures also worked on performance tuning.
  • Designed and developed tools for business requirements using stored procedures.
  • Developed stored procedures/packages using T-SQL to meet the business requirements.
  • Translate business requirements into software applications and models.
  • Analyzed the business requirements from the given specifications.
  • Schedule meetings with managers/executives to gather business requirements.
  • Involved in Business Requirements gathering and Analysis.
  • Created database Triggers to implement business requirements.
  • Created Drill-down and Drill- through reports, also scheduled and managed weekly/monthly inspection and violation reports based on the business requirements.
  • Transformed the Business Requirements into Functional and Non Functional Requirements and interface between the client and the development team.
  • Developed Burst reports, Drill through reports, Master Detail reports in Report Studio based on the business requirements.
  • Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
  • Scheduled and managed daily / weekly / monthly sales and operational reports based on the business requirements.
  • Involved in Business Requirements, System analysis and Design of the Data warehouse application.
  • Defined constraints, rules, indexes and views based on business requirements.
  • Involved in creation of Conceptual Modeling covering all the business requirements.
  • Developed new module as per the business requirements.
  • Worked closely with the client to analyse the business requirements in the user stories and advise accordingly from database perspective.
  • Validated the datastage jobs with the business requirements and logged the defects in HP Quality Center.
  • Developed SQL stored procedures per requirements Updated Excel templates per requirements Tested Excel templates to meet business requirements

Show More

1 Business Requirements Jobs

No jobs at selected location

8. Data Warehouse

demand arrow
high Demand
Here's how Data Warehouse is used in SQL Developer jobs:
  • Involved in ETL architecture enhancements to increase the performance data warehouse using query manager and optimizer.
  • Participated actively in analysis and discovery phases of data warehouse implementation.
  • Collaborated with Data Warehouse in impact analysis to crystal reports.
  • Maintained and enhanced the existing Data Warehouse, exports and reports; developed vendor and client exports that meet provided specifications.
  • Developed stored procedures to transform the data from enterprise data warehouse to SQL server and load data to fact tables.
  • Designed Fact tables, Dimension tables and scheduled data transfer from real time database to data warehouse and databases.
  • Used ETL SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
  • Worked with ETL to implement the slowly changing transformation, to maintain Historical Data in Data warehouse.
  • Retrieved data from data warehouse and generated a series of meaningful business reports using SSRS.
  • Implement Slowly Changing Dimension (SCD2) to maintain historical data in Data Warehouse.
  • Developed and deployed SSIS packages to load data from OLTP to Data Warehouse system.
  • Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
  • Created SSIS packages to migrate data from different data sources to data warehouse.
  • Created SSIS package to extract, validate and load data into Data warehouse.
  • Created and implemented the staging database prior to the final data warehouse.
  • Design, develop and implement complete life cycle of data warehouses.
  • Created a data warehouse based on the Dimensional Model.
  • Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
  • Worked on different Data Interfaces, Data Warehouse, SQL Server, Sybase, Oracle Server, and SQL-Div.
  • involved in normalization and de-normalization of existing tables for faster query retrieval in data warehouse.

Show More

5 Data Warehouse Jobs

No jobs at selected location

9. ETL

demand arrow
high Demand
Here's how ETL is used in SQL Developer jobs:
  • Implemented Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
  • Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business.
  • Involved in full life cycle development including Design, ETL strategy, troubleshooting Reporting, and Identifying facts and dimensions.
  • Developed ETL packages with different data sources (SQL server, Flat Files, Excel source files, etc.)
  • Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse.
  • Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
  • Have a very Good Experience with all the Control Flow and Data Flow tasks in SSIS for ETL.
  • Worked with a team to develop ETL processes to get data from multiple data sources.
  • Involved in Performance tuning of ETL transformations, data validations and stored procedures.
  • Validate data before performing ETL transformations and load into SQL server database.
  • Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
  • Designed and Developed SSIS packages to automate the manual ETL processes.
  • Designed and documented batch logging frameworks for all ETL processes.
  • Performed ETL mappings using MS SQL Server Integration Services.
  • Designed ETL specification documents for all the projects.
  • Developed applications using SQL Server 2008, T-SQL, ETL, SSIS, and SSRS.
  • Used Informatica power center for (ETL) extraction, transformation and loading data from heterogeneous source systems.
  • Performed cost benefit analysis of different ETL packages (SSIS) to determine the optimalProcess.
  • Created, configured and tuned ETL workflow design in SSIS.
  • Designed ETL packages for different data sources (SQL Server, Flat Files, and XMLs etc).

Show More

10 ETL Jobs

No jobs at selected location

10. Query Analyzer

demand arrow
high Demand
Here's how Query Analyzer is used in SQL Developer jobs:
  • Monitored query using query analyzer and tuned queries and procedures to boost database performance.
  • Involved in building RDBMS using T-SQL programming (Procedures, Triggers, Functions and Query analyzer scripts).
  • Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
  • Create Stored Procedures to derive XML data sets in Query Analyzer in an SQL Server environment.
  • Developed and optimized stored procedures using input, output, table valued parameters and Query Analyzer.
  • Well experienced with tools like Query Analyzer, SQL utility.
  • Created stored procedures and triggers using T-SQL in Query Analyzer.
  • Used Query Analyzer and Enterprise manager as a development tool.
  • Handled database objects with Enterprise Manager and Query Analyzer.
  • Used Query Analyzer to optimize SQL Queries.
  • Created cubes using SSAS and created excel pivot table for further analysis Solved T-SQL performance issues using Query Analyzer.
  • Identified problems with SQL queries and offered solutions to optimize performance using Query Analyzer and SQL Profiler.
  • Administer SQL Server with Client/Server tools including SQL Server Enterprise Manager, Profiler and Query Analyzer.
  • Used Index Tuning Wizard, SQL Profiler and SQL Query analyzer for Performance Tuning.
  • Involved in query optimization and performance tuning using SQL Profiler and Query Analyzer.
  • Incorporated SQL profiler and query analyzer to optimize SQL queries and stored procedures.
  • Use Enterprise Manager, Query Analyzer and SQL Server Profiler.
  • Optimized SQL queries using SQL profiler and query analyzer.
  • Experienced in Visual source safe latest version Used SQL Profiler and Query Analyzer to optimize ETL package queries and stored procedures.
  • NET, VB.NET, Windows Sever [ ] SQL Server Management Studio, SQL Profiler, Query Analyzer, Erwin 7.0

Show More

11. DTS

demand arrow
high Demand
Here's how DTS is used in SQL Developer jobs:
  • Used Data Transformation Services (DTS) to populate data from various data sources using the concept of OLE DB.
  • Transformed data of Terminals (AST) from various data sources using OLE DB connection by creating various DTS packages.
  • Used various ETL tools like SSIS/DTS to import data from Flat files, Excel source files into SQL server Database
  • Configured Server for sending automatic mails to the respective people when a DTS process fails or succeeds.
  • Involved in converting all existing earlier versions of SQL Server DTS packages by using different SSIS tasks.
  • Created DTS packages to get data from different sources, consolidate and merge into one single source.
  • Worked on DTS Package, DTS Import/Export for transferring data from Heterogeneous Database to SQL Server.
  • Developed DTS Packages to transfer the data between SQL Server and other database and files.
  • Developed and designed DTS package/application for importing the data from word and update.
  • Performed Documentation for all kinds of reports and DTS and SSIS packages.
  • Performed various data transforms between various servers using BCP and DTS.
  • Implemented batch processing for approval process using Jobs and DTS.
  • Created DTS package to schedule the jobs for batch processing.
  • Involved in Migration of different DTS packages to SSIS packages.
  • Managed up-gradation of DTS packages to SSIS packages for ETL.
  • Worked on MS SQL Server tasks such as batch jobs, BCP, DTS linked servers and indexes.
  • Created and Scheduled DTS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
  • Created SSIS/DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle.
  • Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
  • Implemented DTS packages to Extra, Transform, Load from Flat files , Oracle 8i into SQL Server 2000.

Show More

1 DTS Jobs

No jobs at selected location

12. Constraints

demand arrow
high Demand
Here's how Constraints is used in SQL Developer jobs:
  • Created Entity relationship diagrams, Function relationship diagrams, data flow diagrams and enforced all referential integrity constraints using Oracle Designer.
  • Enforced referential integrity via creation of constraints on database objects.
  • Created database objects - tables, indexes, views, user defined functions, cursors, triggers, constraints and roles.
  • Involved in creating the constraints, rules, defaults, and triggers to maintain the data and referential integrity.
  • Created database objects like Tables, Indexes, Stored Procedure, Triggers, Functions, Constraints and Views.
  • Created various integrity constraints like Primary Key, Foreign Keys, Unique and Check to support application functionality.
  • Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.
  • Involved in creating tables, keys, stored procedures, constraints and User Defined Functions.
  • Involved in Creation of tables, indexes, sequences, constraints, triggers and procedures.
  • Created database tables with various constraints including primary key, foreign key, etc.
  • Created Tables, Indexes, Table Spaces, Views synonyms, and integrity constraints.
  • Created Tables, Stored Procedures, Views, Constraints and User Defined Functions.
  • Used triggers and constraints to maintain the consistency of the databases.
  • Defined Check constraints, Business Rules, Indexes, and Views.
  • Created functions, stored procedures, triggers and constraints using T-SQL.
  • Created indexes, Constraints and rules on database objects.
  • Implemented different types of constraints on tables.
  • Created Tables, Indexes and Constraints.
  • Created Entity relationship diagrams ER-Diagrams, function relationship diagram, Dataflow Diagrams and enforced all referential integrity constraints.
  • Participated in Designing databases (schemas) to ensure that the relationship between data is guided by tightly bound Key constraints.

Show More

4 Constraints Jobs

No jobs at selected location

13. XML

demand arrow
high Demand
Here's how XML is used in SQL Developer jobs:
  • Created data mappings to load and transform the data from XML, Flat files, CSV files to defined XSD Schema.
  • Experience in using XMLA protocol for SQL Server Analysis Services 2005 for interaction between client application and instance of Analysis Services.
  • Used XML creation and parsing techniques to send, receive and store in database in console application.
  • Developed interface store procedure to upload customers driving record from DMV in XML format to CAIS.
  • Created XML file for package configurations and implemented parent-child package configuration in SSIS packages.
  • Involved in writing Spring Configuration XML file that contains object declarations and dependencies.
  • Converted Excel files to XML than load data into tables using SSIS packages.
  • Involved in writing stored procedures, triggers and generating XML objects.
  • Worked on parsing huge XML's data using stored procedures.
  • Copied Facet State to XML file using T-SQL.
  • Extracted data from XML files.
  • Worked on SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server.
  • Extracted data from XML to SQL Server Created SSIS packages for data Importing, Cleansing, and Parsing etc.
  • Implement and maintain XML Schemas that client system is based upon.
  • Worked with the calculated members (CTEs) and XML Data.
  • Extracted data from xml and flat files using SSIS.
  • Created SQL Server query to generate XML files.
  • Experience with Microstrategy Web customization with XML/XSL etc.
  • Configured XML config files (.
  • Design of ETLs using SSIS and vb/c# scripting, for loading files in formats ranging from xml to csv.

Show More

2 XML Jobs

No jobs at selected location

14. Ssas

demand arrow
high Demand
Here's how Ssas is used in SQL Developer jobs:
  • Used Data Analysis Expressions (DAX) for data cleaning, data validation and analysis of data in SSAS tabular Model.
  • Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
  • Involved in the SSAS partitions and calculation of queries with MDX, developing reports using MDX and T-SQL.
  • Created Cubes with Star schema in SSAS and developed SSRS reports based on the cubes.
  • Assisted in creation of SQL Server Analysis Services (SSAS) cubes for analysis.
  • Build a company specific DataMart for the Claims related data using SSIS and SSAS.
  • Scheduled Cube Processing from Staging Database Tables using SQL Server Agent using SSAS.
  • Involved in implementing Key Performance Indicator (KPI) Objects in SSAS 2008.
  • Experience in extracting huge data from SSAS cubes to perform various business operations.
  • Involved in designing, building & testing of OLAP cubes with SSAS.
  • Created MDX queries to retrieve data from SSAS Cubes for analyzing purposes.
  • Designed SSAS cube to hold summary data for Target dashboards.
  • Deployed/Designed cubes in SSAS environment.
  • Created DSV, Cubes, and Dimensions, DMX/MDX for SSAS Reports.
  • Create Calculate member in MOLAP cube using MDX in SSAS 2008.
  • Involved in creating complex MDX and DAX queries in SSAS Cubes.
  • Involved in development &Deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.
  • Experience in creating Multidimensional cubes using SSAS and designing DW schemas.
  • Designed and developed KPIs to measure sales and Growth using SSAS.
  • Created cubes and data marts using SSAS Designed snowflake and star schemas for customer summaries.

Show More

4 Ssas Jobs

No jobs at selected location

15. C # .NET

demand arrow
average Demand

16. Backup

demand arrow
average Demand
Here's how Backup is used in SQL Developer jobs:
  • Configure and manage database maintenance plans for update statistics, database integrity check and backup operations.
  • Perform common scheduled database maintenance including backups/restores, archiving, and monitoring data transfers.
  • Involved in performing database Backup and Recovery.
  • Perform database administration tasks including; Installation, Configuration, Upgrades, Capacity Planning, Performance Tuning, Backup and Recovery.
  • Scheduled daily log backups which would free up the space on Server and was responsible for cleanup of old backup files.
  • Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.
  • Involved configuring where prefer that backup jobs run and then scripting backup jobs to implement backup preference.
  • Created Jobs for taking log backups which frees up the space for Database and increases performance.
  • Performed daily database backup & restoration, monitored the performance of the Server.
  • Recovered the backups of SQL Server production databases in test server environment.
  • Planned and Scheduled the Online/Offline Backups, Maintained Backups and Restore.
  • Write T-SQL scripts for database backup jobs and daily/weekly jobs.
  • Managed database and performed backups and upgrades with Oracle 9i.
  • Develop Backup & Restore scripts for SQL server as needed.
  • Monitor nightly jobs, backups, and maintenance plans.
  • Used export and import utilities for logical backups.
  • Performed Backup and restore of databases.
  • Created Stored Procedures for Automatic Scripting to backup transaction logs, flush/grow/shrink log files, maintain archive of objects.
  • Created stored procedures to backup transaction logs, flush/grow/shrink log files, maintaining and archiving tables.
  • Worked with database export & import scripts to backup database Created tables, indexes, stored procedures and functions.

Show More

2 Backup Jobs

No jobs at selected location

17. Unix

demand arrow
average Demand
Here's how Unix is used in SQL Developer jobs:
  • Designed, implemented and maintained UNIX-based custom statistics collection package.
  • Developed complex SQL queries to perform the back end testing of the Oracle database using SQL and UNIX shell commands.
  • Redesigned Oracle Procedures, Views, and stored SQL used by automated UNIX processes due to database table redesign.
  • Created Database change tickets in UNIX server to update or completely delete TAR numbers as per request from client.
  • Developed and maintained Unix scripts for objects deployment to Development, QA, User testing and Production.
  • Developed UNIX Shell Scripts and PL/SQL procedures to extract and load data for month-end batch processing.
  • Developed UNIX shell scripts to perform a nightly refresh of the test system from Production databases.
  • Obtained performance metrics for in memory session replication using JMETER and Unix utilities i.e.
  • Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process.
  • Created Unix shell and Perl utilities for testing, data parsing and manipulation.
  • Created UNIX Shell Scripts for automating the execution process.
  • Developed UNIX Shell scripts to automate repetitive database processes.
  • Managed job execution and Job Queues in Unix boxes.
  • Involve in Health Checking of Unix servers.
  • Used UNIX Shell scripts (KORN) for Extracting and Parsing data from the files.
  • Developed the Oracle scripts (Package) and UNIX shell scripts.
  • Developed UNIX shell/Perl scripts to process the source files like tar, txt and Mailing them when needed.
  • Provide technical support and back end support using UNIX shell script and SQL for commission application.
  • Putty, Crontab, SQL Loader, UNIX server and Remedy.
  • Experience with UNIX Shell scripts and PERL scripts for automation dialy routine taks.

Show More

2 Unix Jobs

No jobs at selected location

18. Asp.Net

demand arrow
average Demand
Here's how Asp.Net is used in SQL Developer jobs:
  • Created ASP.NET web forms and Class libraries containing code for business and data access logic using C#.NET.
  • Involved in creating ASP.NET MVC 4.0 based Web applications it provides an alternative to the ASP.NET Web Forms pattern.
  • Created Web pages to display various details using ASP.NET controls like Data Grid and Details View.
  • Used ASP.NET Validation controls to do client-side validations based on the user s browser.
  • Developed ASP.NET C# application to interface with accounting system, warehouses.
  • Implemented input validation using the ASP.NET input validation controls and JavaSCript.
  • Designed database and system flow, programmed in ASP.NET.
  • Developed ASP.NET Web Forms, Web Services.
  • Developed custom Web parts using ASP.Net, to get the input from employees and for managers to give their feedback.
  • Involved writing code in ASP, VB.NET and ASP.NET for client application Developed Data export and import using DTS packages.
  • Constructed a SQL/VS2012 ASP.NET web application with login, search, export, CM, and administration.
  • Modified and created ASP.Net applications that were written in C# as business requirements were changing.
  • Designed and developed of entity models, controllers and Views for the ASP.Net, MVC 3.0.
  • Supported and developed both web-based applications using ASP.NET as well as client-server applications written in VB.NET.
  • Developed complex web forms using ASP.NET server-side scripting with C#, .NET Framework 3.5.
  • Designed and developed web application and restful service using ASP.NET and .NET 4.0 Framework.
  • Developed business objects using ASP.Net for various modules.
  • Created Reports and integrated reports into ASP.Net Application.
  • Experience working with ASP.NET as frontend team.
  • Share point, ASP.Net, Erwin7.3, Query Analyzer, Index Tuning wizard, SQL Profiler Windows server 2003.

Show More

19. Html

demand arrow
average Demand
Here's how Html is used in SQL Developer jobs:
  • Exported crystal/SSRS reports into various formats like PDF, HTML, Excel and Word for end users.
  • Develop the User Interface Screens for presentation Web logic using JSP, HTML, and CSS.
  • Generate reports either in HTML, PDF or RTF formats according to the client specifications.
  • Created reports in HTML format for easy navigation of data from web browser.
  • Designed and developed User Interface Screens using HTML, DHTML and JSP.
  • Used HTML and CSS to maintain look and feel of application.
  • Used Bootstrap to transform standard HTML websites into single page design.
  • Involved in designing of Web pages using HTML and XML.
  • Used CSS and HTML to develop the application view.
  • Create HTML/C# razor screens to present data.
  • NET, ASP.NET 3.5, XML, XLST, HTML, Java Script.
  • Used HTML, JSP for UI Design.
  • Designed developed and deployed reports in Cognos portal and made available to render them to HTML and PDF formats.
  • Develop responsive webpage using HTML5, CSS3 so it would render similar across all browsers and devices.
  • Used the HTML code to make the report manager more functional and customizable.
  • Created many Perl CGI/HTML programs for front end support and reporting modules.
  • Used HTML and _Java Script for front end validation.
  • Developed and designed the User Interface using ASP.NET controls, HTML, HTML 5, CSS and Bootstrap.
  • Created Runtime Html Files using PHPWIKI.
  • SOAP, HTML, Java Script, Cobol, JQuery, XML, JAXB, JSON, Maven, Web logic.

Show More

2 Html Jobs

No jobs at selected location

20. Ad-Hoc

demand arrow
average Demand
Here's how Ad-Hoc is used in SQL Developer jobs:
  • Responded to AD-HOC requests and special projects that require immediate attention while at the same time maintaining deadlines on existing requests.
  • Created Ad-Hoc Reports in Report Studio and various complex reports in Report Studio.
  • Perform Ad-Hoc duties as assigned by management.
  • Used SSRS to develop different kinds of reports like canned, ad-hoc reports for the State and Local Agency users.
  • Involved in designing parameterized reports for generating Ad-Hoc reports as per the client requirements using SSRS.
  • Developed queries for drill down, cross tab, sub reports and ad-hoc reports using SSRS.
  • Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
  • Analyze, design, implement and test ad-hoc and standard reports.
  • Perform ad-hoc analysis and translate results into clear and concise reporting.
  • Create ad-hoc SQL queries for customer reports, executive management reports.
  • Migrated ad-hoc reports from MS-Excel and Crystal Reports to SSRS.
  • Created Ad-Hoc reports to satisfy emergency request from clients.
  • Created Reports using OBIEE 10g and SSRS 2008 for ad-hoc Queries Identified data sources, defined and built data source view.
  • Applied conditional formatting in SSRS to highlight key areas in the report data Used Report Builder to do Ad-hoc Reporting.
  • Worked with DBAs in order to schedule SSIS packages as jobs either daily, monthly, yearly or ad-hoc.
  • Developed datasets to perform reporting and included interactive drill down reports, report models and ad-hoc reports.
  • Created Ad-hoc reports to enable the business users to create the need based reports.
  • Used SSRS to create ad-hoc reports for operational / regulatory reporting and analytics.
  • Cleaned existing data and converted them into useful SAS Datasets, merged datasets and created reports based on Ad-hoc requirements.
  • Created ad-hoc queries and reports for unit team lead as requested and provide on-going analytical support for these requests.

Show More

21. Olap

demand arrow
average Demand
Here's how Olap is used in SQL Developer jobs:
  • Designed OLAP model based on Dimension and Fact tables for efficient loads of data which were based on Star Schema structure.
  • Created daily and weekly reports based on the data from OLAP cubes and the SQL database using SSRS 2005.
  • Used third party Visual Basic ActiveX DLL, OLAP Office, for querying and processing SSAS cubes.
  • Used SQL extensively by using Joins, Sub Queries, Set Operations, and Advanced OLAP Functions.
  • Implemented an OLAP database, cubes, and generated multiple reports for business decision making.
  • Drill down, Slice and Dice and Filtering operations done for all OLAP applications.
  • Designed, developed and supported OLAP relational models based on requirements from users.
  • Supported and maintained the associated OLAP cubes for a finance data mart.
  • Designed OLAP cubes with star schema and multiple partitions using SSAS.
  • Designed, developed and maintained ETL processes populating an OLAP DB.
  • Assisted in OLAP and Data Warehouse environment when assigned.
  • Generated SSRS reports utilizing relational databases and OLAP cubes.
  • Cube deployed and Processed from OLAP system in SSAS.
  • Involved in the performance tuning for the OLAP Cube.
  • Worked with DTS packages and MSOLAP Services.
  • Maintained BI/OLAP application for reporting purposes.
  • Created SQL Server Analysis Services OLAP cubes (SSAS).
  • Developed a multi-dimensional database and OLAP cube using SQL Server 2005 that stored and maintained data.
  • Designed and architected of OLAP cubes to support business reporting and forecasting processes.
  • Created OLAP cubes using Cognos Power Play Transformer.

Show More

1 Olap Jobs

No jobs at selected location

22. Complex Queries

demand arrow
average Demand
Here's how Complex Queries is used in SQL Developer jobs:
  • Designed/Developed complex queries efficiently as per the given business requirements.
  • Created complex queries involving CTE's (Common Table Expressions)/ Derived Tables, Sub-queries and Joins.
  • Analyzed and tuned complex Queries/Stored Procedures in SQL Server 2005 for faster execution and developed database structures.
  • Created database objects, stored procedures, views, tables, triggers and doing complex queries.
  • Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
  • Created stored procedures for commonly used complex queries involving join and union of multiple tables.
  • Created indexed views and appropriate indexes to reduce the running time for complex queries.
  • Worked on data partitioning and tuning of long running stored procedures and complex queries.
  • Created virtual tables using views when complex queries are involved and to build security.
  • Created and maintained indexes, and complex queries for data analysis and extraction.
  • Developed, modified, and optimized complex queries to data retrieval and modification.
  • Analyzed complex queries and tune the same to optimize application and system performance.
  • Simplified complex queries using temporary tables, table variables and stored procedures.
  • Helped out in writing complex queries by identifying the joins between tables.
  • Create stored and use complex queries for data analysis and investigations.
  • Create joins and sub-queries for complex queries involving multiple tables.
  • Write complex queries to return information for company viewing.
  • Developed complex queries using joins and sub-queries.
  • Create joins and sub-queries for complex queries involving multiple tables * Created User Defined Functions, Stored Procedures, and Triggers.
  • Created complex queries to automate data profiling process needed to define the structure of the pre staging and staging area.

Show More

7 Complex Queries Jobs

No jobs at selected location

23. Cursors

demand arrow
average Demand
Here's how Cursors is used in SQL Developer jobs:
  • Facilitated data retrieval and manipulation through implementation of Views, Procedures, Triggers and Cursors.
  • Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
  • Involved in database development by creating PL/SQL Functions, Procedures, and Packages, Cursors, Error handling and views.
  • Created and maintained database objects like complex stored procedures, Triggers, Cursors and tables, Views and SQL Joins.
  • Created complex SQL Queries, PL/SQL Stored procedures, Functions, Cursors, and Triggers for back end.
  • Created Complex Stored Procedure, Triggers, and Cursors, Tables, Views and other TSQL JOIN techniques.
  • Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
  • Identify the time taking SQL queries in Cursors and do performance tuning using Explain Plan, TKPROF.
  • Created Cursors and database triggers for maintaining complex integrity constraints and implementing the complex business rules.
  • Used Oracle Native Dynamic SQL, PL/SQL Tables, Ref Cursors and Oracle Object types extensively.
  • Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data.
  • Created Stored Procedures, Triggers, Cursors, Tables, Views and Functions for App.
  • Created stored procedures with cursors to load the data from staging to analysis tables.
  • Used Temporary Tables, Cursors and Joins to write complex T-SQL queries.
  • Developed cursors and views to improve performance in data transactions.
  • Created and modified stored- procedures, triggers, cursors.
  • Write stored procedures, triggers and cursors.
  • Create Stored Procedures with cursors.
  • Key Responsibilities: Developed T-SQL queries, triggers, functions, cursors and stored procedures.
  • Nested cursors Used CLR stored procedures for calling external web services in SQL 2005 Created reports using Crystal Reporting Service 10.0

Show More

24. Toad

demand arrow
average Demand
Here's how Toad is used in SQL Developer jobs:
  • Worked on different Data Modeling projects using Toad Data Modeler on designing Logical & Physical Database.
  • Created database objects like tables, views, procedures, packages using Oracle tools like SQL Plus, PL/SQL and TOAD.
  • Used SQL tools like TOAD, SQL Developer to run SQL queries and validate the data loaded into the target tables.
  • Used Toad and SQL Plus for testing execution of ETL Processes' PL/SQL procedures, packages for business rules.
  • Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
  • Used SQL tools like TOAD to run SQL queries and validate the data pulled in Summary reports.
  • Worked on TOAD and Oracle 10g to develop tables, stored procedures, functions in oracle database.
  • Involved in data modeling (Physical and logical models) using ERWIN and TOAD tools.
  • Used TOAD to run SQL and PL/SQL code to manipulate the Databases in all Environments.
  • Verified the source data and executed various SQL's to verify data in TOAD.
  • Created and manipulated stored procedures, functions, packages and triggers using TOAD.
  • Utilized TOAD and Unix commands to process and validate data in various databases.
  • Developed PL/SQL procedures, functions, Triggers using TOAD.
  • Extracted data from DB2 data base using TOAD.
  • Worked with Toad to validate and manipulate data.
  • Used TOAD and SQL navigator extensively.
  • Used tools like SQL Developer and TOAD to run SQL and PL/SQL queries.
  • Involve in Database, Data warehouse and backend testing using squirrel, SQL Developer and TOAD.
  • Created simple to complex ad-hoc reports using SQL Plus and TOAD for the business users.
  • Excel, Access) Environment: SQL Server 2005, T-SQL, PL/SQL, TOAD, Forms 6i and reports 6i.

Show More

25. Business Logic

demand arrow
average Demand
Here's how Business Logic is used in SQL Developer jobs:
  • Used 3-layered architecture for developing all WCF services by separating business logic, database operations and interfaces.
  • Developed EJB components stateless session/message driven beans to implement business logic.
  • Created stored procedures to apply business logic to specific procedures.
  • Developed Business Logic classes for Transaction Module using Business Services.
  • Authored stored procedures to centralize business logic.
  • Implemented Business logic using stored procedures.
  • Implemented Complex business logic with User-Defined-Functions, Index Views and also created User Defined Data type, Clustered & Non-clustered Indexes.
  • Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
  • Worked on SQL server 2012 to make changes to the existing stored procedures to handle the business logic more effectively.
  • Developed stored procedures and triggers using PL/SQL in order to calculate and update tables to implement business logic.
  • Created new Stored Procedures, functions, and database triggers according to the complex business logic.
  • Developed the business logic, migration of the database and report generation using Deal Point.
  • Created stored procedures for data access and data manipulation in the business logic layer.
  • Implemented Stored Procedures, Functions in T- SQL according to Business logic.
  • Created Triggers, Stored procedures for implementing the business logic.
  • Involved in database analysis and design and business logic modules.
  • Implemented Complex business Logic as per the client requirement.
  • Transformed the complex business logic and calculations into coding.
  • Analyzed the existing business logic and reworked on it to improve the understandability of the reports.
  • Implemented sensitive stored procedures and complex business logics with Views and Indexes.

Show More

26. Management Studio

demand arrow
average Demand
Here's how Management Studio is used in SQL Developer jobs:
  • Worked on deployment of SSIS packages on SQL management studio and created SQL Agent Jobs to schedule run of SSIS Projects.
  • Created and altered Stored Procedures, User Defined Functions, Tables, and Views using SQL Server Management Studio and T-SQL.
  • Scheduled Jobs for execution of SSIS packages through SQL Server Management Studio by adding Steps, notification, alarms and configuration.
  • Cleaned the raw data and performed Performance Tuning using Execution Plan in SQL Server Management Studio or applied stats.
  • Developed complex stored procedures, T-SQL functions, Joins, triggers and views using SQL Server Management Studio.
  • Created Design, and Architect SQL 2005 Server Management Studio Stored Procedures(TSQL) and Functions.
  • Generated reports using SQL Reporting Services, SQL Server Management Studio, and SQL Server Integration Services.
  • Performed most of the SQL Server Enterprise Manager and Management Studio functionality using T-SQL Scripts and Batches.
  • Create, enhance, and maintain scripts and reports through SQL Server Management Studio and Reporting Services
  • Created SSIS Jobs and scheduled Packages using SQL Server Management Studio for the Daily Load.
  • Used SQL Server2008 R2 Management Studio to create, edit, and test SQL scripts.
  • Performed daily tasks such as backup and restore by using SQL Server Management Studio.
  • Create and manage databases across Development and Production instances using SQL Server Management Studio.
  • Worked on SQL Server Management Studio for Database Creation, Operations and Maintenance.
  • Created complex stored procedures using SQL server management Studio.
  • Used SQL Server Management Studio and SQL Profiler for studying the SQL statements and procedures and to monitor their performance.
  • Created Sql tables, Views and store procedures that are needed for application in SQL server Management Studio 2008.
  • Performed database management, performance tuning and issue tracking by using SQL Server Management Studio and SQL Server Profiler.
  • Created Store Procedure using T-SQL to evaluate result for the repots to implement using Management Studio.
  • Designed and developed Parameterized, Dynamic and Static reports Created complex stored procedures using SQL server management Studio.

Show More

11 Management Studio Jobs

No jobs at selected location

27. Referential Integrity

demand arrow
average Demand
Here's how Referential Integrity is used in SQL Developer jobs:
  • Interpreted logical and physical data models for Business users to determine common data definitions and establish referential integrity of the system.
  • Modified existing databases by adding/removing tables there by altering referential integrity, primary key constraints and relationships according to requirements.
  • Developed Stored Procedures, functions and database triggers and maintained referential integrity and implemented complex business logic.
  • Created views to facilitate easy user interface implementation, and triggers to enforce Data and referential integrity.
  • Defined relationship between tables and enforced the referential integrity constraints.
  • Enforced Referential Integrity of data by creating different constraints.
  • Created Triggers to enforce data and referential integrity.
  • Created and managed schema objects such as tables, views, indexes, procedures, and triggers and maintained Referential Integrity.
  • Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
  • Developed, tested and implemented Referential Integrity rules and regulations through constraints, triggers and views, partitioned views.
  • Defined Check constraints, Indexes, Views, Created Triggers to enforce data and referential integrity.
  • Modified existing database by adding Tables, altering Referential Integrity and Relationships to support the system.
  • Check referential integrity of the database by writing database triggers in T-SQL.
  • Created Triggers to maintain audit log and also to maintain referential integrity.
  • Created Indexes and Triggers to maintain data referential integrity using T-SQL.
  • Implemented strong referential integrity and auditing with the use of triggers.
  • Normalized and De-normalized tables and maintained Referential Integrity by using Triggers and Primary and Foreign Keys.
  • Created new SQL scripts/TSQL for the data validation/datatype checks/referential integrity checks/rollback scripts etc.
  • Created Triggers to enforce data and referential integrity Actively designed the database to fasten certain daily jobs, stored procedures.
  • Developed tables and relationship among tables by applying Normalization, Referential Integrity, Constraints and Cardinality in RDBMS.

Show More

28. Oltp

demand arrow
average Demand
Here's how Oltp is used in SQL Developer jobs:
  • Designed and developed both OLTP/OLAP relational models based on user requirements and application needs.
  • Studied the existing OLTP system (s) and Created facts, dimensions and star schema representation for the data warehouse.
  • Optimized the embedded SQL queries using statement level optimizer hints when essential, to adhere to the defined OLTP response time.
  • Generated Dashboards from OLTP and OLAP data sources using SQL Server Reporting Services 2012, Performance Point and Tableau.
  • Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
  • Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages.
  • Project involved maintenance of existing OLTP databases as well as designing SSIS packages for custom warehousing needs.
  • Worked with OLTP, OLAP, Data Warehouse application, star schema and snowflakes schema dimensions.
  • Project Description: Improved the existing OLTP database according to changes in the business process.
  • Designed a schema for OLTP database using Erwin and created in Microsoft SQL Server 2005.
  • Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.
  • Generated reports using SQL Server reporting Services 2005 from OLTP databases.
  • Created package to transfer data between OLTP and OLAP databases.
  • Worked on OLTP systems and implemented Normalization on Databases.
  • Designed and optimized of OLTP, OLAP tools.
  • Forward Engineered OLTP Database to SQL 2008 Server.
  • Used Transactions on OLTP Databases.
  • Created SSIS packages to transfer data between OLTP and OLAP databases Wrote distributed queries to extract data from different servers.
  • Created SQL scripts to pull OLTP data from different Informix servers into the staging database.
  • Created T-SQL scripts for OLTP and ETL application development on SQL server and Teradata.

Show More

14 Oltp Jobs

No jobs at selected location

29. Wizard

demand arrow
average Demand
Here's how Wizard is used in SQL Developer jobs:
  • Deployed Business Objects Universes and Reports in a Secure Environment from One Server to Other Servers using Import Wizard.
  • Migrate existing Java API Service to develop IVR API Service Application based on Drop Wizard Java Service Framework;.
  • Created Dimensions with the cube wizard and also individually and Generated Named calculations and named queries.
  • Performed optimization of indexes and queries by using index tuning wizard to enhance the performance.
  • Increased Stored Procedures performance using SQL Server Traces, Index Tuning Wizards and Executions plans.
  • Extracted data from Oracle DB using Import Export Wizard in SQL Server Management Studio.
  • Report wizard is used for getting combined reports of different samples under same test.
  • Created DTS Packages for transferring the data using IMPORT and EXPORT wizard.
  • Converted the DTS Packages into SSIS using Migration Wizards.
  • Created copies of operational Databases using the Import/Export Wizard.
  • Used Deployment wizard for Deploying the Reports.
  • Developed different types of reports such as ad-hoc reports, matrix reports, tabular reports using report wizard in SSRS.
  • Conducted performance tuning of complex SQL queries and stored procedures by using SQL Profiler and index tuning wizard.
  • Involved in tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
  • Used tools like SQL profiler, index tuning wizard for tuning the performance of the database.
  • Used SQL Profiler and Index Tuning Wizard for tracing slow running queries and stored procedures.
  • Performed the query and database optimization using Profiler and Index tuning Wizard.
  • Created adhoc reports using Import and Export Wizard.
  • Experience in SQL Optimizing by using SQL Profiler, Index Tuning Wizard, and Database Tuning Advisor.
  • Used Performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.

Show More

30. Text

demand arrow
low Demand
Here's how Text is used in SQL Developer jobs:
  • Created SSIS packages to load the data from Text File to staging server and then from staging server to Data warehouse.
  • Created For each loop to iterate through a number of suppliers having multiple text files to be loaded to the database.
  • Designed and developed SSIS Packages for loading data from text files, CSV files to SQL Server databases using SSIS.
  • Imported and Exported data from text files and excel spread sheets into SQL Server 2008 database using SSIS package.
  • Created DTS package to export and import data from SQL Server to Access, text and EXCEL files.
  • Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
  • Developed SSIS packages to format the incoming text files and to further develop the monthly statement files.
  • Resolved loops, Chasm and fan traps by creating Aliases and Contexts and checked integrity of universe.
  • Created Data migration utilities (Import & Export, Bulk Insert) from text to SQL Server.
  • Developed various dashboards, used Context filters, Sets while dealing with huge volume of data.
  • TRIM Context manager, which is the document management system used by the Navy.
  • Created SSIS packages to Export data from text file to SQL Server Database.
  • Created SSIS Packages to integrate data coming from Text files and Excel files.
  • Designed a standard to use alias and contexts as per report requirement.
  • Implemented Full Text Search Index to give better performance in searching.
  • Resolved loops using contexts, aliases and integrity check.
  • Created additional contexts, new dimension and measure objects.
  • Resolved loops by creating Aliases and Context.
  • Developed Excel/VBA customer reference formatter macro that generates itself over customer provided text document as feed.
  • Created SSIS package for reading the Rentrak data from text files and loading them to base tables.

Show More

31. Column

demand arrow
low Demand
Here's how Column is used in SQL Developer jobs:
  • Removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever required.
  • Optimized the query performance with modification in T-SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing
  • Conducted data cleansing to remove unnecessary columns, eliminate redundant and inconsistent data with SSIS transformations.
  • Improved performance by adding indexes, removing unnecessary columns in the inner views and adding conditions to get only required data.
  • Created and used Table Partitions to further improve the performance while using tables containing large number of columns and rows.
  • Created several graphical reports for the sales team using the pie charts, column charts etc based on requirement.
  • Optimized the T-SQL query performance with modifications in T-SQL queries, removing unnecessary columns, establishing necessary joins.
  • Created Views to reduce apparent database complexity for end users and preventing sensitive columns from being selected.
  • Identify columns for Primary Keys in all the tables at the design time and create them.
  • Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
  • Created derived columns on the final fact and dimension tables as per the business requirements.
  • Designed Charts with Lines, Bar Graphs and Columns to generate reports with cumulative totals.
  • Used Conditional split, Derived column and Data Conversion task for cleaning the data.
  • Created indexes on some columns of tables to increase the application's performance.
  • Created derived columns from the present columns for the given requirements.
  • Created pointers as column-values to reference external-files from oracle tables.
  • Experience in aligning columns to right or left.
  • Maintain referential integrity, domain integrity and column integrity by using the available options such as constraintsetc.
  • Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
  • Created and designed ERD to the proposed database of timesheet management, and identified columns for primary keys.

Show More

1 Column Jobs

No jobs at selected location

32. Sharepoint

demand arrow
low Demand
Here's how Sharepoint is used in SQL Developer jobs:
  • Developed a system named PPA Automation system which interfaced between SharePoint server and database.
  • Created InfoPath reports that persisted data into SQL Server and/or SharePoint list(s) via WCF written in C#.
  • Configured report server and deployed reports on web server and SharePoint, built Performance Points Dashboards in SharePoint 2010.
  • Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
  • Used SharePoint (Windows) to keep all the project related files and object installation list for deployment.
  • Collaborated with the Operational business units to assess, design and maintain online reference materials on SharePoint.
  • Migrated wiki pages, documents, forms, SSRS reports from SharePoint 2007 to SharePoint 2010.
  • Created and customized SharePoint KPI lists and WebPages for key business metrics using SharePoint designer.
  • Developed Sites, Team Sites, Views, Alerts and Lists in SharePoint 2010.
  • Created a Report Server Database and deployed the generated reports using SharePoint.
  • Provided DBA assistance in SharePoint 2007 to SharePoint 2010 conversion.
  • Converted Lotus Notes data into a SharePoint List library.
  • Published dashboards on an intranet site using SharePoint Server.
  • Worked with SharePoint Server 2007 while deploying SSRS reports.
  • Created web parts using C# for SharePoint.
  • Manage BI Portals in SharePoint.
  • Supported two Microsoft sharepoint developers with database encapsulation.
  • Created Reports, Report model Definitions, Scorecards, KPIs, and Dashboards utilizing Performance Point Server 2007/SharePoint Server.
  • Migrated and resolved conversion errors for Performance Point Server reports to Sharepoint 2010 Business Intelligence platform.
  • Created Report Models for building Ad hoc reports using SSRS and deployed reports into SharePoint.

Show More

33. Test Cases

demand arrow
low Demand
Here's how Test Cases is used in SQL Developer jobs:
  • Developed Test cases/scenarios with concerned users and obtaining necessary sign offs.
  • Created unit test cases and technical documentation, performed detailed code reviews, and created automated build and deployment scripts.
  • Involved in test cases preparation, mapping them with the requirements, test execution, validation and documentation.
  • Performed Unit, System Testing and created several Test Cases to validate the data from reports.
  • Involved in manual testing of the product and writing test cases for improving the product efficiency.
  • Worked on the analysis of test cases with the team members and make the necessary changes.
  • Worked with Quality assurance to develop test plans and test cases to conduct system testing.
  • Helped end users to design test cases and worked through multiple UAT cycles.
  • Involved in writing the ETL specifications, Test cases and Test Scripts.
  • Involved in identifying and prioritizing the Test Cases to be automated.
  • Prepared the Test cases and test plan to test the application.
  • Created Documentation of development code and the test cases involved.
  • Involved in preparing Unit test cases Requirements for the project.
  • Write and execute automation test cases developed in python.
  • Created test cases and documented each delivery module.
  • Created Test Cases and Technical Design Documents.
  • Designed and developed test cases.
  • Created and performed the Unit and Integrity test cases and assisted the testing team in System Test and Production move process.
  • Used Selenium IDE for web testing Executing Selenium Test cases and reporting defects.
  • Prepared Test Cases, Test Plans for de-commissioning the applications.

Show More

34. Lookup

demand arrow
low Demand
Here's how Lookup is used in SQL Developer jobs:
  • Worked extensively with Slowly Changing Dimension and lookup Transformation for implementing Inserts and Updates.
  • Created data mapping using Derived Column, Data Conversion, Lookup Transformation, Script Component, Conditional Split, among others.
  • Developed SSIS Packages (Lookup, Conditional Split) and T-SQL (Merge) for enhancing the performance of SCD concepts.
  • Implemented different built in transformations tasks including SCD, Aggregate, Lookups and Data Conversion to implement complete ETL strategy.
  • Used different transformations like lookup, condition split, and row count Transformation, Derived Column, Data Conversion etc.
  • Generated surrogate keys in the ODS for a more efficient lookup in reference to the legacy system keys.
  • Used different transformations like Conditional Split, Lookup, Merge Join, Aggregate, Fuzzy Grouping etc.
  • Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
  • Used multiple transformations including Fuzzy lookups and Fuzzy grouping in the data cleansing process.
  • Used Fuzzy group, Fuzzy lookup tasks to eliminate duplicate rows in SSIS packages.
  • Implemented Email tasks, For-loop and Lookup tasks to existing SSIS packages.
  • Used Lookups Transformation to get the data from reference data sets.
  • Created various mapping like Joiner, Lookup, Update Strategy.
  • Created lookup tables to translate the values to current system.
  • Transformed data using Derived Column, Lookups and Conditional split.
  • Used different transformations like Lookup, merge join, derived column, data conversion, union all and multi cast.
  • Filtered bad data from the legacy system utilizing derived columns, lookups, fuzzy lookups, and conditional splits.
  • Performed Data Cleansing using several Transformations like Derived Column, Data Conversion, Lookup, Fuzzy Lookup etc.
  • Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups.
  • Implemented the Data Cleansing using various transformations such as Lookup, Fuzzy Lookup and Derived Column.

Show More

35. DDL

demand arrow
low Demand
Here's how DDL is used in SQL Developer jobs:
  • Designed and implemented integrity constraints, written triggers and stored procedures to offload middle-tier transactions.
  • Developed the C# code for implementing business logic in middle tier in 3-tier application interacting with SQL Server database.
  • Used DDL to define indexes (keys), specifies links between tables, and imposes constraints between tables.
  • Analyze stored procedure-based business logic in order to document and propose solutions for migrating to the middle tier.
  • Project Description: Enterprise Service Platform provides a complete middle and back office solution to State Street clients.
  • Created database objects like tables, user defined functions and cursors using DDL, DML statements.
  • Developed DDL Scripts for generating Tables, Views, and Functions in SQL Server 2005.
  • Developed physical data models and create DDL scripts to create database schema and database objects.
  • Designed and implemented Stored Procedures and Triggers (DDL & DML) for automating tasks.
  • Experienced in developing T-SQL (DDL, DML) statements using dynamically generated SQL.
  • Implemented many stored procedures using DDL commands (Create, Alter, Drop).
  • Developed and optimized database structures, stored procedures, DDL triggers and user-defined functions.
  • Used fiddler tool to debug web applications by capturing network traffic.
  • Used J2EE design patterns for the middle tier development.
  • Create DDL scripts for implementing Data Modeling changes.
  • Design and execution of DDL Scripts Perform Unit Test and Integration Test.
  • Convert Automate middleware into SSIS packages.
  • Generate reports with SSRS, Crystal Report or T-SQL Write store procedure, function, create view and DML, DDL.
  • Created type libraries from existing C# Dlls and these dlls are consumed in the middle tier Architecture.
  • Project: Retail Middleware Implementation Client Shell Petroleum Ltd. Organization Wipro Technologies Ltd.

Show More

36. Data Analysis

demand arrow
low Demand
Here's how Data Analysis is used in SQL Developer jobs:
  • Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.
  • Performed extensive database activities such as data modeling, database design, data analysis, validation and consistency check.
  • Perform data analysis on structured and unstructured data sets to identify structure and normalization for transformation into data warehouse.
  • Report on data analysis findings regularly to a cross-functional Engineering/Support teams and present approaches to achieving quality objectives.
  • Performed Data Analysis for automating various Customers Order Reports utilizing SQL Reporting Services.
  • Performed data mining and data analysis to generate reports.
  • Executed data analysis using appropriate tools and techniques.
  • Performed data analysis to validate data warehouse changes.
  • Project Scope: The project deals with data analysis of application of the Wealth Management Group at Capital One.
  • Extract the data from database and provide data analysis using SQL to the business user based on the requirements.
  • Use technical tools from MS Visual Studio 10 and 12 for research, trouble shooting and data analysis.
  • Created data import/export routines using Microsoft SQL and Data Junction, a data analysis and conversion tool.
  • Created test data to perform QA data analysis in determining fix as pass or fail solution.
  • Experienced in data analysis, data modeling, development, testing and documentation of projects.
  • Designed Report Templates, Bar Graphs and Pie Charts in Crystal Reports for data analysis.
  • Enhanced data analysis migrating MS Access databases and processes to an M S SQL Server.
  • Perform data analysis for data integrity, perform data cleansing & normalization of data.
  • Used various excel functions to perform data analysis.
  • Developed macros for re-usability, Missing-data imputation, data analysis, statistical analysis, reporting and summarization.
  • Accessed Sybase SQL Server in generating Transact-SQL in performing data analysis.

Show More

6 Data Analysis Jobs

No jobs at selected location

37. BI

demand arrow
low Demand
Here's how BI is used in SQL Developer jobs:
  • Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
  • Designed and developed a Generic Billing system for a Telecommunication company.
  • Optimized SQL queries for improved performance and availability.
  • Monitor the overall Raptors availability.
  • Implemented transformation mapping through BizTalk server with the help of Visual Studio to achieve data transformation from one type to another.
  • Experience in conducting JAD sessions in order to understand the feasibility of the requirement in presence of the entire team.
  • Created reports using SSRS from OLTP and OLAP data sources and deployed on Report Server using SSRS and Power BI.
  • Define audits and charging verification activities on IN, Billing (charging/billing system), Roaming, and mediation.
  • Implemented capabilities with the extensive use of Oracle tools, SQL and Oracle Stored Procedures.
  • Assisted in the design and development of dashboards, reports, and other BI metrics.
  • Developed custom reports using SQL Server Reporting Services (SSRS)/SQL Server BI studio.
  • Created Cubes in BIDS ensuring Attributes Relationships and deployed into SQL Server Analysis Engine.
  • Retrieve and modify data using SQL Server2008 and BIDS from different database.
  • Used Power query and Power view extensively for mobile data improvements.
  • Used pipelined functions for faster data accessibility.
  • Combined storedprocedures to perform particular tasks.
  • Process involves data entry and verification of Payments, Commissions, Journal Entry, Unpaid Bills verifications.
  • Worked with team members to build a layered Knockout.js binding system to support partial views.
  • Monitored Vizql and SQL Server activity to track performance and system stability.
  • Experienced in creating security setup in Cognos 8 BI environment.

Show More

13 BI Jobs

No jobs at selected location

38. R2

demand arrow
low Demand
Here's how R2 is used in SQL Developer jobs:
  • Created a SSRS report with sqlserver2012 procedure to perform a table/column data comparison to identify diffs between previous and current tables.
  • Extracted data from SQL Server 2008R2 database tables and Oracle database tables into flat data files and Excel sheet.
  • Involved in Staging Partitions and Usage Based Optimization (UBO) mechanisms for SSAS 2005R2 and 2008 OLAP databases.
  • Used SQL Server 2008R2/2012 Reporting Services (SSRS) for generating reports which resulted in efficient decision making.
  • Perform T-SQL tuning and optimizing queries for Reports which take longer time in execution SQL Server 2008R2.
  • Migrated SQL server 2005 to SQL Server 2008 in Microsoft Windows Server 2003 R2 Enterprise Edition SP2.
  • Interacted with application team at the time database migration from SQL Server2005 to SQL Server 2008.
  • Designed, developed and deployed reports in MS SQL Server environment using SSRS 2008 R2.
  • Peer to peer replication setup with 2 nodes topology on SQL server 2008R2.
  • Created Linked Servers between SQL Server 2008 R2 & Oracle 9i.
  • Installed and Configured of SQL Server 2008 and SQL Server 2008R2.
  • Migrated SQL Server 2000 to 2005, SQL Server 2005 to 2008 R2 and DTS to SSIS (ETL).
  • Developed applications using SQL Server 2008 R2, TSQL, SSRS, DB2, Rapid SQL and Crystal Reports.
  • Worked on MS SQL Server 2008-R2 and also on Visual Studio 2008(SSIS/SSAS/SSRS).
  • Developed SSIS packages and SSRS reports in SQL Server 2008/ 2008 R2/2012.
  • Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.
  • Used ADO.Net for database connectivity, storage and retrieval on SQL Server 2008R2.
  • Created SQLServer 2008 R2 procedures as the record source.
  • Maintain stored procedures, DTS and SSIS processes (SQL Server 2000 2008R2).
  • Log shipping configuration on sql server 2005 and sql server 2008R2.

Show More

39. Javascript

demand arrow
low Demand
Here's how Javascript is used in SQL Developer jobs:
  • Developed client and server side validation for the application using JavaScript and Validation controls.
  • Developed Date Time Picker using Object Oriented JavaScript extensively.
  • Created JavaScript Methods for various front-end custom/form/user data validations.
  • Developed the UI using JavaScript, JSP, HTML, and CSS for interactive cross browser functionality and complex user interface.
  • Involved in developing HTML and JavaScript for client side presentation and data validation on the client side with in the forms.
  • Designed dynamic client-side JavaScript codes to build web forms and simulate process for web application, page navigation and form validation.
  • Developed and maintained in-house web-based system for processing and billing warehouse items using PHP, JavaScript and SQL.
  • Implemented reports and report request forms for use on the Web using ASP, ADO, and JavaScript.
  • Utilized JavaScript and CSS to design and develop the front end of web applications and portals.
  • Developed several templates for websites by hand coding of HTML, XHTML, CSS and JavaScript.
  • Build user interface using JSP and JavaScript.
  • Developed prototype screens using HTML and JavaScript.
  • Used JavaScript for client-side validations.
  • Developed webpages with client side scripting using JavaScript.
  • Utilize Jquery and JavaScript to manipulate forms.
  • Worked with front end technologies like Html, CSS and Javascript.
  • Used Grunt and scss to create modular JavaScript and css.
  • Used jquery and javascript for better user interactive experience.
  • Implemented server-side validations using .Net validation controls and client-side validations using javascript.
  • Developed the view-controller components using Servlets/JSPs, JSF, JavaScript (JQuery).

Show More

3 Javascript Jobs

No jobs at selected location

40. Data Integrity

demand arrow
low Demand
Here's how Data Integrity is used in SQL Developer jobs:
  • Implemented various integrity constraints for data integrity like Referential integrity using primary key and foreign key relationships.
  • Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
  • Worked on File integrity validation, Data integrity validation and Data quality analysis.
  • Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
  • Tested applications for performance, data integrity and validation issues.
  • Defined Tables and implemented Data Integrity using Constraints.
  • Maintained security and data integrity of the database.
  • Maintained data integrity by performing validation checks.
  • Experience in writing T-SQL scripts, dynamic SQL, Constraints, relational database models, data dictionary and data integrity.
  • Created new indexes for better performance of the database, and maintained data integrity by using foreign key relationship.
  • Reviewed code from Vietnam team and helped DBA team to promote in all environments to keep the data integrity.
  • Worked on adding more data integrity check to the existing database and for the newly added SQL objects.
  • Understand the incoming data format and validate the checks on various fields to ensure data integrity.
  • Work with customers to enforce quality control of all reports and data integrity.
  • Verify, enhance, and enforce production data integrity.
  • Created checks and constraints to maintain data integrity.
  • Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
  • Considered Security for activity logging, historical data sets restrictions on intermodule communications data integrity checks.
  • Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.
  • Developed T-SQL Backend for data integrity check application for website to assess whether monthly updates are captured as expected.

Show More

2 Data Integrity Jobs

No jobs at selected location

41. DML

demand arrow
low Demand
Here's how DML is used in SQL Developer jobs:
  • Created database objects like tables, indexed views, indexes, stored-procedures, triggers and cursors using DDL, DML statements.
  • Created database to collect data that were entered in the form, Created index, function and stored procedures DML.
  • Worked with T-SQL, DBCC, DCL, DDL, DML Scripts and established relationships between tables using Constraints.
  • Generated DML/DDL scripts for creation of database objects like tables, views, functions, triggers, stored procedures.
  • Used Data Modification Language (DML) to insert and update data, satisfying the referential integrity constraints.
  • Used DDL and DML to writing triggers, stored procedure to check the data entry and payment verification.
  • Experience in creating and running complex queries that include DDL and DML statements, joins, sub-queries.
  • Created the Tables, Views, Stored Procedures, Triggers and generated DDL and DML scripts.
  • Created database objects like tables, functions, stored procedures using DDL and DML queries.
  • Used DDL and DML for writing triggers, stored procedures, and data manipulation.
  • Created/Modified Stored Procedures, Views, DML, DDL Triggers and Cursors per requirements.
  • Created User defined Functions, Stored Procedures and Triggers using DML and DDL.
  • Produced DDL and DML for implementing physical data structures on the database.
  • Created DML Triggers on Tables / Views to accomplish business needs.
  • Perform DML, DDL Operations as per the Business requirement.
  • Maintained the DML & DDL Scripts and Data Dictionary.
  • Worked on various DDL, DML, and DCL (TCL, ACL) statements.
  • Designed DDL and DML for MS SQL Server 2008.
  • Designed DDL and DML for MS SQL Server Created and managed schema objects such as Tables, Views, and Indexes.
  • Involved in preparing and executing SQL code deployments (DDL/DML) with application rollout teams into QA/Production environments.

Show More

42. TFS

demand arrow
low Demand
Here's how TFS is used in SQL Developer jobs:
  • Collaborated through Team Foundation Server (TFS) as version control tool to distribute and communicate data across cross functional teams.
  • Master of my own SCRUM environment infrastructure and reports team, for preparation of bi-weekly sprint meetings using TFS and SalesForce.com.
  • Merged and updated files using Visual Source Safe (VSS) and Visual Studio Team Foundation Server (TFS).
  • Collaborated with TFS (Team Foundation Server) to work with cross functional team environment including on-shore and off-shore.
  • Implemented Software Configuration Management, setting up company Version policies utilizing Team Foundation Server (TFS).
  • Create and maintain SSRS reports for all clients and employees within using FogBugz/TFS ticketing system.
  • Source control for solutions and T-SQL scripts using Team Foundation Server (TFS).
  • Collaborated with team members on project updates by checking-in and checking-out on TFS.
  • Used Team foundation server (TFS) as a source control.
  • Experience in working with Team Foundation Server (TFS).
  • Worked under Team Foundation Server (TFS).
  • Used TFS for source and document version control.
  • Involved in code management activity using TFS.
  • Used TFS for version control.
  • Experience in migration of parts from Visual source safe (VSS) 2005 to Team foundation server (TFS) 2010.
  • Used Team Foundation Server (TFS) for the version control of the SQL Scripts.
  • Used TFS for Version Control, Code Release MS Build.
  • Worked with TFS - source control.
  • Worked on Team Foundation Server (TFS) to coordinate with the development team on the deliverables and for Version Control.
  • Used Team Foundation Server (TFS) for central repository as a versioning control.

Show More

1 TFS Jobs

No jobs at selected location

43. Multiple Tables

demand arrow
low Demand
Here's how Multiple Tables is used in SQL Developer jobs:
  • Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
  • Write complex SQL queries including joins, sub queries, aggregate functions for faster data retrieval from multiple tables.
  • Used Joins, sub-queries, Stored Procedures and Indexes for complex queries involving multiple tables from different databases.
  • Created Sequence in SQL Server to insert same identity value in multiple tables as per the business rules.
  • Added Indexes to improve performance on tables and used multiple join statements to retrieve data from multiple tables.
  • Experienced in writing T-SQL queries involving multiple tables, inner and outer joins, and stored procedures.
  • Developed SQL queries to fetch complex data from multiple tables on remote databases utilizing linked servers.
  • Imported and created relation between different data sources and between multiple tables using Pivot table.
  • Create joins and sub-queries for complex queries involving multiple tables to retrieve the output faster.
  • Created Indexes based on the query selection and the Joining Conditions between Multiple Tables.
  • Experience in writing complex SQL queries involving multiple tables inner and outer joins.
  • Used different types of Joins to combine multiple tables and retrieved data.
  • Used joins and sub queries to simplify complex queries involving multiple tables.
  • Designed SQL queries involving multiple tables using inner and outer joins.
  • Used multiple join statements to retrieve data from multiple tables.
  • Utilized complex queries to track test data across multiple tables.
  • Loaded data into multiple tables using SQL Loader.
  • Created views on multiple tables.
  • Created Views, Materialized Views to get the values dynamically using joins and other sql queries from the multiple tables.
  • Used Joins to combine multiple tables and use as dataset to create reports in SSRS.

Show More

44. MDX

demand arrow
low Demand
Here's how MDX is used in SQL Developer jobs:
  • Created several cubes in SSAS and build lot of MDX queries to query cubes and to access cube's data.
  • Planned and designed SSAS 2012 Cubes and built attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
  • Managed and maintained stored procedures and standard reports; built reports from Analysis Services cube using MDX query designer.
  • Involved in writing MDX queries and performance optimization of the SSAS cubes for calculated members and measure groups.
  • Worked on MDX query, name calculation, KPI, expressions and mining algorithm for OLAP cubes.
  • Worked on creating calculated measures that fits business logic, using MDX queries.
  • Involved in the design and development of the SSAS cubes and MDX queries.
  • Implemented changes and thus improve performance for the existing cube using MDX functions.
  • Created OLAP Cubes in SQL Server 2000 Analysis Services and MDX queries.
  • Created Key performance Indicators (KPI's) using MDX queries.
  • Developed MDX Queries against SSAS cubes to generate reports.
  • Involved in writing MDX queries for various calculated members.
  • Generated a multitude of reports from cubes utilizing MDX.
  • Created reports from complex SQL queries and MDX queries.
  • Worked on SSRS reports and fine-tuned SSRS MDX queries Designed reports on the monitoring of SQL Server Performance.
  • Created reports to retrieve data using Stored Procedures, MDX Queries that accept parameters.
  • Developed MDX queries for use in .NET UI scripts for client web page development.
  • Created calculated measures and dimension members using multi-dimensional expression (MDX).
  • Created reports by dragging data from cube and wrote mdx scripts.
  • Worked on pre-defined facets included by SQL SERVER Created calculated measures and dimension members using multi-dimensional expression (MDX).

Show More

45. BCP

demand arrow
low Demand
Here's how BCP is used in SQL Developer jobs:
  • Automated scripts in T-SQL, DTS, and BCP to import data from various ODBC sources into production SQL Server databases.
  • Exported and imported data from text files and Excel to SQL Server database using bulk insert and BCP utility.
  • Used Import/Export utility and BCP utility to load test data from SQL Server 2005 to SQL Server 2005.
  • Developed Stored Procedures for the BCP of the data from the client database in the requested format.
  • Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.
  • Created Data Transformation tasks like BCP, BULK INSERT to import/export data from clients.
  • Work on DTS, Import and Export utility, BCP Utility and replication tool.
  • Worked extensively on BCP utilities for bulk data & image file uploading.
  • Have used BCP to transfer data from and to SQL server database.
  • Import data across multiple instances using BULK INSERT and BCP Utility.
  • Migrated databases among the servers using BCP, attach/detach utilities.
  • Used BCP utility to publish table output to text files.
  • Involved in data transfers between various servers using BCP.
  • Performed data transfers using BCP and BULK INSERT utilities.
  • Loaded data using BCP utility.
  • Transfer data from flat files, Excel spreadsheets to and from SQL Server using DTS, BCP and Bulk Insert.
  • Used the BCP to load the large volumes of data from files into tables.
  • Used BCP utility to publish table output to text files Implemented the SQL translation handling mechanism for data consistency.
  • Accomplished this by incorporating BCP, DDL and DML on Sybase.
  • Created and scheduled SQL Server jobs for data import from Sybase 11 Created and executed BCP utility for data import/export.

Show More

46. User Acceptance

demand arrow
low Demand
Here's how User Acceptance is used in SQL Developer jobs:
  • Migrated oracle database with new implementation scripts to the user acceptance testing environment.
  • Configured Snapshot replication for reporting, user acceptance test and development servers.
  • Detected and Corrected bugs during system integration and user acceptance testing.
  • Administer and Monitor the database using SQL server enterprise manager in System Integrated Testing, User Acceptance Testing and Pilot databases.
  • Performed unit testing, system testing and user acceptances test (UAT) for universe, reports and security management.
  • Worked in the development, User Acceptance Testing (UAT) and Production Servers in CCP Verizon.
  • Prepared Test Data and set up Test Environment for Integration, System and User Acceptance testing.
  • Attended functional testing and user acceptance sessions and worked on the feedback provided by them.
  • Involved with Users in designing the User Acceptance testing (UAT) documents and scripts.
  • Worked with Business end users as UAT Coordinator during User Acceptance/End to End Testing.
  • Provided the technical support to the business users for executing the user acceptance testing.
  • Participate in User Acceptance Testing (UAT) on behalf of QA team.
  • Performed System testing, integration, regression testing and User acceptance testing.
  • Developed user test cases and validated test results during user acceptance testing.
  • Involved Integration testing and UAT - user acceptance testing.
  • Participated in User Acceptance Testing for different modules.
  • Created test plan for User Acceptance Testing.
  • Involved in User acceptance testing.
  • Performed User Acceptance Testing Interacting with client in case they find any difficulties or any issues in the export.
  • Monitor SQL SERVER in System Integrated Testing, User Acceptance Testing, Pilot Enviroments for Performance issues.

Show More

47. VB

demand arrow
low Demand
Here's how VB is used in SQL Developer jobs:
  • Modified dating calculations and added design features for easier presentation of payroll information using VBA.
  • Created test cases and did basic manual testing Environment VB6.0, ADO, SQL Server 2000, MS Access, Crystal Report
  • Used VB.NET to develop code behind logic, business tier and SQL Server 2005 for data tier.
  • Imported and exported data into MS Access databases and Debugged VBA scripts linked to said databases.
  • Designed VB forms using the forms and crystal reports were made for business reporting purpose.
  • Net and VB.NET to develop different modules of the end-user interfaces and different SSIS packages.
  • Perform ETL operations for Business Intelligence reporting solutions using custom VBA and Excel web queries.
  • Worked with Visual basic for access the database using data access objects, VB script.
  • Created simple program to track employee company assets in vb.net with SQL back end.
  • Modify and automate VBA macro code through c# to generate tax forms.
  • Automated reports using VBA Macros to tune the performance of report generation.
  • Developed user interfaces using Visual Studio (C# and VB.NET).
  • Designed and validated the Forms according to client requirement by using VB.
  • Report interface via Excel spreadsheet-VBA development, Pivot tables.
  • Developed various applications using MS Access and MS Excel, using DAO, VBA, ADO, ODBC.
  • Developed User Interface using Excel Forms and VBA Macros Involved in Preparing Process/design documents, Data Model and Requirement documents.
  • Developed Automated Reports using Office 2007 VBA with MS Access/Excel Utilized MS Office 2007 for basic job functions.
  • Created VB.Net Script for Data Flow and Error Handling using Script component in SSIS.
  • Programmed in VB.NET Physical design and implementation SQL Server databases.
  • Design and develop Windows Forms using VB.Net, SQL Server 2000 and Infragistics.

Show More

3 VB Jobs

No jobs at selected location

48. Pl/Sql

demand arrow
low Demand
Here's how Pl/Sql is used in SQL Developer jobs:
  • Designed and developed complex procedures to handle errors and exceptions at both application and database level using PL/SQL and shell scripts.
  • Developed user interface Forms, Reports, PL/SQL Packages, Procedures, Functions and Database Triggers to meet the business requirements.
  • Used PL/SQL back-end programming - Database Triggers, Packages, Stored Procedures, Functions, and Management of Schema Objects.
  • Developed PL/SQL-Packages, Procedures, Functions, SQL Scripts and Database Triggers to populate the historic data.
  • Identified duplicate data entries in database using Oracle PL/SQL queries which involved figuring out alphanumeric ranges.
  • Executed SQL commands, wrote PL/SQL commands, Stored Procedures for the existing intranet applications.
  • Created SQL tables with referential integrity and developed queries using SQL, SQL*PLUS and PL/SQL.
  • Developed and maintain PL/SQL (triggers, store procedures, functions, packages).
  • Developed PL/SQL triggers and master tables for automatic creation of primary keys.
  • Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
  • Developed packages, procedures, functions and PL/SQL blocks for data validation.
  • Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
  • Developed PL/SQL procedures to update the database and to perform calculations.
  • Develop, run and schedule queries using SQL and PL/SQL scripts.
  • Developed PL/SQL scripts to validate and load data into interface tables.
  • Used PL/SQL extensively for writing Functions and Database Triggers.
  • Optimized PL/SQL and SQL queries for better performance.
  • Created PL/SQL stored procedures, and functions.
  • Hand on experience on Oracle database wrote PL/SQL Packages, Store procedure, functions to manipulate data.
  • Developed PL/SQL stored procedures, functions and packages for moving the data from staging area to datamart.

Show More

49. Production Environment

demand arrow
low Demand
Here's how Production Environment is used in SQL Developer jobs:
  • Designed and developed SSIS packages to move data from production environment to different environments within the organization.
  • Provided support for database backup/restore and database transfer activity from test environment to production environment.
  • Managed and maintained reports and subscription on production environment using Report manager.
  • Deployed database objects from development/testing environment to production environment.
  • Monitored and scheduled existing/new jobs on production environment.
  • Migrated and replicated production environment onto development environment.
  • Assisted in database design, creation of ER diagrams, phasing from development to QA and to production environment.
  • Supported Production Environment with schedule the packages and make the package dynamic with SQL Server Package Configuration.
  • Tested backup and recovery strategies in a test environment before and after moved to production environment.
  • Promoted SSIS Packages from Test Environment to Production Environment by maintaining multiple package configurations in SSIS.
  • Create Functions and Views using T-SQL in Development and Production environment for SQL Server 2008/2005.
  • Design, development and deployment of Vendor Interfaces for load testing and in production environment.
  • Used XML configurations in SSIS packages to deploy them into DEV/ Testing/ Production environments.
  • Test and prepare ETL processes for deployment to production and non-production environments.
  • Developed complex T-SQL queries to migrate data from staging to production environment.
  • Managed SQL Server 2012 in development, test and Production environment.
  • Deployed database solutions to QA and production environments.
  • Modeled Visio diagrams to track and implement blueprint of ETL processes from Initial phase, Ongoing, Deployment to Production Environment.
  • Used Performance Point Server 2007 Responsible for maintaining UAT (User Acceptance Testing) and Production environment.
  • Involved in debugging weblogic stuck threads and other runtime issues in the testing and production environments.

Show More

50. Informatica

demand arrow
low Demand
Here's how Informatica is used in SQL Developer jobs:
  • Created various reusable transformations in designer such as Slowly Changing Dimensions using Informatica Power Center Transformation Developer.
  • Developed complex mappings and involved in Performance Tuning both in informatica and database level.
  • Worked on various projects involving Data warehousing using Informatica Power Center.
  • Created Informatica Technical and mapping specification documents according to Business standards.
  • Reported debugging using informatica and tracked defects using Quality Canter.
  • Designed and developed initial and incremental data loads using Informatica.
  • Designed and Created data cleansing, validation and loading scripts for Oracle data warehouse using Informatica Power Center 8.6.1.
  • Leveraged Informatica to extract data from heterogeneous source systems and aggregate the data and load into the target warehouse.
  • Worked on UNIX machine on which Informatica Server was installed to check for the session logs.
  • Created and Scheduled Sessions and Batch Process based on demand using Informatica command line prompt.
  • Performed Developer testing, Functional testing, Unit testing for the Informatica mappings.
  • Developed Stored Procedures using T-SQL to run the Store Procedure Transformation in Informatica.
  • Involved in creating Endpoints for file transfer using informatica B2B DX.
  • Created parameter files supported by all Informatica tools for incremental load.
  • Automated the schedules for running sessions and processes with Informatica Scheduler.
  • Worked on creating and setting AutoSys jobs to run the Informatica Workflows in automated manner including Nightly Batch Processes.
  • Created Unix Shell Scripts to schedule and automate the Informatica Workflows.
  • Involved in Unit testing and Integration testing of Informatica workflows.
  • Created and monitored workflows and tasks using Informatica Power Center Workflow Manager.
  • Created various Mapplets in designer using Informatica Power Center Mapplet Designer.

Show More

4 Informatica Jobs

No jobs at selected location

SQL Developer Jobs

NO RESULTS

Aw snap, no jobs found.

20 Most Common Skills For A SQL Developer

Database

19.7%

SQL

15.1%

Ssis

6.6%

T-Sql

6.5%

Windows XP

6.3%

Ssrs

5.6%

Business Requirements

5.4%

Data Warehouse

5.2%

ETL

4.4%

Query Analyzer

4.2%

DTS

3.1%

Constraints

2.9%

XML

2.7%

Ssas

2.3%

C # .NET

2.1%

Backup

1.9%

Unix

1.6%

Asp.Net

1.6%

Html

1.4%

Ad-Hoc

1.4%
Show More

Typical Skill-Sets Required For A SQL Developer

Rank Skill
1 Database 15.1%
2 SQL 11.6%
3 Ssis 5.0%
4 T-Sql 5.0%
5 Windows XP 4.8%
6 Ssrs 4.3%
7 Business Requirements 4.2%
8 Data Warehouse 4.0%
9 ETL 3.4%
10 Query Analyzer 3.2%
11 DTS 2.4%
12 Constraints 2.2%
13 XML 2.1%
14 Ssas 1.8%
15 C # .NET 1.6%
16 Backup 1.5%
17 Unix 1.2%
18 Asp.Net 1.2%
19 Html 1.1%
20 Ad-Hoc 1.1%
21 Olap 1.0%
22 Complex Queries 1.0%
23 Cursors 1.0%
24 Toad 1.0%
25 Business Logic 1.0%
26 Management Studio 1.0%
27 Referential Integrity 0.9%
28 Oltp 0.9%
29 Wizard 0.9%
30 Text 0.9%
31 Column 0.8%
32 Sharepoint 0.8%
33 Test Cases 0.8%
34 Lookup 0.8%
35 DDL 0.8%
36 Data Analysis 0.8%
37 BI 0.7%
38 R2 0.7%
39 Javascript 0.7%
40 Data Integrity 0.7%
41 DML 0.7%
42 TFS 0.7%
43 Multiple Tables 0.6%
44 MDX 0.6%
45 BCP 0.6%
46 User Acceptance 0.6%
47 VB 0.5%
48 Pl/Sql 0.5%
49 Production Environment 0.5%
50 Informatica 0.5%
{[{skill.rank}]} {[{skill.name}]} {[{skill.percentageDisplay}]}%
Show More

24,139 SQL Developer Jobs

Where do you want to work?

To get started, tell us where you'd like to work.
Sorry, we can't find that. Please try a different city or state.