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 Chennai, Tamil Nadu, IND Office
DLF IT SEZ 8th, 9th, and 10th floor Block 2, Chennai, India, 600089
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 Chennai Tech Scene
To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.
