The Analyst will implement the Commercial Card roadmap including ETL, data modeling, and quality. Responsibilities include configuring data ingestion, developing data-related functionalities, writing complex SQL queries, and supporting deployment processes while meeting SLAs and improving documentation standards.
TransUnion's Job Applicant Privacy Notice
What We'll Bring:
Implement Commercial Card roadmap (ETL, Data Model, Data Quality).Configure data ingestion for Bank and Processor feeds. Implement new functionalities for Rebate solution (Rebate related set up)
UAT and Bug fixes. Support production deployment & code migration.
What You'll Bring:
- Develop standardized data models and define data types, and relationships between database attributes. Use of MSSQL, TSQL, PostGres, Python programming language to develop tools for data mining, analysis, and data visualization.
- Build complex algorithms and data transformation logic using SQL to align and load data into relational databases, data extracts, and reports.
- Write Complex SQL queries for Data manipulation, insertion, deletion, and updates.
- Meet SLAs and business agreements for daily, weekly and/or monthly deliverables.
- Ensure production processes follow defined standards, maintain industry standard documentation, enhance operational manuals & runbooks.
- Review of the Code to verify the accuracy, standards and optimizing the queries and minimizing the processing times.
- Work with functional teams within the organization (onshore and offshore) to resolve issues in the products.
Impact You'll Make:
- Escalate to management any issues or risks and assist with recommendations for mitigation/resolution.
- Track the progress of monthly and daily processes and validation, provide timely updates to team so that issues can be identified early in the process. Inform the client and escalate in case of any risks to SLA.
This is a hybrid position and involves regular performance of job responsibilities virtually as well as in-person at an assigned TU office location for a minimum of two days a week.
TransUnion Job Title
Assoc Engineer, Data Development
Top Skills
Python
TransUnion Bengaluru, Karnataka, IND Office
Primeco Towers - 5th floor, Bannerughatta Rd., Arekere MICO Layout, Main Rd. Panduranga Nagar, Bengaluru, India, 560076
Similar Jobs at TransUnion
Be an Early Applicant
As a Consultant, you will develop credit risk management and business intelligence analytic solutions for TransUnion's clients. Your role involves leading analytic engagements, designing programs for data extraction and analysis, and presenting insights. Collaboration with internal and external teams is key, along with mentoring junior colleagues and identifying opportunities to adopt analytic products.
What you need to know about the Bengaluru Tech Scene
Dubbed the "Silicon Valley of India," Bengaluru has emerged as the nation's leading hub for information technology and a go-to destination for startups. Home to tech giants like ISRO, Infosys, Wipro and HAL, the city attracts and cultivates a rich pool of tech talent, supported by numerous educational and research institutions including the Indian Institute of Science, Bangalore Institute of Technology, and the International Institute of Information Technology.
