BizTalk Developer with SSIS Exp

Dellfor Technologies; California City (CA); On-site; USD 54,000 - 66,000; Full time

Benefits offered by this job

Starting salary between $60,000

Referral bonus

On the job support

Travel allowance

Insurance - medical, dental, vision, and 401K

Job summary

A technology solutions provider in California is seeking a BizTalk / SSIS Developer to manage interfaces and develop ETL processes. The ideal candidate should have over 5 years of BizTalk experience and 3 years of SSIS experience. Responsibilities include supporting BizTalk applications, ensuring data quality, and developing SQL queries. The role offers a starting salary of $60,000 with benefits including medical insurance and a referral bonus.

Qualifications

• 5+ years BizTalk experience managing interfaces.
• 3+ years SSIS experience.
• Full understanding of ETL concepts.

Responsibilities

• Manage and support BizTalk applications for claims processing.
• Ensure data integrity and quality through ETL.
• Develop and maintain ETL scripts and workflows.

Skills

BizTalk management

SSIS

Data quality

ETL concepts

SQL

Communication skills

Job description

Dellfor Technologies is founded by software professionals with a fresh approach and ideas empowering clients and partners in meeting unique challenges created by transforming business needs. Our technical, domain expertise across robust solutions. We strive to prove ourselves from project inception through completion.

As a global provider of IT staffing services, Dellfor Technologies connects the very best IT professionals to great opportunities at leading companies. We use our insight, flexibility and expanded resources to anticipate the needs of leading tech companies and help them make exceptional connections with top tech talent.

Job Description

ALL Visa ( Please No H1B & No OPT)

Overview

The BizTalk / SSIS Developer is responsible for managing and supporting the BizTalk interfaces, as well as the creation, support, and administration of ETL processes.

Responsibilities

• Manage, support, and update BizTalk application that processes electronic medical claims
• Along with other key personnel, ensure the overall data integrity and conformity of the information gathered. Manage data quality tasks through the ETL processes.
• Work with DBA Group, Development Teams, and Business Analyst to identify and understand source data systems, as well as provide input for enhancements for standardization and consistency across the Enterprise (Transactional systems, Data Warehouse, etc.)
• Map Import/Export Files to source system data. Map source data to data warehouse models.
• Develop and test extraction, transformation, and load (ETL) processes.
• Develop and maintain ETL scripts and workflows, SQL queries, VB/C++ script components, schedules, etc. using SVN for version control.
• Understand and maintain appropriate data release documentation and approvals according to company policies and procedures
• Define and capture metadata and rules associated with ETL processes.
• Develop processes to identify and analyze data quality issues and recommendations to resolve.
• Document, including diagrams, the architecture and components of the Reporting data warehouse.
• Modify existing ETL processes to improve performance and adapt to changing requirements.
• Use SQL Server query techniques and available tools, against the transaction system and the reporting data warehouse, to identify and analyze data quality issues.
• Perform daily review of production data processes to ensure successful completion
• Provide expertise in the review and correction of data integrity and / or reporting issues
• Review, understand, and provide feedback on functional requirements from a database perspective
• Provide data analysis/troubleshooting/creation support to QA, Developers, Support and others allowing them to complete their assignments.
• Develop, test, and debug new functionality, and maintain/enhance existing functionality in using SQL, stored procedures and API’s
• Will ensure ETL process and project documentation is updated and current for all release cycles.
• Performs performance tuning of queries and stored procedures.

Qualifications

• Has 5+ years BizTalk experience managing interfaces to/from various applications and databases
• Has 3+ years SSIS experience
• Design, customize, develop, and test BizTalk services in a multi-tier software systems environment.
• Full understanding of Extract Transform Load (ETL) concepts and technologies
• Full understanding of the processes of data quality, data cleansing, and data governance
• Must be able to clearly communicate in writing and orally to both technical and non-technical teams
• Medical experience preferred

Additional Information

Highlights and benefits

• We are a registered E verified company
• Starting salary between $ 60,000 with regular increments
• Referral bonus
• On the job support from experienced professionals in the relative field
• Travel allowance
• Insurance- Medical, dental, vision and 401K
• Health Benefits through Carefirst BCBS (Blue Cross Blue Shield)

Please respond with your resume. US Citizens and all other parties authorized to work in the US are encouraged to apply.