We are seeking a highly skilled Senior SQL Developer (SSIS Specialist) to support our mission of delivering innovative data-driven solutions.
This role focuses on maintaining, enhancing, and optimizing SSIS packages while leveraging advanced SQL expertise to deliver reliable and scalable ETL solutions. The ideal candidate will also contribute to shaping future cloud-based data transformations as CoreLogic continues to innovate.
#LI-DNI
Responsibilities
- Develop, maintain and optimize SSIS packages to support data integration, transformation and analysis
- Write, troubleshoot and optimize complex SQL queries for data validation and ETL processes
- Collaborate with stakeholders to understand business requirements and deliver scalable solutions
- Ensure high performance, reliability and scalability of ETL pipelines
- Document technical designs, processes, and best practices using tools like JIRA and Confluence
- Work with CI/CD tools (e.g., Bamboo, Jenkins) and source control systems (e.g., Git) to streamline deployments
- Stay aligned with CoreLogic's architecture standards while contributing to future technology advancements
Want more jobs like this?
Get jobs in Kuala Lumpur, Malaysia delivered to your inbox every week.
- 5+ years of hands-on experience with Microsoft SQL Server, including database design, development and performance tuning
- Proven track record of successfully delivering high-quality SQL and ETL solutions in complex environments
- Advanced skills in writing, optimizing, and troubleshooting complex SQL queries
- Extensive experience in developing, maintaining, and optimizing SSIS packages
- Strong understanding of ETL pipeline development, data transformation and familiarity with cloud platforms such as AWS and GCP
- Experience with Python for data development and hands-on usage of CI/CD tools (Bamboo, Jenkins, Git, Redgate)
- Solid grasp of data warehousing principles, data modeling concepts and data quality best practices
- Strong analytical and problem-solving skills for troubleshooting complex data systems
- Excellent communication and interpersonal skills with the ability to effectively collaborate with technical and non-technical stakeholders
- Adaptable, detail-oriented, and proactive in identifying and resolving challenges
- Client-focused approach with a commitment to delivering high-quality solutions that meet business needs
- By choosing EPAM, you're getting a job at one of the most loved workplaces according to Newsweek 2021 & 2022&2023
- Employee ideas are the main driver of our business. We have a very supportive environment where your voice matters
- You will be challenged while working side-by-side with the best talent globally. We work with top-notch technologies, constantly seeking new industry trends and best practices
- We offer a transparent career path and an individual roadmap to engineer your future & accelerate your journey
- At EPAM, you can find vast opportunities for self-development: online courses and libraries, mentoring programs, partial grants of certification, and experience exchange with colleagues around the world. You will learn, contribute, and grow with us
- EPAM is a leader in the fastest-growing segment (product development/digital platform engineering) of the IT industry. We acquired Just-BI in 2021 to reinforce our leading position as a global Business Intelligence services provider and have been growing rapidly. With a talented multinational team, we provide data and analytics expertise
- We are currently involved in end-to-end BI design and implementation projects in major national and international companies. We are proud of our entrepreneurial start-up culture and are focused on investing in people by creating continuous learning and development opportunities for our employees who deliver engineering excellence for our clients