SysMind Tech
ETL - Datastage Developer
SysMind Tech, Farmington, Michigan, United States, 48331
Job Description:
Must Have Technical/Functional Skills The ETL Developer position focuses on ETL design, development and support. Responsible for ETL processes and tools as well as database loading and manipulation to ensure that the data needs are met throughout the course of the projects and production support. The developer will work to understand the business problems and opportunities in the context of the requirements and recommend solutions that enable the organization to achieve its goals. Additional responsibilities may include interpretation and transformation of information based on business requirements and conducting detailed research of vendor products and assists with general project management.
Experience Required: - 7+ Years
Roles & Responsibilities :Design and implement Extract, Transformation and Load (ETL) processes, programs and scripts.Assist with design and implementation of data warehouses, planning applications and reporting solutions.Develop solutions to leverage ETL tools and suggest process improvements.Provide ongoing maintenance and support of assigned ETL flows and their client applications.Collaborate with business users/developers to provide required data.Research and provide alternatives and recommendations based on best practices and application functionality.Understands the business processes, how the application supports the business processes and applies this knowledge to best solve problemsGains necessary input/approval of requirements and design and participates in code reviews and may perform code review for othersConduct root cause analysis and resolve production problems and data issues.Validate the data in the database and responsible for testing the routines developed.Lead user sessions for requirements gathering and testing.Assists in requirements gathering and creates system and user documentationCreate test plans, test cases, test scripts and performs functional testingAssist users with problems and resolves issues independently.
Must Have Technical/Functional Skills The ETL Developer position focuses on ETL design, development and support. Responsible for ETL processes and tools as well as database loading and manipulation to ensure that the data needs are met throughout the course of the projects and production support. The developer will work to understand the business problems and opportunities in the context of the requirements and recommend solutions that enable the organization to achieve its goals. Additional responsibilities may include interpretation and transformation of information based on business requirements and conducting detailed research of vendor products and assists with general project management.
Experience Required: - 7+ Years
Roles & Responsibilities :Design and implement Extract, Transformation and Load (ETL) processes, programs and scripts.Assist with design and implementation of data warehouses, planning applications and reporting solutions.Develop solutions to leverage ETL tools and suggest process improvements.Provide ongoing maintenance and support of assigned ETL flows and their client applications.Collaborate with business users/developers to provide required data.Research and provide alternatives and recommendations based on best practices and application functionality.Understands the business processes, how the application supports the business processes and applies this knowledge to best solve problemsGains necessary input/approval of requirements and design and participates in code reviews and may perform code review for othersConduct root cause analysis and resolve production problems and data issues.Validate the data in the database and responsible for testing the routines developed.Lead user sessions for requirements gathering and testing.Assists in requirements gathering and creates system and user documentationCreate test plans, test cases, test scripts and performs functional testingAssist users with problems and resolves issues independently.