Position: Lead Analyst Experience: 6-10Years Category: Software Development/ Engineering Job location: Bangalore Position ID: J0823-1147 Employment Type: Full Time Qualification: Bachelor's degree in Computer Science or related field or higher with minimum 5 years of relevant experience. As a Lead ETL Developer you are in charge of designing and creating the data warehouses and all related functions, such as extraction, transformation and loading of data into the warehouse. Improve - Work with the team to pragmatically and continually reduce the gap between getting things done fast and getting things done right Ability to pick up new data tools and concepts quickly. Passionate about complex data structures and problem solving. High attention to detail. Plans and manages team resources through scheduling and load balancing to achieve team objective, SLAs Work collaboratively with Business Analyst to identify and gather detailed business requirements Communicates to all team members any new requirements, changes, updates on all support related information company information Experience in working in an Agile environment Organizational skills: time management and planning SQL knowledge (query performance tuning, index maintenance, etc.) as well as an understanding of database structure Knowledge of data modeling principles and experience with dimension data modelling. Knowledge of at least one ETL tool (Pentaho, Talend, SSIS etc.) Knowledge of various SQL/NoSQL data storage mechanisms and Big Data technologies (Snowflake preferable). Knowledge of any Data replication tool like Qlik replicate, Oracle Golden Gate, Debezium is good to have. Good understanding of programming knowledge like Java/.Net is a bonus. Knowledge of Microsoft Azure & Microsoft Power BI would be an advantage Should be able to work independently Creation of the Semantic Layer (Cubes) based on the data warehouse design and business requirements. Creation of all reporting elements such as filters, hierarchies, custom groups as required by the reports and analytics. Adopt best practices in completion of the assigned tasks ensuring efficiency and accuracy of the desired results. Perform required unit testing and validation of all Reporting objects. Perform in-depth data and functionality validation. Prepare required testing scripts and validation routines as per the testing strategy. Conduct Integration testing on respective work stream modules and document test results effectively. Work with QA associates to resolve defects Your future duties and responsibilities Ability to pick up new reporting tools and concepts quickly. Requires strong analytical, conceptual and problem-solving abilities Experience in working in an Agile environment. Experience with dimension data modelling. Ability to manage multiple priorities, and assess and adjust quickly to changing priorities Requires leadership qualities to mentor junior members of the team. Proficiency with any BI Tool like SAP BusinessObjects, MS Power BI etc. SQL knowledge (query performance tuning, index maintenance, etc.) as well as an understanding of database structure Performance tuning experience related to reporting queries required. Understanding of data integration issues (validation and cleaning), familiarity with complex data and structures Programming / scripting experience and knowledge of software development life cycle is preferred. Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities Gather requirements and business process knowledge in order to transform the data in a way that’s geared towards the needs of end users Maintain and improve already existing processes. Ensure that the data architecture is scalable and maintainable Work with the business in designing and delivering correct, high quality data Investigate data to identify potential issues within ETL pipelines, notify end-users and propose adequate solutions Prepare documentation for further reference Required qualifications to be successful in this role: 8-10 years of experience in creating Semantic Models & ETL processes. Hands on experience in Writing Complex SQL Queries Creating reports using Power BI Team player Good time-management skills Great interpersonal and communication skills Required Qualifications To Be Successful In This Role Must-to have Skills- BI Tool like SAP BusinessObjects, MS Power BI, Pentaho reporting etc. SQL ETL tool (Pentaho, Talend, SSIS etc.) Big Data technologies (Snowflake preferable) Preferably - Microsoft Azure & Microsoft Power BI Good-to Have Skills- Insights you can act on While technology is at the heart of our clients’ digital transformation, we understand that people are at the heart of business success. When you join CGI, you become a trusted advisor, collaborating with colleagues and clients to bring forward actionable insights that deliver meaningful and sustainable outcomes. We call our employees “members” because they are CGI shareholders and owners, and, as owners, we enjoy working and growing together to build a company we are proud of. This has been our Dream since 1976, and it has brought us to where we are today—one of the world’s largest independent providers of IT and business consulting services. At CGI, we recognize the richness that diversity brings. We strive to create a work culture where everyone belongs, and we collaborate with clients in building more inclusive communities. As an equal opportunity employer, we empower all our members to succeed and grow. If you require an accommodation at any point during the recruitment process, please let us know. We will be happy to assist. Ready to become part of our success story? Join CGI—where your ideas and actions make a difference.