Job Description
Insight Global is looking for a Senior ETL Developer who will work as a data specialist and will work with the development team to design, optimize, and oversee the development of the ETL process for one of our Financial Clients. The duties will also include working with LOB architects in finalizing ETL architecture, monitoring compliance, and overseeing data conversions and migrations. The engineer will also work with application support teams to ensure design incorporates requires monitoring and alerting mechanisms to ensure timeliness and accuracy of reporting data.
To succeed in this role, you should know how to examine new data system requirements and implement migration projects. The ideal candidate will also have proven experience in data analysis and management, building large scale data marts for high volume and near real time reporting and possess excellent analytical and problem-solving abilities.
This job is responsible for defining and leading the engineering approach for complex features to deliver significant business outcomes. Key responsibilities of the job include delivering complex features and technology, enabling development efficiencies, providing technical thought leadership based on conducting multiple software implementations, and applying both depth and breadth in a number of technical competencies. Additionally, this job is accountable for end-to-end solution design and delivery. This role is 3x onsite in Charlotte NC.
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.
Required Skills & Experience
• 7+ years of ETL development experience
• Strong hands-on experience with Informatica (primary skill)
• Experience with IBM DataStage
• Advanced Oracle, SQL, PL/SQL
• UNIX/Linux scripting
• Experience with Autosys
• CI/CD automation experience
• Strong troubleshooting skills for ETL and data issues
• Performance tuning for ETL jobs and databases
• Experience working in Agile development environments
• Experience with high data volumes
Nice to Have Skills & Experience
• Data modeling
• Github Co-pilot
• Python
• SAP data / SAP packs experience
Benefit packages for this role will start on the 1st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.