ETL Developer

Job Description:

Job Description

 Roles And Responsibilities of ETL Developer
• Participate in Design discussions & updating Design documents
• Transforms data requirements into functional mapping designs
• Handle data modelling, data warehouse architecture, data pipeline management, and ETL testing
• Utilize various data warehousing fundamentals for setting up a data warehouse
• Help to collect, manage, and analyse huge volumes of data for extraction, transformation, and loading
• Implement database structure, data marts, data stores, and data lakes
• Ensure high-end security and good quality of data
• Come up with robust data flow models for the applications
• Safeguard proper functioning of data once the transfer is done
• Seamless collaboration with data management teams on giving required data
• Testing the warehouse infrastructure/storage system prior to data extraction
• Offer regular maintenance support
• Administering ETL tools, app integration, performance tuning
• Working on technical/functional documentation
• Monitor pre-decided ETL jobs and ensure resolution of discrepancies


Key Skills Needed to Be an Efficient ETL Developer
Technical Skills of ETL Developer 
• Proficiency in at least one ETL tool like Informatica, SSIS, Talend, Pentaho, etc.
o Developer – 3 to 5 years
• Experience in PL/SQL or T-SQL and Oracle/SQL Server development
• Coverage of dimensional modelling techniques
• Expertise in scripting languages like Python, Bash, Perl, etc. preferred
• Specialization in database engineering skills – SQL, NoSQL, Hadoop, etc.
• Exposure to warehousing architecture processes – MOLAP, ROLAP, EDW, etc.
• Exposure to Big Data components like Hadoop components – Hive, Sqoop, Spark, Hbase, HDFS
• Sufficient knowledge about OLAP, SSAS, SSIS
• If possible, understanding of modelling tools – Toad Data Modeler, Erwin, etc.
• Parameterization of ETL jobs for better time management

Soft Skills of ETL Developer 
• Data analytical, thinking, and troubleshooting skills
• Effective communication skills
• Ability to solve complicated technical issues, understand risks prior to the occurrence
• Competence to understand the large picture of the organizational data situation
• Collaboration and team skills
• Task organization, time management, and project management skills
• Creativity, innovation, and bent for thinking out of the box and learning something new
• Problem-solving skills