• Solidify and extend existing ETL SSIS Framework
• Design ETL jobs and reusable components to implement specified business requirements
• Troubleshoot and optimize ETL code, interpret ETL logs, perform data validation, dissect SSIS code, understand the benefits and drawbacks of parallelism, proper use of expressions, scoping of variables, commonly used transforms, event handlers and logging providers, understand and optimize the surrogate key generation and inconsistent data type handling
• Create technical specifications documents and design process diagrams
• Develop functional specifications for data acquisition, transformation and load processes
• Develop scripts for data file processing and process integration tasks
• Define job parameters, reference lookups, filter criteria
• Conduct code reviews and participate in technical design
• Conduct performance analysis and optimize SSIS jobs, custom SQL, and T-SQL jobs
• Writing SQL code using both T SQL and PL SQL
• Set up ETL OLEDB, flat file and other source and destination connection managers
• Create various SSIS transformations and tasks as per requirements and best practices
• Create dynamic file paths, and archival paths, for each loop, variable, parameter and expression
• Deployments of ETLs between Dev, QA, and Prod using SSSI config files and scripts
• Best practices/standard procedures for SQL, except SSIS

Skills: ETL Development, SSIS Design, Troubleshooting, Documentation, Data Integration, SQL Scripting, Performance Optimization, SSIS Transformations

• Act as a technical expert in the designing, coding, testing, supporting and debugging of new software or significant enhancement to existing software
• Troubleshoot and debug ETL jobs and create unit tests for ETL jobs.
• Assess query performance and actively contribute to optimizing the code
• Write technical documentation and specifications
• Work with DBAs and Data Architects to plan and implement the best ETL strategies
• Work with business systems analysts to create technical design specifications, gaining a sound understanding of business processes for related applications so that integration processes fulfill the end-user requirements
• Create a solution following the Software Development Life Cycle (SDLC)
• Communicate with Business Analysts to understand requirements, socialize ideas among peers, and document work product
• Support internal audit by submitting required evidence
• Manage exploratory data analysis to support database and dashboard development required for business users.
• Articulate data issues to business users and provide solutions to cleanse from source.
• Assist in the development of software technical documentation
• Troubleshooting issues with ETL solutions
• Troubleshooting issues with script tasks using both C# and VB
• Performance tuning SQL queries and SSIS solutions etc.
• Enhancing and Automating (as applicable) current manual processes
• Debugging and monitoring SQL agents, syslogs and audit logs

Skills: ETL Development, Debugging, Query Optimization, Documentation, Data Integration, SDLC Implementation, Troubleshooting, Scripting 

• Analyzes, designs, builds, tests, trains and supports ETL routines to support the Master Data Management environment.
• Work with developers and analysts to convert business requirements into ETL routines
• Works with analysts and developers to incorporate data quality checks into ETL routines
• Assist in the development, maintenance, and support of an enterprise data warehouse system and corresponding data marts.
• Troubleshoot and tune existing data warehouse applications. 
• Assist in creating new or enhanced components of the data warehouse.
• Identify data quality issues and support the data governance initiative by participating in necessary activities including data profiling.
• Implement best practices and methodologies and function as a technical expert in the design, development, modification and debugging of data models, databases, etc.
• Support the development of new software or enhance existing software and integrate it into new or modified systems and/or operational environments.
• Assist the reporting team in optimizing the ETL process to ensure that business requirements are met.
• Documents all phases of work including gathering requirements, database diagrams, source-to-target mappings and other program technical specifications using current specified design standards for new or revised solutions. 
• Leverages quality best practices including design reviews, unit testing, code reviews, and continuous integration to ensure a defect-free delivery
• Reviews progress and results, and communicates with management. 
• Leverages team skills for successful project completion
• Maintains consistency and encourages improvement
• Produces software designs to meet complex requirements within time and cost constraints

Skills: ETL Development, Data Integration, Data Quality Assurance, Data Warehousing, Performance Tuning, Data Governance, Technical Documentation, Database Design

• Plan, coordinated, developed, and supported DW development including, architecting/building ETL process, documentation, and long-term preparedness
• Development of ETL routines using SSIS tool which include developing validation rules to ensure data accuracy, developing data validation routines, and reporting on data quality metric
• Define and develop ETL scripts Extract, Transform, and Load using SQL
• Create, maintain and update tables, stored procedures, and SSIS package
• 24X7 Production support of existing SSIS packages less 
• Document steps needed to migrate ETL/database objects between various environments including Development, UAT and Production
• Understanding of CTRL-M scheduling toolless 
• Works closely with the application teams to understand the data migration requirements and provides technical design recommendation
• Provide regular project updates to management 
• Communicate issues, risks, and concerns proactively to management
• Document the ETL process thoroughly to allow peers to assist with support 
• Switch between Development and production support
• Plans overall documentation needs and provides technical documentation relating to system design, application deployment planning, and production support requirements

Skills: ETL Development, SSIS Development, SQL Scripting, Data Validation, Production Support, Process Documentation, Data Migration, Job Scheduling

• Conducts on-site analysis of legacy systems and databases with the goal of producing the initial Data Mapping for the Extract process.
• Working closely with subject matter experts to find where data is stored in a database.
• Define data integrity, business rules, and cleansing requirements for the Transform process.
• Preparation of detailed specifications from which programs will be written.
• Creates accurate code to Load the data into the target database.
• Tests all conversion programs in succession in order to identify programmatic dependencies.
• Executes onsite conversion and migration tests in order to obtain program run times and uncover software/hardware/environment constraints.
• Creates data verification plans to be used following trial runs at the client site.
• Participation in the development and preparation of documentation for procedural, program, and user documentation.
• Conducts data conversion and migration training and works with users to ensure successful system implementation.
• Work with the project team to efficiently troubleshoot problems.
• Ensures technical documentation reflects changes to application functionality or implementation choices. 
• Plans, conducts, and supervises assignments
• Contributes to system design, applying established and emerging database and ETL best practices and standards
• Balances between robustness and speed/cost considerations, optimizing based on what’s appropriate for the solution domain

Skills: Data Mapping, Database Analysis, Data Transformation, ETL Development, Data Migration, Validation, Technical Documentation, Troubleshooting

• Collaborate with BI analysts, BI architects, data architects and ETL developers, during EDW design, data modeling, data mapping and system specification activities
• Work with stakeholders to perform source system analysis and identify data quality issues
• Diagram technical decompositions, describe technical processes and data components and design exception handling and controls
• Participate in functional design reviews and lead technical design reviews
• Design and develop ETL solutions using Informatica Cloud and PowerCenter, including components to address data quality issues
• Create ETL technical specifications, design documents, test plans, and test results
• Create and execute ETL unit test plans
• Troubleshoot data issues and defects to determine the root cause
• Performance tuning of the ETL processes and SQL queries and recommend and implement ETL and query tuning techniques
• Collaborate with QA team to develop and execute test strategies and plans
• Participate in QA, UAT & Production support related to the project
• Conduct technical code reviews and provide feedback
• Follow technical standards and architectural best practices in the environment
• Deliver the best possible technical solution in terms of performance, quality and maintainability
• Provide integration tools and product expertise related to design, development, testing and deployment

Skills: Data Modeling, Data Quality Analysis, ETL Development, Technical Documentation, Troubleshooting, Performance Tuning, Informatica Cloud, Testing

• Building APIs for use in both internal and externally used applications.
• Developing interfaces between HMS, HUIT, and 3rd party vendors and SaaS applications.
• Interfacing with DevOps teams, Harvard security, and compliance groups.
• Writing test scripts, and performing testing, that includes performance testing and tuning.
• Designing system architecture for new applications, sharing knowledge on best practices and techniques and abiding by and following the Harvard University IT technical standards, policies and Code of Conduct
• Participate fully in the software development life cycle
• Research, design, and implement technical solutions to deliver business requirements
• Identify opportunities to improve and simplify applications portfolio and implement related enhancements
• Contribute to the creation and maturing of software development best practices and new technologies
• Draw on relationship and technical skills to act as technical liaison to internal and external clients and to mentor junior staff
• Responsible for the analysis, design, development and maintenance of the enterprise ETL systems and applications.
• Works closely with diverse operational data systems, external data partners, business intelligence, statistical analysts and report developers.
• Acts as a technical analyst to identify and understand source data systems.
• Adapts ETL processes to accommodate source system(s) changes in source systems or new requirements.
• Provides expertise in ETL performance tuning. 
• Maps source system data into data warehouse models.
• Coordinates with Technical Architects, other Data Modelers and DBAs to review design strategies for new ETL processes.
• Works with the business partners to identify and ensure that all service level agreements are met.
• Perform ongoing monitoring of the environment and applications for capacity planning, performance tuning and improvement opportunities.

Skills: API Development, System Integration, DevOps Collaboration, Performance Tuning, System Architecture, ETL Development, Data Mapping, Software Development Lifecycle

• Design, implement and develop ETL AbInitio & SQL processes against high volume and complex data sources.
• Responsible for all phases of application programming and processes for diverse development platforms.
• Documents, tests, implements and provides ongoing support for applications.
• Evaluate detailed business, functional, and high-level technical requirements
• Design & document detailed technical components with high-level architecture
• Complete component design documents on assigned user stories.
• Participate and provide feedback in design reviews.
• Develop code for intermediate to complex modules, following documentation and development standards.
• Conduct timely structured code reviews to ensure standards and systems interoperability.
• Participate in testing reviews and provide technical assistance.
• Conduct Unit Testing according to process standards.
• Utilize Continuous Integration and Deployment tools.
• Analyze and resolve moderate to complex problems.

Skills: ETL Development, SQL, Application Programming, Technical Documentation, Code Review, System Architecture, Unit Testing, CI/CD Implementation

• Work with data architects and analysts in understanding business requirements, business rules and mapping specifications.
• Develop Informatica ETL mappings according to mapping spec to load data into staging, dimension, fact and reporting tables.
• Write SQL to analyze data and find data problems in the early stages, and to validate and test data loaded by ETLs.
• Write Shell scripts to trigger Informatica Workflows and handle errors.
• Create Autosys jobs to trigger Shell scripts and set job dependencies and schedules.
• Investigate and troubleshoot production ETL failures and data problems.
• Create change management tickets to track changes.
• Create data flow diagrams to document data flow from source to ETL and to target.
• Conduct impact analysis to determine impacted ETL, tables and columns per information provided
• Provide development support as required to ensure the availability and performance of developed ETL mappings.
• Collaborate with other Data Warehouse specialists to take over or continue current Data Mart ETL development.
• Provide development support to project team members in creating or maintaining ETL mappings and automation scripts and provide technical assistance 
• Designs, documents, administers and maintains SSAS cubes (both DAX and MDX) from dimensional models
• Implementation of data governance through the use of SSAS meta-data layers in cubes (both DAX and MDX)
• Extract complex data from multiple sources into usable and meaningful reports and analyses
• Create and maintain detailed documentation for the development team
• Support user community on data analytics

Skills: ETL Development, Informatica Mappings, SQL Analysis, Shell Scripting, Autosys Job Scheduling, Troubleshooting, Data Flow Documentation, SSAS Development 

• Provides the leadership role for activities including creating folders and users and managing developer access.
• Takes the lead role in evaluating load monitoring and productivity tools.
• Provides leadership to development teams on code development, access and security requirements
• Assists with code review
• Serves as the lead designer of all activities for a specific project.
• Works closely with project Business Analyst, Data Modeler, and BI Lead to ensure that the end-to-end designs meet the business and data requirements
• Identifies, documents, and tracks all ETL-related performance problems and takes a leadership role in the resolution 
• Evaluates, recommend, and implement tools and methods to automate administration processes
• Defines, develops, and oversees information gathering and reporting of performance metrics to determine the effectiveness and efficiency of the processes.
• Acts upon the results to continuously improve the processes.
• Provides strategic direction, guidance and integrated solutions to enterprise-wide initiatives involving data migration, and system integration.
• Presents, communicates and leads the implementation of complex data load solutions to technology problems and inefficiencies.
• Analyze complex business requirements
• Design and write technical specifications to design or redesign platforms/applications
• Develop highly complex original code and provide coding direction to less experienced staff
• Work closely with business partners to evaluate business requirements, plan projects, and participate in efficient development, delivery, and deployments
• Create new documentation, technical procedures, and user guides

Skills: Access Management, Load Monitoring, Code Leadership, Code Review, Project Design, Business Collaboration, ETL Performance, Process Automation.

• Must have the ability to problem solve, troubleshoot, be attentive to detail, and understand implications for the business
• Ability to work independently, or in groups, while maintaining a courteous attitude when dealing with customers and users
• Ability, and willingness, to complete several concurrent tasks in a fast-paced, detail-oriented, multi-tasking environment
• Ability to set objectives, manage project timelines and see projects to completion
• Ability to explain technical terms in everyday language
• Continually updates skills and knowledge
• Strong analytical skills and the ability to learn new technologies
• Proficient understanding of code versioning tools, preferably with Azure DevOps Server
• Experience with Middleware solutions
• Experience deploying, integrating and supporting ECM solutions such as Hyland Onbase
• Experience with application and database security
• Experience in SQL Server Reporting Services (SSRS)
• Experience in writing complex reports in Crystal Reports
• Knowledge of MS SQL Server 2012 or later
• Experience with SSRS, SSIS, T-SQL, develop SSIS packages
• Strong Data analysis and data migration script creation experience
• Good to have a person who has previously worked on some ERP Master data conversion especially from iSeries / IBM Mainframe flat files as a source to SQL Server tables

Qualifications: BA in Software Engineering with 7 Years of Experience.

• Experience with T-SQL, including stored procedure development
• Knowledge of data integration, e.g. extract, transform, and load (ETL) process developmentsupport.
• Able to develop and troubleshoot reports delivered with SSRS requires good analytical skills.
• Experience with data access performance tuning, and database performance optimization.
• Application Development Lifecycle knowledge and experience.
• Experience with Case Management data and Call Center data.
• Basic understanding of networking principles.
• Ability to analyze system resource usage and constraints.
• Strong communication skills, ability to interact at all levels including management.
• Experience in AWS GLUE, Hudi, Data brew, experience extracting data from multiple sources, and working with GLUE Studio. 
• Experience working with AWS Elastic Search, RDS, PostgreSQL 
• Experience AWS services such as Lambda, and EMR, developing and maintaining data pipelines using AWS Cloud formation. 
• Experience in Requirements Analysis, Data Analysis, Application Design, Application Development, Implementations and Testing of Data warehousing business systems. 
• Solid experience in developing Ab Initio applications for Extraction, Transformation, Cleansing and Loading into Data WarehouseData mart. 
• Experience in developing reusable generic applications for high-volume DWH environments. 
• Experience in writing UNIX Shell Scripts.

Qualifications: BA in Data Science with 4 Years of Experience.

• Demonstrated experience in database development on any major RDBMS platform (SQL Server/Oracle/Sybase/DB2)
• Experience with an ETL tool (Ab Initio/Informatica)
• Strong knowledge of data warehousing concepts and ETL best practices
• Experience with Windows batch and Unix shell scripts
• Strong knowledge of data objects like JSON and XML.
• Strong knowledge of software development and the system implementation life cycle
• Strong analytical and quantitative skills.
• Understanding of the integrity of development models including the enforcement of standards, policies and system stewardship principles.
• Ability to develop support materials for applications to expand overall knowledge sharing throughout the group.
• Able to perform dimensional data profiling as needed and must be expert in SQL with Healthcare applying clinical for financial terminology
• Ability to analyze technical information and requirements to design and develop robust data interaction solutions. 
• Ability to deal effectively with people and elicit support from other department areas, vendors, and customers. 
• Excellent analytic, communication, and documentation skills. 
• Able to organize technical work
• Demonstrate excellent planning, problem-solving, analysis, documentation, presentation and organization skills
• Able to communicate effectively in English in person, in writing, and on the telephone

Qualifications: BA in Information Technology with 8 Years of Experience.

• Advanced knowledge of SQL databases and queries. 
• Advanced knowledge of CDC (Change Data Capture) CT (Change Tracking) inner workings. 
• Experience in implementing and supporting several different ETL solutions 
• Experience in working with many different data sets, large and small. 
• Experience with normalizing and de-normalizing data. 
• Knowledge of ETL best practices and standards. 
• Ability to quickly resolve issues. 
• Strong written communication skills. 
• Experience with Tableau and Power BI
• Transportation, Manufacturing Industry experience
• Able to communicate with others by telephone and in person. 
• Able to utilize a computer for word processing, email communication, and preparation of documents and presentation skills 
• Experience in Computer Science, Computer Engineering, Systems Engineering, or a closely related discipline.
• Experience with cloud services and specifically AWS; and cloud-based database services such as Databricks and EMR; and experience with AWS long-term storage options.
• Understanding of SQL database structures and mapping of data structures between different SQL databases.
• Experience with Nifi, working with a Hadoop cluster, and the Extract-Transform-Load processes.
• Knowledge of API development techniques.
• Ability to create operating system-level scripts to perform ETL operations on SQL databases.
• Experience with version control systems, preferably Git.

Qualifications: BA in Computer Science with 5 Years of Experience.

• Experience working with Data Analytics tools to pull data from different sources
• Proficient SQL skills, and Python
• Comfortable working in Linux and distributed environments
• Experience with AWS
• Experience with Hadoop (Cloudera/Impala), Agile Scrum or Kanban experience or Training
• Experience with Cloud-based architecture (example: Bluemix, Google Cloud or AWS development).
• Experience using Apache Spark, Nifi, and/or Kafka.
• Experience using Python and Spark/Python/SQL and common data science tools and libraries 
• Proficiency in other programming languages (Java, etc.)
• Experience moving data between systems
• Must be able to maintain an Enterprise Data Warehouse (EDW) in support of business intelligence analytics
• Experience working within an Extraction Transform Load (ETL) software
• IT and Business stakeholder management and governance, team building and team management experience
• Ability to encourage and inspire team to help realise their potential, providing knowledge and guidance to all team members
• Ability to work in high-pressure, milestone-driven project plan.
• High personal integrity, able to maintain confidentiality and proprietary company information.
• Experience with data conversion, transformation, and query optimizations
• Proficient in system analysis, debugging and defect fixing.
• Ability to work in a team environment and client interfacing skills

Qualifications: BA in Business Analytics with 5 Years of Experience.

• Working experience using Talend / Informatica and Teradata Tools and Utilities to provide a service that specializes in the architecture, design, and development of the Talend / Informatica ETL environment, processes, programs, and scripts to acquire data from source systems and apply the data to the database tables
• Strong skills in performance tuning to be able to provide recommendations to the database designer on how to tune the physical database based on the features of the platform, ETL tools, and physical models.
• Experience in technical design and documentation for Data Integration and Development
• Experience in developing data integration processes
• Experience in Quality Assurance Testing
• Experience in performing production support (data issue investigation/root cause analysis)
• Knowledgeable in Unix shell scripting
• Knowledgeable in Informatica PowerCenter, Talend Open Studio, and AWS
• Knowledgeable in SQL (stored procedures)
• Exposure to Teradata Tools (BTEQ, SQL Assistant / Teradata Studio)
• Strong data analysis and problem-solving skills
• Good communication skills, as there will be daily handover calls with clients and team members
• Strong hands-on experience using Informatica PowerCenter
• In depth SQL Experience and query writing ability
• Expertise in developing applications using BI and Data warehouse technologies
• Proven informatics experience
• Experience in Unix, Shell Scripting and Autosys

Qualifications: BA in Computer Science with 5 Years of Experience

• Demonstrate strong, problem-solving, communication, organizational, time management, and multi-tasking skills
• Knowledge of programming languages and tools
• Data warehousing experience
• Ability to conduct research into software-related issues
• Understands relational database, client-server concepts, and software development life cycle methodology
• Ability to work independently, positively handle conflict, and work in a fast-paced environment
• Ability to troubleshoot software
• Display detail-oriented approach to work
• Ability and proficiency in Microsoft Windows and Office products
• Previous experience with HPE Pointnext Services Supply Chain systems/applications desired.
• Experience designing and managing large software systems. 
• Excellent analytical and problem-solving skills. 
• Strong Technical leadership with key skills in understanding SAP system integrations and working in an SAP-driven environment and data structures
• Must be able to lead a small team of 3-5 developers and provide technical guidance
• Knowledge of Demand Planning, and echelon Optimization highly desirable
• Experience in Service Now, ITSM Process desired
• Good understanding of business intelligence/data warehouse designs and integration patterns.
• Familiar with Big Data technologies.

Qualifications: BA in Information Technology with 4 Years of Experience.

• Experience in IT with an emphasis on ETL, Reporting, and systems integration.
• Proficient using at least one industry standard ETL tool, such as SQL Server Integration Services or Azure Data Factory.
• Experience designing and building relational databases
• Expert knowledge of ETL concepts and techniques.
• Proficient in SQL, stored procedures, triggers, indexes.
• Experience integrating with SOAP and Restful Web Services
• Experience applying enterprise design and architectural patterns
• Experience in end-to-end Software Development Life Cycle (SDLC) projects
• Experience with code review and evaluation
• Good at understanding requirements and estimation
• Team player, have ability and willingness to mentor junior developers
• Excellent verbal and written communication skills
• Self-starter that can work well in a team environment
• Proactive issue resolution with a positive attitude
• Ability to adapt and respond in a rapidly evolving business environment
• Proficient in Microsoft Office (Word, Excel, Outlook, PowerPoint)
• Possess experience in the insurance industry and/ or basic knowledge of insurance or financial services.
• Experience with Azure DevOps, CI/CD Pipelines and GIT source control
• Experience with Azure Data Factory, Azure SQL, API Management, Power BI
• Experience with Azure virtual networks and private endpoints
• Experience working with Agile/Scrum methodologies

Qualifications: BA in Data Science with 11 Years of Experience.

• ETL Talend skills 
• Knowledge of Microsoft SSIS, MS SQL and Prostage (Database), PL/SQL Stored Procedure are mandatory skill
• Familiar with Azure ETL products like Azure Data Factory, Azure Synapse, Azure Data lake, Azure DevOps
• Understand code base solutions, repository management and branching strategy using Bitbucket
• Familiar using JIRA, confluence
• Familiar with using Batching Tools like Control-M
• Strong Analytical, Attention to detail and problem-solving skills
• In-depth experience and knowledge about data warehousing methodologies and best practices
• Experience with generating data/files for front-end applications
• Experience in health care domain, specifically claims, ADT and enrollment data
• Strong interpersonal and communication skills, proactive mindset and ability to multitask

Qualifications: BA in Software Engineering with 6 Years of Experience.

• Proven experience within a programming and application system environment, with solid experience and a working knowledge in the following technologies T-SQL (SQL Server) C and .Net experience ETL Tools, ETL (Extract, transform, load) techniques Source Code repositories (GIT) 
• Experience working in Financial software or related field. 
• Proven ability with commercial software architectures at both a software and infrastructure level Functional skills ndash 
• Ability to work under pressure and be highly adaptable 
• Strong written and communication skills for collaboration with various teams and upper management 
• Able to adapt and adopt change and support business strategy and vision. 
• Experience programming ETL programs using DataStage language or tools
• Experience performing data analysis and profiling, and designing ETL systems/program
• Advanced SQL skills
• In-depth understanding of data integration best practices, leading industry applications and features such as master data management, entity resolution, data quality assessment, metadata management, etc.
• Understanding of data warehouse best practices
• Good interpersonal skills and the ability to collaborate with other technical teams, project management, client management and business analysts
• Health and human services experience
• Complete understanding of warehousing methodologies
• Experience with hash algorithms
• Experience implementing systems that utilize Oracle DBMS

Qualifications: BA in Business Analytics with 4 Years of Experience.