ETL Informatica Developer

Charles Schwab - Littleton, CO

Full-time

Littleton, CO

Securities, Commodity Contracts, and Other Financial Investments and Related Activities

About the position

As an ETL Informatica Developer at Schwab, you will play a crucial role in building end-to-end data flow solutions primarily for investment operations and reconciliation. This position is part of a Scrum team focused on data flow analysis and development, utilizing various ETL tools and database programming to enhance the company's information technology capabilities.

Responsibilities

• Interpret functional and data requirements to build end-to-end data flow solutions.
• Develop ETL processes using Informatica Power Center.
• Create and optimize stored procedures and queries in Microsoft SQL Server and T-SQL.
• Utilize scripting languages like Python and PowerShell for data processing tasks.
• Collaborate within an Agile Scrum team to deliver data solutions.
• Conduct data analysis, profiling, mapping, and ensure data quality and governance.

Requirements

• 5+ years of experience with ETL development using Informatica Power Center.
• 3+ years of experience developing stored procedures and basic query tuning in Microsoft SQL Server and T-SQL.
• 3+ years of experience with scripting languages like Python and PowerShell.
• 3+ years of experience working in an Agile Scrum team.
• Experience with data analysis, profiling, mapping, quality, lineage, and governance.

Nice-to-haves

• Experience in the Investment Management industry.
• Experience working with Snowflake.
• BI/Reporting experience with tools such as Tableau.
• Knowledge of SQL Server security model.
• Experience with Atlassian toolset including JIRA, Bitbucket, Bamboo, & Confluence.
• Experience processing or producing XML, XSD, and XSL.
• SQL Server performance tuning.
• Experience developing applications using C#.
• Experience developing automated data validation and testing routines with Data Validation Option (DVO).