Senior ETL Developer at ADVANSYS, focusing on ETL processes design and development using Informatica PowerCenter and Microsoft SSIS. Collaborate on data integration solutions and performance monitoring.
Responsibilities
Analyses and revises information and data initiatives including database structure, ETL processes, and external data interfaces.
Design and Development of ETL processes based on the requirements.
Excellent experience in using Informatica PowerCenter and Microsoft SSIS ETL tools.
Develop Program Units (such as Stored Procedures, Packages) required for the ETL process.
Exceptional knowledge of using Microsoft Office products especially Word, Excel, Outlook, Access, PowerPoint.
Interact with the other departments to understand and identify data needs and requirements and work with other members of the IT organization to deliver ETL solution to address those needs.
Provide third-level support for production Data Integration environment.
Monitor performance of all Data Integration systems; provide ongoing performance tuning, review logs, clean temp files and all other administrative issues required to ensure applications and databases are performing efficiently.
Must possess excellent organizational skills, be detail oriented with an ability to meet critical deadlines.
Excellent communication (oral/written) skills with respect to team members, peers, and staff at all levels of the organization.
Has ability to work both independently and as part of a team.
Requirements
Bachelor's Degree required in Computer Science or equivalent (a combination of education and experience will be considered).
High level interpersonal skills and communication skills both written and oral.
A minimum of 4 years hands-on experience working with database and ETL technologies and architectures; including both logical and physical designs, data mart creation, ETL tools, loaders and development and reporting tools is preferable. This experience should include influencing global data architecture directions and defining major data architecture related technology standards.
A minimum of 4 years’ experience with implementation of ETL processes using Informatica PowerCenter and Microsoft SSIS tools.
A minimum of 4 years’ experience writing Oracle & SQL Server stored procedures and packages.
A minimum of 4 years hands-on experience in various data definition and modelling projects and demonstrated capabilities in carrying best practices and common objects/components to other projects is required.
Strong expertise in Data Integration and ETL methodologies and concepts.
Strong expertise in Informatica and Microsoft SSIS ETL tools.
Strong expertise in database design and database development.
Experience in real time/near real time data integration.
Experience with development processes and production release management; application and database tuning and interdependencies on operating system configuration is highly desired.
Must possess excellent organizational skills, be detail oriented with an ability to meet critical deadlines.
Exceptional knowledge of using Microsoft Office products especially Word, Excel, Outlook, Access, PowerPoint.
Analytics Engineer developing and maintaining data models to support strategic decisions in Hostinger. Revolutionizing data use to enhance business insights and accessibility.
Data Engineer at Regions Bank focusing on designing and maintaining data structures for analytics. Collaborating with technical teams to deliver data - driven business value and products.
Analytics Engineer shaping Statista's reporting platform for data - driven decision - making. Focusing on BI tools like Power BI and improving report usability and transparency.
Director of Data & Analytics leading data strategy for Reach Financial, enhancing decision - making through a data - driven culture. Guiding a team to innovate and implement scalable data solutions.
Data Scientist creating scalable insights from unstructured data at AI safety company. Collaborating with engineering and research teams in a hybrid Paris location.
Senior Analytics Engineer owning the analytics data platform for parenting technology startup. Requires deep SQL expertise and data pipeline experience in a hybrid role.
Senior Analytics Engineer at Higgsfield AI translating product and finance metrics into data models. Collaborating cross - functionally to ensure consistent, reliable data for decision - making.
Senior Data Analytics Developer for Krux, building data infrastructure for innovative SaaS solutions in mining industry. Collaborating with a self - motivated team to drive company growth.
Lead Risk Analytics Consultant at Wells Fargo focused on model governance and risk management strategies. Collaborate across teams to enhance system stability and mentor junior staff.
Analytics Engineering Lead responsible for building data products at Sanlam Fintech. Overseeing analytics engineering practice modernization and talent development within the organization.