Lead ETL Developer

Lead ETL DeveloperAs a SSIS ETL Consultant you will participate in all aspects of the software development lifecycle which includes estimating, technical design, implementation, documentation, testing, deployment and support of applications developed for our clients.You will be part of the team to create the architecture and implement enterprise-scale integration solutions integrate, transform and load master and reference data from multiple source systems using ETL frameworks and platforms using Microsoft's SQL Server Integration Services (SSIS) platform.Mandatory Skills:MS SQL Server Integration Services (SSIS)MS SQL Server 2008/2012/2014/2016Experience integrating SSIS to SOAP and/or REST APIs-based interfacesRoles and responsibilities:Design and develop ETL programs primarily using SSIS packages and frameworksExtract, transform & load data from both relational-, flat file, and API-based operational data sourcesConvert legacy integration processes to utilize SSIS framework.Implement detection and capture strategies for extracting only changed data.Implement performance improvement & tuning of SSIS packages & mappingsPerform source data analysis and data profiling to detect and resolve integration issues.Be able to produce code that is well-formatted, documented and highly efficient.Test and implement functional requirements to meet expected quality and results.Create necessary documentation as per SDLC standardsUpload the source code to version control toolsPerform unit testing of programs and support QA on End-to-End testingWork with deployment team in the code migration across the SDLC environmentsTriage the Production issues and work on the code fixesMay participate in a 24x7 rotational on-call responsibilityMandatory Qualifications:7+ years of experience performing data batch-oriented integration of both operational and analytical platform environments3+ years SQL Server 2008/2012/2014/2016 experience3+ years SSIS 2008/2012/2014/2016 ETL development experience1+ years experience integrating SSIS to SOAP and/or REST APIs-based interfaces.Must have first-hand experience with at least 2-3 large to medium scale ETL implementation projects supporting either an MDM and/or data warehouse platformsExperience developing in all phases of the full SDLC of a project is required.Knowledge and experience in developing software using agile methodologies.Ability to apply design concepts - layered architectures, components, interfaces, messaging and patterns.Solid foundation in Computer Science, with strong competencies in data structures, algorithms and software design.Proficient in authoring, editing and presenting technical documents.Ability to communicate effectively via multiple channels (verbal, written, etc.) with technical and non-technical staff.Preferred Qualifications:Experience working banking / financial services industryExperience working with MDM platforms like TIBCO MDM, Informatica, Orchestra, etc.