"Alerted.org

****Hybrid * Webcam interview; very long term project; initial PO for 1 year with multiyear extensions ***Need 1 reference

In this role, the following services are required:

+ 1. Develops Tableau Reports.

+ 2. Assist in the design and development of the database architecture including relational data structures, data marts, data dictionaries and logical and physical data models.

+ 3. Develop strategies for data acquisitions, data quality and data discrepancy.

+ 4. Assist in migration and integration of data and processes from legacy systems to new applications and new technologies.

+ 5. Develop and maintain efficient, well documented custom SQL scripts, stored procedures, triggers using Microsoft T-SQL in accordance with defined business rules and requirements to support application development.

+ 7. Must have the ability to access data stored in a variety of database management systems such as DB2, SQL Server and other.

+ 8. Design, develop and implement ETL/ ELT solutions for data ingestion, cleansing, business rules execution and Data Distribution.

+ 9. Implementing Data Analytics best practices in designing data modeling, ETL Pipelines, Near time data solutions.

+ 10. Coordinate with Business Analyst and users to validate requirements.

+ 11. Implementing solutions to integrate external data with inhouse data.

+ 12. Perform tests and validate data flows and prepare ETL processes according to business requirements.

+ 13. Designing and implement a data conversion strategy from legacy to new platforms.

+ 14. Perform design validation, reconciliation and error handling in data load processes.

+ 15. Optimize SSIS Package execution and SQL execution to optimize data load performance.

+ 16. Design SSIS packages using data exchange tasks such as File transfer and Secured File transfer. Ability to import and export files from FTP/SFTP.

+ 17. Involvement in all stages like Requirements gathering, Data mapping, Data extraction, Data loading, Data testing, Troubleshooting, documentation, performance optimization and maintenance.

+ 18. Development of different kind of reports using Tableau as per user requirement and deploying to report server/ integrated SharePoint report server.

+ 19. Experience using dynamic grouping fields, dynamic group sorting, on-demand sub reports, drill down and summary reports, and creating cross tab reports highlighting key summary information.

Skills

+ A 10 or more years of prior experience demonstrating the following knowledge and skills:

+ + 1. More than 5 years of Experience with Tableau.

+ 2. More than 5 years of experience writing complex SQL queries

+ 3. More then 5 years Expertise with TSQL, SSRS, SSIS or Talend

+ 4. Experience with debug and improve query performance

+ 5. Experience with deploying SSIS packages using git check-in, setting up environmental variables and creating respective jobs in SQL Agent.

+ 7. Experience with Transact-SQL and stored procedures desired.

+ 8. Experience with creating, deploying and maintaining of Tallend reports.

+ 9. Experience with code control/version Team Foundation.

+ 11. Strong problem solving, cross-functional analysis and forward-thinking abilities

+ 12. Flexibility to adapt to changing situations, handle multiple tasks, and meet tight deadlines

Additional Preferred Qualifications:

1. Experience with Salesforce

2. MuleSoft.

+