ETL Application Developer

PradeepIT Consulting Services Pvt Ltd; Bengaluru; Hybrid; INR 1,000,000 - 1,800,000; Full time

Job summary

A technology consulting firm is seeking an experienced ETL developer with Ab Initio expertise in Data Warehouse applications. The ideal candidate has over 7 years of experience in data integration, advanced SQL skills, and familiarity with GCP cloud technologies. Responsibilities include developing complex programs, performing maintenance, and ensuring high-quality systems. Opportunities for career growth and learning in a collaborative team environment are plentiful.

Qualifications

• 7+ years of experience in Ab Initio and Data Warehousing.
• 5+ years of advanced SQL experience in an enterprise setting.
• Experience with GCP cloud technologies including Big Query.

Responsibilities

• Develop complex programs from detailed technical specifications.
• Designs, codes, tests, debugs, and documents programs.
• Independently performs ongoing system maintenance and problem resolution.

Skills

Ab Initio

SQL

Data Warehousing

Hadoop

Analytical skills

Tools

GCP

Pig

Hive

Scope

Job description

Overview

ETL developer with Ab initio experience for Data Warehouse and Data Mart applications withing the HealthCare Insurance business. The position requires a strong proficiency in data integration (ETL) and involvement in all phases of application development. When you join the team, you are joining a team of elite, passionate software professionals that take pride in engineering excellence and creative solutions that add value to our stakeholders. You will have plenty of opportunities to showcase your talent, learn new technologies and have a rewarding and fulfilling career.

Responsibilities

• Develop complex programs from detailed technical specifications.
• Designs, codes, tests, debugs, and documents those programs. Competent to work at the highest technical level of phases of applications systems analysis and programming activities.
• Independently designs and/or codes the development of cost-effective application and program solutions.
• Independently performs ongoing system maintenance, research, problem resolution and on-call support tasks for existing systems.
• Is fully familiar and compliant with the efficient utilization of the prescribed methodologies and ensures compliance with all work performed.
• Performs unit testing. May perform or assist with integration and system testing, according to detailed test plans to ensure high-quality systems. May assist business partners with User Acceptance Testing.
• Responsible to follow all procedures and directions to ensure Code Asset Management for an application or set of applications.
• Supports and promotes the reuse of assets across the organization.

Required Qualifications

• Expertise in one or more programming language, development tools, and/or databases and the systems development life cycle, applicable to development organization.
• 7+ years of Ab initio and Data Warehousing in parallel processing environment required
• 5+ years SQL experience, advanced SQL coding in an enterprise setting
• Hadoop, Pig, Hive, Scope, HQL Experience
• Ab initio and Data Warehousing coding experience, testing, and debugging experience required
• Solid analytical and software development skills
• Ability to optimize SQL coding for efficiency
• GCP cloud technologies including Big Query

Preferred Qualifications

• ZEKE knowledge a plus
• Working knowledge of mainframe and midrange environments
• Experience with application development support software packages
• Experience working in an Agile framework such as SAFe.
• Affiliations with a technical or professional organization or user group

Locations :: Bangalore, Delhi, Chennai, Kochi, Noida, Gurgaram