Data Integration Lead

Back to Jobs
Hexaware logo

Data Integration Lead

Hexaware

Location

India

Experience

Senior

Posted

Jul 30, 2026

Apply by

August 6, 2026

Applicants

0

Early applicantEasy applyFull-timeWork from Office

Job Description

Job profile: SQL Developer with OFSAA (Oracle Financial Services Analytical Applications) knowledge. Experience: 8-10 years Job Summary: Skilled SQL, and SSIS developer, complemented by minimum experience Oracle OFSAA. Other skills include Control-M, PowerShell, and Unix. Key Responsibilities: •Lead the design, development, and implementation of OFSAA solutions. •Develop and optimize complex SQL queries and database procedures. •Build and maintain ETL processes using SSIS to support data integration and reporting. •Manage job scheduling and automation using Control-M. •Write and maintain PowerShell scripts for automation and system management tasks. •Perform Unix shell scripting and administration to support development and production environments. •Collaborate with business stakeholders and translate business requirements into technical specifications. •Lead and mentor a team of developers, ensuring best practices and quality standards. •Communicate effectively with cross-functional teams and stakeholders to provide project updates and resolve issues. •Troubleshoot and resolve technical issues related to OFSAA, SQL, SSIS, and related tools. •Ensure adherence to project timelines and deliverables. Required Skills: •Strong expertise in OFSAA (Oracle Financial Services Analytical Applications). •Advanced SQL skills for data manipulation and reporting. •Proficient in SSIS for ETL development. •Experience with Control-M for job scheduling and automation. •Knowledge of PowerShell scripting. •Familiarity with Unix/Linux environments and shell scripting. •Excellent communication and interpersonal skills. •Proven leadership and team management experience. •Ability to understand and handle business requirements and communicate effectively with stakeholders

Key Responsibilities

  • Lead the design, development, and implementation of OFSAA solutions.
  • Develop and optimize complex SQL queries and database procedures.
  • Build and maintain ETL processes using SSIS to support data integration and reporting.
  • Manage job scheduling and automation using Control-M.
  • Write and maintain PowerShell scripts for automation and system management tasks.
  • Perform Unix shell scripting and administration to support development and production environments.
  • Collaborate with business stakeholders and translate business requirements into technical specifications.
  • Lead and mentor a team of developers, ensuring best practices and quality standards.
  • Communicate effectively with cross-functional teams and stakeholders to provide project updates and resolve issues.
  • Troubleshoot and resolve technical issues related to OFSAA, SQL, SSIS, and related tools.
  • Ensure adherence to project timelines and deliverables.

Skills Required

OFSAASQLSSISControl-MPowerShellUnixShell ScriptingCommunicationInterpersonal skillsLeadershipTeam managementHyperion PlanningIBM CognosMicroStrategyMicrosoft PowerBIMicrosoft SQL Server Analysis ServicesOracle Business Intelligence Enterprise Edition (OBIEE)QlikViewSAP BusinessObjectsSpotfireTableau

App exclusive · Free

Smart Job AI Coach

Your personal interview coach on every job — readiness tips, profile improvements, and role-specific prep. Available only in the Pulse Job app.

Interview readiness

See how prepared you are and what to improve for each role.

Personalized tips

Actionable suggestions based on your profile and the job.

After you apply

Keep coaching momentum from job detail through application success.

Get Smart Job AI Coach in the appFree on iOS and Android