Lead ETL Architect developing, testing, and deploying solutions at S&P Global. Collaborating with teams and optimizing data processes in an environment focused on essential intelligence.
Responsibilities
Own the technical ETL delivery for various data migration projects.
Design, develop, test, and deploy ETL and CDC solutions.
Maintain and optimize database systems.
Collaborate with other teams to integrate systems.
Develop and maintain code using IICS.
Monitor and debug published processes.
Write performance-efficient complex SQL queries and tune existing queries.
Manage a small team of technical resources.
Serve as an escalation point for less experienced developers.
Requirements
Senior-level experience in developing, testing, and deploying ETL and/or CDC solutions (utilizing Informatica Intelligent Cloud Services).
5+ years of experience with ETL tools, like Informatica, Tableau, Power BI, AWS Clue, etc.
Strong database programming skills.
Ability to effectively lead, train, and mentor less experienced developers.
Experience with Data warehouse technologies including ETL Data transformations.
Experience in best practices design of ETL implementations in a high-volume environment, including ETL software, database, and tuning.
Experience in best practices design of CDC implementations in a high-volume environment, including CDC software, database, and tuning.
Strong communication and collaboration skills.
Proficient with software development lifecycle (SDLC) methodologies such as Agile.
Experience in writing performance-efficient complex SQL queries and tuning existing queries.
Benefits
Health & Wellness: Health care coverage designed for the mind and body.
Flexible Downtime: Generous time off helps keep you energized for your time on.
Continuous Learning: Access a wealth of resources to grow your career and learn valuable new skills.
Invest in Your Future: Secure your financial future through competitive pay, retirement planning, a continuing education program with a company-matched student loan contribution, and financial wellness programs.
Family Friendly Perks: It’s not just about you. S&P Global has perks for your partners and little ones, too, with some best-in-class benefits for families.
Beyond the Basics: From retail discounts to referral incentive awards—small perks can make a big difference.
Intern in Revenue Operations at CloudTalk analyzing sales and customer data for insights. Collaborating with teams for reporting and dashboard creation to support decision - making.
Analytics Developer at Intact Lab employing machine learning and data science. Collaborating with IT teams on projects to enhance customer experience in the insurance sector through analytics.
Analytics Engineer at UK's premier publisher assisting data - driven insights for customer understanding. Bridging gap between data engineering and analytics with clean, reliable data access.
Analytics Engineer designing and developing software solutions for complex data at OCLC. Collaborating with teams to enhance data access and analytics capabilities.
Analytics Engineer enabling data - driven decisions across clinical and operational functions at QualDerm Partners. Responsible for data collection, analysis, visualization, and stakeholder collaboration.
Lead Digital Analytics Engineer driving modernization of site analytics and data layer for multi - brand ecommerce. Architecting a unified measurement foundation and collaborating with various stakeholders across the organization.
SAP Analytics Developer managing and delivering SAP BW/BI solutions for Niterra. Collaborating with stakeholders to optimize business intelligence and data warehousing capabilities.
Analytics Engineer responsible for data consolidation and maintenance, supporting reporting and dashboards at Brilliant Corners for vulnerable populations.
ETL Developer maintaining data pipelines and supporting data quality for IMT Insurance. Collaborating with the data team and learning ETL tools under guidance.
Analytics Engineer creating scalable data models to support multiple products at Marshmallow. Collaborating across teams to enhance data - driven decision - making and optimize product offerings.