Sr DataStage ETL Engineer
Apply NowCompany: Tech Tammina
Location: New York, NY 10025
Description:
MUST HAVE:
Consultant must have experience:
- Must have 8+ years of experience working for US companies in the US.
- Must have 4 + years of 'Recent' Banking experience (Since 2017).
- 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 have at least 5+ years of experience with different flavors of RDBMS such as SL Server, Oracle, DB2, and Vertica.
- 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
Consultant must have experience:
- 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.
- Must specialize in creating, enhancing, and supporting multiple data pipelines.
- Perform 'Enhancements' to legacy platforms by providing scalable and maintainable solutions.
- Manage the development and deployment of New projects and enhancement in the ETL process using DataStage.
- Designing tables and picking datatypes o Using Profiler traces and other tools to find the most frequently run queries.
- On-call troubleshooting for SQL Server service outages.
- Deciding whether clustering, log shipping, mirroring, replication, etc are the right fit to solve a business problem.
- 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.