Senior ETL Developer - IBM DataStage:

Company: LanceSoft Inc
Location: Alpharetta
Posted on: November 18, 2021

Job Description:

Job DescriptionSummary:The candidate must be a self-starter, who can work under general guidelines in a fast-paced work environment. Overall minimum of 7 years of experience in business intelligence / Data Warehousing tools / technologies.Experience in data integration using IBM Information server 11.x is a must.Responsibilities:Able to design and develop data stage (ETL) common data integration templatesIBM Information server 11.x application administrationPerform deep technical analysis by reverse engineering exiting business logic embedded in Unix / Perl / Data Stage jobs.Work as ETL SME to understand and drive analytical/business requirementsPrepare detailed ETL designPrepare and validate end to end business logic and mappings.Develop ETL jobs, prepare unit test cases, test data and perform unit testingCode review with Data Integration SMEPrepare detailed design, architecture, mapping sheet and other ETL documentsData Stage code roll and deploymentResolve all technical issues raised during SIT/UAT/Warranty phasesPrepare root cause corrective action document for the ETL issuesPerform batch support for EDW / AWS jobs on rotation.Requirements:Industry Name - Experience - PreferenceBanking and Brokerage - 3+ Years - PreferredIndustry Function - Experience - PreferenceInformation Technology - 7+ Years - RequiredFinancials, Marketing - 3+ years - preferredTechnology/Business DomainBI / Data Warehousing - 7+ years - requiredBig Data - 2+ years - PreferredCloud Technologies (AWS) - 1+ year - DesiredTechnology /Application Category - Experience - PreferenceData Integration (ETL) technologies - 7+ Years - requiredHadoop Technologies, OLAP Technologies - 1+ year - preferredAWS Analytics - 1+ year - preferredAWS Snowflake - 1+ year - preferredAzure Analytics - 1+ year - preferredAzure Snowflake - 1+ year - preferredTech/ Product Tools - Experience - PreferenceData Stage (IBM Information Server 11.x) - 6+ Years - requiredUNIX / Python Scripting - 5+ years - requiredPL / SQL - 6+ Years - Required (Expert Level)SVN, GitHub, Control M / JCL - 3+ years - PreferredSoft Skills - PreferenceExcellent Communication - RequiredExcellent Analytical Ability - RequiredSpecial Requirements - PreferenceETL Batch System Support - preferredEDUCATION, CERTIFICATION, TRAINING:Minimum bachelors degree or equivalent to bachelors in computer science - required*//EEO EmployerMinorities/ Females/ Disabled/ Veterans/ Gender Identity/ Sexual Orientation//*

Keywords: LanceSoft Inc, Alpharetta , Senior ETL Developer - IBM DataStage:, IT / Software / Systems , Alpharetta, Georgia