- Position: Business Intelligence/Data Warehousing-Lead Analyst
- (BI/DW) – ETL & Reporting Developer
- Category: Software Development/Engineering
- Main Location: Bangalore, Karnataka, India
- Position ID: J0823-1147
- Employment Type: Full Time
Position Description:
- This full-time function based in Bangalore requires 6-10 years of experience and a Bachelor’s degree in Computer Science or a related subject.
- Your obligations include designing and creating records warehouses, focusing on extraction, transformation, and loading (ETL) of statistics. Collaborate with the team to bridge the distance between velocity and accuracy, paint in an agile environment, and manage team sources successfully.
Duties and Responsibilities For Lead Analyst
- Design and create information warehouses, making sure of the finest ETL techniques.
- Collaborate with the crew to enhance performance at the same time as maintaining accuracy.
- Quickly adapt to new facts gear and concepts.
- Demonstrate an ardor for complex data systems and problem-fixing.
- Manage crew sources, scheduling, and cargo balancing to fulfill targets and SLAs.
- Work intently with Business Analysts to gather precise enterprise requirements.
- Communicate new requirements, changes, and updates to the crew.
- Work in an Agile surroundings, demonstrating organizational and time control skills.
- Utilize SQL information for question performance tuning and information database systems.
- Apply facts modeling concepts and revel in measurement information modeling.
- Demonstrate information in at least one ETL tool (Pentaho, Talend, SSIS, and so on.).
- Familiarity with diverse SQL/NoSQL statistics storage mechanisms and Big Data technology, with a preference for Snowflake.
- Knowledge of Data replication equipment like Qlik Replicate, Oracle Golden Gate, and Debezium is effective.
- Understanding programming languages like Java/.Net is an advantage.
- Familiarity with Microsoft Azure & Microsoft Power BI is a bonus.
- Independently execute responsibilities, which include the creation of the Semantic Layer (Cubes) primarily
- based on information warehouse layout and business requirements.
- Create reporting elements, which include filters, hierarchies, and custom companies, as required by means of reports and analytics.
- Adopt nice practices to ensure maximum efficiency and accuracy in finishing assigned duties.
- Perform unit trying out, validation of all Reporting objects, and in-depth records and functionality validation.
- Prepare try-out scripts and validation workouts as in step with the checking out approach.
- Conduct integration testing on work circulate modules and efficaciously file check outcomes.
- Collaborate with QA associates to resolve defects.
Required Qualifications For Lead Analyst :
- 8-10 years of enjoyment in creating Semantic Models & ETL techniques.
- Hands-on enjoyment in writing complex SQL queries.
- Proficient in growing reviews using Power BI.
- Strong teamwork, time-management, interpersonal, and communication abilities.
Must-Have Skills: - BI Tools: SAP BusinessObjects, MS Power BI, Pentaho reporting, etc.
- SQL
- ETL Tools: Pentaho, Talend, SSIS, etc.
- Big Data Technologies (Preferably Snowflake)
- Preferably Microsoft Azure & Microsoft Power BI.
- Good-to-Have Skills:
Anticipate Our Commitment:
- As a Lead Analyst at CGI, focusing on Business Intelligence/Data Warehousing, you will play a pivotal role in ETL and Reporting Development.
- When you are a part of CGI, you turn out to be a dependent guide, taking part with colleagues and customers to supply actionable insights for significant and sustainable outcomes.
- As a valued member of CGI, you’re not just a worker; you’re a shareholder and contributor to our boom considering the fact that 1976. We cherish range, fostering an administrative center in which every person feels an experience of belonging, and participating with customers to build extra-inclusive groups.
- CGI, as an same possibility organization, empowers each member to thrive and evolve. If you require lodges at some stage in the recruitment procedure, allow us to realize this, and we will gladly help.
- Join CGI for a fulfilling career in IT and commercial enterprise consulting, where your contributions form our collective fulfillment. Our dedication to inclusivity and identical opportunities makes CGI a place wherein diverse capabilities come together to create revolutionary solutions and significant effects. Your journey with us isn’t only a process; it’s a partnership in using excellence and fostering boom.
CLICKS FOR OTHER JOBS
- Azure Data Engineer Job: Lead Analyst Role IN CGI 2023
- Join CGI: SharePoint Developer in Bangalore: 2023