Position

Senior ETL Developer,
New York City

Location


New York City

Office Address


Project Description


The ETL Developer is responsible for data integration (ETL) development for data warehouse solutions that deliver diverse reporting and analytic capabilities to health and human services customers in the public and private sector.

This role develops data integration programs that load, transform and extract data from the data warehouse, assures that architecture and development follow data warehouse best practices. This individual works with DW architects, data architects, hardware/software engineers, DBAs, application vendors and managed services to ensure enterprise DW solutions are reliable, scalable, flexible and low maintenance.

This position requires a bachelor's degree or equivalent experience. The candidate must demonstrate expertise in data warehouse concepts, practices, and procedures, has technical hands on experience implementing data warehouse solutions, has strong communication skills and the ability to provide consultation to customers and collaborate internally on complex projects as a the key contributor/specialist. This candidate should also be able to find creative solutions to complex and diverse business requirements. This position typically reports to an ETL Team Lead.

Responsibilities


    • Review business and technical requirements and ensure the data integration platform meets requirements
    • Apply industry best practices for ETL design and development
    • Assists in design, development and implementation of end-to-end complex ETL system using Datastage tools
    • Plan and contributes to ETL development efforts for team utilizing PL/SQL and DataStage tools
    • Produce written deliverables for technical design, system testing and implementation activities
    • Implement ETL systems that are operationally stable, efficient and automated
    • Implement technical solutions that are scalable, aligned with the enterprise architecture and can adapt to changes in business
    • Implement ETL systems that maximize re-usable components/services, collect/share metadata, incorporate audit, reconciliation and exception handling
    • Implement parallel processing, load balancing, near real-time and real-time ETL processes
    • Implement monitoring and measurement of data quality as defined by business rules
    • Employ best practices, standards of excellence, and guidelines for programming teams
    • Conduct System Testing - execute job flows, investigate system defects, resolve defects and document results
    • Assist in the development, documentation and application of best practices and procedures that govern DW implementations and operations
    • Off hour and weekend support may be required to meet project milestones

Skills


Must have

    • 5+ years’ experience programming ETL programs using standard languages or tools (Datastage preferred)
    • 5+ years’ experience performing data analysis and profiling, and designing ETL systems/programs
    • Advanced SQL skills
    • In depth understanding of data integration best practices, leading industry applications and features such as master data management, entity resolution, data quality assessment, metadata management, etc.
    • Understanding of data warehouse best practices
    • Good communication skills
    • Good interpersonal skills and the ability to collaborate with other technical teams, project management, client management and business analysts

Nice to have

    • Health and human services experience
    • Experience implementing MMIS, T-MSIS or other Government-specific solutions
    • Experience implementing systems that utilize Oracle DBMS

Languages


English: B2 Upper Intermediate

Relocation package


If needed, we can help you with relocation process. Click here for more details: see more details

Work Type


ETL (Informatica, Ab Initio etc.)

Ref Number


VR-54704

Explore More

LoGeek Magazine
icon Logeek Luxoft
Learn more
Events
icon Events Luxoft
Learn more
Relocation Program
icon Relocation Luxoft
Learn more
Referral
Platform
icon Referral Luxoft
Learn more
Students
and Grads
icon Students Luxoft
Learn more

More job opportunities in
ETL (Informatica, Ab Initio etc.)

Specialization Position / Title Location Send to a friend
ETL (Informatica, Ab Initio etc.) Data Integration Lead (DataStage) New York City, US