Pilot - Senior Data Integration Developer

Company:  Genesis10
Location: Charlotte
Closing Date: 16/10/2024
Hours: Full Time
Type: Permanent
Job Requirements / Description
Genesis10 is currently seeking a Specialty Software Engineer with our client in the financial industry located in Charlotte, NC. This is a 24+ month contract position.

Responsibilities:

Consult on or participate in moderately complex initiatives and deliverables within Specialty Software Engineering and contribute to large-scale planning related to Specialty Software Engineering deliverables

Review and analyze moderately complex Specialty Software Engineering challenges that require an in-depth evaluation of variable factors

Contribute to the resolution of moderately complex issues and consult with others to meet Specialty Software Engineering deliverables while leveraging solid understanding of the function, policies, procedures, and compliance requirements

Collaborate with client personnel in Specialty Software Engineering

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

Requirements:

4+ years of Specialty Software Engineering experience, or equivalent demonstrated through one or a combination of the following: work or consulting experience, training, military experience, education

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 designing and optimizing complex SQL queries involving table joins and correlated sub-queries on large scale data tables

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

2+ years of Hadoop/Big Data development experience

Comfortable working on multiple, complex issues and projects

Desired Skills:

BS/BA degree or higher in science or technology

2+ years of experience with Talend ETL development

An industry-standard technology certification

Strong verbal, written, and interpersonal communication skills

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

Knowledge and understanding of GitHub

Only candidates available and ready to work directly as Genesis10 employees will be considered for this position.

If you have the described qualifications and are interested in this exciting opportunity, please apply!

About Genesis10:

Ranked a Top Staffing Firm in the U.S. by Staffing Industry Analysts for six consecutive years, Genesis10 puts thousands of consultants and employees to work across the United States every year in contract, contract-for-hire, and permanent placement roles. With more than 300 active clients, Genesis10 provides access to many of the Fortune 100 firms and a variety of mid-market organizations across the full spectrum of industry verticals.

For contract roles, Genesis10 offers the benefits listed below. If this is a perm-placement opportunity, our recruiter can talk you through the unique benefits offered for that particular client. Benefits of Working with Genesis10:

Access to hundreds of clients, most who have been working with Genesis10 for 5-20+ years.

The opportunity to have a career-home in Genesis10; many of our consultants have been working exclusively with Genesis10 for years.

Access to an experienced, caring recruiting team (more than 7 years of experience, on average.)

Behavioral Health Platform

Medical, Dental, Vision

Health Savings Account

Voluntary Hospital Indemnity (Critical Illness & Accident)

Voluntary Term Life Insurance

401K

Sick Pay (for applicable states/municipalities)

Commuter Benefits (Dallas, NYC, SF)

Remote opportunities available

For multiple years running, Genesis10 has been recognized as a Top Staffing Firm in the U.S., as a Best Company for Work-Life Balance, as a Best Company for Career Growth, for Diversity, and for Leadership, amongst others. To learn more and to view all our available career opportunities, please visit us at our website.

Genesis10 is an Equal Opportunity Employer. Candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
Apply Now
An error has occurred. This application may no longer respond until reloaded. Reload 🗙