Technology: ETL
Position: Permanent
Overall Experience: 6+ years
Relevant Experience: 1+ years
No. of position: 1
Location: Bangalore
Mandatory Skill: Experience on ETL Tool SSIS and SSAS .
Technical Skills:
 

  • At least 6+ years of technical experience with databases, data warehousing and BI tools especially SSIS/SSAS.
  • Strong ETL Experience in Design, Configuration, Data Mapping, Extraction, Transformation and Loading in an extremely complex environment processing large volumes of data using SSIS/SSAS.
  • Skills in maximizing the high-performance capabilities and parallel execution of processes provided by ETL functionality.
  • Experience in any one programming language (java or .net) as per based on Tool in order to overcome complex challenge scenario.
  • Experience with code deployment and automation using Jenkins. Should be able to investigate build issue and resolve independently.
  • Experience in Handling ETL process from big data source like Hadoop.
  • Experience in understanding the end user data and provide key insight for bringing value addition from that data.
  • Strong understanding of relational database concepts & technology data modeling (dimensional/snowflake), T-SQL, query optimization, data warehouse architecture, knowledge on Data Modeling tools like Erwin or any other open source.
  • Experience with setup, configuration, design best practices, performance optimization, team-based development approaches with a leading ETL/BI tool.
  • Well organized and able to manage multiple projects in a fast-paced demanding environment.
  • Ability and willingness to learn new tools and applications.
  • Effective written and verbal communication skills with the ability to convey complex technical concepts to business users and management.
  • Experience with databases such as Oracle, Postgres, MySQL, NoSQL (MongoDB),MSSQL,etc.

Profile:

  • Proven experience as ETL developer (SSIS/SSAS) for almost 5 to 7 Yrs of experience with proven current hands-on experience in SSIS/SSAS for at least last 4 years.
  • Translate Business Needs to Technical Specifications, review technical design documentation to ensure the correct development of reporting solutions.
  • Evaluate and Improve existing BI systems.
  • Design, build, Deploy BI solution (e.g ETL Tools like SSIS/SSAS, ).
  • Maintain and support data integration platform (e.g SSIS/SSAS).
  • Familiarity or hands on with multiple BI technologies (e.g SSIS/SSAS,
  • Experience working with data analysis, data modeling Knowledge  and  tools experience  (e.g. ER/ Win, Power Designer, ERStudio), Database technologies (SQL/Oracle),ETL Tools (SSIS/SSAS).