- Microsoft SQL Server
Designing and developing ETL processes as per ETL standards to meet functional and nonfunctional requirements.
Developing ETL design documentation, HLD (High level design), SRS (software requirement specification) and Mapping document as per business requirement.
Optimization of complex ETL process using Performance Tuning Methods.
Writing shell scripts in UNIX.
Designing of the User Interface Components.
TDeveloping SQL /PLSQL query code and performing unit/integrated testing of ETL process
Scheduling and monitoring the ETL/BI jobs using Control-M/Tivoli.
Implementing Data Warehouse and Business Intelligence Projects.
Experience in ETL tool Informatica and Ab Initio.
Knowledge of Version Control tools like IBM Rational Suite- Clear Case / Clear Quest and Visual Source safe.
Participating with team of technical staff and managers to understand systems requirements and functionality needed in large/complex development project.
Provide technical guidance to team member as and when required.
Work with production support to ensure transition to production and application execution in production environment is smooth
Santa Clara, CA and other unanticipated locations throughout the U.S. Candidate may be required to relocate to client sites.
Educational Level Requirement
Minimum Master’s or foreign equivalent in Computer Science/Computer Engineering and 1 year experience in the job offered or in the alternative occupation of Developing ETL processes as per ETL standards. Experience must include 1 year in use of developing ETL design documentation HLD SRS and ETL mapping document as per business requirements; Working on ETL Tool Informatica/Ab initio and relational database like Oracle, DB2, Teradata and SQL server. Implementing Data Warehouse and Business Intelligence Projects; Writing Shell scripts in Unix and scheduling and monitoring the ETL/BI jobs using Control-M/Tivoli. In lieu of Master’s degree and 1 year experience, employer will accept bachelor’s degree and 5 years post-baccalaureate progressive experience in job offered or in Developing ETL Processes as per ETL standards or any suitable combination of education, experience or training. PLEASE NOTE: 1 year experience requirement in not additional but already included in Bachelor’s and Five years progressive experience requirement.
Mail Us at: email@example.com