| SSIS Informatica Database Developer Dallas, Texas Hybrid at Dallas, Texas, USA |
| Email: [email protected] |
|
http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=2325086&uid= From: Prveen Nagar, Vyze inc [email protected] Reply to: [email protected] Job Description - SSIS / Informatica Database Developer Contract Hybrid Work Environment - 3 days on-site (Tuesday, Wednesday and Thursday) All Candidates must currently live and work in the Dallas / Fort Worth, Texas areas About the job 6-9 mo Contract Only LinkedIn must 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. 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 Informatica and 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 Keywords: Missouri SSIS Informatica Database Developer Dallas, Texas Hybrid [email protected] http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=2325086&uid= |
| [email protected] View All |
| 10:35 PM 08-Apr-25 |