Data Engineer jobs

Informatica ETL Developer With SQL (SSIS) Experience is Must

Sonsoft Inc (agency)Clayton, MOContract

Pay not listed

Key facts

Experience
3+ years
US visa
No US visa sponsorship

2 things to check before you apply.

On Sonsoft Inc’s own careers site (SmartRecruiters), checked open today.

  • To check: Posted by the employer 9 years agoLong-open jobs are sometimes already filled. Ask when they plan to hire.
  • To check: No pay range listedAsk for the pay range before you interview.
  • Checked: On the company's own careers siteSmartRecruiters board
  • Checked: Checked open todaySmartRecruiters board
  • Checked: No reposts foundSmartRecruiters board
  • Trust score 60 / 100 · Check details
See all 6 checksShow fewer
How we check

What you’ll do

  • Analyze, design, build, test, and maintain application and ETL solutions for finance business needs.
  • Support remittance, eligibility, revenue reconciliation, and health benefit ratio calculations.
  • Create and maintain Teradata and SQL Server tables, views, macros, and stored procedures; analyze data and tune queries.
  • Maintain existing Informatica and SSIS solutions and packages, and develop portable production-ready packages for disparate data sources.

Summarised from the posting by AI and can be wrong. The full description is the source.

Requirements

Licenses and certifications

  • Teradata Certified Professional (preferred)

Experience

  • 3+ years of experience analyzing, designing, and building Teradata ETL solutions
  • Experience with Informatica and/or SSIS ETL tools
  • Healthcare or finance experience (preferred)

Skills

  • Strong experience with SQL on Teradata and/or SQL Server
  • Understanding of database design and modeling

Other requirements

  • Authorized to work independently in the United States; sponsorship is not available
  • Eligible applicants include U.S. citizens, Green Card holders, GC-EAD, H4-EAD, L2-EAD, OPT-EAD, and TN visa holders; H1B candidates are not eligible

Your match

Sign in and add your resume to see which of this job's requirements it shows.

Sign in to check your match

Saved to your account, encrypted. The AI that reads it doesn't keep it or train on it.

Full job description

From Sonsoft Inc’s careers site

Company Description

Sonsoft , Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled Services.

Job Description

Show full descriptionShow less

Senior Application Software Engineer (ETL/ SQL) Reports to IT Manager, Business Intelligence (Financial Analytic Solutions) Responsibilities ? Analyze, design, build, test and maintain scalable and stable off the shelf application or custom built technology solutions to meet business needs. ? Contribute to the entire implementation process including driving the definition of improvements based on business need and architectural improvements ? Meet with business partners to understand business needs ? Responsible for overall design of the solution ? Conduct root cause analysis and advanced performance tuning for complex business processes and functionality ? Act as a subject matter expert for Application Software developers and Engineers Specific Assignments ? The position is aligned with our Finance business partners and is to support their key projects o Remittance/ eligibility/ revenue reconciliation o Health benefit ratio (medical loss ratio) calculations ? Partner with IT lead and business owners to o Effectively communicate development status in daily standups o Define technical requirements o Provide accurate level of effort estimates o Define scope of sprints o Define testing requirements ? Teradata/SQL Server development including o Table/view creation o Macro creation/maintenance o Stored procedure creation/maintenance o Analyzing data and queries to collect relevant statistics and create applicable indexes, or for production issues o Performance tuning of queries for better performance o Partner with DBA as needed ? Informatica/ SSIS o Maintain existing Solutions and Packages o Develop new solutions and packages connecting to disparate data sources o Develop portable production ready packages Experience ? 3+ years of experience analyzing, designing, and building Teradata ETL solutions ? Strong experience with SQL on Teradata and/ or SQL server ? Experience with Information and/ or SSIS ETL tools ? Understanding of database design and modeling ? Teradata Certified Professional preferred ? Healthcare or Finance experience a plus

Additional Information

** U.S. Citizens and those who are authorized to work independently in the United States are encouraged to apply. We are unable to sponsor at this time.

Note:-

  • This is a Contract job opportunity for you.
  • Only US Citizen, Green Card Holder, GC-EAD, H4-EAD, L2-EAD, OPT-EAD & TN-Visa can apply.
  • No H1B candidates, please.
  • Please mention your Visa Status in your email or resume.

** All your information will be kept confidential according to EEO guidelines.

Something wrong with this job? Report it · This flag looks wrong

Similar jobs

Sr Data Engineer

National Information Solutions Cooperative (NISC) · Cedar Rapids, IA +2 places

Hybrid

Looks goodPay not listedChecked open todayPosted 8 days ago

ETL Developer

GRVTY · McLean, VA

$150k–$250k/yr

StrongChecked open todayPosted 12 days ago

See more like this