Position: Data Warehouse and ETL Developer
Company: Luxoft
Experience required: 5y
Category: SQL
English level: upper
Published: 2020-08-01T00:00:00+03:00

**Project Description:**

As part of our strategic partnership with one of the biggest financial institutions in the World, we are hiring various IT specialists, who will become part of their new IT Service Center. The bank is an international organization dedicated to providing financing, advice, and research to developing nations to aid their economic advancement.

 The bank predominantly acts as an organization that attempts to fight poverty by offering developmental assistance to middle- and low-income countries. Our client is a provider of financial and technical assistance to individual countries around the globe. The bank considers itself a unique financial institution that sets up partnerships to reduce poverty and support economic development.

**Responsibilities:**
The Key Developer must have demonstrated experience building and maintaining data repositories and/or data warehouses. Preference will be given where the Key Developer's experience is in public health data. The Key Developer should demonstrate prior experience in building and managing data warehouses, producing code to manipulate the data in such a way as to be both exportable to flat files and also machine readable by the business intelligence tool that will be the backbone of the web portal. 

The Key Developer should have experience in data visualization and building web portals of a similar size and scope to the one required for this project. If needed and applicable, the project manager may deem that two key developers commit to this project: One for the data repository and one for the web portal. In this case, the offeror should provide a resume for each proposed key developer. 

**Mandatory Skills:**
• At Least 7 years of hands-on experience of complex ETL mappings, building data pipelines to collect data and move it into storage, and workflows in a Cloud-based ETL tool such as IICS and Azure Data Factory/SSIS
• Prepare the data as part of an ETL or ELT process, and perform transform-load design and development
• Integrate new data management technologies and software engineering tools into existing structures
• Work with application DBA and modelers to construct data stores
• Ability to build and interact with large data processing pipelines in distributed data stores, and distributed file systems
• Strong programming and algorithmic skills with the ability to stitch data together with scripting languages
• Develop data set processes for data modeling, mining and production
• Experience with managing and maintaining quality data by performing operations such as cleaning, transformation and ensuring integrity in both on-prem and a Cloud-based relational database environment
• Ensure data is ready for use by consuming application, analyst and scientist using frameworks and microservices to serve data
• Collaborate with data architects, modelers and IT team members on project goals
• Familiarity with various process modeling techniques (activity hierarchy diagrams, data flow diagrams,
sequence diagrams, workflow diagrams, system interface diagrams, etc.)

**Required Technologies:**
• Tools: Informatica Cloud Services (IICS), Informatica PowerCenter 10.x, Azure Data Factory
• Database: Oracle 12c/18c/19c, Azure SQL DW, SQL Server 2016/2014/2012/2008
• Cloud Technologies: Azure Microsoft Technologies, Unix, Linux, Windows
• Design Language: Visio, Erwin 9.x and above

**Nice-to-Have Skills:**
• Technical Degree in Computer Science/Engineering or related field
• Ability to work independently upon receiving guidance and objectives
• Experience in various development methodologies such as Agile/Scrum development methodology
• Ability to juggle multiple tasks in a fast-paced environment
• A wide degree of creativity and lateral thinking
• Excellent communication, writing/documentation and facilitation skills
• Strong diplomatic, interpersonal and teamwork skills
• Maturity to participate in multiple complex programs at the same time in an Agile environment