Informatica ETL Developer With SQL (SSIS) Experience is Must

Posted 17 Days Ago
Be an Early Applicant
Clayton, MO, USA
In-Office
Senior level
Information Technology • Professional Services • Software • Consulting
The Role
Design, build, test and maintain ETL solutions for finance/healthcare analytics. Develop and maintain Informatica/SSIS packages, Teradata/SQL Server objects, perform performance tuning, root cause analysis, and collaborate with business partners and DBAs.
Summary Generated by Built In
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

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:-

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

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

Skills Required

  • 3+ years analyzing, designing, and building Teradata ETL solutions
  • Strong SQL experience on Teradata and/or SQL Server
  • Experience with Informatica and/or SSIS ETL tools
  • Understanding of database design and modeling
  • Authorized to work in the United States (US Citizen, Green Card, GC-EAD, H4-EAD, L2-EAD, OPT-EAD, TN-Visa); no H-1B candidates (no sponsorship)
  • Teradata Certified Professional
  • Healthcare or Finance domain experience
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
87 Employees
Year Founded: 2007

What We Do

SonSoft Inc. is a global consulting and IT services firm specializing in software development, software consultancy, and Information Technology Enabled Services (ITES). The company provides a range of expertise including business consulting, systems integration, application development, and product engineering, helping clients re-engineer and re-invent their businesses to compete in a changing marketplace.

Similar Jobs

People Inc. Logo People Inc.

Senior Software Engineer

AdTech • Consumer Web • Digital Media • eCommerce • Marketing Tech
Remote or Hybrid
US
3500 Employees
160K-195K Annually

SailPoint Logo SailPoint

Answer Engine Optimization (AEO/GEO) Manager

Artificial Intelligence • Cloud • Sales • Security • Software • Cybersecurity • Data Privacy
Remote or Hybrid
2 Locations
2461 Employees
101K-171K Annually

Artera Logo Artera

Head of Segment

Healthtech • Sales • Software • Analytics • Conversational AI
Easy Apply
Hybrid
3 Locations
250 Employees
200K-300K Annually

Artera Logo Artera

Solutions Engineer

Healthtech • Sales • Software • Analytics • Conversational AI
Easy Apply
Hybrid
3 Locations
250 Employees
120K-134K Annually

Similar Companies Hiring

Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees
Kepler  Thumbnail
Fintech • Software
New York, New York
6 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account