Job Description :
Position: Data Modeler
Work Location: Chicago, IL
Job Details:
· Experience as a data engineer/modeler is highly desirable, demonstrating hands-on experience in enterprise data architecture, data warehousing, data modeling.
· Must have strong knowledge of principles, techniques, and methodologies of enterprise data modeling and dimensional data modeling.
· Strong skills in transferring functional specifications and requirements into technical design.
· Experienced to design and develop Informatica mappings, sessions, workflows and identify areas of optimization
· Ability to design, build, deploy and support end to end ETL processes
· Ability to implement an Informatica based ETL solution fulfilling stringent performance requirements.
· Lead and guide development of an Informatica based ETL architecture.
· Ability to design, coding, unit testing of ETL packages, triggers, and stored procedures, views, SQL transactions.
-Experience in developing slowly changing dimensions, error handling and performance tuning.
· Strong understanding of Very Large Database and DW Implementation experience
· Demonstrated experience and ability to work with business users to gather requirements and manage scope
· Demonstrated experience and ability to deliver results quickly in a fast-paced environment on multiple projects
· Proven ability to effectively manage their time and a desire to deliver results quickly and correctly
· Strong trouble-shooting and problem-solving skills with a Logical and pragmatic attitude Team player with strong oral and interpersonal skills
· Ability to communicate across all levels of the organization and work with diverse project teams.
Must Have Skills
· Must have solid requirements gathering, data modeling, design, coding, testing
· Must have experience working with Qlik Sense creating visualizations, building dashboards,
· debugging skills
· Must have experience with Qlik scripting and reporting
· Understanding data schema
Minimum years of experience - 10+