Senior ETLReport Developer

3 weeks ago

Par, United Kingdom RICEFW Technologies Inc Full time

The Department of Children and Familiesdepends on the core missioncritical applications LINK and IVEConnecticuts Federallyreimbursed SACWIS (Statewide Automated ChildWelfare Information System). Implemented in 1996 available on everydesktop and used by over 2000 social workers and case managers theapplication has been enhanced and modified continually to meet datacapture and process functionality requirements driven by good childwelfare case practice as well as State and Federal legislation andstatute. Additionally LINK continues to experience change chieflyin compliance with the 1991 Juan F. Consent Decree as well as theagencys ongoing goal of improving the safety permanency andwellbeing of children in care. The agency is currently committed todeveloping the next generation Comprehensive Child Welfareinformation system (CCWIS) and has invested significant resourcesto ensure that Connecticut has efficient economic and effectivetools to aid our Child Welfare Staff Providers and the children andfamilies of CT.

DCF Information Systemsprovides technology expertise and services as well as aninformation systems infrastructure to the agency and its roughly3300 employees. DCF Information Systems strives to improvecontinually improving technology services that are costeffectiveand of the highest effectiveness and quality.

3. SCOPE OF WORK

Theagency needs the service of a senior level Lead Full StackDeveloper. The candidate will serve in the capacity of a LeadDeveloper participating in various SDLC processes includingrequirements verification design and development testingmaintenance and support activities per the direction of agencymanagement. The specific focus of this candidate will be the to bepart of the team which supports existing .NET applications as wellas to participates in the SDLC process of the new SACWIS system andwork with the System Integrator to ensure the transfer of knowledgeand ongoing maintenance of the solution for a given module.Specifically the candidate will be responsible forcreating/maintaining SSRS reports and SSIS ETL packages supportingSOA integration initiatives and participating in the SDLC processwhich includes meetings with the SI verification of deliverablessuch as requirements design testing and environment configuration.

Specific ServicesRequired:

In the role of the LeadDeveloper the following services are required:

Must be very organized proactive andselfdirected.

Must beselfstarter and driven. Must Drive the work from requirements toimplementation.

Must havevery strong abstract thinking and problemsolving skills.

Must have very good verbal and writtencommunication skills.

In this role the followingservices are required:

1. Develops general anddetailed design specifications for moderate to complexsystems.

2. Assist in the design and developmentof the database architecture including relational data structuresdata marts data dictionaries and logical and physical datamodels.

3. Develop strategies for dataacquisitions data quality and data discrepancy.

4. Assist in migration and integration of data andprocesses from legacy systems to new applications and newtechnologies.

5. Develop and maintain efficientwell documented custom SQL scripts stored procedures triggers usingMicrosoft TSQL in accordance with defined business rules andrequirements to support application development.

6. Create and troubleshoot stored procedures and queriesperformances using SQL Server Profiler Performance Monitor DBCCCommands Database Engine Tuning Advisor and Execution plans.Recommend query and index improvements to increaseperformance.

7. Must have the ability to accessdata stored in a variety of database management systems such as DB2SQL Server and other.

8. Design develop andimplement ETL/ ELT solutions for data ingestion cleansing businessrules execution and Data Distribution.

9.Implementing Data Analytics best practices in designing datamodeling ETL Pipelines Near time data solutions.

10. Coordinate with Business Analyst and users to validaterequirements.

11. Implementing solutions tointegrate external data with inhouse data.

12.Perform tests and validate data flows and prepare ETL processesaccording to business requirements.

13.Designing and implement a data conversion strategy from legacy tonew platforms.

14. Perform design validationreconciliation and error handling in data load processes.

15. Optimize SSIS Package execution and SQL execution tooptimize data load performance.

16. Design SSISpackages using data exchange tasks such as File transfer andSecured File transfer. Ability to import and export files fromFTP/SFTP.

17. Involvement in all stages likeRequirements gathering Data mapping Data extraction Data loadingData testing Troubleshooting documentation performance optimizationand maintenance.

18. Development of differentkind of reports using SSRS as per user requirement and deploying toreport server/ integrated SharePoint report server.

19. Experience using dynamic grouping fields dynamic groupsorting ondemand sub reports drill down and summary reports andcreating cross tab reports highlighting key summaryinformation.

20. Use Microsoft Team FoundationServer (TFS) and/or Azure Dev Ops to manage changes tocode

REQUIRED SKILLS ANDEXPERIENCE

Refer to the Statecontracts for IT Professional Services Agreement (22PSX0163) forexperience and skill requirements for the job classificationSolution Architect to fill the role. In addition the agencyrequires:

A 10 or more years of prior experiencedemonstrating the following knowledge and skills

1. Experience in the analysis and design of applicationsolutions within appropriate standards.

2.Ability to write complex SQL queries

3.Expertise with TSQL SSRS SSIS required and PowerBi SSAS aplus

4. Experience with debug and improve queryperformance

5. Experience with deploying SSISpackages using git checkin setting up environmental variables andcreating respective jobs in SQL Agent.

6.Significant experience in realtime multitiered data processingsystems

7. Experience with TransactSQL andstored procedures desired.

8. Experience withcreating deploying and maintaining of SSRS reports.

9. Experience with code control/version TeamFoundation.

10. Experience with enterprise dataintegration technologies including Java SQL XSLT Graphical andXML

11. Strong problem solving crossfunctionalanalysis and forwardthinking abilities

12.Flexibility to adapt to changing situations handle multiple tasksand meet tight deadlines

AdditionalPreferred Qualifications:

1.Experience with SSIS connectors like KingswaySoft or Cozyroc isplus

2. Experience with DB2 DynamicsSalesforce.

Type Category Qualification Description Competency Required Skills Database Data Modeling Expert (10 Years) No Skills Database Microsoft SQL Server Expert (10 Years) No Skills Tools SQL Server Reporting Services(SSRS) Expert (10 Years) No

  • Senior Flutter developer

    1 month ago

    Par, United Kingdom Zigsaw Full time

    RoleDescriptionWeare seeking a fulltime Senior Flutter Developer for an onsite roleat our Jaipur location. As partof our teamyou will be responsible for developing and maintaining mobileapplications using Flutter.Your daytodaytasks will include developing applications from scratch integratingwith APIs andworking closely with UI/UXdesigners to...

  • Senior ERP Developer

    4 days ago

    Par, United Kingdom V R Della Infotech Inc Full time

    POSITIONPURPOSEProvide a brief description as to the primarypurpose of this job (no more than three to fivesentences).The Senior ERP Developerwill be responsible for design development and implementation ofERP solutions to streamline business processes and driveoperational efficiencyThe Senior ERP Developer will workclosely with business and technology...

  • Sr Peoplesoft Developer

    3 weeks ago

    Par, United Kingdom Bright Mind Solutions LLC Full time

    Senior PeopleSoft Developer Location: Paramus NJ Hybrid 2 daysminimum onsite Duration: 12 months RTH (NeedGreen Card or US Citizen) The Senior PeopleSoft Developer will be responsible fordesign development and implementation of ERP solutions tostreamline business processes and drive operational efficiency. Youwill work closely with business and technology...

  • Android Developer

    4 weeks ago

    Par, United Kingdom Precision Technologies Corp Full time

    Position: Android Developer Location: Onsite (McLean/ Richmond VA ORChicago IL) Duration: Long Term Responsibilities forAndroid: Develop Android client code solutions that deliver onProduct Strategy and adhere to established engineering bestpractices design guidelines and principlesPartner with Software Engineers UX/UI Quality EngineersProduct...

  • Sr Flutter DeveloperMobile Developer

    1 month ago

    Par, United Kingdom Zigsaw Full time

    JobDescriptionRoleDescriptionWeare seeking a fulltime Senior Flutter Developer for an onsite roleat our Jaipur location. As partof our teamyou will be responsible for developing and maintaining mobileapplications using Flutter.Your daytodaytasks will include developing applications from scratch integratingwith APIs andworking closely with UI/UXdesigners to...

  • OpenSearch Software Developer Java

    3 days ago

    Par, United Kingdom Noblesoft Technologies Full time

    Role: OpenSearch Software Developer(Java) Location: Overland Park Kansas Dallas TX(onsite) About therole As an OpenSearchsoftware developer you will design implement and test features forour opensource search and analytics platform.Work with senior engineers in the team to delivercomponents of the entire stack. You will useyour Java skills and experience to...

  • OpenSearch Software Developer

    4 days ago

    Par, United Kingdom Inherent Technologies Full time

    Position: OpenSearch SoftwareDeveloper Location: OverlandPark KS/Dallas TX***Day 1 Onsite***Duration: 1 Years Phone& Skype Client:HCL ImmediateInterview Skill Rating MandatorySkills Hands on experience in Years Last usedYear SelfRating (Scale 110) 1. 2. 3. 4. Submissionformat CandidateName ...

  • Night Senior Healthcare Assistant

    1 week ago

    Par, United Kingdom Cornwallis Care Full time

    Trecarrel Care HomePar *£250 Joining Bonus * T's and C's applyCornwallis Care are looking to recruit an enthusiastic and experienced senior healthcare assistant, to lead a team of passionate care assistants. You must be hard working with good communication and leadership skills and proficient in the assessment of...

  • Business Developer Senior IT HF

    3 weeks ago

    Par, United Kingdom EURHASI Full time

    EURHASIrecrute pour son unBusiness DeveloperSenior(H/F)Notreclient est une soci t de services num riques qui con oit d veloppeet maintien des solutions fiables efficaces volutives et adapt esaux besoins de sesclients.Leclient n accepte pas de candidatures n cessitant des d marchesadministratives pour une autorisation de travail (permis de s jourpermis de...

  • Senior Data Scientist- 1056 1

    1 month ago

    Par, United Kingdom Wakapi Full time

    TheRole:We areseeking a highly motivated and experienced Senior Data Scientist tojoin our BDgrowing team. As a Senior Data Scientist you will play akey role in our organizations datadriven decisionmaking process byleading and executing complex data analysis projects. You will beresponsible for the entire data science lifecycle from identifyingand framing...

  • Senior Project Manager

    1 month ago

    Par, United Kingdom Novel Financial Solutions Full time

    Job Title : Senior ProjectManager Third Party Risk Management (TPRM)Contract Term :1st July 30th Jan2025 Headcount : 1Location : Changi Business ParkSingapore Salary : SGD$(Monthly) Responsibilities: Project manage SG TPRM project aligning with MASoutsourcing guidelines and Program Management Council (CPMC)standards. Document project plan scoperesource...

  • Global Oil Gas Senior Financial Consulting Analyst

    1 month ago

    Par, United Kingdom MatchaTalent Full time

    This role required candidate topermanently relocate at Dhahran SaudiArabia. About theCompany This company engagesin the exploration production transportation and sale of crude oiland natural gas. It operates through the following segments:Upstream Downstream and Corporate. The Upstream segment includescrude oil natural gas and natural gas liquids...

  • Senior Software Platform Engineer

    1 month ago

    Par, United Kingdom Coders Connect Full time

    CodersConnect and Sanofi are joining forcesto bring an electrifying twist to the biopharmaceutical world!Work with a rhythmthat suits your style (2 days remote and 3 days onsitemagic).Language:Proficiency in English is required for this role to ensureeffective communication within our diverse globalteam.AboutSanofi:Werenot just a company; were a global...

  • Global Oil Gas Senior Contract Advisor

    1 month ago

    Par, United Kingdom MatchaTalent Full time

    This role required candidate topermanently relocate at Dhahran SaudiArabia. About theCompany This company engagesin the exploration production transportation and sale of crude oiland natural gas. It operates through the following segments:Upstream Downstream and Corporate. The Upstream segment includescrude oil natural gas and natural gas liquids...

  • Global Petrochemical Senior Rotor Dynamics Engineer

    1 month ago

    Par, United Kingdom MatchaTalent Full time

    This role required candidate topermanently relocate at Jubail SaudiArabia. About theCompany Founded in the late 1970sin Saudi Arabias oilrich region this multinational corporation hassolidified its position as a global leader in the petrochemicalsector. With a diverse product portfolio ranging from chemicals andintermediates to polymers agrinutrients and...

  • Sr Manager Statistical Programming

    3 weeks ago

    Par, United Kingdom UrBench Full time

    Senior ManagerStatisticalProgramming Location: ParsippanyNJ Duration: 12 Months Work mode: Onsite but somehybrid work may be considered Pacira is seeking a handsonexpertlevel Statistical Programmer for a 12month contract inParsippany NJ. Candidates must have experience in thePharmaceutical industry. The JD asks for a Masters degree. Lets tryto find...

  • Global Oil Gas Senior Secretary

    1 month ago

    Par, United Kingdom MatchaTalent Full time

    This role required candidate topermanently relocate at Sydney NSWAustralia. Aboutthe Company This companyengages in the exploration production transportation and sale ofcrude oil and natural gas. It operates through the followingsegments: Upstream Downstream and Corporate. The Upstream segmentincludes crude oil natural gas and natural gas liquids...

  • Chief Commercial Officer

    1 month ago

    Par, United Kingdom Keller Executive International Search Full time

    The Chief Commercial Officer(CCO) will play a pivotal role in driving the sales and marketingefforts of our client a prestigiouswinery. Tasked with formulating and executinginnovative commercial strategies the CCOs primary goal will be tosignificantly boost revenue growth and solidify the winerysposition in the market.JobResponsibilities:Developand execute...

  • Perm - Medical Director - Geriatric Medicine FayettevilleNC

    1 month ago

    Par, United Kingdom V R Della Infotech Inc Full time

    LIFE at St.Joseph of the Pines (SJP) has an excellent fulltime opportunity fora Board Certified Geriatric Medicine Internal Medicine or FamilyMedicine physician to join as Medical Director of the Program ofAllInclusive Care for the Elderly (PACE) facility located inFayetteville NorthCarolina.Program ofAllInclusive Care for the Elderly (PACE) model is...

  • Perm - Medical Director - Geriatric Medicine FayettevilleNC

    1 month ago

    Par, United Kingdom Superbeo Full time

    LIFE at St.Joseph of the Pines (SJP) has an excellent fulltime opportunity fora Board Certified Geriatric Medicine Internal Medicine or FamilyMedicine physician to join as Medical Director of the Program ofAllInclusive Care for the Elderly (PACE) facility located inFayetteville NorthCarolina.Program ofAllInclusive Care for the Elderly (PACE) model is...