Akkodis is seeking an Data Pipeline Consultant for a contract position with our Fortune 500 banking client.
Rate Range: Up to $66.63/hr W2
Location: Hopkins, MN
Summary:
As part of a Tech Modernization initiative, ELZ is migrating to Azure. To support this migration, Wealth Management needs to update 300+ data pipelines to support ELZ on Azure.
Top Desired Qualifications:
Ability to Design and Develop Data Pipelines using PySpark
Knowledge on DevOps, Autosys
Experience in Azure Data Lake, Azure Synapse, Informatica BDE, SQL Server
Ability to provide estimates and manage Jira Stories
Ability to communicate and provide timely updates
List responsibilities of this position:
Responsible for all phases of the software development lifecycle (analysis, design, and implementation).
Provide application development and maintenance for all phases of the software development lifecycle, including analysis, design, and implementation.
Design and maintain complex ETL (Extract, Transform and Load) processes that load from both data files and other databases.
Develop and maintain complex PL/SQL functions and procedures.
Create and optimize complex SQL queries for reports and applications.
Provide input to project plans that includes estimates of tasks, duties and technologies for future releases and write technical documentation.
Provide end user support and problem diagnosis and resolution.
Perform all assignments in accordance with ESH&Q, Security, and business practice requirements and policies.
Provide expert level development support of PL/SQL functions, procedures, and database architecture.
Provide advanced SQL tuning skills to complex queries, ETL’s, and data processing.
Provide advanced support towards the IT needs for financial and/or budget and planning applications.
Ideal Qualifications:
Broad experience developing and maintaining custom ETL scripts.
Comprehensive knowledge and experience with relational database design, techniques, and development methodologies
Broad experience using SQL, PL/SQL, and Oracle 11g or higher.
Broad experience developing ETL processes within Oracle database environments and non-Oracle environments using SQL Server, MySQL, File Transfer, or similar technologies.
Proficient interpersonal skills necessary to effectively collaborate as part of a cohesive development team working with multiple customers and organizations simultaneously with time constraints.
Proficient written and verbal communication skills necessary to effectively prepare, present and explain technical information to others.
Significant experience supporting financial and business applications.
Advanced experience with SQL Tuning and ETL Optimization.
Significant experience with data virtualization tools such as Denodo.
***Equal Opportunity Employer/Veterans/Disabled
Benefit offerings include medical, dental, vision, term life insurance, short-term disability insurance, additional voluntary benefits, commuter benefits and 401K plan. Our program provides employees the flexibility to choose the type of coverage that meets their individual needs. Available paid leave may include Paid Sick Leave, where required by law; any other paid leave required by Federal, State or local law; and Holiday pay upon meeting eligibility criteria. Disclaimer: These benefit offerings do not apply to client-recruited jobs and jobs which are direct hire to a client
To read our Candidate Privacy Information Statement, which explains how we will use your information, please visit https://www.modis.com/en-us/candidate-privacy/
The Company will consider qualified applicants with arrest and conviction records.
