ETL Informatica Developer - Hybrid

Charles Schwab - Westlake, OH

Full-time - Mid Level

Westlake, OH

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

About the position

The ETL Informatica Developer at Charles Schwab is responsible for building end-to-end data flow solutions primarily for investment operations and reconciliation purposes. This role involves interpreting functional and data requirements and working as a core member of a Scrum team focused on data flow analysis and development using ETL tools and database programming.

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.
• Collaborate within an Agile Scrum team to deliver data solutions.
• Conduct data analysis, profiling, mapping, quality checks, and governance.

Requirements

• 5+ years 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 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).

Benefits

• 401(k) with company match
• Employee stock purchase plan
• Paid time for vacation
• Paid time for volunteering
• 28-day sabbatical after every 5 years of service for eligible positions
• Paid parental leave
• Family building benefits
• Tuition reimbursement
• Health insurance
• Dental insurance
• Vision insurance