Senior Data Migration Engineer

Varite Inc.; Bengaluru; On-site; INR 1,500,000 - 2,100,000; Full time

Job summary

VARITE INDIA PRIVATE LIMITED is seeking a Data Migration Engineer in Bangalore with 8 to 14 years of experience. You will translate Informatica workflows to Python EL scripts and dbt models, land high-volume data into the warehouse, and implement robust testing and orchestration.

The role requires strong expertise in Informatica PowerCenter, Python, SQL, dbt Core, Airflow and Oracle Data Pump, and offers a challenging environment for data movement and transformation at scale.

Qualifications

• 5+ years of Informatica PowerCenter experience including mappings, sessions and parameterization.
• 3+ years of hands-on dbt Core including model layering, macros and tests.
• Experience with Airflow DAG authoring and integration with scheduling tools.
• 5+ years of Python experience including parallelism and batch processing.
• 5+ years of SQL experience with complex joins, window functions and large data sets.
• Experience with Oracle Data Pump (expdp/impdp) or SQL Server BCP for high-volume data movement.

Responsibilities

• Assess complex Informatica workflows and translate into Python EL scripts and dbt models.
• Develop and maintain Python EL pipelines to land high-volume data into the target warehouse.
• Design and develop dbt transformation models based on Informatica mappings with best practices.
• Develop dbt native tests and Python unit tests to validate data quality.
• Create Airflow DAGs to orchestrate Python EL and dbt scripts end-to-end.

Tools

Informatica PowerCenter

dbt Core

Airflow

Python

SQL

Oracle Data Pump

Job description

Job Title : Data Migration Engineer

Experience Required : 8 to 14 Year(s) - Immediate joiners only

Location - Bangalore

Openings: 5

Company Name: VARITE INDIA PRIVATE LIMITED

About The Client: A global IT services and consulting company, multinational information technology (IT), headquartered in Tokyo, Japan. The Client offers a wide array of IT services, including application development, infrastructure management, and business process outsourcing. Their consulting services span business and technology, while their digital solutions focus on transformation and user experience design. It excels in data and intelligence services, emphasizing analytics, AI, and machine learning. Additionally, their cybersecurity, cloud, and application services round out a comprehensive portfolio designed to meet the diverse needs of businesses worldwide.

About The Job:

Data Migration Engineer

Essential Job Functions:

• Assess complex Informatica workflows including sessions, mappings, and parameterizations and translate them into equivalent Python EL scripts and dbt transformation models.
• Develop and maintain Python EL pipelines to land high-volume data, including billion-row tables, into the target warehouse using SQLAlchemy, cx_Oracle, pyodbc, and bulk export tools such as Oracle Data Pump and SQL Server BCP.
• Design and develop dbt transformation models based on Informatica mapping logic, incorporating dbt best practices including model layering, macros, incremental strategies, and snapshot patterns.
• Develop dbt-native tests as well as custom Python unit tests to validate transformation correctness and data quality.
• Develop Airflow DAGs to orchestrate Python EL and dbt scripts end-to-end, producing output that is functionally equivalent to the source Informatica workflows.

Qualifications:

• 5+ years of Informatica PowerCenter experience, including mappings, sessions, workflows, and parameterization.
• 3+ years of hands-on dbt Core experience, including model layering, macros, tests, and incremental materializations.
• Experience with Airflow, including DAG authoring, task dependencies, and integration with scheduling tools.
• 5+ years of Python experience, including production use of parallelism and batch data processing.
• 5+ years of SQL experience, including complex joins, window functions, and aggregations across large datasets.
• Experience with Oracle Data Pump (expdp/impdp) or SQL Server BCP/BULK INSERT for high-volume data movement.

Equal Opportunity Employer: VARITE is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. We do not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity or expression, national origin, age, marital status, veteran status, or disability status.

About VARITE: VARITE is a global staffing and IT consulting company providing technical consulting and team augmentation services to Fortune 500 Companies in USA, UK, CANADA and INDIA. VARITE is currently a primary and direct vendor to the leading corporations in the verticals of Networking, Cloud Infrastructure, Hardware and Software, Digital Marketing and Media Solutions, Clinical Diagnostics, Utilities, Gaming and Entertainment, and Financial Services.