Description :

Looking for Software Engineer working on Sql server, SSIS/SSRS platform and will be responsible for creating customized SSRS/Microsoft Power BI/Management Reporter reports for both ad hoc and production use.

 Responsibilities:

• Analyze, design, develop, administer and support database business intelligence solutions using SQL Server, SSIS, Azure Data factory, Azure Data Lake Store and Azure Data Lake Analytics.
• Establish physical database parameters; Utilize structure query language to define database objects using data control languages; Perform maintenance, enhancement, and design of data dictionaries.
• Evaluate users requests for new data elements and systems; Incorporate changes into existing shared data environment; Coordinate the use of data to ensure data integrity and control redundancy, database loads, and reorganization.
• Perform logical and physical data modeling and prototyping; Design relational database models; Create physical data models from logical data models; Design and develop data migration scripts, procedures and functions.
• Create PowerShell and Azure CLI(Command Line Interface) scripts to clean up and deploy Linked services, datasets and pipelines across multiple environment.
• Analyze database requirements of existing and/or new applications; Proactively monitor database activity performance and performance tune and fine tune for optimal performance.
• Determine technical feasibility of solution implementation, estimate time and cost, ensure compatibility with current applications and systems.

 Requirements:

• Requires minimum of Bachelors degree in computer science or Information Technology or related field or its Equivalent.
• Good Knowledge of database query languages such as Oracle, PL SQL, SQL Server. And SSIS, SSRS,
• Experience in system tuning, optimization of information/data processing, maintenance, and support of the production environment
• Good Communication Skills.