9-12 mo 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

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. You will reverse engineer Informatica (ETL) workflows.

RESPONSIBILITIES

Design and Migration:

1. Lead the migration of existing informatica workflows to SSIS packages, ensuring functionality and performance are maintained or improved
2. Analyze current Informatica workflows to understand data flow, transformations, and dependencies
3. Design streamlined ETL solutions
4. Develop and optimize SSIS packages for seamless data integration, transformation, and migration processes

Development and Implementation:

1. Build robust, scalable, and efficient ETL solutions using SSIS
2. Write and optimize SQL queries, stored procedures, and functions to support integration processes
3. Implement error handling, logging, and auditing mechanisms in SSIS packages

Testing and Optimization:

1. Perform thorough testing of migrated workflows and SSIS packages to ensure accuracy, performance, and reliability
2. Generate automated unit testing
3. Identify and resolve performance bottlenecks in both SQL Server and SSIS packages
4. Validate data integrity throughout the migration process

Documentation and Communication:

1. Prepare documentation for migrated workflows, including data mapping, process flows, and technical specifications
2. Maintain clear and consistent communication with project stakeholders regarding progress, challenges, and deliverables

Governance and Best Practices:

1. Ensure all work adheres to data governance, security, and compliance standards
2. Follow industry best practices for database development, ETL processes and data integration
3. Comply with the Bank’s 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
• Bachelor’s degree in computer science, Information Technology, or equivalent experience preferred