Notice of Filings

Perform design, development and deployment of scalable EDW applications that includes data mining, data modeling, predictive modeling/analytics, database design, ETL processes and mappings and deployment of BI interfaces. Responsible for performance tuning for ETL and as well for BI applications through complex procedures and scripts. Develop complex procedures, views, queries and functions. Involved in data governance and data quality/integrity. Work in security, QA and support. Coordinate between and among Business Users, Developers, QA Teams, Testing Teams and Support Groups. Contribute to overall quality and consistent deliverables. Responsible for troubleshooting development issues. Work in EDW environment; ETL & BI tools, BI interfaces, ERWIN, RDBMS, MSBI, PowerBI, SQL, Agile, Ralph Kimball Methodologies and Windows, UNIX, or Linux. Will work in Rocky Hill, CT and/or various unanticipated client sites throughout the U.S. Must be willing to travel and/or relocate.

Responsible for leading requirements gathering, data analysis, design, development and deployment of Enterprise Data Warehouse (EDW) applications on Unix and Windows. Prepare design and functional specifications (HLD, LLD) and implement required features as per specifications. Perform Erwin data modeling and design data marts and cubes. Perform database design and development and create complex procedures using PL/SQL. Perform design and development of complex ETL mappings and perform ETL development. Perform performance tuning of SQL, ETL jobs and applications. Coordinate with team members to perform database management, governance and quality. Perform data replication and data migrations. Perform Data Integration and Synchronization using Oracle Data Integrator. Create Unix Shell scripts to help stress analysis tasks. Perform database upgrades by applying required software updates and patches. Ensure security, reliability, availability and scalability. Responsible for troubleshooting of development issues. Work on Erwin data modeling, Oracle, EDW, OLTP, ETL, SQL, PL/SQL, ODI, Scripting languages, Oracle Golden Gate on UNIX and windows. Will work in Rocky Hill, CT and/or various unanticipated client sites throughout the U.S. Must be willing to travel and/or relocate.

Job Duties: Responsible for gathering business and IT requirements, perform business application analysis and prepare functional and technical documents for overall Quality Assurance (QA). Perform Test Strategy and deployment of IT Applications in a complex integration testing environment. Perform Business Process Management (BPM), design and develop Automation Frame works (HP QC, ALM, QTP) and create operational metrics/performance improvements. Perform design and development of test scenarios. Manage Test Data, End to End Test Execution and Reporting. Perform programming in Web services (SOAP UI), SQL, RDBMS (Oracle, SQL Server) and scripting languages (javascript, vbscript and shell). Ensure optimum test coverage and standardize defect management process. Perform data validations using SQL. Involved in regulatory compliant procedures, reporting and standards in healthcare. Follow Agile/Rational methodologies. Perform user training, support and maintenance. Will work in Rocky Hill, CT and/or various unanticipated client sites throughout the U.S. Must be willing to travel and/or relocate.