ETL Developer

Position(s) Required: ETL Developer-Level III Designated Work Location: Albany, NY The assignments Onsite/Offsite regulations are the NYS hybrid model, which is out of 10 business days, the applicant is to be onsite 5 business days.It usually works out where one week you work onsite 3 days and the next week you work onsite 2 days and so on. Anticipated Duration of the Engagement: 28 months Mandatory Qualification: Level III- More than seven (7) years of experience working on complex projects with 2 or more years in a leadership role as a Developer More than seven (7) years of experience working on complex data migration projects with 2 or more years in a leadership role as a Developer performing data extraction, data transformation, and data loading (ETL) from legacy systems to a modern data platform. More than (7) years of hands-on experience in implementing and maintaining data integration and master data management processes using Informatica suite of products such as Informatica PowerCenter, Informatica Data Quality, and Informatica Master Data Management (MDM). Desirable Qualifications: Seven years or more of hands-on experience using Informatica PowerCenter to migrate data from various sources and targets including databases, flat files, JSON, and XML files. Five or more years of experience with Data Quality processes, approaches, measurement techniques and business cases for data analysis, data profiling, data cleansing, data standardization, match and merge functionality using Informatica Data Quality. Three or more years of hands-on professional experience performing MDM activities such as data cleansing, data ingestion pipelines, matching, merging, deduplication, hierarchy management, automation, and orchestration using Informatica MDM. Five years or more experience in implementing concepts such as Slowly Changing Dimension (SCD Type) and Change Data Capture (CDC) functionality for data migration projects. Seven or more years of experience developing complex SQL, T-SQL, PL/SQL objects with Oracle 19c or SQL Server 2019, or higher such as stored procedures, triggers, packages, materialized views, and performance tuning. Three or more years of experience writing complex UNIX shell scripts to validate and ftp files, and for scheduling / automating ETL processes. Duties/Responsibilities: Daily activities will include, but are not limited to: As part of the product development team, you will work in an agile environment and collaborate and develop solutions to solve data integration challenges. As part of the Data Migration team, you will perform data migration activities to migrate data from legacy systems such as the mainframe, extracted data files, and databases to a modern data platform. As part of the Data Migration team, you will perform activities such as analyzing, designing, developing, testing, and deploying Extract, Transform, and Load (ETL) solutions. As part of the Data Migration team, you will perform data preparation activities such as data extraction, data analysis, data profiling, and data cleansing. As part of the Data Conversion team, you will perform data conversion activities such as data mapping and data consolidation of duplicate and redundant data. As part of the Data Management team, you will monitor daily ETL jobs and processes that identify load and performance issues and determine the resolution and revise the incorrect operational processes. As part of the Data Management team, you will create ETL design, source to target mapping documents, and implementation documentation. Communicate and coordinate with members of the product team to work across multiple projects. Other duties as assigned. About Us: InterSources Inc , a Certified Diverse Supplier, was founded in 2007 and offers innovative solutions to help clients with Digital Transformations across various domains and industries. Our history spans over 16 years and today we are an Award-Winning Global Software Consultancy solving complex problems with technology. We recognize that our employees and our clients are our strengths as the diverse talents and opportunities they bring to the table enable us to grow as a global platform and they are causally linked with our success. We provide strategic and technical advice, and we have expertise in areas covering Artificial Intelligence, Cloud Migration, Custom Software Development, Data Analytics Infrastructure & Cloud Solutions, Cyber Security Services, etc. We make reasonable accommodations for clients and employees and we do not discriminate based on any protected attribute including race, religion, color, national origin, gender sexual orientation, gender identity, age, or marital status. We also are a Google Cloud partner company. We align strategy with execution and provide secure service solutions by developing and using the latest technologies that thrive our resources to deliver industry-leading capabilities to our clients and customers, making it convenient for our clients to do business with InterSources Inc. Our teams also drive growth by refining technology-driven client experiences that put the users first, providing an unparalleled experience. This results in strengthening the core technologies of clients, enabling them to scale with flexibility, create seamless digital experiences and build lifelong relationships.