Big Data ETL Engineer

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.