Browse Jobs
For Employers
Post JobLog inGet Started

ETL Consultant

Singleclic
Cairo, Egypt
Posted 4 years ago
16Applicants for1 open position
  • 1Viewed
  • 0In Consideration
  • 0Not Selected
Search other opportunities

Job Details

Experience Needed:
Career Level:
Education Level:
Salary:
Job Categories:

Skills And Tools:

Job Description

Job Summary:

The ETL Consultant will work as part of the Data Management Team, which manages the data related toolsets such as analytics tools, data warehousing appliances, data integration, LDAP and more. This role is to manage, configure, and tune Information platform to ensure high levels of performance, availability, and security of the supported applications.
This individual also participates in the planning and implementation of policies
and procedures to ensure system provisioning and maintenance that is consistent with Departmental goals, industry best practices, and regulatory requirements. Knowledge of the IBM InfoSphere Information Server platform, Redhat LINUX, shell scripting, LDAP, networking, and server virtualization are critical to successful performance in this role, while knowledge of Docker and Kubernetes will be assets. As a ETL Consultant you will apply your deep expertise in designing, development, code fix and testing the applications. Should be comfortable in an agile environment. You should have demonstrated development support skills

Job Description:

  • Involved in the Business Requirements gathering wherein the client’s business process is studied in detail.
  • Business Requirements is understood and analyzed by having frequent interaction with various user levels to understand their requirements.
  • Involve in mapping of clients business requirements to the Reports and
  • Dashboards to come out with a clear cut picture of the DWH data model to be designed.
  • Create Low level design documentation from the High level requirement from the business team.
  • Create ETL Unit test cases
  • Design and development of ETL processes using DataStage against variety data sources
  • Troubleshooting and performance tuning of ETL jobs
  • Handling Technical issues, Involve in Code reviews, mentoring the team members.
  • Working knowledge in DML commands, complex SQL queries, data movement methods from various sources.
  • Will be the key developer for new requirements and data base performance, stability and availability.
  • Will work across several brand groups within GBM to understand the data requirements, where to source data along with design/enable/code/deliver against the business requirements
  • Work closely with Cognos report writers to ensure they understand the data and can deliver the reports the business is looking for
  • Develop or assist with business and functional requirements, project scope, estimates of effort and duration (especially for the ETL part as a developer and administrator).
  • Translate functional and business requirements into technical requirements.
  • Conduct, assist with, and/or manage unit and system tests.
  • Establish technical standards for the technical framework.
  • Install, configure, update, and administer IBM InfoSphere products, including the full InfoSphere Information Server Enterprise Edition on windows/linux virtualized environment.
  • Participate in, and support capacity planning and the development of long-term strategic goals for systems and software in conjunction with department managers.
  • Coordinate with business application, database administration functions, and SSC network engineering to implement server systems that utilize industry best practices to meet corporate objectives.
  • Anticipate, mitigate, identify, troubleshoot, and resolve hardware and software problems on servers. Escalate incidents as necessary.
  • Support application development teams throughout project life cycles.
  • Analyze system, server, application, and network performance.
  • Recommend, schedule, and perform software and hardware improvements, upgrades, patches, and/or reconfigurations.
  • Conduct research on emerging products, services, protocols, and standards.
  • Create required reports in response to business user needs.
  • Collect, assemble, create, and prepare evidence required by security audits.
  • Develop, document, and maintain policies, procedures and associated training plans for system administration and appropriate use.
  • Work with IBM support as required to

Job Requirements

  • Skill on Agile methodology work-process
  • Strong development skills using IBM Information server products
  • (Datastage, QualityStage, IGC, Information Analyzer, .. etc.)
  • Strong SQL skills.
  • Exposure to engagements focused on Data and Advanced Business
  • Analytics
  • Qualifications
  • Education
  • Requirements
  • A university degree in a related business or technology discipline;
  • 5+ years of development experience in ETL DataStage
  • Experience with translating interface requirements in design specifications for development
  • 7+ years of experience in DB2/SQL/Oracle or major relational DB platforms
  • Individual Contributor with proven soft skills.
  • Able to work independently
  • Willing to learn new technologies for driving the project
  • Ability to communicate with both Technical team & internal Stakeholders

Featured Jobs

Similar Jobs

Search other opportunities
JobsIT/Software DevelopmentETL Consultant