Sonsoft Inc
Informatica ETL Developer With SQL (SSIS) Experience is Must
Sonsoft Inc, Clayton, Missouri, United States,
Informatica ETL Developer With SQL (SSIS) Experience is Must
ContractSonsoft , 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 custombuilt technology solutions to meet business needs.? Contribute to the entire implementation process including driving the definition ofimprovements 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 processesand functionality? Act as a subject matter expert for Application Software developers and EngineersSpecific Assignments? The position is aligned with our Finance business partners and is to support their key projectso Remittance/ eligibility/ revenue reconciliationo Health benefit ratio (medical loss ratio) calculations? Partner with IT lead and business owners too Effectively communicate development status in daily standupso Define technical requirementso Provide accurate level of effort estimateso Define scope of sprintso Define testing requirements? Teradata/SQL Server development includingo Table/view creationo Macro creation/maintenanceo Stored procedure creation/maintenanceo Analyzing data and queries to collect relevant statistics and create applicable indexes, orfor production issueso Performance tuning of queries for better performanceo Partner with DBA as needed? Informatica/ SSISo Maintain existing Solutions and Packageso Develop new solutions and packages connecting to disparate data sourceso Develop portable production ready packagesExperience? 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
ContractSonsoft , 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 custombuilt technology solutions to meet business needs.? Contribute to the entire implementation process including driving the definition ofimprovements 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 processesand functionality? Act as a subject matter expert for Application Software developers and EngineersSpecific Assignments? The position is aligned with our Finance business partners and is to support their key projectso Remittance/ eligibility/ revenue reconciliationo Health benefit ratio (medical loss ratio) calculations? Partner with IT lead and business owners too Effectively communicate development status in daily standupso Define technical requirementso Provide accurate level of effort estimateso Define scope of sprintso Define testing requirements? Teradata/SQL Server development includingo Table/view creationo Macro creation/maintenanceo Stored procedure creation/maintenanceo Analyzing data and queries to collect relevant statistics and create applicable indexes, orfor production issueso Performance tuning of queries for better performanceo Partner with DBA as needed? Informatica/ SSISo Maintain existing Solutions and Packageso Develop new solutions and packages connecting to disparate data sourceso Develop portable production ready packagesExperience? 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
or
resume .** All your information will be kept confidential according to EEO guidelines.
#J-18808-Ljbffr