At Sapient Consulting, we are quite literally on the front lines of the biggest issues facing the global markets leaders today – investment banks, asset management firms, wealth managers, oil and energy firms, and government and regulatory agencies. Driving transformation and leading change within these industries requires big thinkers who bring insight, knowledge, technical acumen and passion for innovation. We offer the opportunity to join a recognized leader in developing and delivering groundbreaking solutions for today’s dynamic global marketplace and an award-winning culture that fosters growth and leadership.
As an ETL Developer at Sapient Consulting you will design and develop technology based business solutions for our clients in the financial services and energy trading industry. You may be required to play a team lead role for a small team and/or take on responsibility for the development for a specific component or track of the solution architecture. At all times you will actively support the development, and drive quality assurance during design and realization of the solution.
Provide technical leadership and support for inbound/outbound data integration (ETL), maintenance/tuning of applications, data model changes, data profiling, data quality assessment, executing and monitoring incremental updates, and working with infrastructure and DBA teams to maintain multiple environments (development/test/production).
At least 5+ years of experience in developing ETL solutions using IBM DataStage
Experience working in Teradata
Experience with pipeline & partitioning in DS
Knowledge of DS partition types & their differences
Work with business team to understand and design ETL solution for requirements.
Hands on experience in performance tuning DataStage Jobs (Parallel/Server), capacity planning and developing high volume data loads
Design, develop and test IBM DataStage Jobs and Sequences
Develops scripts to execute and test mappings and workflows
Must be facilitating the establishment and implementation of standards, guidelines and best practices that guide the various DataStage and Data Warehouse projects within the organization
Experienced in developing Sequencer Jobs, routines
Experienced working in an Agile environment
Strong communication skills
About Global Markets
Sapient Global Markets, a part of Publicis.Sapient, is a leading provider of services to today’s evolving financial and commodity markets. We provide a full range of capabilities to help our clients grow and enhance their businesses, create robust and transparent infrastructure, manage operating costs, and foster innovation throughout their organizations. We offer services across Advisory, Analytics, Technology, and Process, as well as unique methodologies in program management, technology development, and process outsourcing. Sapient Global Markets operates in key financial and commodity centers worldwide, as well as in large technology development and operations outsourcing centers.