ETL Developer

3 weeks ago

Cincinnati, United States Encore Talent Solutions Full time

Encore Talent is seeking an ETL Developer to be responsible for managing the design, development, implementation, management and support of critical enterprise Business Intelligence reporting processes and environments. The ETL Developer will use their knowledge of data warehousing and architecture to develop ETL solutions and help automate data extraction from source systems and transform unstructured and disparate source data into target data stores or data marts.

Responsibilities:

  • Use various data warehousing concepts to build a data warehouse for internal departments of the organization.
  • Create and enhance data solutions enabling seamless delivery of data and collect, parse, manage, and analyze large sets of data.
  • Lead the design of the logical data model.
  • Implement the physical database structure and constructs.
  • Implement operational data stores and data marts.
  • Develop and support stored procedures, understand and code in open SQL language in SQL and HANA cloud foundry (BAS) environments.
  • Develop smart data Integration (SDI) objects between multiple source systems which helps in transformation, extraction and loading into target database.
  • Develop logical and physical data flow models for ETL application.
  • Monitor, create and troubleshoot SAP job failures, through SAP HANA and SAC cockpit for high performance system availability (i.e. Alerts, services, disk space usage, memory usage, CPU usage, stored procedures for QA/DEV/PRD)
  • Perform complex data analysis/validation to ensure the accuracy and integrity of data.
  • Troubleshoot and research data anomalies and recommend/implement corrective actions.
  • Perform performance optimization and tuning on new and/or existing data warehouse and/or ETL operations.
  • Participate in ongoing architecture quality review activities to ensure both current and future capability meets architecture standards.
  • Create and maintain of documentation for existing architecture, data dictionaries, future data warehouse architecture and business intelligence reporting.
  • ·Prepare accurate and detailed requirement specifications documents, workflow analysis, user guides, and functional specification documents
  • Determine storage needs for reporting databases and data warehouse.

Qualifications:

· 3+ years related experience as a ETL Developer/Data Analyst or similar position

· 3+ years related experience with data modeling with Cloud concepts (Snowflake, HANA calculation views

· Strong understanding of SQL Server Integration Services (SSIS) (or similar tools) for ETL

· Proficient in MS SQL Server (or similar relational databases like Oracle and PostgreSQL)

· Experience working with SAP HANA cloud foundry is a plus

· Experience with SAP Analytics Cloud a plus

· Experience in database design and management

· Excellent analytical and problem solving skills

· Strong planning and organizational skills

· Ability to clearly articulate pros and cons of various technologies and platforms

· Outstanding interpersonal, verbal, and written communication skills

· Ability to perform detailed analysis of business problems and technical environments and use this in designing the solution

· Exhibit patience with other associates

· Ability to estimate the financial impact of individual solution architecture alternatives

· Ability to provide accurate estimates for tasks and project activity

· Possess personal drive and initiative regarding career growth

· Ability to work independently, prioritize own tasks, and tasks of others

· Able to multi-task in fast paced environment and manage time effectively

· Passion for customer service, efficiency, effectiveness, precision and quality

· Good team player, and willingness to assist others, and share expertise

· Able to work flexible hours; expected to work nights and weekends as needed

· Ability to travel between offices, as required


Encore Talent Solutions is an Equal Opportunity Employer. We respect and seek to empower each individual and support the diverse cultures, perspectives, skills, and experiences within our workforce.

  • ETL Developer

    1 week ago

    Cincinnati, United States Planet Technology Full time

    Planet Technology has partnered with a Cincinnati company to an ETL Developer for a full time position. Candidates are required to be onsite in our Cincinnati client offices at least three days a week. This is a full-time position and we will not accept any inquiries from Third Party Vendors. We are seeking a talented SQL ETL Developer to join our team and...

  • ETL Developer

    1 week ago

    Cincinnati, United States Planet Technology Full time

    Planet Technology has partnered with a Cincinnati company to an ETL Developer for a full time position. Candidates are required to be onsite in our Cincinnati client offices at least three days a week. This is a full-time position and we will not accept any inquiries from Third Party Vendors. We are seeking a talented SQL ETL Developer to join our team and...

  • ETL Developer

    3 weeks ago

    Cincinnati, United States Planet Technology Full time

    Business Intelligence/ETL DeveloperLocation - Cincinnati, OH - Hybrid - Prefer local candidatesAs a member of the Business Intelligence team, the ETL Developer is responsible for managing the design, development, implementation, management and support of critical enterprise Business Intelligence reporting processes and environments. The ETL Developer will...

  • ETL Developer

    4 weeks ago

    Cincinnati, United States Planet Technology Full time

    Business Intelligence/ETL DeveloperLocation - Cincinnati, OH - Hybrid - Prefer local candidatesAs a member of the Business Intelligence team, the ETL Developer is responsible for managing the design, development, implementation, management and support of critical enterprise Business Intelligence reporting processes and environments. The ETL Developer will...

  • ETL Developer

    1 week ago

    Cincinnati, United States Insight Global Full time

    A large financial services client is seeking an ETL Developer for a permanent opportunity onsite in downtown Cincinnati. This person day to day responsibilities will include:- 80% of their day is development- 20% mentorship, code-reviews, giving suggestions○ This person should be able to step in and quickly help mentor junior developers with code reviews...

  • ETL Developer

    1 week ago

    Cincinnati, United States Insight Global Full time

    A large financial services client is seeking an ETL Developer for a permanent opportunity onsite in downtown Cincinnati. This person day to day responsibilities will include:- 80% of their day is development- 20% mentorship, code-reviews, giving suggestions○ This person should be able to step in and quickly help mentor junior developers with code reviews...

  • ETL Developer

    1 week ago

    Cincinnati, United States Insight Global Full time

    A large financial services client is seeking an ETL Developer for a permanent opportunity onsite in downtown Cincinnati. This person day to day responsibilities will include:- 80% of their day is development- 20% mentorship, code-reviews, giving suggestions○ This person should be able to step in and quickly help mentor junior developers with code reviews...

  • ETL Developer

    2 weeks ago

    Cincinnati, United States CBTS Full time

    CBTS is currently seeking an ETL Developer for a position located in Cincinnati, OHResponsibilities:Software feature development, data inquiries, troubleshooting, data analysis, and data pipeline build out. Responsible for producing stable, scalable, high quality database features that support the application code for the team’s applications and services;...

  • BI ETL Developer

    2 weeks ago

    Cincinnati, United States Rumpke Full time

    As a member of the Business Intelligence team, the ETL Developer is responsible for managing the design, development, implementation, management and support of critical enterprise Business Intelligence reporting processes and environments. The ETL Developer will use their knowledge of data warehousing and architecture to develop ETL solutions and help...

  • BI ETL Developer

    2 weeks ago

    Cincinnati, United States Rumpke of Ohio, Inc. Full time

    Job DescriptionJob DescriptionAs a member of the Business Intelligence team, the ETL Developer is responsible for managing the design, development, implementation, management and support of critical enterprise Business Intelligence reporting processes and environments. The ETL Developer will use their knowledge of data warehousing and architecture to develop...

  • BI ETL Developer

    1 week ago

    Cincinnati, United States Rumpke Full time

    As a member of the Business Intelligence team, the ETL Developer is responsible for managing the design, development, implementation, management and support of critical enterprise Business Intelligence reporting processes and environments. The ETL Developer will use their knowledge of data warehousing and architecture to develop ETL solutions and help...

  • BI ETL Developer

    3 days ago

    Cincinnati, United States Rumpke Full time

    As a member of the Business Intelligence team, the ETL Developer is responsible for managing the design, development, implementation, management and support of critical enterprise Business Intelligence reporting processes and environments. The ETL Developer will use their knowledge of data warehousing and architecture to develop ETL solutions and help...

  • BI ETL Developer

    4 hours ago

    Cincinnati, United States Rumpke Full time

    As a member of the Business Intelligence team, the ETL Developer is responsible for managing the design, development, implementation, management and support of critical enterprise Business Intelligence reporting processes and environments. The ETL Developer will use their knowledge of data warehousing and architecture to develop ETL solutions and help...

  • Informatica Developer/ Senior Developer

    6 days ago

    Cincinnati, United States Tata Consultancy Services Full time

    Languages: SQL, Unix ShellTools: Informatica PowerCenterDatabases: Oracle, SQL Server, and Teradata.Big Data: Cloudera Hadoop, HiveDev Methodologies: Agile, WaterfallOthers: Toad, SVN, Control-M, Dollar Universe or AutosysRoles & Responsibilities:7+ years of development experience in delivering ETL/database/programming solution.5+ years of hands-on...

  • Informatica Developer/ Senior Developer

    7 days ago

    Cincinnati, United States Tata Consultancy Services Full time

    Languages: SQL, Unix ShellTools: Informatica PowerCenter Databases: Oracle, SQL Server, and Teradata.Big Data: Cloudera Hadoop, HiveDev Methodologies: Agile, WaterfallOthers: Toad, SVN, Control-M, Dollar Universe or AutosysRoles & Responsibilities:7+ years of development experience in delivering ETL/database/programming solution.5+ years of hands-on...

  • Informatica Developer/ Senior Developer

    7 days ago

    Cincinnati, United States Tata Consultancy Services Full time

    Languages: SQL, Unix ShellTools: Informatica PowerCenter Databases: Oracle, SQL Server, and Teradata.Big Data: Cloudera Hadoop, HiveDev Methodologies: Agile, WaterfallOthers: Toad, SVN, Control-M, Dollar Universe or AutosysRoles & Responsibilities:7+ years of development experience in delivering ETL/database/programming solution.5+ years of hands-on...

  • Informatica Developer/ Senior Developer

    2 days ago

    Cincinnati, United States Tata Consultancy Services Full time

    Languages: SQL, Unix Shell Tools: Informatica PowerCenter Databases: Oracle, SQL Server, and Teradata. Big Data: Cloudera Hadoop, Hive Dev Methodologies: Agile, Waterfall Others: Toad, SVN, Control-M, Dollar Universe or Autosys Roles & Responsibilities: 7+ years of development experience in delivering ETL/database/programming solution. 5+ years of hands-on...

  • Informatica Developer/ Senior Developer

    7 days ago

    Cincinnati, United States Tata Consultancy Services Full time

    Languages: SQL, Unix ShellTools: Informatica PowerCenter Databases: Oracle, SQL Server, and Teradata.Big Data: Cloudera Hadoop, HiveDev Methodologies: Agile, WaterfallOthers: Toad, SVN, Control-M, Dollar Universe or AutosysRoles & Responsibilities:7+ years of development experience in delivering ETL/database/programming solution.5+ years of hands-on...

  • Informatica Developer

    5 days ago

    Cincinnati, United States Tata Consultancy Services Full time

    Tata Consultancy Services is an Indian multinational information technology services and consulting company with its headquarters in Mumbai. It is a part of the Tata Group and operates in 150 locations across 46 countries. In July 2022, it was reported that TCS had over 600,000 employees worldwide. About Job: Job Title:Informatica Developer Location:...

  • Informatica Developer

    5 days ago

    Cincinnati, OH, United States Tata Consultancy Services Full time

    Tata Consultancy Services is an Indian multinational information technology services and consulting company with its headquarters in Mumbai. It is a part of the Tata Group and operates in 150 locations across 46 countries. In July 2022, it was reported that TCS had over 600,000 employees worldwide. About Job: Job Title:Informatica Developer Location:...