Data Analyst (ERP Migration)

Role Overview

We are seeking a skilled Senior Data Analyst with substantial hands-on experience in Source System Analysis, data mapping, data modeling, SQL analysis, and integration testing. The ideal candidate will support seamless data flow across business applications, ensure data accuracy, and contribute to system improvements.

Key Responsibilities

• Conduct detailed data mapping between source and target systems, ensuring consistency and accuracy.
• Build and maintain data models to support business processes, reporting needs, and integration workflows.
• Write and optimize SQL queries for data validation, analysis, migration, and troubleshooting.
• Work closely with cross-functional teams to gather data requirements and understand business logic.
• Develop and execute integration test plans, including functional, data validation, and regression testing.
• Support data migration activities, including extraction, transformation, and loading (ETL).
• Monitor and troubleshoot integration issues, ensuring timely resolution.
• Document integration flows, data dictionaries, mapping catalogs, and knowledge artifacts.
• Ensure integration security, data integrity, and compliance with organizational standards.

Required Skills & Qualifications

• 5+ years of experience insource system integrations, data mapping, and system-to-system data workflows.
• Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field.
• Hands-on experience with data mapping, data modelling, and database schema design.
• Proficiency in SQL (complex joins, stored procedures, performance tuning).
• Experience with ETL tools or integration platforms (Informatica, Boomi, MuleSoft, Talend, Pentaho).
• Strong analytical and problem-solving skills.
• Experience with API-based integrations (REST/SOAP) is a plus.
• Familiarity with testing methodologies for integrations and data validation.
• Ability to work with business users, understand workflows, and translate requirements into technical solutions.

Preferred Qualifications

• Experience with cloud ERP or cloud integration (AWS/Azure/GCP).
• Knowledge of JSON, XML, CSV transformation.
• Exposure to scripting languages (Python, Shell).
• Experience in Agile/Scrum environments.
• Prior involvement in ERP implementation or upgrade projects.

Competencies

• Tech Savvy - Anticipating and adopting innovations in business-building digital and technology applications.
• Self-Development - Actively seeking new ways to grow and be challenged using both formal and informal development channels.
• Action Oriented - Taking on new opportunities and tough challenges with a sense of urgency, high energy, and enthusiasm.
• Customer Focus - Building strong customer relationships and delivering customer-centric solutions.
• Optimize Work Processes - Knowing the most effective and efficient processes to get things done, with a focus on continuous improvement.

Why Join Us?

• Be part of a collaborative and agile team driving cutting-edge AI and data engineering solutions.
• Work on impactful projects that make a difference across industries.
• Opportunities for professional growth and continuous learning.
• Competitive salary and benefits package.

Application Details

Ready to make an impact? Apply today and become part of the QX Impact team!

CAP-190 : Senior Data Analyst

📍Location : Bangalore / Hyderabad / Chennai / Pune / NCR

🧠Experience : 7 - 15 Years

🆔Job Code : CAP-190

🏢Work Type : Hybrid - 3 Days in a Week

About the Client (CODE: CAP)

CAP operates at the forefront of the financial services industry, providing consulting, technology, and digital transformation solutions to leading organizations worldwide. With a focus on innovation, CAP empowers clients to navigate complex regulatory landscapes, optimize operations, and drive business growth. The company fosters a collaborative and agile culture, encouraging continuous learning and excellence.

Key Responsibilities

● Define and obtain source data required to deliver insights and use cases.

● Determine data mapping and join multiple data sets across various sources.

● Develop methods to highlight and report data inconsistencies for user review.

● Propose and assist with suitable data migration sets for stakeholders.

● Support teams in processing data migration sets and coordinating migration activities.

● Plan, track, and coordinate the data migration team and migration run-book.

● Collaborate with stakeholders to avoid negative customer and business impacts.

● Ensure robust communication and escalation mechanisms across project portfolios.

● Implement strategic solutions and avoid short-term workarounds.

● Maintain strong control and compliance standards in data handling.

Required Skills

● Minimum 7+ years of experience as a Data Analyst, preferably in financial services.

● Strong expertise in Pyspark, Python, and SQL.

● Experience with big data programs and data models in banking or financial markets.

● Ability to write SQL queries and navigate databases such as Hive, CMD, Putty, and Note++.

● Excellent analytical skills and commercial acumen.

● Strong verbal and written communication skills.

● Proven ability to manage multiple priorities and deliver within tight deadlines.

● Business analysis skills, including defining and understanding requirements.

● Familiarity with SDLC, Agile processes, and a bias towards TDD.

● Attention to detail and a proactive, problem-solving mindset.

Nice to Have

● Knowledge and experience in Data Quality & Governance.

● Working experience with Spark Scala or Java for Spark.

● Proven track record of managing small, delivery-focused data teams (for senior roles).

● Experience with market data vendors and domains such as Party/Client, Trade, Settlements, Payments, Instrument and Pricing, Market and/or Credit Risk.

Why Join CAP (Code Name)

Join CAP to work on impactful data initiatives within the financial services sector, tackling complex technical challenges and driving meaningful business outcomes. You'll collaborate with talented professionals in a dynamic, agile environment that values innovation and continuous improvement. CAP offers opportunities for professional growth, skill development, and the chance to contribute to high-visibility projects that shape the future of financial technology.

About the Employment Model

Direct Hire (Client Payroll) : For this role, you’ll be hired directly by the client and be part of their internal team. Straatix supports the hiring process, but your employment, payroll, and benefits are all managed by the client.

Position title: Business Intelligence and Data Analyst

Summary -

• Operate and continuously improve the CARS/BI backend within the global Enterprise Data and Business Intelligence platform, ensuring system stability, continuous data loading, and Warehouse the timely delivery of business-critical reports.

• Own the underlying data foundation — SQL pipelines, relational data models, and data warehouse structures — that internal reporting teams and global Data Management initiatives depend on, and act as 1st and 2nd level support for internal customers such as SCM and Sales.

• The role is needed to secure daily BI availability in the Asian time zone, reduce the risk of late or incorrect reporting, and add dedicated database and ETL capacity to the global BI team, including support to the Data Centre team on infrastructure-related issues.

Responsibilities:

• Operate, monitor, and maintain the CARS/BI data integration and data processing workflows, ensuring continuous data loading and stable daily business operations.

• Provide 1st and 2nd level support for CARS/BI, including user support, incident handling, and root-cause analysis of data issues.

• Develop, maintain, and optimise SQL-based data pipelines and transformations within the Enterprise Data Warehouse.

• Design and maintain relational data models and data warehouse structures for CARS BI.

• Integrate data from ERP and other enterprise systems into the BI backend.

• Ensure data consistency, integrity, and performance at the database level, including query tuning and database efficiency improvements.

• Administer the BI technical environment and contribute to its continuous enhancement as part of a global team.

• Support reporting teams by providing structured, reliable datasets and safeguarding the timely delivery of business-critical reports.

• Contribute to global Data Management initiatives, with a focus on Master Data Management and the development of a Common Data Model within the Business Integration Platform.

• Collaborate with the Data Centre team to resolve infrastructure-related issues affecting BI availability.

Education and Experience:

Bachelor's degree in Engineering (BE/B.Tech) or equivalent in Computer Science, Information Technology, or a comparable technical field.

Minimum 3 years of relevant professional experience in Business Intelligence, data warehousing, or database development, including hands-on SQL and ETL work in an enterprise environment.

Experience supporting business users in a global or multi-time-zone IT organisation is an advantage.

Competencies:

• Knowledge about either BI platforms (e.g. IBM Cognos BI suite) or ETL tools (e.g. Informatica PowerCenter)

• Database, data modeling and SQL (preferred Oracle PLSQL)

• Good analytical and communication skills

• Teamplayer

• English

• Strong hands-on experience with SQL (advanced level)

• Solid understanding of relational databases and data warehouse concepts

• Experience with ETL tools and database technologies (e.g., Oracle, SQL Server, SAP BW,Informatica or similar)

• Performance tuning and query optimization skills

• Structured, detail-oriented, and quality-focused working style

• Good understanding of enterprise data flows (SAP/CARS is a plus)

Key Interfaces and Stakeholders:

Only internal customers with different topics: e.g. SCM, Sales etc.

Geography to cover and Travel requirements:

Asian Time Zone, Sometimes travel is required

Behavioral Characteristics

Reliability and accountability — the role safeguards daily reporting availability, so dependable ownership of monitoring and issue follow-up is expected. Structured, analytical problem solving with the patience for thorough root-cause analysis. Service orientation and clear communication towards internal customers such as SCM and Sales. Initiative taking and self-reliance, given largely independent work in the Asian time zone. Cooperation and team spirit within a globally distributed BI team across cultures and time zones. Flexibility and resilience under time pressure, including occasional off-hours support during critical data loads. Integrity and discretion when handling confidential business data. Quality focus and attention to detail, with a continuous improvement mindset.

Interview process

2 rounds - Virtual interview and 1 round Face to Face

Any other Criteria

• Notice Period: Below 60 or 90 Days . No Negotiation on Notice Period
• Gender: Female and Male; Female preferred
• Qualification:Bachelor's degree in Engineering (BE/B.Tech) or equivalent in Computer Science, Information Technology, 

Define and obtain source data required to deliver insights and use cases.

● Determine data mapping and join multiple data sets across various sources.

● Develop methods to highlight and report data inconsistencies for user review.

● Propose and assist with suitable data migration sets for stakeholders.

● Support teams in processing data migration sets and coordinating migration activities.

● Plan, track, and coordinate the data migration team and migration run-book.

● Collaborate with stakeholders to avoid negative customer and business impacts.

● Ensure robust communication and escalation mechanisms across project portfolios.

● Implement strategic solutions and avoid short-term workarounds.

● Maintain strong control and compliance standards in data handling.

Required Skills

● Minimum 7+ years of experience as a Data Analyst, preferably in financial services.

● Strong expertise in Pyspark, Python, and SQL.

● Experience with big data programs and data models in banking or financial markets.

● Ability to write SQL queries and navigate databases such as Hive, CMD, Putty, and Note++.

● Excellent analytical skills and commercial acumen.

● Strong verbal and written communication skills.

● Proven ability to manage multiple priorities and deliver within tight deadlines.

● Business analysis skills, including defining and understanding requirements.

● Familiarity with SDLC, Agile processes, and a bias towards TDD.

● Attention to detail and a proactive, problem-solving mindset.

Nice to Have

● Knowledge and experience in Data Quality & Governance.

● Working experience with Spark Scala or Java for Spark.

● Proven track record of managing small, delivery-focused data teams (for senior roles).

● Experience with market data vendors and domains such as Party/Client, Trade, Settlements, Payments, Instrument and Pricing, Market and/or Credit Risk.

Key Responsibilities

• Lead end-to-end data migration initiatives, including assessment, planning, mapping, transformation, validation, and reconciliation.
• Define and implement data governance frameworks, standards, policies, and processes.
• Design and manage data solutions using Microsoft Azure Data Services.
• Lead development of BI dashboards, reports, KPIs, and analytics solutions.
• Work with business and technical stakeholders to understand reporting and data requirements.
• Develop and maintain data models, data pipelines, ETL/ELT processes, and reporting architecture.
• Ensure data quality, consistency, integrity, security, and compliance throughout migration and reporting processes.
• Identify data risks, dependencies, gaps, and migration challenges and drive their resolution.
• Establish data validation and reconciliation mechanisms to ensure migration accuracy.
• Provide technical leadership and guidance to data engineers, BI developers, and other project team members.
• Collaborate with application, cloud, infrastructure, and business teams during project implementation.
• Monitor data migration and BI deliverables against project timelines, quality standards, and business objectives.
• Prepare technical documentation, data dictionaries, mapping documents, governance guidelines, and project reports.

Required Skills & Experience

• 7+ years of experience in data, migration, BI, or related technology roles.
• Strong experience working on software/IT projects and managing data-related workstreams.
• Hands-on experience with Microsoft Azure Data Services.
• Strong understanding of data migration methodologies, ETL/ELT, data transformation, and reconciliation.
• Experience in Data Governance, Data Quality, Master Data, Metadata Management, and Data Security.
• Strong experience with BI reporting and dashboard development.
• Good understanding of SQL and relational databases.
• Experience with Power BI and data visualization is highly desirable.
• Knowledge of Azure services such as Azure Data Factory, Azure Data Lake, Azure Synapse Analytics, Azure SQL Database, or equivalent.
• Strong understanding of data architecture and data lifecycle management.
• Excellent stakeholder management, communication, analytical, and problem-solving skills.

Strong Senior Developer – PL/SQL, SQL & ETL (Microsoft SSIS) Profile

2

Mandatory (Experience 1) – Must have minimum 5+ years of strong hands-on experience in PL/SQL and SQL development, including complex stored procedures, functions, queries, joins, data manipulation, and query/performance optimization.

3

Mandatory (Experience 2) – Must have strong hands-on experience in ETL development using Microsoft SSIS, including building, maintaining, optimizing, and troubleshooting SSIS packages for large-volume data movement and transformation.

4

Mandatory (Experience 3) – Must have solid experience working with Data Warehousing concepts and architectures, including data models, fact/dimension structures, ETL data flows, and enterprise reporting/data warehouse environments.

5

Mandatory (Experience 4) – Must have experience managing batch jobs, scheduling, and data pipelines, ensuring timely and reliable execution of enterprise ETL workflows.

6

Mandatory (Experience 5) – Must have hands-on experience in production support for SSIS/ETL and data warehouse jobs, including monitoring job execution, troubleshooting failures, performing root cause analysis, and implementing preventive fixes.

7

Mandatory (Experience 6) – Must have experience with data quality, validation, and troubleshooting, including identifying and resolving data discrepancies/issues affecting downstream reports, dashboards, and analytics.

8

Mandatory (Experience 7) – Must have experience with unit, integration, and regression testing of SQL, PL/SQL, and ETL components, along with strong documentation of technical designs, data mappings, data flows, and deployment processes.

9

Mandatory (Location) – Must be willing to work in a hybrid model from a city where Cognizant has an office.

10

Mandatory (Notice Period) – Immediate joiners or candidates who can join within 2–4 weeks.

Strong Data Analyst Profile with advanced Excel and SQL expertise

2

Mandatory (Experience 1): Must have 4+ years of overall experience as a hands-on Data Analyst

3

Mandatory (Tech skill 1): Must be highly proficient in advanced Excel — complex functions, macros, calculations, and pivots

4

Mandatory (Tech skill 2): Must have strong hands-on SQL and a good understanding of relational database concepts

5

Mandatory (Tech skill 3): Must be able to automate routine tasks using Python (for automation purposes)

6

Mandatory (Skill 1): Must have exceptional analytical, problem-solving, and logical skills, with strong attention to detail and accuracy

7

Mandatory (Skill 2): Must be able to understand complex data and business logic and convert it into a model (the role models complex utility tariffs, rates, and programs)

8

Mandatory (Communication): Must have strong verbal and written communication, able to work independently with India- and US-based team members and articulate problems and solutions over calls and email.

9

Mandatory (Location): Must be based locally in Pune (or the nearby Maharashtra belt — Mumbai, Nagpur), as the final round is in person

10

Preferred (Domain): Experience in the Energy/Utility industry and familiarity with basic utility (electrical/gas) tariff concepts

Job Description:

Skill Set

Informatica, IDMC, Informatica MDM

Experience

4-6 Years

Location

Faridabad, Haryana, India

Work Mode- Hybrid

Job Description

Roles & Responsibilities

• Lead project team members through all activities required to successfully deliver Informatica.
• Define technical specifications for workflows and business rules.
• Prepare detailed design documents for data migration.
• Configure, build and unit test Informatica components, including data structures, roles, workflows, and portals.
• Train and mentor colleagues in Informatica implementation activities and best practices.
• Support integration, system, and user acceptance testing.
• Accountable for the Master Data Management, Technical Architecture, providing data modeling solutions and recommendations.
• Profile & Analyze Source Data usage using ETL tool.
• Automation, job scheduling, dependencies, monitoring.
• Configure/Script Business rules and transformation rules in ETL
• Data pipeline using IICS
• Hands on experience in Informatica MFT, Data Exchange (DX),and Data Transform (DT) modules
• Integration experience using various adapters (MLLP, SOAP, REST, SFTP, ODBC) will be essential.
• Strong knowledge and experience with developing complex SQL Queries, stored procedures, and triggers for RDBMS systems.
• Experience in administering, supporting, and performance tuning using Informatica.

This role will be permanent with NAM info and deploy to client location Hyderabad & Pune.

Work Mode: WORK FROM OFFICE

Role Descriptions:

• Perform detailed data analysis and support business decision-making
• Gather and document business requirements and translate them into technical specifications
• Work closely with stakeholders to define data needs and reporting requirements
• Create user stories, functional specifications, and support UAT activities
• Ensure alignment between business objectives and data solutions

Required Skills:

• Strong expertise in SQL and data querying
• Proven experience in data analysis, requirement gathering, and stakeholder management
• Ability to translate business requirements into technical solutions and user stories
• Good understanding of data models, reporting, and analytics concepts

Skills: Business Analysis~ORACLE SQL

Locations: ~HYDERABAD~PUNE~

Desire candidate

• Candidate should have valid PF.

• Design, build, and maintain scalable ETL/ELT pipelines for batch and real-time data ingestion and transformation.
• Develop and optimize data lake and data warehouse architectures (e.g., Snowflake, BigQuery, Redshift).
• Work with cloud platforms GCP, Azure to manage data infrastructure.
• GCP as mandatory skills
• Collaborate with analytics and product teams to understand data needs and deliver solutions.
• Ensure data quality, reliability, security, and compliance across all data systems.
• Mentor junior data engineers and contribute to best practices and code reviews.
• Monitor and troubleshoot data pipeline performance and resolve data-related issues.
• Automate data validation, monitoring, and alerting processes.
• 8+ years of experience in data engineering or software engineering with a data focus.
• Proficient in SQL and at least one programming language (e.g., Python, Scala, Java).
• Experience with modern data warehousing tools (e.g., Snowflake, Redshift, BigQuery).
• Strong understanding of data modeling, data lakes, and ETL/ELT design.
• Hands-on experience with orchestration tools like Airflow, dbt, or similar.
• Solid experience with cloud data platforms (AWS/GCP/Azure).
• Familiarity with CI/CD pipelines, containerization (Docker/Kubernetes), and version control (Git).
• Experience working in a DevOps or DataOps environment.
• Knowledge of data governance, lineage, and cataloging tools (e.g., Collibra, Alation).
• Familiarity with streaming technologies (Kafka, Spark Streaming, Flink).
• Experience supporting machine learning workflows and data science initiatives.