JobsEQ by Chmura Logo

Senior Database Developer (Full Time)

Stellar Consulting Group LLC

Location: Tampa, FL 33601
Type: Full-Time, Non-Remote
Posted on: April 29, 2021
This job is no longer available from the source.
ETL, T -SQL
Full Time
Depends on Experience
Job Description
Senior Database Developer, will serve as a lead ETL developer and data analyst, responsible for understanding business requirements, performing data analysis, design, build, test, and implement functionalities based on the business requirements. The candidate will work extensively with Data Conversion Team to populate the Target database and provide reports with metrics on data conversion throughout the Software development life cycle (SDLC) of a complex pension administration solution.
Responsibilities
• Consult with the business owner and understand the functional requirements.
• Create a document based on the requirements and clarify any questions with the business owner.
• Analyze business requirements, analyze Source and Target Schema/Data and perform Source to Target Mappings.
• Based on business requirement and Mapping documents, design and develop the ETL Scripts and Stored Procedures.
• Test ETL program & Stored Procedures routines to eliminate errors.
• Execute the ETL Programs to migrate the data and troubleshooting any issues that may arise.
• Produce Data quality/count reports and Error reports.
• Conduct preliminary testing of the migrated data and ensure all the data has been transferred and meets the business needs.
• Provide maintenance support.
• Work with the IT management team on project priorities and deliverable timelines.
• Meet daily\weekly\monthly deadlines.
Qualifications
• Minimum 6+ years of experience in SQL Server, SSIS (ETL Processing)
• Has a strong understanding of the overall software delivery lifecycle and activities.
• Expertise in developing ETL packages using SQL Server Integration Services (SSIS)  ( Data Extraction, Transformation, and loading from heterogeneous Sources to SQL Server target).
• Strong in T-SQL Scripting. Designing, Developing, Testing SQL queries.
• Experience with Microsoft SQL Server 2005 or above.
• Experience with Microsoft SQL Server Security and User administration.
• Ability to analyze the data sources, identify the data issues and patterns before Data Migration.
• Ability to learn and support new and existing applications.
• Ability to work in a fast-paced work environment, manage time effectively and meet deadlines.
• Flexibility to work within technical framework with evolving business requirements.
• Excellent technical trouble shooting and code debugging skills.
• Strong customer focus, excellent problem solving and analytical skills.
• Excellent verbal, written, and social skills to communicate effectively with all levels of the organization.
• Manage projects with minimal supervision. Proactively addresses actions and issues.
• Reporting Tools, ETL Tools experience a plus
• Pension or Retirement domain experience a plus
Education
• Bachelor’s degree in Computer Science, IT, or related field.