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

ETL / DW Developer

Expired Job

Robert Half Technology Tampa , FL 33607

Posted 4 months ago

This role will be responsible to work on internal, external various data sources and system and integration of those systems with company application. He/she will work closely with business users to design and implement reporting and analytical solutions, including the design and development of table structures and the processes used to populate those structures with data from internal and external sources. He/she has to develop ETL processes using SQL, SSIS, with consideration to fault-tolerance, error logging, auditing and data quality.

  • Create data integration and technical solutions around Microsoft SQL Server, Informatica and various other ETL Tools.

  • Data modeling and requirements analysis.

  • Prepare storage logical and physical models based on requirements

  • Create end-to-end analytics and reporting solutions.

Job Requirements

? Bachelor's degree in Computer Science, Engineering, or equivalent education

  • Experience with database/datawarehouse and ETL development.

  • SSIS, SSRS, SSAS

  • Experience with Informatica or other ETL tools outside of Microsoft a big PLUS

  • Advanced Structured Query Language (SQL)

  • Demonstrated ability to write transact-SQL / PL-SQL queries

  • Extensive experience with database/datawarehouse extraction and be comfortable with multiple ETL tools

  • Experience with Cloud computing concepts (private, public and hybrid) a plus

  • Experience working with reporting tools like Power Bi, Qlik Sense, Tableau a plus

  • Excellent written and verbal communication skills

  • Strong in Unix shell scripting.

  • Expertise in developing complex Stored Procedures, Functions, Packages.

  • Strong knowledge of performance tuning, query plan / explain plan analysis, indexing, table partitioning.

  • Expert in Data Architecture, Modeling, and any Modeling Tool.

  • Ability to create and manage sophisticated SSIS packages that import and validate data from various other SQL databases, flat files, and feeds (e.g. JSON, XML).

  • Validate ETL jobs against business use cases.

  • Develop and deploy all post-production enhancements.

  • Should have a familiarity with OLAP cubes

  • Ability to prioritize, perform multiple tasks and be a team player

If interested, email resume to

Skills:
Analysis, Architecture, Data Architecture, Database, Data Modeling, DataWarehouse, Developer, Development, Informatica, Modeling, OLAP, Shell Scripting, SQL, SQL Server, Transact-SQL, Unix, XML
Permanent


upload resume icon
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.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

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
Core Java Developer
New!

Reqroute,Inc

Posted Today

VIEW JOBS 1/16/2019 12:00:00 AM 2019-04-16T00:00 <strong>Description</strong><br /> ·         Risk is a consolidated platform for Risk Management and Risk Reporting globally. It is supported by the Enterprise Technology Solutions (ETS) within Global Functions Technology Services Organization. Risk provides the strategic infrastructure for Institutional Clients Group, Commercial Bank, Consumer Bank and Investment Products, Treasury and Enterprise Risk Management<br />  <br /> <strong><u>Job Purpose</u></strong><br /> ·         The purpose of the job is to design, develop, and enhance enterprise applications in Risk Technology primarily using SDLC/PDLC methodologies in Market Risk area. It centers around technologies such as Java/JEE/RDBMS.<br />  <br /> <strong>Key Responsibilities</strong> <ul> <li style="padding: 0; margin: 0;">Responsible to Build/implement & Design technology solution for one of the application with-in Market Risk.</li> <li style="padding: 0; margin: 0;">Participate in design review/ code/ project review meetings- local/global</li> <li style="padding: 0; margin: 0;">Participate in all project planning, progress & development meetings with the team & global managers</li> <li style="padding: 0; margin: 0;">Be Collaborative with our developers</li> <li style="padding: 0; margin: 0;">Maintain technical, though leadership and disseminate knowledge to team and peers</li> </ul>  <br /> <strong>Qualifications</strong><br /> <strong>Knowledge/Experience:</strong><br /> 7– 9 years of industry experience, with a minimum of 7 years in java/j2ee development<br /> Experience of Agile development and scrums<br /> Banking and securities domain knowledge would be an added advantage<br /> Strong knowledge on Core Java (preferred version 7 and 8), Spring framework (Core, MVC, JDBC, Spring boot), Hibernate/JDBC/JPA/ORM, JSON<br /> Good hands on experience on Oracle PL/SQL and should be able to write simple and complex queries, stored procedures, packages, Indexes and triggers<br /> Expertise in Web API implementations (Web services, RESTful services etc) is preferable<br /> Strong knowledge on build (Maven), continuous integration (Jenkins), code quality analysis (SonarQube) and unit and integration testing (JUnit)<br /> Exposure to SCM toll like Bit Bucket/GIT etc.<br /> Should be able to work on UNIX shell script and VI editor<br /> <br /> <strong>Added advantage</strong><br /> Exposure to Big data technology like Apache Kafka, Storm, Spark etc.<br /> Good analytical, debugging and problem solving skills<br /> Organized and able to deliver in multiple projects in the stream<br /> Passion for research, ideation and exploration<br /> Excellent communication and presentation skills<br /> Ability to work independently and in a team<br /> Expertise with designing multi-clustered applications. <div><b>Qualifications</b></div> <div>B. Tech from a top engineering college, University, preferably in computer science. Other preferred branches are EE, ECE. Candidates with passion for coding and systems development from other disciplines also can apply. Substantial part of experience should be in top notch IBs/Banks and product companies<br /> <br /> Interested candidates, send your resume to renuka@reqroute.com</div> Reqroute,Inc Tampa FL

ETL / DW Developer

Expired Job

Robert Half Technology