Vacancy expired!
Our client, a banking company, is seeking an ETL Developer IV - Daily
Location: Jersey City, NJ Position Type: Contract Position Purpose: The North American IT Transversal Functions is working on implementing IT solutions to support various clients: Finance, Human Resources, Procurement, Premises & Logistics, Business Continuity Management, IT Security, etc. We are looking for a talented individual looking to join a dynamic environment where they can raise the bar for the industry. The person will be responsible for the success of IT TF projects by developing new, maintaining existing and supporting a number of in-house/vendor applications from the data warehouse, database and business intelligence perspective. The work will require analyzing business requirements, interpreting and understanding technical specifications and following instruction from the team lead, peer developers, business analysts and project managers. The scope of the engagement will include but not be limited to:- Review, understand, interpret and transform clearly defined technical specifications into data warehouse, database and/or business intelligence solutions
- Perform detailed data analysis (i.e. determine the structure, content, and quality of the data through examination of source systems and data samples)
- Perform problem analysis, structured analysis, design and programming techniques
- Use Data Modeling, Database Query Optimization and Data Access techniques and concepts
- Use Database knowledge in areas of import and export, users, roles, privileges, schema and object management, session monitoring, etc.
- Code, maintain, test and provide code reviews for developed processes and procedures (e.g. queries, scripts, stored procedures, database objects, indices, triggers, etc.)
- Apply strong performance tuning knowledge in SQL to interpret plans, identify bottlenecks in queries and remediate them
- Apply strong knowledge in Python and Shell Scripting required for file processing and database connections
- Work proactively to solve issues and problems
- Create use cases and assist in UAT testing efforts for the developed solutions
- Document, effectively track and resolve issues in a timely manner during the development and testing phases (work with the team and end users as appropriate)
- Provide weekly progress reports of work performed
- Work with the project team to assist in other aspects of the project
- Follow and adhere to the development standards, the software development lifecycle, vendor application / project standards and guidelines
- Embrace the opportunity to take on special projects outside of specific roles and responsibilities
- Closely interact with onshore stakeholders and onshore teams on a regular basis.
- Contribute towards knowledge sharing initiatives across the team
- Contribute towards Innovation and Creativity initiatives across the team and the organization.
- Oracle: SQL, PL/SQL (Mandatory)
- Unix Scripting
- Python Scripting
- AutoSys
- T-SQL, MS SQL
- Oracle: Warehouse Builder, Data Integrator
- Good working knowledge of data warehouse, database and business intelligence environments, concepts and techniques
- Good understanding of SDLC processes.
- Good understanding of concepts and techniques for design, development and implementation of ETL and data quality
- Strong coordination and organizational skills.
- Excellent communication skills (written and verbal) with the ability to explain complex issues in a simple concise manner
- Smooth communication with business users and be able to withstand the pressure.
- Multi-tasking capabilities.
Vacancy expired!