Birlasoft

Subcontractor

Birlasoft  •  New Jersey (Onsite)  •  15 hours ago
Apply
AI can make mistakes so check important info. Chat history is never stored.

Job Description

Area(s) of responsibility

We are looking for a Senior Informatica ETL Developer with strong experience in Data Warehousing concepts and ETL development The candidate should have hands-on expertise in designing, developing, and optimizing ETL pipelines using Informatica PowerCenter / Informatica Intelligent Cloud Services, along with deep understanding of data models, CDC, SCD, and performance tuning.

Key Responsibilities:

  • Design and develop ETL pipelines to load data into Data Warehouse
  • Work with multiple source systems (RDBMS, flat files, APIs) and integrate data into staging and DWH layers
  • Build and maintain Fact and Dimension tables based on business requirements
  • Implement Slowly Changing Dimensions (SCD Type 1, 2, 3) in ETL processes
  • Handle Late Arriving Dimensions using industry best practices
  • Implement Change Data Capture (CDC) mechanisms, including scenarios without timestamp columns
  • Optimize long-running ETL sessions and improve performance using partitioning and tuning techniques
  • Debug and optimize complex SQL queries and ETL workflows
  • Work with clustered and non-clustered indexes, and understand row store vs column store
  • Collaborate with business and analytics teams for data validation and reporting needs
Birlasoft

About Birlasoft

Navigating Change. Powering Progress. | Reimagining the Future with Birlasoft

Birlasoft, a powerhouse where domain expertise, enterprise solutions, and digital technologies converge to redefine business processes. We take pride in our consultative and design thinking approach, driving societal progress by enabling our customers to run businesses with unmatched efficiency and innovation. As part of the CKA Birla Group, a multibillion-dollar enterprise, we boast a 12,000+ professional team committed to upholding the Group's 170-year legacy. Our core values prioritize Diversity, Equity, and Inclusion (DEI) initiatives, along with Corporate Social Responsibility (CSR) activities, demonstrating our dedication to building inclusive and sustainable communities. Join us in shaping a future where technology seamlessly aligns with purpose.

For further information, visit www.birlasoft.com

Industry
IT & Software
Company Size
10,000+ employees
Headquarters
Pune, IN
Year Founded
Unknown
Social Media