Technical Specialist-Data Engg

Birlasoft

2 - 5 years

Noida

Posted: 22/06/2025

Job Description

Area(s) of responsibility

Must have at least 5+ Years of working experience in ETL Informatica tools.
Responsible for designing, developing, and maintaining complex data integration solutions using Informatica tools using Informatica PowerCenter10.x/9.5.
PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools –Informatica Server, Repository Server manager.
Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, SQL Server Databases.
Hands on experience in IICS and IDQ.
Extensive experience in developing Stored Procedures, Views, Complex SQL queries using SQL Server and Oracle PL/SQL.
Gather the requirements from the business and create detailed technical design documents, and model data flows for complex ETL processes using Informatica PowerCenter
Experience in resolving on-going maintenance issues and bug fixes, monitoring Informatica sessions as well as performance tuning of mappings and sessions.
Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documentation.
Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, MS SQL Server, XML,Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP.
Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
Ability and experience in managing/ coordinating with Onshore-Offshore teams

Skills with M/O flag are part of Specialization

Programming/Software Development -PL3 (Functional)

Systems Integration And Build -PL3 (Functional)

Help the tribe -PL2 (Behavioural)

Think Holistically -PL2 (Behavioural)

Database Design -PL1 (Functional)

Win the Customer -PL2 (Behavioural)

Data Visualisation -PL2 (Functional)

One Birlasoft -PL2 (Behavioural)

Data Management -PL2 (Functional)

Results Matter -PL2 (Behavioural)

Data Governance -PL1 (Functional)

Get Future Ready -PL2 (Behavioural)

Requirements Definition And Management -PL2 (Functional)

Test Execution -PL2 (Functional)

Data Engineering -PL3 (Functional)

Data Modelling And Design -PL2 (Functional)

MS SQL - PL3 (Mandatory)

Python - PL3 (Mandatory)

Informatica IICS - PL3 (Mandatory)

Spark - PL2 (Optional)

Oracle SQL - PL2 (Optional)

Oracle PL/SQL - PL2 (Optional)

Informatica Power Center - PL3 (Mandatory)

Unix Shell Scripting - PL2 (Optional)

Unix - PL2 (Optional)

About Company

Birlasoft is a global IT services and consulting company that is part of the CK Birla Group. It specializes in digital transformation, enterprise application services, and IT modernization for industries such as manufacturing, life sciences, BFSI, and energy. Birlasoft is known for its strong capabilities in SAP, Oracle, cloud, and analytics, helping clients drive innovation, reduce costs, and improve agility.