Big Data/SQL Developer - SGA Inc.
Irving, TX
About the Job
Software Guidance & Assistance, Inc., (SGA), is searching for a Big Data/SQL Developer for a CONTRACT assignment with one of our premier Financial Services clients in Irving, TX.
Responsibilities:
This role is responsible for the delivery of Data Quality rules which includes:
Required Skills:
Preferred Skills:
SGA is a technology and resource solutions provider driven to stand out. We are a women-owned business. Our mission: to solve big IT problems with a more personal, boutique approach. Each year, we match consultants like you to more than 1,000 engagements. When we say let's work better together, we mean it. You'll join a diverse team built on these core values: customer service, employee development, and quality and integrity in everything we do. Be yourself, love what you do and find your passion at work. Please find us at https://sgainc.com/ .
SGA is an Equal Opportunity Employer and does not discriminate on the basis of Race, Color, Sex, Sexual Orientation, Gender Identity, Religion, National Origin, Disability, Veteran Status, Age, Marital Status, Pregnancy, Genetic Information, or Other Legally Protected Status. We are committed to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities in employment, and our services, programs, and activities. Please visit our company EEO page to request an accommodation or assistance regarding our policy.
Responsibilities:
This role is responsible for the delivery of Data Quality rules which includes:
- Code & development & enhance SQL Queries.
- Release the SQL to UAT testing and Prod; Job scheduling and running.
- Production support - job monitoring and SQL error debugging.
- Ad_hoc python script creation.
- Hosting meetings and present tech demos.
- Discovery of new technical challenges that can be solved with existing and emerging Big Data hardware and software solutions.
- Assisting and support analyst team on technical solutions.
- Understands the SQLs syntax/functions across different analytic engine/platform, responsible to convert Starburst/impala SQL to SparkSQL by referring spark documents and provide optimal query.
- Works with team members to ensure efforts within owned tracks of work will meet their needs.
- Communication and documentation.
Required Skills:
- 5+ years Working experiences with Starburst/TRINO, Impala, Hive, SparkSQL.
- Good knowledge with hadoop environment and distribution system.
- Strong data analysis, data evaluation and problem-solving skills
- Proficiency in SQL and debugging is crucial.
- Experiences with writing Python, Pyspark
- Identify and troubleshoot data issues and provide timely resolution.
- Great communication skills to explain technical to non tech team member.
- Great skills to understand business requirement and convert into tech requirement with action steps.
- .Agile experience.
Preferred Skills:
- Domain knowledge of data quality/data entitlement is a plus
SGA is a technology and resource solutions provider driven to stand out. We are a women-owned business. Our mission: to solve big IT problems with a more personal, boutique approach. Each year, we match consultants like you to more than 1,000 engagements. When we say let's work better together, we mean it. You'll join a diverse team built on these core values: customer service, employee development, and quality and integrity in everything we do. Be yourself, love what you do and find your passion at work. Please find us at https://sgainc.com/ .
SGA is an Equal Opportunity Employer and does not discriminate on the basis of Race, Color, Sex, Sexual Orientation, Gender Identity, Religion, National Origin, Disability, Veteran Status, Age, Marital Status, Pregnancy, Genetic Information, or Other Legally Protected Status. We are committed to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities in employment, and our services, programs, and activities. Please visit our company EEO page to request an accommodation or assistance regarding our policy.
Source : SGA Inc.