ETL Developer
Location: Wilmington DE
Length: 1 year with the option to extend
Interview process: Phone then onsite
Software Design, Programming and Unit Testing
• Strong database (Oracle) skills including database design,
development (packages, functions, procedures)
• Strong data warehousing and OLTP system knowledge from
database/ETL development perspective.
• Database code performance tuning skills required
• Designing software modifications from supplied requirements and
design specifications using agreed standards and tools, achieving
well-engineered results that follow the agreed implementation level
software architectures.
• Taking responsibility for the design, coding, testing, and
documentation (as defined by the SDLC process) of particularly large,
complex or mission critical software programs.
• Proposing options and preparing cost estimates to enable the
business area to make informed decisions
• Adhere to all BCUS standards, Policies and governance practices.
• Assume ownership of various initiatives across Solutions Delivery
as agreed with Team Lead for complete and successful delivery.
• Provide functional expertise within his/her skills to assist
delivery team members, and foster collaboration within Technology.
• Provide issue response and root cause analysis on work assigned by
Team Lead and Project Lead.
• Planning, designing and conducting Unit and System Integration
Tests, correcting errors and re-testing to deliver an error-free product.
• Reacting quickly and as necessary to live software errors and
service problems, limiting downtime and resolving the problem during
project handover.
• Report progress, delays and risks on assigned activities to
Project Lead and Team Lead.
• Raise awareness when existing code, systems or processes do not
meet current quality expectations and standards.
• Maintain code and all related artifacts in source control; perform
code merges and resolve conflicts as defined by development process, update
documentation and automated tests.
• Develop code, configuration files, build scripts, schemas or other
artifacts as assigned by Team Lead.
• Develop system integration test to verify the code running in its
functional environment.
• Work with the Project Lead and Team Lead to schedule features into
Releases.
• Create implementation plans and Change Management Requests as
assigned.
• Maintain accurate feature status during development by the agreed
upon SLA.
• Verify build and deployment completeness of the features owned in
the QA environment before making it available for Testing.
• Review the feature requirements as presented by the Business
Analyst and the delivery team, in context of the overall project feature
set and existing implementation. Translate requirements to technical
concepts.
• Contribute to the logical/physical data models, class diagrams,
activity diagrams, sequence diagrams and UI prototypes.
• Assist QA and production testing and deployment; assume ownership
of the work until it passes successful Production Verification Test.
• Test all code, content, build and unit test changes in the lowest
environments first, if such environments exist.
• Taking part in reviews of own work and leading reviews of
colleagues’ work.
Technical Knowledge
• Strong data warehousing and OLTP system knowledge from
database/ETL development perspective.
• Strong Oracle database knowledge including database design,
development (package, procedure, functions, indexes)
• Database code (SQL and PLSQL) performance tuning skills
• Datastage 8.1 knowledge required
• Unix commands and shell scripting knowledge
• Big Data – Hadoop, Hadoop Spark
• NoSQL Databases: MongoDB, Cassendra
*Needed some details for submission process -*
*Full Legal Name : Contact Number :
Email ID : Current
Location : *
*Relocation :*
*Last 4 digit of SSN : Skype ID
: DOB(MM/DD) : *
*Availability to Join : *
*Work authorization :*
*Education, University, Year:*
*Regards*
*Vishal Ji Awasthi*
*Srimatrix Inc.*
[image: Logo.png]
E-Mail:*[email protected] <[email protected]>*
Phone: *214-227-9311(Direct)*
Web: www.srimatrix.com