ETL Developer

Our client, a major bank in New York City, is looking for ETL Developer Consultant.
Initial 6 months with possible extensions and FT opportunity.

W2 Rate is $60-65/h. C2C is also an option.

Must be 2/3 days per week in the office.

ETL Developer Consultant

To work on project requirements in Corporate IT.
Must be experienced with identifying and analyzing technology and process problems, while developing solutions for tactical and/or strategic projects, in collaboration with Business and Technology stakeholders across the organization. Identify and document gaps in procedures, and create solutions for scalable and repeatable processes, in adherence with the various department s frameworks and IT best practices established. Own the management information and data requirements gathering initiative to develop and/or streamline the operational reporting capabilities.

Ensure that all the necessary processes are thoroughly implemented to take full advantage of the capabilities of the systems. The candidate must be a people person, technically proficient, able to multi-task well, explain solutions clearly, is well organized, and is able to work independently with minimal oversight.
Previous exposure/knowledge in developing IT solutions for equity Compliance regulations (e.g CAT, CAIS, LOPR) at a bank desired.

Major Responsibilities:

• • Design & Development ETL tasks and Tidal jobs including scheduling and dependencies (Python scripts)
  • Maintain Tidal jobs across all environments (DEV, UAT & PROD)
  • Maintain all ETL code in subversion repositories (DEV & TRUNK)
  • Follow build & version control process using Jenkins & AZURE Dev Ops
  • Set up FTP connections for data transmission supporting automated processes
  • Support BA team with data analysis, with identification and extraction of correct data required, and suggest data extract rules
  • Verify all job changes & promotions to UAT and prod environments
  • Create Service Now tickets for all Tidal & ETL jobs
  • Manage and track all time and tasks in JIRA
  • Help set up and streamline various data extract processes

Required Qualifications:

• Bachelor s Degree in Computer Science, Management of Information Systems, or related business discipline(s).
• 3-5 years work experience with IT or process engineering
• Process mapping/ process improvement experience
• Complex SQL query knowledge
• Python knowledge
• Ability to prioritize and effectively manage multiple tasks
• Excellent interpersonal, written and verbal communication skills
• Highly motivated, self-directed individual with the ability to work independently and in team environments
• Effective presentation skills, combined with extreme attention to detail
• Strong analytical, problem solving, and decision-making skills
• Collaborative team player and relationship builder.