ETL Developer

ETL Developer

Position : 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.

• Job Order No : 9712821.

• This position is eligible for a referral bonus through our employee referral program

• Position : ETL Developer

• Job Duties :

Perform software analysis, design, development, implementation, testing and support of ETL applications; assist during SDLC; analyze business and technical requirements; draft functional and technical specifications, and data flow and process diagrams; develop ETL mapping to extract data from multiple source systems; create sessions and workflows; create and edit partitions; create and execute automation scripts, SQL queries and user-defined functions; develop ETL and maintain consistent functions; reduce redundancy in code and increase code reusability; create and execute stored procedures; schedule workflows and monitor jobs; perform query optimization; monitor and tune performance; implement change control systems and processes; prepare test cases and validation procedures, and perform ETL testing; push code into production; provide QA and assist with production support; track issues to resolution; and use: Windows, Unix, Oracle, Teradata, SQL Server, WebLogic, SOAP, Cognos, Informatica, Data Stage, Ab-Initio, Selenium, QTP, Autosys, Visio, C, Java, HTML, XML, XSD and related tools.

Minimum Qualifications Education

• Bachelor degree in Computer Science, Computer/Electronic Engineering, Information Technology or in a related field of study (will accept equivalent foreign degree);

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

• Other Requirements :

• Experience must include two (2) years of work with Unix, WebLogic, Informatica and Selenium; must be willing to relocate.

• Job Order No : 8960374.

• This position is eligible for a referral bonus through our employee referral program