Infometry - Lead SSIS Developer - ETL/Datamart (8-10 yrs)

JOB DESCRIPTION :

- Excellent communication skills, should be able to understand requirements/ business needs on calls from

customers, articulate response & provide inputs effectively.

- Good understanding of Data Warehousing, including the understanding of data relationships.

- Assists with data model tuning and model implementation.

- Understanding of dimensional models as it pertains to database implementation, tuning and maintenance.

- Hands-on expertise on SSIS package development, which includes developing, maintaining and enhancing
SSIS packages.

- Developing ETL logics and verifying data migration.

- The data warehouse developer must have a strong understanding of database tuning techniques to
optimize ETL jobs as well as complex SQL queries in addition to BI reporting and analytics.

- Good experience in SQL database, preferable SQL Server.

- Solid understanding of core SQL database design principles and practices as well as a working knowledge of data warehouse.

- Working knowledge on data extraction via pull method, synchronization between DB's, pushing data from source to destination.

- Responsible for doing functional database testing of SSIS packages.

- Good to have working knowledge on SSAS.

- Review and analyze business requirements and provide technical feasibility and estimates.

- Twisting SQL queries for improving performances.

- Finding the key areas of automation to make the business processes smooth.

- Developing reference documents or reports for the finalized project.

- Participate in DW/Data Mart and BI architecture process.

- Prepare design documents pertinent to DW components, data flow, ETL, data models, and OLA.