| Hiring Now :: SSIS ETL Database Developer :: Hybrid at Remote, Remote, USA |
| Email: amit@vyzeinc.com |
|
From: Amit Kumar Pradhan, Vyze Inc. amit@vyzeinc.com Reply to: amit@vyzeinc.com Job Description - Tittle : SSIS ETL Database Developer Visa: | USC | Green Card Work Type: Hybrid - Tuesday, Wednesday, and Thursday in the office with the team with Monday and Friday remote. Interview process: 1. Video 2 In Person Linkedin Must Verbal communication skills must be excellent. Resume MUST include the following: Candidate Legal Name (First and Last) I do not need a middle name. Phone number not a google voice number. Candidate email address City, State and Zip Code example (Dallas, TX 75051) LinkedIn profile URL Degrees, including University, City/State or Providence/Country and Month and Year received Resume MUST NOT have the following: Please do not send candidate that have half a page or more in the summary Only what they have had hands on experience with in the last 7 years. Bullet Points under their jobs should only include technologies that they have hands on experience using at that company NOT every technology the company uses. Role in Project: Migrating Informatica Workflows to SSIS Packages. Contract Duration: 69-month project but will extend as needed. Top Skills by Importance: SSIS and ETL Database Development are required. Informatica Highly preferred (if they have Informatica doesnt have to be heavy experience) . Will look at no Informatica candidates but prefers Strong SSIS and some Informatica. We are seeking a skilled database developer with expertise in designing and developing SQL Server Integration Services (SSIS) packages. In this role, you will collaborate with our team on a project to migrate existing Informatica workflows to SSIS packages, ensuring seamless and efficient data integration. his is an excellent opportunity to contribute your expertise to a dynamic and impactful initiative. RESPONSIBILITIES Design and Migration: Lead the migration of existing informatica workflows to SSIS packages, ensuring functionality and performance are maintained or improved Analyze current Informatica workflows to understand data flow, transformations, and dependencies Design streamlined ETL solutions Develop and optimize SSIS packages for seamless data integration, transformation, and migration processes Development and Implementation: Build robust, scalable, and efficient ETL solutions using SSIS Write and optimize SQL queries, stored procedures, and functions to support integration processes Implement error handling, logging, and auditing mechanisms in SSIS packages Testing and Optimization: Perform thorough testing of migrated workflows and SSIS packages to ensure accuracy, performance, and reliability Generate automated unit testing Identify and resolve performance bottlenecks in both SQL Server and SSIS packages Validate data integrity throughout the migration process Documentation and Communication: Prepare documentation for migrated workflows, including data mapping, process flows, and technical specifications Maintain clear and consistent communication with project stakeholders regarding progress, challenges, and deliverables Governance and Best Practices: Ensure all work adheres to data governance, security, and compliance standards Follow industry best practices for database development, ETL processes and data integration Comply with the Banks software development practices such as secure coding and change-control process JOB REQUIREMENTS Proven experience in SQL Server database development and SSIS package design with strong focus on ETL processes Hands-on experience migrating workflows from Informatica to SSIS Expertise in writing complex SQL queries, stored procedures and optimizing database performance Experience in ETL processes, data migration, and workflow transitions, specifically from Informatica to SSIS Familiarity with version control tools and deployment practices Ability to work independently, manage time effectively, and meet project deadlines Excellent analytical and problem-solving skills Ability to communicate issues and formulate recommendations Bachelors degree in computer science, Information Technology, or equivalent experience preferred PREFERRED SKILLS Experience with Azure DevOps Familiarity with other data integration tools and cloud-based data platforms Knowledge of version control tools and deployment practices Attention to detail and commitment to delivering high-quality work Keywords: Texas Hiring Now :: SSIS ETL Database Developer :: Hybrid amit@vyzeinc.com |
| amit@vyzeinc.com View All |
| 12:31 AM 22-Mar-25 |