Responsibilities: Designs, develops, and maintains database back-end and ETL applications for Data Warehouse and Business Intelligence solutions. Uses knowledge of ETL languages and development techniques to build and expand application functionality by writing high-quality code using appropriate patterns. Ensures applications remain scalable while complying to standards and following best practices. Tests and debugs applications and ensures that software is properly documented. Collaborates clearly and professionally as part of a development team and communicates with clients. Work as an integrated member of the Data Management team to support cross functional data initiatives with various business clients Interact with Business teams to better understand the technical functionality requirements and analyze data requirements and their impact to the existing systems 3+ Years of experience in designing, developing, testing and implementing Extract/Transform/load (ETL) data pipelines with Azure data technologies such as Azure Data Factory, Databricks, Azure Synapse, and/or SQL Data Warehouse 4+ years experience in data modeling and working with common data warehouse Models 4+ years experience doing analysis and developing with SQL (e.g. Oracle, MS SQL, DB2) and PySpark. 5+ years experience working DevOps tools and practices 5+ year experience working with accepted methods, standards, techniques and best practices for development in agile/scrum practices Oral communication skills to work effectively with and discuss development approaches to clients/senior management and external stakeholders; written communications skills to document and communicate development specifications 2+ years development experience with PeopleSoft V 9.1, PeopleTools V8 with data integration and ETL experience with relevant application design, development and testing experience Create ETL Mappings and develop stored procedures, SQL queries and tune/optimize SQL code the ETL process and the target database for reporting Execute unit tests to ensure the accuracy of code changes, and to verify that data integrity and performance requirements are met Participate in meetings and scrums, works on incident and enhancement/maintenance tickets assignments and delivers excellent technical support Create and maintains technical documents, including data models
Job Title
Senior ETL Developer-10 YEARS