Genesis10 is currently seeking an Sr. Data Engineer Consultant with our client in the transportation industry in their Atlanta, GA location. This is a 12 month + contract position.

Description:

• Seeking an Sr. Data Engineer
• Our client is on a journey to becoming the best IT organization in the airline industry, a journey of transformation. They are changing the way we do business from top to bottom as we strive to create meaningful and innovative solutions and are looking for team members to help us realize our vision

Responsibilities:

• Understand the business needs and translate them into a scalable, automated solution
• Designing processes that can extract/receive data from various heterogeneous source systems
• Design, develop, test, and support new capabilities and ongoing changes within the various application data marts
• Create ETL data flow diagrams based on the business requirements and pseudo logic
• Building capabilities to exchange the data with external partners in various formats (XML, CSV, Flat File, JSON)
• Perform data cleansing and transforming the data according to business rules
• Developing reusable frameworks for data extraction, loading and cleansing
• Should work with the multiple teams to understand the requirements, design, develop and test the interfaces
• Work with data owners to document data mappings and transformations to support effective downstream analytics and alerts
• Update the team on a daily or weekly basis in case of any project blockers and red flags
• Provide performance improvement related guidance for scalability and reusability of code and data objects
• Apply specialized knowledge in assembly or integration, cross-discipline functions, knowledge engineering, industry expertise, or legacy evolution
• Raise software access requests to any database servers, tools and SharePoint portals required for the project

Requirements:

• Senior ETL developer SSIS, and strong experience on SQL server, Linux/Unix scripting
• At least 7 years' experience developing enterprise class data pipelines using Informatica PowerCenter, MS SQL Server, Control M
• At least 2 years of experience working in Agile - Scrum teams
• Good understanding of the Data warehousing concepts, SQL server, Oracle SQL, or any other database SQL expertise
• Strong technical background covering ETL environments with PowerCenter, Shell scripting, Python
• Extensive experience designing and deploying SQL Server (ETL) solutions in a data warehousing, BI environment involving complex data transformations, change, data capture, and error handling
• Advanced experience with SQL Server ETL Development and its related tools (SSIS, SSRS, SSMS, Visual Studio), including extracting, transforming, and loading data from various data sources and APIs
• Advanced experience with production SSIS packages troubleshooting and development
• Solid hands-on experience and knowledge of ETL technology in use in projects
• Strong coding expertise with extensive knowledge and understanding of the systems development life cycle (SDLC)
• Excellent SQL programming is required as well (SQL, PowerShell, JavaScript, HTML, etc.)
• Solid hands-on experience and knowledge of database concepts of data modeling and mapping including normalization, dimensionality, referential integrity, indexes, keys, master data, and metadata
• Advanced knowledge in applying appropriate test methodologies and QA processes which includes writing test plans and test cases
• Experience in Python or other programming languages
• Experience writing complex SQL queries, SQL Tuning, and knowledge of database design and development (SQL and TSQL)
• Should have experience with Unit and Integration Testing process
• Strong Data Warehousing skills including Data profiling, Data masking, Auditing in ETL
• Experience extracting data from a variety of sources, and a desire to expand those skills (SQL server, Oracle)
• Should have good coordination skills and Data Analysis skills
• Should have experience with Unit and Integration Testing process

Desired Skills:

• Any cloud experience on AWS, Azure, and snowflake with any relevant certifications

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.