ETL Developer

Job Duties :

Analyze, design, develop, implement, test and support ETL applications using Agile methodology; assist during SDLC; analyze business and technical requirements; draft functional and technical specifications, and data flow and process diagrams; analyze and configure mappings and workflows; integrate data sources into data staging area; perform data analysis; create and execute automation scripts, SQL queries and user-defined functions; develop database programming for data warehouses and dimensional modeling; develop stored procedures, functions, triggers, views and queries; design and develop server jobs; perform query optimization; monitor and tune performance; implement change control systems and processes; prepare test cases and validation procedures, and perform ETL testing; provide QA and assist with production support; debug mappings, test stored procedures and functions and unit test sessions, batches and data; track issues to resolution; and use: UNIX, Oracle, SQL Server, DB2, Teradata, Informatica, Datastage, OLAP, SQL, PL/SQL, JavaScript, UNIX Shell Scripting, XML, Flat files and related tools.

Minimum Qualifications Education :

Bachelor’s Degree in Computer Science, Computer Engineering, Computer Information Systems or in a related field of study (will accept equivalent foreign degree); will accept a Bachelor equivalent based on a combination of education and experience, as determined by a professional evaluation service;

Experience  : Three (3) years of experience as a Software Developer, Systems Analyst, Programmer or in a related occupation;

Other Requirements :

Experience must include work with Teradata, Datastage and PL/SQL; must be willing to relocate