Company:
Sonsoft Inc
Location: Clayton
Closing Date: 26/10/2024
Salary: £100 - £125 Per Annum
Hours: Full Time
Type: Permanent
Job Requirements / Description
Partner with IT lead and business owners to: Teradata/SQL Server development including: Informatica/ SSIS:
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 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:
- Remittance/ eligibility/ revenue reconciliation.
- Health benefit ratio (medical loss ratio) calculations.
- Effectively communicate development status in daily standups.
- Define technical requirements.
- Provide accurate level of effort estimates.
- Define scope of sprints.
- Define testing requirements.
- 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.
- 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. **
#J-18808-LjbffrShare this job
Sonsoft Inc