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
What You Will Be Doing
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
- 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.
- 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.