| SSIS / Informatica Database Developer/ Migrating Informatica Workflows to SSIS Packages // Irving Texas 75063 // , , -. at Irving, Texas, USA |
| Email: [email protected] |
|
http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=2341126&uid= Job Title : SSIS / Informatica Database Developer/ Migrating Informatica Workflows to SSIS Packages Federal Home Loan Bank of Dallas Location (Hybrid/ Onsite/ Remote): 500 Freeport Parkway South, Irving Texas 75063 Work Environment: Hybrid- Mon & Fri WFH / Tues-Wed-Thurs - IO , , -. Duration: 6-9 months Contract Only Interview Process: Candidates will be sent a Calendly Link to schedule a time to talk once I have reviewed the resume and they meet the requirements. Having Long Term contracts is a huge plus. 1st Round - 30-to-45-minute phone conversation with me to discuss their experience, what they are looking for in a company and other interview questions. 2nd Interview is MS Teams Video with the Bank 3rd Interview is On-site/ In-Person - NO EXCEPTIONS in Irving, TX If anything should be required during submission, please mention below 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 Candidates MUST be in the Dallas area and have no planned vacations for the next 3-months other than maybe a Friday. I need someone that has Informatica experience and or has done a migration recently from Informatica Workflows to SSIS Packages but if they do not have Informatica it is not a deal breaker but if they do, they will take priority over someone who does not. 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. About the job 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. This 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 -- Mike Lead Technical Recruiter [email protected] Max IT Consulting LLC A : 25 Oak Tavern Cir Branchburg, New Jersey - 08876 -- Keywords: information technology card microsoft Texas SSIS / Informatica Database Developer/ Migrating Informatica Workflows to SSIS Packages // Irving Texas 75063 // , , -. [email protected] http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=2341126&uid= |
| [email protected] View All |
| 10:26 PM 14-Apr-25 |