Required Skills

ANSI SQL SSIS Ab Initio Unix Shell Scripting

Work Authorization

  • Us Citizen

  • Green Card

Preferred Employment

  • Corp-Corp

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 17th Dec 2020

JOB DETAIL

The Senior ETL Developer will be held accountable for the following responsibilities:

● Maintain and Manage the existing Enterprise Data Warehouse and ODS builds.

● Model extensions to the existing Data Warehouse

● Builds ETL components according to ETL specifications. Code must address performance,

dependency, auditing, error handling and data quality issues.

● Support post deployment by debugging, fixing, and participating in maintenance.

● Create reports to meet business requirements and address data needs.

● Create Dashboard pages and metrics with custom dashboard solution.

● Responsible for data integrity as well as the quality of data within Dashboard presentation layer.

● Participate in code reviews and ensure that all solutions are aligned to pre-defined architectural

specifications; identify/troubleshoot code-related issues; and review and provide feedback to

the final user documentation.

● Read and understand business requirements, write functional requirements, develop detailed

technical designs, and build / unit / system test ETL code.

 

Type of Education Required :

● Bachelor's Degree in Computer Science or related field

Type of Experience and Number of Years :

● 10+ years of Enterprise Data Warehouse experience

● 5+ years of experience with an ETL product (SSIS, Ab Initio, etc) in a development role

(administrative knowledge a plus)

● Good knowledge of data modeling/Star Schema

● Strong ANSI SQL expertise

● 3+ years of experience with Unix and Shell Scripting

● Experience with SQL Server 2012

● Ability to develop and organize high-quality documentation

● Experience with at least one job scheduler

● Experience with Record Linking

● Experience with Medicaid Data Processing

Company Information