Sr. DataStage ETL Developer/Consultant

DPSI in Manhattan, KS

  • Industry: Information Technology - Software Architect And Senior Engineer
  • Type: Full Time
position filled
Excellent Consulting Opportunity NO 3rd party calls please Must be local to NYC Must be able to attend face to face interview in NYC Looking for a Senior DataStage (ETL) Developer with expert skills in SQL, Data Analysis and Data Warehouse. The potential hire will play a multi-faceted role, which will be responsible for designing and developing batch/ETL interfaces using IBM's ETL tool Datastage as part of the IT ETL Team. The candidate will be responsible for maintenance and support of the existing interface DataStage processes including investigation of issues and production troubleshooting. This position will be a key member in of the ETL Team and will support corporate critical applications. Must have expert skills in writing complex SQL procedures. Skills Required: Bachelors Degree or equivalent work experience in IBM DataStage (8 years). Expert SQL skills with complicated queries, tuning of SQL and data analysis. Proven experience in Analysis, Design, Development, Testing and Implementation (all phase of software development life cycle SDLC) including low-level Design. Proficiency in developing strategies for Extraction, Transformation and Loading (ETL) mechanism Expertise in designing parallel jobs using various stages like Join, Merge, Lookup, Remove duplicates, Filter, Dataset, Lookup file set, Complex flat file, Modify, Aggregator, XML, MQ, Hierarchical Experience in schema designing for data marts, data transformation and data integration Expertise in designing complex SQL queries joining more than 10 tables with aggregations, partitions, order by, etc Ability to analyze customer requirements and transform them into technical design specifications Experience in production support with quick turn-around time for hot fixes Experience in any of the following will make you a stronger candidate: DB2, Oracle, SQL Server, Enterprise scheduling. Experience developing projects that have high level of complexity, being responsible for structuring the work, prioritizing and assigning project tasks, providing guidance and resolving issues. Create, update and publish interface documentation, system diagrams, presentations, workflows, project plans, risk logs and issue logs. Knowledge of DW, Data Virtualization (LDW) and Data Lake Understand data and business needs Understand Retail Data Model is a plus Able to design efficient and sustainable ETL processes to support BI and Analytical Requirements Perform technical walkthroughs of DataStage programs for design and development peer reviews. Excellent understanding of data warehouse concepts and experience implementing data warehouse using DataStage ETL tool Knowledge of DBMS including Relational vs Columnar vs Distributed Strong knowledge of relational and dimensional database concepts provided by Dice
Associated topics: backend, design, develop, devops, expert, lead, perl, php, senior software engineer, software engineer lead

You may be interested in these similar jobs!
Apps dev sr. programmer anlyst
Citi in Westmoreland, KS

Job Description The Applications Development Senior Programmer Analyst is an intermediate level position responsible for participation in the establi…

Read More
Senior Full-Stack Software Engineer
HIRED in Manhattan, KS

Join Hired and find your dream job as a Senior Full Stack Software Engineer at one of 10,000+ companies looking for candidates just like you. Compani…

Read More
Senior Business Intelligence Engineer (Wamego)
Humana in Wamego, KS

Description The Senior Business Intelligence Engineer solves complex business problems and issues using data from internal and external sources to…

Read More
Senior Full-Stack Software Engineer - Manhattan, IL
HIRED in Manhattan, KS

Job Description:Join Hired and find your dream job as a Senior Full Stack Software Engineer at one of 10,000+ companies looking for candidates just l…

Read More
Senior Backend Engineer
HIRED in Manhattan, KS

Join Hired and find your dream job as a Senior Backend Engineer at one of 10,000+ companies looking for candidates just like you.Companies on Hired a…

Read More
Lactation consultant rn PRN days
AdventHealth in Westmoreland, KS

Description Lactation Consultant - RN AdventHealth Tampa Location Address: 3100 East Fletcher Avenue Tampa, Florida 33613 Top Reasons to Work at Adve…

Read More
Retail Sales Associate, Wireless
Wireless Lifestyle in Manhattan, KS

Join one of the largest and fastest growing Sprint Dealers in the nation with over 200 retail locations across the 50 US states and Puerto Rico! Here…

Read More
Salesforce Developer (Saint Marys)
LRS in Saint Marys, KS

LRS Consulting Services is seeking a Salesforce developer for our client in Lenexa, KS. This is a 6-month contract opportunity that could lead to per…

Read More
Psychiatrist (Fort Riley)
Barton Associates in Fort Riley, KS

A clinic in Kansas is looking for a psychiatrist to provide locum tenens coverage for approximately seven months, beginning in February 2020, with th…

Read More
Clinical Psychologist
Reef Systems in Fort Riley, KS

Participate in and successfully complete required DoD or service required training.Contact referred patients to assess treatment adherence.Use valida…

Read More