• US Citizen

• Green Card

• Corp-Corp

• W2-Permanent

• W2-Contract

• Contract to Hire

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 7th Oct 2023

• Responsible for coding, modifying, debugging, and documenting Data and Analytics applications that best support Office of Internal Audit (OIA) business requirements. You will also modify moderately complex Data & Analytics application programs, including detailed data design, ETL and Data Warehousing.

PRIOR WORK EXPERIENCE:

• 5 + Years of Data ingestion and transformation experience on SQL, SSIS, SSDT
• 2+ Years of experience with Python and RPA (Nice to have)

EDUCATION

• Bachelor’s degree in computer science, or IT or equivalent

SKILLS AND ABILITIES:

• 10+ years of development experience in data ingestion, data transformation, and data load
• Advanced knowledge of ETL tools such as SSMS, SSIS, Microsoft SQL Server
• Experience in or knowledge of Azure Data platforms such as Azure Data Factory, Azure Synapse, Azure ADLS Gen2, etc.
• Certification in Data Engineering or ETL (highly desirable)
• Advanced knowledge of secure data development, including design and implementation leading practices
• Demonstrated broad problem-solving skills, including experience identifying and using code libraries and open-source forums.

JOB DUTIES | ESSENTIAL FUNCTIONS:

• Plan, design, develop, modify, debug and evaluate moderately complex Data and Analytics software for the OIA business unit.
• Analyze existing ETL jobs, data warehouse applications or work to formulate logic for moderately complex new systems and devise moderately complex algorithms.
• Perform data analysis and test/debug software solutions.
• Design and extract data from different data sources such as Guidewire, Oracle Fusion, and other SQL Server databases.
• Apply effective programming security practices.
• Knowledge of RPA tools such as UiPath to automate unstructured data extraction and improve operational efficiency.
• Collaboratively work with Internal Audit, Enterprise Risk and Internal Control teams to help with their data extraction and analytics needs