Lead ETL Developer Job at Omega Solutions Inc, West Pittsburg, PA

  • Omega Solutions Inc
  • West Pittsburg, PA

Job Description

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.

Job Tags

Similar Jobs

Regal Rexnord

Manufacturing Engineer II Job at Regal Rexnord

 ...is a fully onsite role, with work performed at your designated Regal Rexnord office. ____________________ The Manufacturing Design (MD) Engineer plays a key role in Portescaps Slotted Brushless DC motor product line, supporting applications in surgical hand tools... 

idealforce

.Net Web Developer (40913) Job at idealforce

Company DescriptionIDEALFORCE has a CONTRACT position available immediately for a .NET Developer to join our customer in Phoenix AZ. This is an ONSITE contract role. Please find below additional details about this job. Kindly respond with your most up to date resume if... 

Raytheon

Additive Manufacturing Materials Engineer Job at Raytheon

 ...us and help shape the future of aerospace and defense.The Additive Manufacturing Process and Capability Center (AMPCC) encompasses a critical...  ...for our business units. The Additive Manufacturing Materials Engineer will be challenged with solving unique and interesting... 

Honda Dev. and Mfg. of Am.,LLC

Manufacturing Quality Senior Engineer Job at Honda Dev. and Mfg. of Am.,LLC

 ...progress and performance against NM Project, plan versus actual. Resolve quality problems as a subject matter expert through FTA, engineering theory, etc. Coordinate with other areas in the organization to secure specialized resources and contributions for the project/... 

Merry Maids

House cleaning Job at Merry Maids

 ...Merry Maids Cleaning Services Merry Maids is currently looking for enthusiastic, hard-working...  ...Friday from 8:00 to 4:00. We do not work nights, weekends or holidays. We begin and end...  .... We have implemented staggered start times and once trained, employees typically work...