ETL Developer

Role : ETL Developer with Strong SSIS- Must be in NJ/NY area and willing to go to the office in Hicksville, NY (1-2 days a week).

 Key Skills:

SSIS

C#

Python,

C is a plus

 Skills & Job Responsibilities: Sr. DataStage Developer Responsibilities and Duties This role is responsible to create, integrate, implement, and support large, highly complex ETL Data Warehouse.

Skills & Job Responsibilities: Sr. DataStage Developer Responsibilities and Duties This role is responsible to create, integrate, implement, and support large, highly complex ETL Data Warehouse.

• Develop and implement tests on all data stage jobs.

• Design and analyze all ETL jobs edition.

• Manage work and apply various performing techniques.

• Document all program level and user level processes.

• Prepare ETL architecture and associate procedures.

• Designs or enhances ETL systems, applications, functions, and procedures to solve complex problems and meet business objectives.

• Prepares detailed ETL functional specification solution development -- has full technical knowledge of all phases of analysis, integration, development, quality assurance, and implementation procedures

• Application/System Troubleshooting interfaces with appropriate corporate area to provide detailed data and analysis to assist with problem determination and resolution.

• Maintain an efficient infrastructure by recognizing and reducing latencies and gaining efficiencies where recognized or needed

JOB REQUIREMENTS:

• Bachelor's Degree in a Computer Science or Technology related field -- or -- an equivalent combination of education and experience

• 10 years of quality experience in designing and development of ETL jobs using IBM DataStage.

• Experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing projects.

• Proficiency to understand DW concepts like conformed dimensions, conformed facts and Data Warehouse architecture for ETL development.

• Recent experience with ETL in a cloud environment

• Experience working with Cloud Databases (Snowflake preferred)

• Experience working with Relational Databases, Business Intelligence solutions

• Strong SQL skills, able to write and optimize complex queries

• Experience with multiple Database platforms (DB2, Oracle, Informix, SQL Server, MySQL, Netezza, Snowflake - as many as possible) and Oracle Database is a must

• Experience with Unix shell scripting

• Strong written and verbal communication skills, and effective interpersonal skills to work with internal and external customers and vendors Good analytical/research and problem-solving skills.

Position Description: Build ETL jobs (Extract, Load and Transform) for Salesforce and integrate with EDW, Write complex SQL queries, use Tidal scheduler if needed to schedule the jobs at scheduled frequency and test the jobs

Skillset & education Required: 7-10 years of experience with IBM DataStage ETL development is a must. Informatica ETL will be a plus.; B.S. Degree (Computer Science is preferred)