Informatica ETL Developer With SQL (SSIS) Experience is Must

Sonsoft Inc; Clayton (MO); On-site; USD 80,000 - 100,000; Full time

Job summary

A software development firm is seeking an Informatica ETL Developer with SQL (SSIS) experience in Clayton, Missouri. The ideal applicant will have over 3 years of experience in Teradata ETL solutions and strong skills in SQL on Teradata or SQL Server. Responsibilities include designing and maintaining scalable applications, collaborating with IT leads and business partners, and conducting advanced performance tuning. This is a contract opportunity for U.S. citizens and authorized workers only.

Qualifications

• 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.

Responsibilities

• Analyze, design, build, test and maintain scalable applications.
• Contribute to the entire implementation process with partners.
• Conduct root cause analysis and advanced performance tuning.

Skills

Teradata ETL solutions

SQL on Teradata

SSIS ETL tools

Database design understanding

Performance tuning

Tools

Teradata

SQL Server

Informatica

Job description

Informatica ETL Developer With SQL (SSIS) Experience is Must

• Contract

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.

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 applications 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:
  • Remittance/eligibility/revenue reconciliation
  • Health benefit ratio (medical loss ratio) calculations
• Partner with IT lead and business owners to:
  • Effectively communicate development status in daily standups
  • Define technical requirements
  • Provide accurate level of effort estimates
  • Define scope of sprints
  • Define testing requirements
• Teradata/SQL Server development including:
  • Table/view creation
  • Macro creation/maintenance
  • Stored procedure creation/maintenance
  • Analyzing data and queries to collect relevant statistics and create applicable indexes, or for production issues
  • Performance tuning of queries for better performance
  • Partner with DBA as needed
• Informatica/ SSIS:
  • Maintain existing Solutions and Packages
  • Develop new solutions and packages connecting to disparate data sources
  • 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

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.