What are the responsibilities and job description for the Senior ETL Developer position at Maintec Technologies?
Job Title - Senior ETL Developer
Duration - Long term
Location - Chicago, IL (Remote)
Job Description : Key Required Skills-
ETL design, processes, tools (e.g. Ab Initio, Informatica), scripting, programming languages (e.g. Python, R), data modeling, data warehousing, relational databases (e.g. PostgreSQL), SQL, Tableau, cloud-based data platforms (e.g. AWS), related services
Position Description-
- Collaborate with cross-functional teams to understand business requirements and translate them into technical ETL solutions.
- Design and develop data models, ETL processes and SQL queries to extract and manipulate data required for BI reporting.
- Optimize data loading strategies to achieve efficient use of resources and minimize processing time.
- Implement data structures that enable agile and flexible reporting capabilities.
- Analyze reporting requirements and data needs to ensure availability of data required to develop dashboards and reports.
- Design and develop robust interactive dashboards and reports in Tableau using data from a variety of sources.
- Brief management, customer, team, or vendors using written or oral skills at appropriate technical level for audience.
- All other duties as assigned or directed
Detailed Skills Requirements Foundation for Success (Basic Qualifications) :
This experience is the foundation a candidate needs to be successful in this position :
Factors to Help You Shine (Required Skills) :
These skills will help you succeed in this position :
o Experience architecting end-to-end ETL solutions, from data extraction to loading, ensuring scalability, reliability, and performance.
o Strong experience designing and developing complex ETL workflows using tools (e.g., Ab Initio, Informatica) and / or scripting languages (e.g., Python), incorporating best practices for data transformation and loading.
o Ability to evaluate and enhance existing ETL processes to ensure efficient data transformation, cleansing, and loading.
o Experience identifying bottlenecks and optimizing ETL workflows to improve data quality, accuracy, and processing speed.
o Experience creating and maintaining comprehensive documentation for ETL workflows, data lineage, and transformations.
o In-depth knowledge of database concepts and proficiency in working with relational databases (e.g., PostgreSQL, Oracle, SQL Server).
o Strong SQL skills and familiarity with data warehousing concepts.
o Experience designing and developing data models that facilitate accurate and efficient self-service reporting and analysis.
o Expertise in both Dense and Sparse loading techniques, employing them based on specific data scenarios and requirements.
o Experience designing and developing Tableau visualization solutions.
o Experience developing interactive dashboards, charts, pivots, and reports in Tableau Desktop 2021.1 or higher using advanced calculations, parameters, and data blending.
o Experience connecting to varied data sources for BI reporting purposes, including but not limited to, Oracle 19c or above, DB2, Greenplum, SQL Server, and other enterprise data sources.
o Experience with other BI tools (e.g., Power BI, QlikView, MicroStrategy)
How to Stand Out from the Crowd (Desired Skills)
Showcase your knowledge of Tableau through the following experience or skills :
Education
