Job Description :
Day to Day:
Talend 6.0 Developer to write ETL code, with strong SQL, and Data mapping troubleshooting skills.
DW methodologies and concepts - star schemas, snowflakes, ETL processes and dimensional modeling
Create ETL scripts that are easy to read, repeatable, and have good modular components.
Will not have to define it all ETL jobs from scratch. There is a framework built to fast track them.
Required Skills:
5+ years database modeling, data mapping (Excel is okay
2+ years Talend ETL development coding ETL scripts and jobs
3-5 years as an ETL developer in data warehouse environment
using tools such as Talend, Informatica, or Data Stage
Must Have:
Talend ETL
Strong SQL
Data mapping
Strong Plus:
Sailfish (IBM Integrated Analytics Systems)
2+ years Netezza back end (DB2 in a box)
Talend Admin experience (with RunDeck Automation tool, Jenkins)
Additional Notes:
Agile/Scrum (2 week sprints) - Dev methodology
Ideal Candidate: Writing ERL code for a netezza appliance
Job description: ETL Talend Developer
Description
Work with designated team to identify, design and implement solutions for extraction and integration of data to and from operational system and the data warehouse for the purposes of reporting, decision support and analysis.
Your responsibilities will include:
Work with business users to understand and document business and technical requirements to drive design and development
Collaborate on the design of physical structure and implementation of database objects
Document and build physical database objects from table, column, index and view definitions
Develop scripts for the creation of the physical data warehouse tables, views and macros
Adhere to data security and protection policies
Monitor and troubleshoot Extract-Transform-Load (ETL) and system performance, including optimization and tuning of data loads
Understand job and activity schedules to promote optimal performance, maximize availability and minimize data latency and data load duration
Maintain a positive work atmosphere by acting and communicating in a manner which facilitates the success of business operations in order to meet company demands and expectations
Perform additional duties as assigned
Proactively seek opportunities to broaden and deepen knowledge base and proficiencies and share acquired skills with team members through formal and informal channels
Maintain a positive work atmosphere by acting and communicating in a manner which facilitates the success of business operations in order to meet company demands and expectations
Ability to multi-task, prioritize workload and communicate timelines clearly
Required Qualifications
2+ years’ experience as an ETL developer in data warehouse environment using tools such as Informatica, Data Stage or Talend
Strong knowledge of data warehousing methodologies and concepts, including and not limited to: star schemas, snowflakes, ETL processes and dimensional modeling
Experience with system integration across multiple systems and platforms utilizing various technologies such as ODBC, FTP, Window, Unix/Linux, and AS400
Experience working with high volume databases with partitioned data, performance and tuning
Experience working with cross functional development, QA, test and production teams
Proven track record of meeting project deadlines and delivering high quality consulting services
Preferred Qualifications
2+ years of Netezza experience or related Appliance
Excellent analytical skills and a proactive approach to problem solving
Strong interpersonal, teamwork, organizational and workload planning skills
Strong analytical, evaluative, and problem-solving abilities as well as exceptional customer service orientation
Ability to drive clarity of purpose and goals during release and planning activities
Excellent organizational skills including ability to prioritize tasks efficiently with high level of attention to detail
Excited by the opportunity to continually improve processes within a large company
Healthcare background.
Familiarity with major big data solutions and products available in the market.
Proven ability to drive continuous improvements in organizational performance, efficiency and innovation for customers.