You would be responsible for ETL development leveraging SSIS against the Marketing and Merchandising Enterprise Data Warehouses. This position reports to the ETL Manager. You must demonstrate a proficiency with data modeling and Microsoft SSIS. You will work closely with the peer members of the enterprise data and other IT teams to ascertain expert understanding of the available data in all systems. You will be responsible for leveraging ETL best practices as well support any corporate projects and data inquiries. An ideal candidate is a well-spoken, organized, self-motivated individual who continues to learn about emerging technologies and is able to deliver expert-quality, timely results.
RESPONSIBILITIES
• Work with Atlassian Jira to complete tasks in a timely manner
• Requirements gathering, development and deployment of new ETL processes
• Work directly with reporting team to ensure ongoing operational and new work complies with requirements and ETL best practice and standards
• Provide ad-hoc support for advanced strategic data analysis initiatives
• Update Atlassian Confluence documentation on all developed transformation logic against data in the data warehouse
• Support business user questions about the data and provide documentation and training when and where necessary
• Provide rotating on-call off-hours support of all ETL systems
REQUIRED SKILLS
• At least 5 years of dedicated data warehousing ETL SSIS work experience is required
• Experience transferring data into datawarehouses is a must.
• Ability to think and communicate critically, in order to support and facilitate strategic data warehouse extension and analytical initiatives
• B.A. or applicable degree and/or equivalent work experience
Plus skills:
• Previous data modelling experience with retail or e-commerce data model(s)
• Expert knowledge of data modeling concepts, data warehouse and data aggregation processes and strategies
• Knowledge and command of data governance/best practices
[REMOVED BY FREELANCER.COM ADMIN - PLEASE SEE SECTION 13 OF OUR TERMS AND CONDITIONS]
I have deep experience in T-SQL, SSIS development. Debugging of queries and packages, with huge complexity( I have developed lot of T-SQL, SSIS solutions for US company during 3 years). Also i have participated in highly sophisticated DWH project as ETL developer during 5 years.
Having Developers who has 10+ years of experience in SSIS development.
Wide industry experience with deep learning of BI and Data Warehousing.
Aware about Dimension Modeling which is critical in Data Warehousing Projects.
Technical expertise in SSIS, SSRS, Sql server, SSAS and Power BI.
My past experience is dealing with same sort requirements where i have accomplished the work.
Good solution finder for design and architectural problems.
Am adhered to the given timelines and deliver the solution.
For the past 5 years I have been working as a ETL developer and have worked with different versions of the Microsoft Data Tools.
I have work experience in the following domains Retail, Manufacturing and Healthcare.
Have extensive knowledge in gathering the business requirements from the business user and transforming the data as per the business logic.
Extensively worked on data aggregation processes and strategies