1.Net (C# )- OMAR web application(portal) developed in C# .Net and running through the web server(IIS). 2. SQL server –Loads the data from various systems(Informatica,CTM,SNOW,HDI) and maintain it in OMAR database. 3.SSIS/ INFA –For Loading data from various source systems and generate the reports (excel format/CSV format/auto email with URL). 4.control-M /SQL Agent- CTM used to schedule the SSIS/INFA jobs .SQL Agent to schedule the SQL jobs(stored procedures). 5. Windows services – used to copy the active job CSV file from Control-M shared drive path to ETL shared drive path. To send the OMAR job failures notifications for some of the jobs ,when the data in OMAR is not up to date. To run the OMAR balancing service when the EDW claim load completes. This service runs for every 5 mins and keeps checking for the claim load completion. On completion balancing SSIS packages triggers through the windows service ,which is written in C#.net code.
As a database developer, you will deliver SQL Server database solutions to support a growing suite of applications. You must be able to work in a fast-paced environment and learn fast with little guidance. You will be responsible for design, development, implementation and support of database code. You will develop ETL (SSIS), SSRS ,T-SQL and PowerShell processes upon new and legacy systems. You will develop new solutions and provide automation to reduce manual tasks. Qualified candidates should possess the ability to perform at a high level under aggressive timelines and complex solutions. 3+ years of SQL Development in a large enterprise environment Should have developed complex database code with T-SQL, SSIS, SSRS and SQL Server best practices to support UI, Middleware and Batch applications. Familiar with Agile development methodology Experience with SVN a plus Experience with Business Intelligence is a plus. Experience with Tableau is a huge plus. Experience with PowerShell is a plus. Exposed to data modelling is a plus.
Duration of contract: 12 Months Total Yrs. of Experience: 7years Relevant Yrs. of experience: 7years Detailed JD *(Roles and Responsibilities): · 7 yrs experience with technology. · Proven experience with heavy usage of SSIS and SQL database tool and related infrastructure like development, deployment, administration and investigation of issues with quick turnaround (functional as well as performance). · Demonstrated development/deployment/administration/support with SSAS Tabular project using advanced concepts like percentile, partitioning, row level security implementation is a must · Good understanding of reporting UIX and demonstrated development of reports using "Online Microsoft Power BI" features and visuals for 5K+ users. · Demonstrated effective and proactive communication with clients · In general, the candidate would be working in fast paced agile environment having around 8-10 team members to work with and direct daily client interaction (in second shift 2pm to 11pm) in GDM model. The daily activities would be as below but not limited to o identify data needs and analyze available data o comprehend business and technical requirements o analysis of code and understanding existing system o and preparing high level design document, low level design o contributions to schedule and effort estimation o Build, Unit testing, Understanding of configuration management · SQS Server 2016 experience is plus · Azure experience related to Microsoft business intelligence stack is a plus · SSRS experience is good to have
MS SQL 2012 Server Administrator, with experience of data migration projects using SSRS, SSIS packages. Needs to have a very strong and credible record as a DBA, experience of handling enterprise Data Base migration projects preferably in a financial or banking arena. Provide hands on support to our internal DBA and development teams. Strong knowledge of database design, query cost and performance measurement, use of stored procedures and performance tuning. Experience in using Integration Services (SSIS) platform for building high performance data integration and workflow solutions, including extraction, transformation, and loading (ETL) operations. Will provide database functions by designing and coding utilities and scripts Maintains database performance by calculating optimum values for database parameters; implementing new releases and completing maintenance requirements. Provides information by answering questions and making recommendations. Maintains quality service by establishing and enforcing organization standards.
NAV Consulting, Inc. is an independent global Fund Administrator for over 20 years which provides complete fund administration for hedge fund industry with reporting, investor services and back office support. NAV serves over 750 clients around the world, which have combined assets under administration over US$ 54 billion. NAV has been ranked as one of the 15 largest Fund Administrators globally. For the year 2014, NAV Consulting has been awarded as “Hedge Fund Administration Service Provider of the Year – USA”
We conceptualize, architect, build and run scalable and complex, modern day full stack technology platforms