Data Analyst

About 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 CK Birla Group, a multibillion-dollar enterprise, we boast a 12,500+ professional team committed to upholding the Group's 162-year legacy. Our core values prioritize Diversity, Equity, and Inclusion (DEI) initiatives, along with Corporate Sustainable Responsibility (CSR) activities, demonstrating our dedication to building inclusive and sustainable communities. Join us in shaping a future where technology seamlessly aligns with purpose.

About the Job:

AnETL (Extract, Transform, Load)developer is an IT specialist and software engineer who manages and oversees the process of extracting, transforming, and loading datasets into a data warehouse1. Here are the key responsibilities and skills associated with this role

Title: Data Analyst

Experience Required 4-6 Relevant years. less than/greater than experience profiles will consider as screen reject.

Location: Gurugram Sec 62

Notice Period 0-30 Days only

Mode Hybrid (3 days are mandatory)

Shift General

Educational Background: BE, B. Tech. or MCA/MS (Comp Sc.) from reputed institute.

Key Responsibilities:

Experience with Data Modeling and Data Warehousing, strong data analysis and modeling skills

Creating and maintaining Data dictionaries

Performance tuning ,indexing etc in PL/SQL

Exposure to Business Intelligence tools such as Business Objects and Composite is highly desirable

Ability to lead by example and set high standards of professionalism

• SQL Db
• Set up the database and user account for the domain configuration repository, Configure Kerberos for user authentication to the domain, Create domain for installing Informatica services
• Configuration and management of application services, license service etc
• Informatica Installation on servers or upgrade the existing setup
• The main job isdevelopment using IICS -mappin,mapping task and taskflows.
• The main job function of this role is development using Informatica, Teradata and UNIX
• Provide business and technical application support and troubleshooting
• Creation and maintenance of application and system documentation
• Configure Security domain, Scheduling Synchronization of users/group with LDAP service
• Person should know in and out of PL/SQL, post gre SQL both to work in project .

Mandatory Skills Required:

Experience in advanced ETL development such as designing/developing of Informatica mapping, mapplets, and workflows using Power Center (preferably 9 )

Strong knowledge of PL/SQL , post gre SQL

MS SQL Server and/or Sybase experience

Informatica Master Data Management

Informatica Data Services

Informatica Data Archival

Informatica Intelligent Cloud Service(IICS).