Designing and developing ETL/ Datawarehouse and OLTP solutions using Informatica Power Center 9.1.
Design, develop, debug, and optimize ETL Workflows using Workflow Manager and Workflow Monitor for Data Extraction and Data Loading for Reporting.
Writing shell scripts in UNIX/ Linux including sed and awk programming.
Unit testing and smoke testing of ETL Code.
Working with Oracle and Netezza SQL and PL/SQL Procedures, Packages, Functions and Triggers.
Implementing Data Warehouse and Business Intelligence Projects.
Experience in ETL tool Informatica and PL/SQL development including RDBMS such as Oracle and Netezza.
Query optimization and Performance tuning of ETL code.
Developing ETL design documentation, HLD (High level design), SRS (software requirement specification) and Mapping document as per business requirement.
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
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: firstname.lastname@example.org