REG: BizTalk / SSIS Developer :: Ontario, CA
Santhosh Kumar
Hello All,
Please be advised that our direct client has an opening of BizTalk / SSIS Developer for Ontario, CA location. Please provide the customary onboarding info when presenting candidates (given in template below).
Position: BizTalk / SSIS Developer
Location: Ontario, CA
Role details -
Will you be interviewing (face to face or phone): Both
Please confirm the worksite location: Ontario, CA
What are the hours? (Training hours?) 8:00 AM – 5:00 PM PST – no training hours
Duration: 6 months with probable extension
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
Template:
Full Legal Name as in Driving License/Passport:
Email Address:
Phone Number:
LinkedIn Profile:
Birth Month and Day (MM/DD, i.e., June 8 or 06/08):
Last 5 digits of SSN/Passport/Other ID:
Current Location:
Work Authorization/Visa Status:
Earliest availability for Phone, Web, Videoconference, and/or On-Site interview:
CTC:
Employment Type (W2, C2C, etc.):
Current Employer:
Earliest possible start date:
Two Professional References (Name, Title, Company, Length of Time Known, Phone, Email):
Thanks and Regards
Srinivas| Talent Acquisition, Menzo Technologies Corp 1146 Easton ave, Somerset, New Jersey-08873 |
Note: We respect your online privacy. This is not an unsolicited mail. Under Bills 1618 Title III passed by the 105th US Congress this mail cannot be considered spam as long as we include Contact information and a method to be removed from our mailing list. If you are not interested in receiving our e- mails then please reply with a "Remove" in the subject line and mention all the e-mail addresses to be removed with any e-mail addresses, which might be diverting the e-mails to you. I am sorry for the inconvenience if any causedto you.