Lead ETL Developer Job at Cloud Analytics Technologies LLC, Columbus, OH

M2tROHUreVFXNHFRM3BnNXp6Q0RxMm02Qmc9PQ==
  • Cloud Analytics Technologies LLC
  • Columbus, OH

Job Description

Job Details

Position: Lead ETL Developer with Snowflake

Location: Columbus, OH (Day 1 Onsite)

Duration: Long Term

looking for a Lead ETL Developer Lead in our Enterprise Data Warehouse. In this role you will be part of a team working to develop solutions enabling the business to leverage data as an asset at the bank. As a Lead ETL Developer, you will be leading teams to develop, maintain and enhance code ensuring all IT SDLC processes are documented and practiced, working closely with multiple technologies teams across the enterprise. The Lead ETL Developer should have extensive knowledge of data warehousing cloud technologies.

If you consider data as a strategic asset, evangelize the value of good data and insights, have a passion for learning and continuous improvement, this role is for you.

Total Experience: 10 + years

Relevant exp:

Should have played the role of Lead for a minimum of 3+ years

5 years of experience in ETL development within a Data Warehouse

As a Lead Developer at Onsite, Candidate needs to coordinate with Offshore team at India and Client and drive/lead the team for smooth deliverables.

Key Responsibilities

Translate requirements and data mapping documents to a technical design.

Develop, enhance and maintain code following best practices and standards.

Create and execute unit test plans. Support regression and system testing efforts.

Debug and problem solve issues found during testing and/or production.

Communicate status, issues and blockers with project team.

Support continuous improvement by identifying and solving opportunities.

Basic Qualifications

Bachelor degree or military experience in related field (preferably computer science) and 5 years of experience in ETL development within a Data Warehouse.

Deep understanding of enterprise data warehousing best practices and standards.

Strong experience in software engineering comprising of designing, developing and operating robust and highly-scalable cloud infrastructure services.

Strong experience with Python/PySpark, DataStage ETL and SQL development

Proven experience in cloud infrastructure projects with hands on migration expertise on public clouds such as AWS and Azure, preferably Snowflake.

Knowledge of Cybersecurity organization practices, operations, risk management processes, principles, architectural requirements, engineering and threats and vulnerabilities, including incident response methodologies.

Strong communication and interpersonal skills.

Strong organization skills and the ability to work independently as well as with a team.

Preferred Qualifications

AWS Certified Solutions Architect Associate, AWS Certified DevOps Engineer Professional and/or AWS Certified Solutions Architect Professional

Experience defining future state roadmaps for data warehouse applications.

Experience leading teams of developers within a project.

Experience in financial services (banking) industry.

Mandatory Skills

ETL - Datawarehouse concepts, Datastage ETL

AWS, Glue

SQL

Job Tags

Similar Jobs

DSM-Firmenich - Princeton

EHS Process Safety & Site Security Manager (Nutritional Premix) Job at DSM-Firmenich - Princeton

 ..., aligning a CAPEX project with process safety lifecycle requirements, and finalizing updates...  ...and reinforce Life Saving Rules and Key Security Behaviors across operations, Maintenance...  ...ll Do Design the sites approach to managing combustible dust hazards across product... 

Omada Health

Senior Clinical Product Manager, Behavioral Science Job at Omada Health

 ...inspire and engage people in lifelong health, one step at a time. Job Overview: The Senior Clinical Product Manager, Behavioral Science at Omada is a pivotal cross-functional leader who applies clinical expertise and product development experience to resolve... 

System One

Rotating Machinery SME Job at System One

 ...nuclear fluid pumps, ensuring adherence to project timelines and specifications. Provide technical oversight to partners and subcontractors, guiding the development of mechanical system designs. Coordinate comprehensive reviews of analyses, including thermal,... 

Mak Design & Build

In Office, Interior Project Designer Job at Mak Design & Build

 ...MAK Design + Build - Searching for a Talented Project Designer Are you the right person to fit our team? Are we the right team for you...  ...mileage reimbursement. This is a full-time position with flexible remote options. If you are excited about this opportunity and possess... 

Jerry

Legal Researcher Job at Jerry

 ...performance, not tenure. Gain hands-on legal experience and accelerate your growth...  ...house at a high growth startup? As a Legal Researcher at Jerry.ai, youll be embedded in the business...  ...love to hear from you! This is a fully remote full-time role with options to work...