Think.
Create.
Accelerate.

Luxoft, a DXC Technology Company, (NYSE: DXC), is a digital strategy and software engineering firm providing bespoke technology solutions that drive business change for customers the world over. Luxoft uses technology to enable business transformation, enhance customer experiences, and boost operational efficiency through its strategy, consulting, and engineering services. Luxoft combines a unique blend of engineering excellence and deep industry expertise, specializing in automotive, financial services, travel and hospitality, healthcare, life sciences, media and telecommunications. For more information, please visit www.luxoft.com

Line of Business:

Financial Services

Position:

Database ETL developer (SSIS, Informatica, Data factory), Washington, D. C.

Project Description

Project is aimed to support the client engagement solutions program in Operations and corporate unit (ITSOP). This product offers a wide range of business capabilities including management of individual and organizational contacts, cases, correspondence, partners, and events. The objective of this project is to complete the ongoing work program to offer the complete cycle case management for the business. This involves developing the new business capabilities and improving the business process for the case management system.

Responsibilities

Team responsibility would be to develop case management system in Dynamics 365 and transitioning the existing application to the new system and migrate data from GoPro. The application is being developed in Angular frontend and Dynamics 365 as the backend engine, Power BI for reporting, SSIS for ETL and migration with the following capabilities
The ETL developer is responsible for developing workflows and mapping by using data migration tools like SSIS, Informatica and Data factory

Skills

Must

• Strong experience in designing and developing ETL mappings, mapplets, workflows, sessions using SSIS, Informatica and Data factory data migration tools
• Must have an extensive understanding and experience using various Informatica transformation types and reusable components
• Demonstrate hands-on experience in design and development of Informatica-Oracle based data warehouse solutions
• Demonstrate in-depth understanding of Data Warehousing (DWH) and ETL concepts, design and development of ETL loading strategy, Data archiving, Data reconciliation, ETL error handling, Error logging mechanisms, workflow recovery, standards and best practices

Nice to have

• In-depth experience with relational, dimensional, multi-dimensional and OLAP techniques & technology
• Experience with interfaces such as TOAD, SQL Navigator, and SQL Developer
• Strong SQL and data analysis capabilities
• Proven ability to serve as a senior developer responsible for designing and delivering solutions that meets complex business needs
• Actively participate in design and analysis sessions to ensure sound team decision-making
• Support system and user acceptance testing activities, including issue resolution
• Complete technical documentation to ensure system is fully documented
• Share best practices and lessons learnt from past implementation efforts

Languages

  • English: Upper-intermediate

Relocation package

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

WHERE

Washington, D. C.

Work Type

ETL (Informatica, Ab Initio etc.)

Seniority Level

Regular

Ref number
VR-45263
ADD TO MY JOB
RECOMMEND A FRIEND
Apply