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