ETL Specialist

• Perform requirement gathering and analysis with business stakeholders • Perform hands-on ETL solution design, development, test execution and production deployment. • Communicate and build strong positive rapport with various business and technology stakeholders. • Provide BAU support for existing and new data platforms • Collect multiple streams of data and decompose them into concise specifications. • Assist in identifying data quality problems and in determining options for how they will be handled • Ensure that final product meets requirement specifications. • Follow company and industry defined best practices to ensure smooth and continuous product development operations. • Develop process improvements that ensure product quality and productivity. • Communicate product efficiency or enhancement ideas and concepts to Manager. • Review and recommend changes to current product development processes. • Maintain expert knowledge on product development procedures. • Maintain product requirements, technical and functional documentations for release management. • Analyze and troubleshoot product issues in a timely fashion. • Understand and evaluate existing SQL and or Data Modeling. • Design and develop queries for a high-performance environment. • Develop, manage and maintain data dictionaries, metadata, and process flow documentation. • Design, develop and implement complete solutions throughout the product life cycles. • Maintain and manage revisions of code in production, testing and development environments. • For a data consolidation based project who can provide skills to drive solutions from the requirements phase through delivery, with preferred financial industry experience. The developer will be responsible for delivering high quality solutions that meet design requirements and technical specifications within stipulated timeline. • Contribute to the specification and software design phases of the software development life cycle and performing and aiding in quality assurance testing, performance testing, troubleshooting application and environment issues, and production support. • Accountable to development and delivery of solutions that meets and exceeds quality standards • Deliver multiple projects on-time, on-budget and with targeted zero defects • Coordinate with offshore resources on development projects from requirements through delivery. • Provide support for Quality Assurance testing • Provide support for ETL batch job issues in lower environments and in Production if need arises • Provide estimation and coordination of technical activities related to system development • Ensure solutions alignment to Enterprise Architecture policies and best practices; ensure that process methodologies are followed in system development • Create technical documentation including the Technical Design document • Manage day to day technical challenges and communicate to project manager any risks or issues associated with the development activities • Participate in Code Reviews and provide inputs on necessary corrections if needed • Identify opportunities for system reuse and system simplification • Collaborate with IT partners to devise capacity plan and ensure appropriate infrastructure for the end to end system delivery