Need Active LinkedIn profiles.
Job Title: ETL Developer
Location: Raleigh, NC
Work Mode: Hybrid (3 Days Onsite per week)
Duration: 6+ months Contract
MOI: Phone/Skype
Visa: No H1’s & OPT
Client: First Citizens Bank
Job Description:
- Design of complex ETL interfaces with agnostic tool set for various source/target types
- SAP BODS is preferred.
- Performance Tuning & Troubleshooting skills across all technologies used
- Strong in DB and SQLs with decent data modeling skills
- Ability to lead the developers and QA and adhere to timelines committed.
- Agile experience is preferred.
- Ability to work with both upstream, downstream and reporting system stakeholders and convert the business requirements into technical requirements / JIRA stories.
- 10+ years of experience in ETL tools, repository maintenance, migration of jobs/workflows/dataflows, job monitoring, break fix, user maintenance, CDC, Oracle Golden Gate, worked with different sources targets to load the data (Oracle, SAP, Files as source; SQL Server, file uploads etc. as targets).
Responsibilities:
- Responsible for Planning, Developing, Implementing and Managing Data Warehouse Project Deliverables, Design Documents and High-Level Data Mapping for ETL Specifications
- Create transformations in ETL jobs to achieve data cleansing and standardizations during initial data load
- Provide support for integration testing, defect fixing and deployment.
- Proficient knowledge in transformations like Query, push down, SQL, Table Comparison, Pivot, Look up () etc.
- Proficient Knowledge in Databases like Oracle (SQL Queries), SQL Server
- Proficient Knowledge in Dimensional modelling, Data Mining and Data warehouse concepts
- Should have Excellent Analytical Skills
- Knowledge to transfer data from Oracle, SQL Server tables and Web Services either Incrementally (Delta Load) or full Load to the Data warehouse on periodic basis.
- Knowledge in Troubleshooting existing ETL jobs and improve performance of the existing jobs
- Should be able to create and load data into Aggregate Tables using transformations.
- Should be able to perform tasks individually and independently
Regards,
Sucheta Chauhan
Direct Voice: (201) 484 – 7129 | [email protected]
LinkedIn: linkedin.com/in/sucheta23
Voto Consulting LLC | http://www.votoconsulting.com
1549 Finnegan Lane, 2nd floor, North Brunswick, NJ 08902