JerseyCityRecruiter Since 2001
the smart solution for Jersey City jobs

ETL Developer

Company: SkillStorm
Location: Jersey City
Posted on: January 11, 2022

Job Description:

SkillStorm is seeking an ETL Developer for our client in Jersey City, NJ. Candidates must be able to work on SkillStorm's W2; not a C2C position. EOE, including disability/vets.Job Description:Over 10 years of IT experience with ability to work in multi technology project -Works with IT staff, business, FLUs through design, coding and implementation of onboarding data source files providing clarifications and data quality as necessary. -Strong Development experience of ETL development and ETL architecture using Informatica, and understanding and building the flat file/Fixed file structures -Strong Oracle Database technical knowledge in building general SQL and PL/SQL, stored procedures, cursors, triggers, performance tuning etc--- -Strong UNIX Shell scripting , experience working with Red Hat Linux, creation of Autosys jobs, and build Oracle reports -Strong hands on experience in ETL solution design and creation of design specifications to implement changes -Perform Functional and technical impact analysis of potential changes to the clients ETL environment -Hands on using and configuring Informatica tools -Source Analyzer, Power center Designer, Power Center Repository Manager, Power Center Workflow Manager, Power Center Workflow Monitor -Perform Data analysis, data mapping, data loading, and data validation using informatica and oracle, and implement data controls -Provide L3 support and guidance to production support team on production instances, run book, control plan, and source related audit/data requests -Support other ETL developers; providing mentoring, technical assistance, troubleshooting and alternative development solutions -Should be able to design, develop, create mapping, and support application solutions with focus on Informatica architecture. -Should be able to propose best practices and opt for changes in the upgraded versions of Informatica tool -Excellent oral/written communication skills -Organized and able to multi-task in a fast-paced environment -Highly motivated, able to work independently, self-starter; and problem/solving/analytical -Excellent interpersonal skills; positive attitude; team player; flexible -Willingness to learn and adapt to changes -Good to have business knowledge in financial domains related to Economic Sanctions, Anti-Money LaunderingRequired Skills:Demonstrable experience of minimum 10-12 years of work experience as ETL Informatica/Oracle and in the capacity of an Architect with total experience in IT including but not limited toWorks as an Application Manager and as a Feature Lead to manage all the activities around application management and governance.As an App Manager own the responsibility of managing a critical compliance application , working closely with compliance and operations on Regulatory Requirements to provide optimal solutions .Works closely with Information Technology staff, business, FLUs, COE through the phases of design, coding and implementation of onboarding data source files providing clarifications and data quality as necessary. Maintains effective ongoing communications with the business and IT community and operational management regarding system plans, projects, ,and economic sanctions policiesDevelopment experience at ETL development and ETL architecture using Informatica and understanding the flat file/Fixed file structuresStrong Oracle Database technical knowledge in building general SQL and PL/SQL, stored procedures, cursors, triggers etc---Strong experience on Informatica Designer Components and development tools -Source Analyzer, Power center Designer, Power Center Repository Manager, PowerCenter Workflow Manager, PowerCenter Workflow Monitor using UnixStrong hands one experience in UNIX Shell scripting , Autosys creation skillsPerform Data analysis, data mapping, data loading, and data validation using informatica and Oracle, and implement data controlsUnderstand reusability, parameterization, Informatica workflow designs, and build Oracle reportsSupport other ETL developers; providing mentoring, technical assistance, troubleshooting and alternative development solutionsOracle Performance tuning and end-to-end lifecycle experience with Enterprise wide data and optimize the execution timingsPerform overall solution design and creation of design specifications to implement changesPerform Functional and technical impact analysis of potential changes to the clients requirementsExperience with migration projects in AML and economic sanctions is a plus.Good written and verbal communication skillsWorking experience in Agile methodology and JIRA is preferredIndependent learner with no hand holding and be able to handle production releases in a shared environment#LI-DNI

Keywords: SkillStorm, Jersey City , ETL Developer, IT / Software / Systems , Jersey City, New Jersey

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Log In or Create An Account

Get the latest New Jersey jobs by following @recnetNJ on Twitter!

Jersey City RSS job feeds