Sorry, this job is no longer accepting applications. See below for more jobs that match what you’re looking for!

Data Architect

Expired Job

Enquero Dublin , CA 94568

Posted 3 months ago

Job Summary
10+ years experience in Data Engineering with specializing in Microsoft SQL Server and SSIS or any other ETL tool.
Required Qualifications
Hands-on Experience in working on Microsoft SQL Server and SSIS ETL
Prior Applications developments using Microsoft SQL Server as RDMS using agile methodology
Experience in Microsoft SQL Server (DB) performance tuning of SQL.
Experience in Application integration with Microsoft SQL DW and build of analytical views
Experience in data migration from one database or filesystem to Microsoft SQL Server (DB) using SQL Server Integration Services (SSIS). Must have handled a few conversion/integrations with high volume of data e.g. 4TB+.
Ability to perform detailed study of the current processes and gather requirements from business stakeholders
Hands-on in data analysis, data capture, and data mapping.
Ability to work in agile or waterfall delivery environment and work with evolving requirements balancing the short-term and long-term.
Preferred Qualifications
Microsoft Azure SQL Database.
Microsoft Azure SQL Data warehouse.
Microsoft Azure Data Factory using Pipeline and SSIS.
Design and modelling of Data warehouse.
Usage of JMeter or any tool for performance benchmarking
Must be able to create Data Flow Diagrams and process flow diagrams
Must be able to create AS-IS and TO-BE (as needed) process documentation along with requirements documentation
Data modelling for OLTP and OLAP
Performance tuning of SQL running on SQL Server/DB
MS Office, Visio fluency and PowerPoint is a must

Microsoft SQL Server, SSIS ETL, Data Warehouse, Pipeline, Azure, Jmeter, Dataflow, AS-IS, OLTP, OLAP, Visio

See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Senior Data Integration Consultant

Callidus Software

Posted 2 months ago

VIEW JOBS 9/28/2018 12:00:00 AM 2018-12-27T00:00 Overview CallidusCloud, now part of SAP, is the global leader in cloud-based sales, marketing, learning, and customer experience solutions. CallidusCloud enables organizations to accelerate and maximize their lead to money process with a complete suite of solutions that identify the right leads, ensure proper territory and quota distribution, enable sales forces, automate configure price quote, speed up contract negotiations, properly recognize revenue under ASC 606, and streamline sales compensation—driving bigger deals, faster. Over 6,400 leading organizations, across all industries, rely on CallidusCloud to optimize the lead to money process to close more deals for more money in record time. CallidusCloud is looking for an experienced Data Integration Consultant to join our Professional Services organization to help architect and build data integration solutions for our customers. This role can be based at HQ - Dublin, CA, or Birmingham, AL or remote in the United States. Responsibilities * Analyze and define customer requirements, design and build Integration solutions using our Lead to Money suite of applications. * Develop functional and design specifications for client data integration solutions. * Apply complex problem-solving skills using database management, data mapping , APIs and webservices skills to research, troubleshoot and resolve technical questions and configuration requests from customers, partners and project teams. * Event-handling and resolution of potentially complex production processing issues involving: * File transfers into customer production environments * Data imports and validation * Informatica ETL processing * Data uploads using Webservices * Oracle database configuration, * Performance analysis and tuning using SQL Travel Expectation: up to 25%. Qualifications * Bachelor's degree in Computer Science, Management Information Systems or Information Technology. * 5+ years of related external customer facing experience, or an equivalent combination of education and relevant technical consulting experience. * 2+ years developing with Informatica v.8/9 and designing ETL solutions. * 2+ years of experience with Oracle RDBMS (preferably in UNIX environment) Technical with SQL (queries, stored procedures, query plans, optimizer). * 2+ years of UNIX programming (shell scripting), including coding from scratch, troubleshooting existing code, job control scripting, process automation scripting. Perl scripting experience preferred. * Experience using webservices, REST and SOAP based APIs. * Demonstrated initiative, ownership and independent judgment. * Strong customer management, teamwork, communication and organizational skills . Technical Skills: * REST based/SOAP based APIs. * Pulling/uploading data via WebServices in systems such as Salesforce, Workday, NetSuite etc Oracle PL/SQL coding, Informatica 8.x, 9.x * Performance Tuning - Oracle SQL, PL/SQL & Informatica workflows. * UNIX shell scripting. The following skills are a plus: * SFTP, Encryption, SSO. * Experience implementing the Callidus solution. * Knowledge of enterprise incentive management / compensation applications. Callidus Software (d.b.a CallidusCloud) is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, religion, color national origin, sex, age status as a protected veteran, or status as a qualified individual with disability. Callidus Software Dublin CA

Data Architect

Expired Job