General Dynamics Information Technology

SENIOR SYSTEMS ENGINEER – ETL, Data Bricks, Kafka, Informatica. Strong with Informatica ETL coding, Shell Scripting, PL SQL. Must have experience in various cloud platforms (AZURE, GOOGLE CLOUD PLATFORM, INFORMATICS CLOUD) and data stores. Strong database experience in any or all: Oracle, SQL Server, Teradata. To encourage work/life balance, GDIT offers employees full flex work weeks where possible and a variety of paid time off plans, including vacation, sick and personal time, holidays, paid parental, military, bereavement and jury duty leave.

senior systems engineer

Job Description: Type of Requisition: Regular Clearance Level Must Currently Possess: None Clearance Level Must Be Able To Obtain: None Suitability: Public Trust/Other Required: Job Family: Systems Engineering Skills: Job Qualifications: Informatica PowerCenter, MongoDB, SUSE Linux Certifications: Experience: 10 + years of related experience US Citizenship Required: No Job Description: SENIOR SYSTEMS ENGINEER – ETL, Data Bricks, Kafka, Informatica Seize your opportunity and make a personal impact as at GDIT. Own your opportunity to work alongside federal civilian agencies. Make an impact by providing services that help the government ensure the well-being of U.S. citizens. At GDIT, people are our differentiator. As Senior Systems Engineer, you will help ensure today is safe and tomorrow is smarter. Our work depends on a Systems Engineer joining our team to support our client and their mission. HOW A SENIOR SYSTEMS ENGINEER WILL MAKE AN IMPACT Experience with Informatica EDC and ETL tools
Performing extraction, transformation, and loading (ETL) of data from multiple sources into appropriate landing tables.
Profiling incoming data to identify various patterns, inconsistencies, column characteristics, distinct values and perform data distribution.
Cleansing and manipulating data into acceptable values (trimming, normalization, various data manipulation functions, etc.), and using address validation of incoming records (using Address Doctor) to identify exceptions.
Loading the cleansed data into staging tables for EDC consumption.
Creating Data Quality Scorecards on various attributes to ‘grade’ the source data to the Golden Record (completeness, accuracy, duplication, consistency, conformity, integrity), and Data Analyst tool allows data stewards to choose components, create and refresh scorecards.
Scheduling the above listed tasks for automation purposes. REQUIRED SKILLS & ABILITIES: Experience with EXTRATION, TRANSFORMATION and LOADING (ETL) experience with data from multiple sources
Must have strong experience with DATA BRICKS
Must have experience in utilizing KAFKA queues
Strong with Informatica ETL coding, Shell Scripting, PL SQL
Experience with SUSE Linux and RED HAT
Exposure in using INFORMATICA or other ETL products
Must have experience in various cloud platforms (AZURE, GOOGLE CLOUD PLATFORM, INFORMATICS CLOUD) and data stores
Must have experience in creating APIs WHAT YOU’LL NEED TO SUCCEED Strong background in supporting Informatica Data Quality and Informatica cloud
Experience with SUSE Linux and Informatica product(s)
Strong database experience in any or all: Oracle, SQL Server, Teradata
Strong in Informatica ETL coding, shell scripting and have Linux/RedHat experience
Ability to research tool & platform related problems and document
SECURITY CLEARANCE LEVEL: Ability to achieve a Public Trust clearance - the security clearance for this program requires the selected candidate to have resided in the US for the past five years. The selected candidate cannot have left the country for longer than 90 consecutive days and no more than 180 cumulative days. LOCATION: Raleigh, NC or Remote, East Coast Time GDIT IS YOUR PLACE: 401K with company match
Comprehensive health and wellness packages
Internal mobility team dedicated to helping you own your career
Professional growth opportunities including paid education and certifications
Cutting-edge technology you can learn from
Rest and recharge with paid vacation and holidays SECURITY CLEARANCE LEVEL: Ability to achieve a Public Trust clearance - the security clearance for this program requires the selected candidate to have resided in the US for the past five years. The selected candidate cannot have left the country for longer than 90 consecutive days and no more than 180 cumulative days. LOCATION: Raleigh, NC or Remote, East Coast Time GDIT IS YOUR PLACE: 401K with company match
Comprehensive health and wellness packages
Internal mobility team dedicated to helping you own your career
Professional growth opportunities including paid education and certifications
Cutting-edge technology you can learn from
Rest and recharge with paid vacation and holidays The likely salary range for this position is $112,000 - $168,000. This is not, however, a guarantee of compensation or salary. Rather, salary will be set based on experience, geographic location and possibly contractual requirements and could fall outside of this range. Scheduled Weekly Hours: 40 Travel Required: None Telecommuting Options: Remote Work Location: USA NC Raleigh Additional Work Locations: Any Location / Remote Total Rewards At GDIT: Our benefits package for all US-based employees includes a variety of medical plan options, some with Health Savings Accounts, dental plan options, a vision plan, and a 401(k) plan offering the ability to contribute both pre and post-tax dollars up to the IRS annual limits and receive a company match. To encourage work/life balance, GDIT offers employees full flex work weeks where possible and a variety of paid time off plans, including vacation, sick and personal time, holidays, paid parental, military, bereavement and jury duty leave. GDIT typically provides new employees with 15 days of paid leave per calendar year to be used for vacations, personal business, and illness and an additional 10 paid holidays per year. Paid leave and paid holidays are prorated based on the employee’s date of hire. The GDIT Paid Family Leave program provides a total of up to 160 hours of paid leave in a rolling 12 month period for eligible employees. To ensure our employees are able to protect their income, other offerings such as short and long-term disability benefits, life, accidental death and dismemberment, personal accident, critical illness and business travel and accident insurance are provided or available. We regularly review our Total Rewards package to ensure our offerings are competitive and reflect what our employees have told us they value most. We are GDIT. A global technology and professional services company that delivers consulting, technology and mission services to every major agency across the U.S. government, defense and intelligence community. Our 30,000 experts extract the power of technology to create immediate value and deliver solutions at the edge of innovation. We operate across 30 countries worldwide, offering leading capabilities in digital modernization, AI/ML, Cloud, Cyber and application development. Together with our clients, we strive to create a safer, smarter world by harnessing the power of deep expertise and advanced technology. We connect people with the most impactful client missions, creating an unparalleled work experience that allows them to see their impact every day. We create opportunities for our people to lead and learn simultaneously. From securing our nation’s most sensitive systems, to enabling digital transformation and cloud adoption, our people are the ones who make change real. GDIT is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status, or any other protected class.
#J-18808-Ljbffr

START NEW SEARCH