Job Description :
ETL Developer

This position participates in a team environment for the development, implementation, and maintenance of processes to populate multi-division data stores. Responsible for programming, debugging and testing of ETL work in a development environment. The successful candidate will be generally responsible for providing the team with technical oversight, code reviews, design reviews, and mentorship. This position provides technical, interpersonal, and administrative skills in performing day-to-day work.



Your Professional Experience and Education will include:

Bachelor''s degree in Computer Science, Mathematics, Business Administration, or a related field. Appropriate additional experience beyond the minimum required experience may be substituted for education.
Minimum 6 years relevant experience in a multi-platform environment, including, but not limited to application development or database development.
Must be able to develop efficient and effective program and system solutions in solving highly complex business problems.
Proven ability to implement and deliver software solutions through the iterative life cycles using Agile or Waterfall style methodologies.
Must be able to effectively adapt to rapidly changing technologies and methodologies and apply them to technological and/or business needs.
Must be able to analyze, diagnose and resolve complex programming and system problems independently.
Able to work well with groups of business customers and IT partners.
Able to provide direction to others in analyzing and solving program and system issues and problems.
Able to provide technical direction and solutions to other team members.
Strong familiarity with Oracle, SQL Server, Sybase, DB2, Microsoft Analysis Services/OLAP and mainframe database systems and reporting methodologies.
Strong writing, documentation, and oral communication skills.
Be able to plan and manage his/her own work.
Thorough knowledge of all stages of the Software Development Life Cycle.
Strong understanding of the principles of Data Warehousing, including the use of Fact Tables, Dimension Tables, star schema modeling and snowflake schema modeling.
Strong knowledge of data modeling support for numerous strategic application development projects.
Excellent experience working with Oracle, PL/SQL and writing stored procedures and triggers.
Tool set and COTS knowledge requirements:
Extensive ETL tool experience using Ascential DataStage Version 11.3 or better, including designing and developing jobs using DataStage Designer, DataStage Manager, DataStage Director and DataStage Debugger and Parallel Extender
Oracle
Sybase
MS SQL Server
XML
UNIX (AIX ksh)
Source Code Management: GIT, TFS
Facets 5.x data model knowledge


A successful candidate will demonstrate:



Capability to Review and provide input to modify existing Data-Models.
Involvement in Code Review meetings and ability to communicate suggestions based on Best-Practices.
Development of DataStage jobs using various stages including Aggregator, Join, Transformer, Sort, Merge, Filter, Funnel, Surrogate Key generator, Modify, Row-generator, Column generator, Change Capture, Lookup, ODBC, Link Partitioner, Link Collector, Hash File, Head, and Peek
Experience in Tuning DataStage transformations and SQL queries for jobs to enhance their performance.
Capability to develop the technical specification documents from the functional documents and maintain the technical specification document.
Experience to map multiple data sources to single target database by analyzing the business requirements specified in the functional specification or Data Mapping Document
Knowledge to write korn shell scripts for scheduling of processes as well as the FTPing and Backup of required files, and maintenance of said backup files.