Analysis, design, develop, and implement Data Warehousing applications using such software tools and technologies as Datastage, Oracle, PL / SQL, DB2, SQL Server, UNIX, Windows and related tools.
Analyze business requirements and various operational data sources. Review the data model and Extraction, Transformation and Loading (ETL) specifications.
Design the overall ETL strategy. Develop and implement ETL processes for populating data warehouse from various disparate operational systems.
Develop scripts to schedule, monitor and manage ETL processes. Load data from operational systems into Staging, datawarehouse and datamart.
Create jobs in Datastage to load the datawarehouse and datamarts using Datastage ETL tool. Schedule the jobs in DataStage to run daily at a specific interval.
Develop scripts to schedule, monitor and manage ETL processes. Optimize ETL processes to tune the data load and tune SQL queries.
Perform ETL testing and Unit testing to ensure that the jobs are successful and the source data is loaded into the datawarehouse and datamarts as expected.
Provide technical support and troubleshoot operating problems.
Requirements : Master’s degree or equivalent in Computer Science, Information Systems, Information Technology or a related field and 2 years of experience as a Programmer Analyst, Software Engineer, Software Developer or any job involving development of datawarehousing or ETL applications.
Experience must include development of datawarehousing or ETL applications. Background Checks and Reference Checks required.