About this opportunity
Sonsoft Inc lists this Informatica ETL Developer With SQL (SSIS) Experience is Must opportunity in clayton, Missouri. Review the employer’s description below for duties, qualifications and application requirements.
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.
#J-18808-Ljbffr
Who can apply
Review the original listing for work authorization, qualifications and employer requirements.