Designs, develops, tests, and supports ETL/ELT integrations for financial and operational data. Responsibilities include source-to-target mapping, transformation, validation, reconciliation, batch pipeline development, file generation, data quality checks, production monitoring, defect resolution, and audit-ready documentation. The role collaborates with business, product, data, vendor, and engineering stakeholders across SIT, UAT, and Agile delivery environments.
This role is for one of Weekday’s clients
Salary range: Rs 2200000 - Rs 3000000 (ie INR 22 - 30 LPA)
Min Experience: 12+ years
Location: Hyderabad, Bengaluru
JobType: full-time
The Data Integration Engineer will design, develop, and support data integration solutions that extract financial and operational data from enterprise source systems and deliver trusted data to analytics platforms and external vendors. The role emphasizes source-to-target mapping, transformation, validation, batch pipelines, reconciliation, production support, and audit-ready documentation.
Requirements
Must Have
- Strong experience developing data integration, ETL/ELT, batch processing, and scheduled data delivery solutions.
- Proficiency in SQL and experience working with enterprise data sources, file-based integrations, and analytics platforms.
- Ability to analyze source-system structures and implement source-to-target mappings and transformation logic.
- Experience with data quality validation, reconciliation, exception handling, and root-cause analysis.
- Experience supporting SIT, UAT, production deployments, and defect resolution.
- Ability to create interface specifications, mapping documents, transformation rules, and operational support procedures.
- Strong collaboration skills across Business Analysts, Product Owners, data owners, vendors, Scrum Masters, and engineering teams.
- Experience working in Agile delivery environments.
Good-To-Have Skills
- Experience with financial services data, including brokerage, wealth management, cash management, deposits, or banking.
- Experience performing financial data reconciliation and validation.
- Understanding of data governance, auditability, security, and regulatory controls for financial data.
- Experience monitoring production jobs and supporting time-sensitive data feeds.
Key Responsibilities
- Design, develop, test, and maintain integrations that extract financial and operational data from enterprise source systems.
- Analyze source structures and collaborate with Business Analysts to define mappings, transformations, validations, and business rules.
- Develop automated extraction, transformation, validation, reconciliation, and file-generation processes.
- Build and maintain reliable scheduled batch jobs and recurring data pipelines.
- Implement data quality checks, control totals, exception handling, and reconciliation processes.
- Work with stakeholders, data owners, and vendor teams to validate source data, file formats, mappings, and integration requirements.
- Support SIT, UAT, production deployment, and data-output validation; investigate and resolve defects.
- Troubleshoot discrepancies, perform root-cause analysis, and implement corrective and preventive actions.
- Optimize data extraction and transformation processes for performance, scalability, and reliability.
- Monitor production jobs, investigate failures, and ensure timely delivery of data feeds.
Preferred Qualifications / Good to Have
- Bachelor’s degree in Computer Science, Engineering, Information Systems, or a related discipline.
- Relevant experience in place of formal education may be considered.
Financial services integration experience is strongly preferred
Must-have skills
ETL, ELT
Good-to-have skills
Data Integration
Similar Jobs
Artificial Intelligence • Information Technology • Software • Consulting
Build and maintain Java Spring Boot microservices exposing SAP data through secure REST APIs. Develop Informatica ETL pipelines, configure and manage Apigee API proxies, and integrate Elasticsearch. Ensure production-grade logging, monitoring, performance, testing, resilience, and documentation. Collaborate with data engineering, platform, and product teams in an Agile/Scrum environment while troubleshooting the complete integration chain.
Top Skills:
ApigeeCi/CdData ModelingElasticsearchEtl/EltGitInformaticaJavaMicroservicesOauthRest ApisSpring BootSQL
Aerospace • Greentech • Robotics • Analytics
Build and maintain infrastructure and integrations that move CMS, SCADA, and other customer data into cloud platforms. Monitor and resolve connectivity issues, support AWS infrastructure, respond to data support tickets, collaborate with service delivery teams, and improve connectivity processes for scalability and reliability. The role requires Linux command-line expertise, knowledge of data protocols, networking, and IT security, plus flexibility to support global operations outside normal business hours.
Top Skills:
Amazon CloudwatchAmazon Ec2Amazon S3Amazon VpcAWSCmsLlmsPythonScadaSQLUnix/Linux
Financial Services
This is a test requisition with no actual job responsibilities, qualifications, technologies, compensation details, or application requirements provided.
What you need to know about the Hyderabad Tech Scene
Because of its proximity to leading research institutions and a government committed to the city's growth, Hyderabad's tech scene is booming. With plans to establish India's first "AI city," the city is on track to become one of the world's most anticipated tech hubs, with companies like TransUnion, Schrödinger and Freshworks, among others, already calling the city home.
