senior etl/report developer

1 week ago

Hartford, Connecticut, United States Mavensoft Technologies Full time

Job Title:
SENIOR ETL/REPORT DEVELOPER

Duration: 12 Months (contract on W2)

Location:
Hartford, CT (Hybrid)

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

Specific Services Required :
In the role of the Lead Developer, the following services are required:

  • Must be very organized, pro-active and self-directed.
  • Must be self-starter and driven. Must Drive the work from requirements to implementation.
  • Must have very strong abstract thinking and problem-solving skills.
  • Must have very good verbal and written communication skills.
In this role, the following services are required:
1. Develops general and detailed design specifications for moderate to complex systems.
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.

6.

Create and troubleshoot stored procedures and queries performances using SQL Server Profiler, Performance Monitor, DBCC Commands, Database Engine Tuning Advisor and Execution plans.

Recommend query and index improvements to increase performance.
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 SSRS 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.

20. Use Microsoft Team Foundation Server (TFS) and/or Azure Dev Ops to manage changes to code

  • Experience in the analysis and design of application solutions within appropriate standards.
2. Ability to write complex SQL queries
3. Expertise with TSQL, SSRS, SSIS required and Power-Bi, SSAS a plus
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.
6. Significant experience in real-time, multi-tiered data processing systems
7. Experience with Transact-SQL and stored procedures desired.
8. Experience with creating, deploying and maintaining of SSRS reports.
9. Experience with code control/version Team Foundation.
10. Experience with enterprise data integration technologies including Java, SQL, XSLT, Graphical, and XML
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 SSIS connectors like KingswaySoft or Cozyroc is plus
2. Experience with DB2, Dynamics, Salesforce.

Email your resume to:

To learn more about Mavensoft visit us online at

  • Data Bricks ETL

    1 week ago

    Hartford, Connecticut, United States eTeam Full time

    Job Title: ETL Databricks & Python DeveloperCompany: Innovative Data SolutionsPrimary Skill:ETL experience using Databricks & PythonJob Description:Looking for a skilled ETL Databricks & Python Developer with a minimum of 2-5 years of experience in the IT, logistics, supply chain, production/manufacturing, aerospace, or defense industry. The ideal candidate...

  • External Reporting, Senior Analyst

    1 week ago

    Hartford, Connecticut, United States Creative Financial Staffing Full time

    External Reporting, Senior AnalystABOUT THE COMPANY:External Reporting, Senior Analyst Our client is a premier organization in the Hartford area with multiple entities. This company is investing in new technology to be on the cutting edge They are rapidly growing and looking for talented and motivated individuals to join their growing team. Position is open...

  • Programmer/Developer

    1 week ago

    Hartford, Connecticut, United States HexaQuEST Global Full time

    Job Description:Candidate must be within 50 miles to Hartford, CT We are seeking a highly motivated and skilled Full-Stack Developer to join our team and play a crucial role in developing a data submission ETL portal. This portal will serve as a central hub for collecting, transforming, and loading data from various sources into our data warehouse.Hybrid...

  • Talend AWS Developer

    1 week ago

    Hartford, Connecticut, United States LTIMindtree Full time

    Talend AWS Developer Job Req Id: About Us: Job Title: Talend AWS Developer Work Location Hartford, CT Job Description: Must have (Primary)- Talend + AWS (S3, EC2, IAM, Data Services) Good to have (Secondary)- Snowflake, Python Requirements: Candidate must be experienced working in ETL based projects involving Talend especially Talend on AWS Cloud...

  • Reporting Analyst

    7 days ago

    Hartford, Connecticut, United States Experis Full time

    Postion DetailsContract-to-hire Location: Hartford, CT (Hybrid: T-Th onsite) $20-30/hr. depending on experiencePosition Summary: Responsible for the production of timely and accurate Client Reports/presentations for Asset Management clients and consultants. Compiles reports and documents from several different sources, including commentary from the managers,...

  • Programmer/Developer

    1 week ago

    West Hartford, Connecticut, United States Abacus Full time

    Summary Requisition ID Salesforce Developer-DAS/BITS Requisition Name Programmer/Developer Folder DSS (Piggyback) Customer CT DSS Quantity Requested 2 Description The Connecticut Bureau Of Information Technology Services under the Department of Administrative Services (DAS-BITS) is looking for Salesforce Developers. The developers will be assigned to...

  • Backend Senior Developer

    1 week ago

    Hartford, Connecticut, United States CapB InfoteK Full time

    For one of our long-term multiyear projects we are looking for a Backend Senior Developer with Java, J2EE, Hibernate, Spring boot.Skills & Responsibilities: Minimum 10 years of experience in the role of a software engineer. At least four years of experience in Java, J2EE, Spring, Hibernate, Spring boot, Web Services Provide technical support and guidance...

  • Sr. .Net Developer

    3 weeks ago

    Hartford, Connecticut, United States Cognizant Technology Solutions Full time

    Cognizant is looking for a Senior.Net Developer for developing customized product for our clients. The role is expected to drive technology discussions and analyze the current landscape for gaps in addressing business needs. Cognizant needs a motivated individual to challenge the status quo and provide thought leadership/standard processes to improve our...

  • Sr. .Net Developer

    1 month ago

    Hartford, Connecticut, United States Cognizant Technology Solutions Full time

    Cognizant is looking for a Senior.Net Developer for developing customized product for our clients. The role is expected to drive technology discussions and analyze the current landscape for gaps in addressing business needs. Cognizant needs a motivated individual to challenge the status quo and provide thought leadership/standard processes to improve our...

  • Teradata SQL Developer-Remote

    7 days ago

    Hartford, Connecticut, United States Georgia IT Inc Full time

    Teradata SQL Developer Location: Hartford, CT or Remote Duration: 03 Months plus Rate: DOEUS Citizens and Green cards Preferred. No third partiesWhat You Will Do:Responsible for Extracting, Transforming Loading data from flat files using BTEQ, Fast Load, MultiLoad, Python and loading data into Teradata Data Warehouse. Experience in developing of Complex...

  • Senior Consultant, Health Product Development

    1 week ago

    Hartford, Connecticut, United States Sun Life Financial Full time

    Senior Consultant, Health Product Development at Sun LifeAre you ready to join a dynamic team of experts at Sun Life for the role of Senior Consultant, Health Product Development? This exciting opportunity allows you to work on innovative health solutions that make a real difference in the lives of individuals, families, and communities around the...

  • Application Development Senior Advisor

    3 weeks ago

    Hartford, Connecticut, United States Randstad USA Full time

    job summary: Enterprise Healthcare client has an immediate opening for a highly motivated Application Development Senior Advisor to join their dynamic and growing team. All qualified candidates are encouraged to apply We are seeking a highly skilled and experienced Senior Full-Stack Software Engineer to join our team. The ideal candidate will be an expert in...

  • Application Development Senior Advisor

    1 month ago

    Hartford, Connecticut, United States Randstad USA Full time

    job summary: Enterprise Healthcare client has an immediate opening for a highly motivated Application Development Senior Advisor to join their dynamic and growing team. All qualified candidates are encouraged to apply We are seeking a highly skilled and experienced Senior Full-Stack Software Engineer to join our team. The ideal candidate will be an expert in...

  • Application Development Senior Advisor

    1 week ago

    Hartford, Connecticut, United States Randstad USA Full time

    job summary: Enterprise Healthcare client has an immediate opening for a highly motivated Application Development Senior Advisor to join their dynamic and growing team. All qualified candidates are encouraged to apply We are seeking a highly skilled and experienced Senior Full-Stack Software Engineer to join our team. The ideal candidate will be an expert in...

  • Senior Hardware Developer

    1 week ago

    Hartford, Connecticut, United States Oracle Full time

    Oracle Senior Hardware Developer (JoinOCI-NDC) Hartford , Connecticut Apply Now Oracle Cloud Infrastructure – Network Hardware EngineeringSupports the design, deployment, and operations of a large-scale global Oracle cloud computing environment (Oracle Cloud Infrastructure - OCI). Primarily focused on the development and deployment of the physical rack...

  • Senior Java Developer

    1 week ago

    Hartford, Connecticut, United States Legal & General Group Full time

    Hove Time/Part Time__ Full-time Family__ IT & Change__jobinformationwidget.freetext.ExternalReference__For nearly 200 years we have provided financial services to customers across the UK, and now the US. As one of Europe's largest insurance and asset management groups, with over £1 trillion in assets, we are experts in safeguarding people's financial...

  • Data Engineer

    1 week ago

    Hartford, Connecticut, United States Aetna Resources LLC Full time

    Aetna Resources LLC, a CVS Health company, is hiring for the following role in Hartford, CT: Data Engineer to design, build and manage large scale data structures, pipelines and efficient Extract/Load/Transform (ETL) workflows to support business applicationsDuties include: develop large scale data structures and pipelines to organize, collect and...

  • Hybrid Senior Full Stack Developer

    1 week ago

    Hartford, Connecticut, United States Cognizant North America Full time

    Hybrid Senior Full Stack Developer (ReactJs and Node) Cognizant Digital Engineering practice is seeking a highly skilled Senior Full Stack Developer (ReactJS and Node) with a strong background in building scalable high-quality and high-performance digital solutions. With a focus on both front-end and back-end development the ideal candidate will contribute...

  • Business Development Analyst Sr

    1 month ago

    Hartford, Connecticut, United States Munich Re Full time

    The Senior Business Development Analyst will be responsible for supporting the data, reporting and analytical needs across the entire Specialty Re Department. The role will involve analyzing and synthesizing financial data from multiple sources (S&P IQ...), producing high quality insights that demonstrate a full narrative and ultimately communicating to key...

  • Business Development Analyst Sr

    1 week ago

    Hartford, Connecticut, United States Munich Re Full time

    The Senior Business Development Analyst will be responsible for supporting the data, reporting and analytical needs across the entire Specialty Re Department. The role will involve analyzing and synthesizing financial data from multiple sources (S&P IQ...), producing high quality insights that demonstrate a full narrative and ultimately communicating to key...