Senior ETL / DataStage Developer
Horizontal

Sacramento, California

Posted in Retail


This job has expired.

Job Info


*Projects the candidate will be working on: *




* This position is for a Medi-Cal Data Warehouse project

* The ETL Developer position is for the ETL Operations Team which is primarily responsible for the periodic data releases from multiple source feeds, production maintenance, operations, data quality, system changes and fixes.



*Experience:*




* Level of expertise in top 3 skills outlined above and ability to quickly learn project specific knowledge.



*Top Requirements:*




* 1. Strong ETL experience using IBM Datastage V7 or higher - 5+ years

* 2. Strong knowledge on Teradata architecture and loading utilities like TPT, TEQ, FLOAD and MLOAD - 2+ years

* 3. Strong SQL writing ability and data analysis skills - 2+ years.



*Team and Team size:*




* ETL Team has 6 ETL developers (DataStage, Teradata, SQL programming), 2 BusinessObjects (BusinessObjects) and Data Dictionary Librarian (Erwin, SAS) analysts, 2 QA testers, 6 Source Data Feeds developers (Mainframe Cobol, SQL), 1 ETL Lead(DataStage, Teradata, SQL programming), 1 Manager.



*Day-to-Day:*




* Responsible for analysis of source systems to determine required transformations.

* Writes the design and mapping specifications for ETL development.

* Identifies methods of improving performance in ETL design and development.

* Analyses customer requirements, improving performance on existing scripts /process/procedures, and document detailed user requirements and program functions.

* Monitors database performance, support application users, determine cost of database changes, and train team members on applications.

* Coordinates the work of others to develop, test, install, and modify programs and establish physical database parameters.



*Requirements:*




* Bachelors Degree in Computer Science, Information technology (or related fields) from an accredited college or university or equivalent work experience.

* Strong ETL experience 5-6 years using IBM Datastage V7 or higher

* Strong knowledge on Teradata architecture and loading utilities like TPT, TEQ, FLOAD and MLOAD

* Strong SQL writing ability and data analysis skills

* Unix commands and shell scripting

* Good understanding of IT fundamentals, architecture, and the system development life cycle.

* Ability to reason logically and creatively, and use a variety of analytical and research techniques to solve complex problems.

* Communicate effectively both verbally and in writing with a variety of audience types



*Interview Process:*




* a. How many rounds? 2-3

* b. Video vs. phone? Video

* c. How technical will the interviews be? Very technical, general and scenario based questions.


This job has expired.

More Retail jobs


Walmart
Fort Worth, Texas
Posted about 4 hours ago

Walmart
Greenville, South Carolina
Posted about 4 hours ago

Sam's Club
Atlanta, Georgia
Posted about 4 hours ago

Get Hired Faster

Subscribe to job alerts and upload your resume!

*By registering with our site, you agree to our
Terms and Privacy Policy.