This job has expired.
Accolite
Expired

ETL Data Warehouse SQL Developer (Remote)

Remote

Location restricted
This job is restricted to tax residents of , but we detected your IP as outside of the country. Please only apply if you are a tax resident.

Position Title ETL Data Warehouse SQL Developer / Data Engineer

Location : Rockville, MD

Long term contract

Job Description: -

As a key member of the Software development team, you will be responsible for the delivery of high quality, reliable, sustainable software to satisfy technical designs for the customer solutions. You will be involved in implementing cutting-edge sophisticated data integration, data warehouse and data mart (ELT/ETL) solutions using Netezza, Oracle, Informatica and Denodo. An ideal candidate will have extensive knowledge of the data warehouse architecture, capabilities, system setup, data integration, data modeling concepts. This role is high paced and requires self-discipline to work remotely and meet delivery schedules.

 Develop, test and implement software components

 Work closely with teams to turn technical project requirements into functioning code

 Analyze and develop enhancements to applications using leading software principles

 Define and document requirements and develop supportable application solutions to automate business processes

 Collaborate with end-users, business analysts, data analysts and systems analysts to determine features, requirements and solution design

 Document technical specifications and designs

 Adhere to industry standard established design, coding, naming and standards

Minimum Criteria

 8+ years of proven hands-on experience in data integration, data warehouse, BI solution design, development, and implementation

 5+ years of hands-on experience in at least one relational data source such as Oracle, SQL Server and Data warehouse MPP applications such Netezza, Teradata, Exadata, GreenPlum etc.

 Proven expertise in writing efficient advanced and analytical SQL and Unix shell scripts.

  • Extensive knowledge of fundamental concepts, practices, and procedures of data warehousing and data marts

 Expert grasp of data warehouse design techniques including slowly changing dimensions, aggregation, partitioning and indexing strategies.

  • Experience working PowerCenter 10.x, Golden Gate Replication and Denodo desirable

 Hands-on experience with source version control, continuous integration and experience with release/change management delivery tools/methodology.

 Experience with multiple software development methodologies, e.g. Agile,iterative, waterfall.

  • Experience in uncovering requirements, conceptualizing solutions, and developing a framework for implementation of a data warehouse, data mart, or data web on at least one other project or work assignment
  • Possess a thorough understanding of the data, sources of data, and relationships of data
  • Experience with data extraction, manipulation, and cleansing tools
  • Knowledge of database design, with emphasis on data warehousing, OLAP, star schemas or reporting cubes
  • Problem-solving skills and proven record of working well in a team environment
  • Advanced proficiency in communication skills (verbal and written) across all organizational levels

Job Type: Contract

Experience:

  • strong: 1 year (Preferred)
  • building: 1 year (Preferred)
  • java: 1 year (Preferred)
  • SQL: 1 year (Preferred)
  • project management: 1 year (Preferred)

Benefits:

  • None

Schedule:

  • Monday to Friday

Work Remotely:

  • Temporarily due to COVID-19

Other Data Warehouse contracts

Remote
0
USD
/hr

0 outside IR35 Data Warehouse contracts