● Having 10+ Years of Experience in IT industry in Developing Data Engineering and BI (Data warehouse) using Oracle11G, Informatica (BDM), SQL Server 12/16/17, SSIS, SSRS, SSAS and Power BI.
Team Leader experienced in directing activities of workgroups. Develops strategies, provides training, sets goals and obtains team feedback. Excellent interpersonal and communication skills. Big picture focus with excellence in communicating goals and vision to succeed. Problem solver, networker, and consensus builder.
● As Scope is base lined now, we need to plan the one-to-one meeting with CR requester, so Schedule the meetings with requester.
● Motivating the team and solving problems and guiding the team to complete their tasks
● Develop database solutions to store and retrieve required information. Analyze structural requirements for new software and applications
● Design, develop, and implement ETL pipelines using Informatica (BDM),for big data platforms (Hadoop, Hive, etc.)
● Optimize big data processing for high performance and scalability.
● Connect to various data sources: RDBMS (Oracle, SQL Server), flat files, cloud storage (Azure Blob, AWS S3), APIs.
● Build complex transformation logic using Informatica Big Data Edition transformations (Joiner, Aggregator, Lookup, Expression, etc.).
● Team capacity planning and Performance pack preparation for each individual.
● Technical specification Document and Mapping Sheets preparation for all the datasets.
● Having Excellent Knowledge in writing SQL queries, Joins, Stored Procedures, and Views & Indexes.
● Designed and Developed the SSIS Packages by using different data Transformations to Load.
● Data migration from Sales Forces Applications.
● Experience in Tuning the SSIS Packages
● Good Experience with Package Configurations, Error Handling and Scheduling packages.
● Good experience on implementing Logging, break points and check points.
● Good knowledge on tuning the Queries & Stored Procedures.
● Build ETL/ELT pipelines using ADF, Databricks.
● Reads curated data from Data Lake using Power BI, or SQL Server.
● Proficient with Reporting Services (SSRS) to generate different types reports for Business Users.
● Hands on experience in SQL Server Master Data services (MDS).
● Thorough Knowledge on Data Warehouse Concepts like Star Schema and Snow Flake Schema.
● Strong ability to understand new concepts and applications.
● Developing visual reports, dashboards and KPI scorecards using Power BI desktop.
● Connecting to data sources, importing data and transforming data for Business Intelligence.
● Excellent in analytical thinking for translating data into informative visuals and reports.
● Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills.
