Motion Recruitment Partners LLC
Hadoop Spark ETL Developer
Motion Recruitment Partners LLC, Charlotte, North Carolina, United States, 28245
Hadoop Spark ETL Developer
Charlotte, NC
Hybrid
Contract
$66.26/hr - $75/hr
Outstanding long-term contract opportunity! A well-known Financial Services Company is looking for a Big Data ETL Engineer in Charlotte, NC (Hybrid).
Work with the brightest minds at one of the largest financial institutions in the world. This is long-term contract opportunity that includes a competitive benefit package! Our client has been around for over 150 years and is continuously innovating in today's digital age. If you want to work for a company that is not only a household name, but also truly cares about satisfying customers' financial needs and helping people succeed financially, apply today.
Contract Duration: 24 Months
Required Skills & Experience
7+ years of Software Engineering experience, or equivalent demonstrated through one or a combination of the following: work experience, training, military experience, education
5+ years of ETL (Extract, Transform, Load) Programming experience
3+ years of experience writing SQL relational database queries, stored procedures, query optimization and performance tuning
3+ years of experience with databases such as Oracle, DB2, SQL Server, or Teradata
Desired Qualifications:
An industry-standard technology certification
Strong verbal, written, and interpersonal communication skills
A BS/BA degree or higher in science or technology
Knowledge and understanding of software development life cycle (SDLC): all phases and types of testing
Ability to work effectively in virtual environment where key team members and partners are in various time zones and locations
MS SQL server experience
Knowledge and understanding of Selenium software testing framework
2+ years of experience with Talend ETL development.
Knowledge and understanding of GitHub
What You Will Be Doing
We are seeking a Senior Data Integration Developer to be part of a team that provides reporting data warehouse solutions for Risk and Compliance across all levels of the organization.
This position will use their strong understanding of data management, how to design and build dimensional data models, and overall delivery of data integration solutions.
This position will partner with Data Modelers, report developers, and Business Intelligence Analysts to design/develop/deploy information solutions in the enterprise risk domain.
In this role, you will:
Work closely with Data Modelers to structure data requirements into a data warehouse model for reporting and analytics
Design, develop and debug ETL integration code to meet defined source to target mappings
Handle complex ETL requirements and design
Work with Business Stakeholders to build database objects to meet desired output
Build, maintain and govern the Hadoop data layer to ensure data consistency and single version of the truth
Complete Unit Testing to ensure low probability of defects and that data matches with back-end systems
Ensure solutions are highly usable, scalable, and maintainable
Understand the impacts of data layer performance factors and collaborate with the Data Architect to implement mitigating physical modeling solutions
Perform code and design reviews to ensure performance, maintainability, and standards
Work with the Data Architect to define data security roles, groups and policies
Enforce Hadoop design standards, reusable objects, tools, best practices, and related development methodologies for the organization
Partnering with Business Stakeholders and developers to ensure deliverables meet business expectations
Suggest solutions for development or process improvement
Tuning of dataset design for optimal performance
Develop, execute, and troubleshooting of complex report SQL
Must be comfortable working on multiple, complex issues and projects.
You will receive the following benefits:
Medical Insurance - Four medical plans to choose from for you and your family
Dental & Orthodontia Benefits
Vision Benefits
Health Savings Account (HSA)
Health and Dependent Care Flexible Spending Accounts
Voluntary Life Insurance, Long-Term & Short-Term Disability Insurance
Hospital Indemnity Insurance
401(k) including match with pre and post-tax options
Paid Sick Time Leave
Legal and Identity Protection Plans
Pre-tax Commuter Benefit
529 College Saver Plan
Motion Recruitment Partners (MRP) is an Equal Opportunity Employer, including Veterans/Disability/Women. All applicants must be currently authorized to work on a full-time basis in the country for which they are applying, and no sponsorship is currently available. Employment is subject to the successful completion of a pre-employment screening. Accommodation will be provided in all parts of the hiring process as required under MRP’s Employment Accommodation policy. Applicants need to make their needs known in advance.
Posted by: Chris Clark
Specialization: Data Engineering
Charlotte, NC
Hybrid
Contract
$66.26/hr - $75/hr
Outstanding long-term contract opportunity! A well-known Financial Services Company is looking for a Big Data ETL Engineer in Charlotte, NC (Hybrid).
Work with the brightest minds at one of the largest financial institutions in the world. This is long-term contract opportunity that includes a competitive benefit package! Our client has been around for over 150 years and is continuously innovating in today's digital age. If you want to work for a company that is not only a household name, but also truly cares about satisfying customers' financial needs and helping people succeed financially, apply today.
Contract Duration: 24 Months
Required Skills & Experience
7+ years of Software Engineering experience, or equivalent demonstrated through one or a combination of the following: work experience, training, military experience, education
5+ years of ETL (Extract, Transform, Load) Programming experience
3+ years of experience writing SQL relational database queries, stored procedures, query optimization and performance tuning
3+ years of experience with databases such as Oracle, DB2, SQL Server, or Teradata
Desired Qualifications:
An industry-standard technology certification
Strong verbal, written, and interpersonal communication skills
A BS/BA degree or higher in science or technology
Knowledge and understanding of software development life cycle (SDLC): all phases and types of testing
Ability to work effectively in virtual environment where key team members and partners are in various time zones and locations
MS SQL server experience
Knowledge and understanding of Selenium software testing framework
2+ years of experience with Talend ETL development.
Knowledge and understanding of GitHub
What You Will Be Doing
We are seeking a Senior Data Integration Developer to be part of a team that provides reporting data warehouse solutions for Risk and Compliance across all levels of the organization.
This position will use their strong understanding of data management, how to design and build dimensional data models, and overall delivery of data integration solutions.
This position will partner with Data Modelers, report developers, and Business Intelligence Analysts to design/develop/deploy information solutions in the enterprise risk domain.
In this role, you will:
Work closely with Data Modelers to structure data requirements into a data warehouse model for reporting and analytics
Design, develop and debug ETL integration code to meet defined source to target mappings
Handle complex ETL requirements and design
Work with Business Stakeholders to build database objects to meet desired output
Build, maintain and govern the Hadoop data layer to ensure data consistency and single version of the truth
Complete Unit Testing to ensure low probability of defects and that data matches with back-end systems
Ensure solutions are highly usable, scalable, and maintainable
Understand the impacts of data layer performance factors and collaborate with the Data Architect to implement mitigating physical modeling solutions
Perform code and design reviews to ensure performance, maintainability, and standards
Work with the Data Architect to define data security roles, groups and policies
Enforce Hadoop design standards, reusable objects, tools, best practices, and related development methodologies for the organization
Partnering with Business Stakeholders and developers to ensure deliverables meet business expectations
Suggest solutions for development or process improvement
Tuning of dataset design for optimal performance
Develop, execute, and troubleshooting of complex report SQL
Must be comfortable working on multiple, complex issues and projects.
You will receive the following benefits:
Medical Insurance - Four medical plans to choose from for you and your family
Dental & Orthodontia Benefits
Vision Benefits
Health Savings Account (HSA)
Health and Dependent Care Flexible Spending Accounts
Voluntary Life Insurance, Long-Term & Short-Term Disability Insurance
Hospital Indemnity Insurance
401(k) including match with pre and post-tax options
Paid Sick Time Leave
Legal and Identity Protection Plans
Pre-tax Commuter Benefit
529 College Saver Plan
Motion Recruitment Partners (MRP) is an Equal Opportunity Employer, including Veterans/Disability/Women. All applicants must be currently authorized to work on a full-time basis in the country for which they are applying, and no sponsorship is currently available. Employment is subject to the successful completion of a pre-employment screening. Accommodation will be provided in all parts of the hiring process as required under MRP’s Employment Accommodation policy. Applicants need to make their needs known in advance.
Posted by: Chris Clark
Specialization: Data Engineering