Title: DataStage Consultant
Work onsite- New York
Contract role
Skills Need:
Must have 8+ years of experience working for US companies in the US.
Must have 4 + years of 'Recent' Banking experience.
Must have at least 7+ years of experience with IBM Data Stage version 9.1 - 11.5.
Must have min 5 years of experience with ETL using Datastage.
Must specialize in creating, enhancing, and supporting multiple data pipelines.
Perform 'Enhancements' to to legacy platforms by providing scalable and maintainable solutions.
Must have at least 5+ years of experience with different flavors of RDBMS such as Sql Server, Oracle, DB2, and Vertica)
Manage the development and deployment of New projects and enhancement in the ETL process using Datastage.
Must have at least 5+ years of strong experience in coding using SQL, procedures, functions and triggers.
Must have extensive experience writing complex mapping, operations scripts and triggers to load data in to data warehouses and database and integration.
Must have at least 2+ years of working experience in agile development practices
Must have 'Excellent and Articulate' communication skills are a must. Being able to easily identify and discuss with all team members any development needs or recommended approaches is critical.
The JOB:
Client is seeking consultants that will participate as seniors on there DataStage team. The team will ensure that the new database code meets company standards for readability, reliability, and performance.
Advise developers on the most efficient database designs (tables, datatypes, stored procedures, functions, etc).
Developing, and maintaining ETL jobs using DataStage to load into the data warehouse.
Work with business analysts and other stakeholders to undersatnd business requirments and ETL jobs that meet thoses requirments.
Consultant must have experience:
1) Writing and improving SQL Server T-SQL queries for at least a year. You will be known amongst the office as the go-to person for T-SQL questions. 2)
Designing tables and picking datatypes o Using Profiler traces and other tools to find the most frequently run queries.
3) On-call troubleshooting for SQL Server service outages.
4) Deciding whether clustering, log shipping, mirroring, replication, etc are the right fit to solve a business problem.
...Role : SP6 (C3PAO Authorized Organization) is looking for a Compliance SME wanting to take the next step in their career! In this... ...knowledge across cyber risk and compliance engagements. Consulting with end clients to gather requirements and understand our clients...
...seeking a highly organized and detail-oriented Administrative Assistant to join our dynamic radiopharmaceutical company. You will be part... ...meetings Provides administrative support to the executive team Attends department meetings as requested; records, prepares...
Love the Holidays? Want to work alongside Easter Bunny? Weve got a job for you! VIP Holiday Photos needs your help to make children's dreams come true this coming Easter Season- March Through April 19, 2025 WHY WORK WITH P HOLIDAY PHOTOS? VIP Culture: Honesty, Loyalty...
Do you enjoy working with seniors? Are you tired of feeling unappreciated?We are looking for Live In caregivers who want to be appreciated and choice assignments, educational opportunities, referral bonuses, and high pay...all while having the opportunity to make a difference...
...We are looking for a highly organized, neatly-presented Chiropractic Office Receptionist to be responsible for our office's front desk duties. The Receptionist's responsibilities include answering e-mails and phone calls, scheduling appointments, and welcoming patients...