ETL Developer (Oracle SQL & Python)

Perfict

Remote

$52.25 - $68.25/hr

Full-time

Re-posted 3 days ago


Job description

Job Summary:
Perfict Global is a leading IT consulting services provider focused on providing innovative and successful business workforce solutions to Fortune 500 companies. They are seeking an ETL Developer to lead ETL development using Oracle SQL and Python, monitor processes, and assist in deployment.
Responsibilities:
• Leading ETL development using Oracle SQL scripts and Python for extracting, transforming and reporting data based on specified requirements.
• Monitor and fine tune process to improve throughput and efficiency, perform unit testing and SIT and assist the development team in deployment and monitoring.
Qualifications:
Required:
• Bachelors degree
• 7+ years of related experience w/ Oracle ETL development
• Advanced/extensive Oracle SQL scripting experience
• Experience utilizing Python for ETL development
• Experience building out ETLs and monitoring and fine tun process to improve throughput and efficiency, performed unit testing and SIT and assisted development teams in deployment and monitoring
• Candidates who are primarily focused on utilizing Python for analytics or Oracle DBA's are not a fit. This is a ETL development position.
Preferred:
• Healthcare, medicare or Medicaid, healthplan
Company:
Perfict Global is an IT consulting services provider, focused on providing innovative and successful business workforce solutions. Founded in 2011, the company is headquartered in Concord, USA, with a team of 51-200 employees. The company is currently Growth Stage.

Perfict logo

About Perfict

Sourced by ZipRecruiter

We are a technology company focused on providing innovative and successful business workforce solutions. Since 2011, Perfict has partnered with the biggest names across sectors offering a customized approach to each solution. We’ve established networks of genuine relationships that allow us to source the highest-quality talent and execute deals and hires quickly. With locations in US and India, we work globally to help you build your organization. Our methodology begins with listening to you about your needs. We work with your team to gain a clear understanding of your requirements, while providing a knowledge transfer of best practices.

Industry

Recruiting and staffing services

Company size

51 - 200 Employees

Headquarters location

Walnut Creek, CA, US

Year founded

2011

Social media



Frequently asked questions

Q: What skills or qualities help someone succeed as a ETL Developer?

A: To succeed as an ETL (Extract, Transform, Load) Developer, key technical skills include proficiency in data warehousing tools such as Informatica, Talend, or Microsoft SQL Server Integration Services (SSIS), as well as expertise in programming languages like Java, Python, or C#. Additionally, knowledge of data modeling, data governance, and data quality is crucial.\n\nSoft skills that contribute to success in this role include strong analytical and problem-solving skills, attention to detail, and effective communication skills to collaborate with cross-functional teams. Adaptability and the ability to learn new technologies quickly are also essential in this rapidly evolving field.\n\nThese technical and soft skills enable ETL Developers to design, develop, and implement efficient data pipelines, ensuring high-quality data is available for business intelligence and analytics, ultimately supporting data-driven decision-making and driving business growth.

Q: What is the career path for a ETL Developer?

A: A typical career progression for an ETL (Extract, Transform, Load) Developer involves starting as a Junior ETL Developer, where they focus on building and maintaining data pipelines, and then advancing to a Senior ETL Developer or ETL Lead, where they oversee complex data integration projects and mentor junior team members. Key opportunities for skill development include learning data warehousing, business intelligence tools, and programming languages such as Python, Java, or SQL, as well as staying up-to-date with emerging technologies like cloud-based data platforms and machine learning. Long-term, ETL Developers may transition into roles like Data Architect, Business Intelligence Analyst, or even move into leadership positions, such as Data Management or IT Director.