ETL Developer (Closed)
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 Laundering
Required 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 to
- Works 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 policies
- Development experience at ETL development and ETL architecture using Informatica and understanding the flat file/Fixed file structures
- Strong 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 Unix
- Strong hands one experience in UNIX Shell scripting , Autosys creation skills
- Perform Data analysis, data mapping, data loading, and data validation using informatica and Oracle, and implement data controls
- Understand reusability, parameterization, Informatica workflow designs, and build Oracle reports
- Support other ETL developers; providing mentoring, technical assistance, troubleshooting and alternative development solutions
- Oracle Performance tuning and end-to-end lifecycle experience with Enterprise wide data and optimize the execution timings
- Perform overall solution design and creation of design specifications to implement changes
- Perform Functional and technical impact analysis of potential changes to the clients requirements
- Experience with migration projects in AML and economic sanctions is a plus.
- Good written and verbal communication skills
- Working experience in Agile methodology and JIRA is preferred
- Independent learner with no hand holding and be able to handle production releases in a shared environment
#LI-DNI