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 2 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


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
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
ETL Big Data Developer VP

Citigroup Inc.

Posted 2 months ago

VIEW JOBS 10/5/2018 12:00:00 AM 2019-01-03T00:00 * Primary Location: United States,Florida,Tampa * Other Location: United States,Texas,Irving * Education: Bachelor's Degree * Job Function: Technology * Schedule: Full-time * Shift: Day Job * Employee Status: Regular * Travel Time: Yes, 10 % of the Time * Job ID: 18050555 Description Apps Dev Tech Lead Analyst to design, develop and deliver enterprise applications in Finance and Risk Technology primarily using best in class software engineering practices with help of relevant technologies and tools. Develop an application to use firm's big data platform using Spark/Hadoop, while delivering critical pieces of business functionality. Key Responsibilities: Experience in design, development and coding world class software with 10+ years of sound ETL experience. Experience with Spark/Scoop/Hive (Or willingness to learn backed with solid technology understanding of distributed systems) is essential. Must have the ability to design, co-ordinate and develop in a fast paced agile environment. Key responsibilities are: * Lead team of offshore developers in Chennai to deliver best in class functionalities to users. * Be a hands on project lead at offshore who can lead by example. * Coordinate with other consultants located in onshore (USA) and offshore (India). * Ownership and responsibility for end-to-end design and development, testing, release of key components. * Ensure process compliance and manage expectations of the leadership. * Actively participate in brainstorming session and provide solid inputs to the team. * Create design document, test, release plans. * Successfully migrate ETL logic into Spark/Hadoop platform. * Ensure best practices are followed . Development Value: * Opportunity to learn/ add domain skill in the area of finance and primary market trading and accounting. * Opportunity to directly work for one of the best technology teams on Wall Street. * Opportunity to work on latest technology stack and multi-tiered/ Cloud based architecture * Excellent opportunity to learn senior management reporting, cutting across global functions, related analytics, reporting methodologies for a large global bank. Qualifications Qualifications: First class degree with excellent academic qualifications. B.E/ B.Tech. in Comp science, IT, or other engineering disciplines from a reputed institute with relevant work experience. Knowledge/Experience: * Experienced with Brokerage/Banking application development (10+ year) * 5+ Year Development and Design Experience in Big Data Architectures like Apache Hadoop * 5+ Year Development and Design Experience in Spark/Sqoop/Hive * Relational Database SQL (Oracle) experience (8+ year). Should be capable of writing complex and efficient SQL DML statements. * Programming language (Java) experience * Sound ETL experience (e.g. Ab-initio, Informatica, Data Stage) Skills: * Strong design & execution bend of mind * Software engineering best practices * Passion for technology and self- starter * Orientation towards disciplined development processes * Strong writing, communication, time-management, decision-making, and basic task organization skills * Ability to prioritize and manage schedules under tight, fixed deadlines. Competencies * Ability to lead a team of developers. * Co-ordinate the work effort between onsite / offshore. * Sense of ownership and ability to escalate when/if required * Good change management discipline * Sincere, Flexible and willing to learn new technology as and when new mandates com * Good written & verbal communication skills * Ability to understand domain concepts * Ability to mentor team members technically Apply Now Citigroup Inc. Tampa FL

ETL / DW Developer

Expired Job

Robert Half Technology