Job Summary: 

• Own ETL pipelines from customer data to SecureLink's applications
• Evaluate and implement data transformation workflows
• Construct and revise SQL queries to extract data from customer data sources
• Advise clients on generating data compatible with the application
• Advise on & define data requirements for new or underutilized customer features
• Collaborate with internal and customer teams to meet project milestones
• Provide technical expertise during implementation projects
• Perform validation on data both in raw form and when loaded into the application
• Maintain documentation of customer data feeds, technical specifications, and data workflows
• Help define and create the next generation of ETL tools and workflows used by the team
• Data extraction, cleansing, conversion, standardization, profiling, transformation and loading, data mining, archiving, and reporting
• Processing, cleansing, and making sure the integrity of data used for analysis is running smoothly
• Acquiring data from data sources
• Collect, clean, organize, store, and create data pipelines
• Updating data to source production systems
• Performing ad-hoc analysis and presenting results to leadership in a clear presentation
• Create available data tools and products and operationalize data activities

Skills on Resume: 

• ETL Management (Hard Skills)
• SQL Construction (Hard Skills)
• Data Transformation (Hard Skills)
• Data Validation (Hard Skills)
• Data Reporting (Hard Skills)
• Teamwork (Soft Skills)
• Client Communication (Soft Skills)
• Problem-Solving (Soft Skills)

Job Summary: 

• Collaborate with the BI Data Visualization developers to translate the business requirements of the customers of the BI team into the DWH technical design.
• Collaborate closely with IT and other groups to map business requirements to data sources.
• Collaborate with the BI Data Architect to ensure that the created DWH technical designs adhere to conventions and standards.
• Collaborate with the Lead BI analyst to ensure that the ETL transformation logic to be implemented is aligned with company-wide definitions of metrics, dimensions, and other data points.
• Implement complex non-conflicting concurrent ETL processes that are SLA-driven.
• Create, maintain, and update DWH technical documents, including source-target mapping documents, data model and data flow documents, monitoring documents, and test scripts and testing documents.
• Support the BI Data Architect in performing regular checks on the data warehouse to ensure environment health, data integrity, and availability, by working closely with IT and other dependencies.
• Support the BI Data architect by identifying and initiating processes, documentation, and technical design improvement for warehouse delivery.
• Manage assigned deliverables and projects or initiatives ensuring achievement of dedicated tasks that should result in satisfying overall project objectives with regular project phase updates to team lead and/or to stakeholders.
• Continuously recommend, introduce and innovate processes, systems, and products by presenting facts-based analysis and impact of recommendations to the immediate head.
• Manage all process documents, records, and databases for reference, research and report purposes. 
• Maintain a strong relationship with the Data Warehouse team for capability management/delivery standards, peer checking, operational support obligations such as risk and incident management, preventative maintenance/performance tuning, release scheduling and environment management.
• Develop and maintain documentation including the Enterprise Bus Matrix, technical and release specifications, user documentation
• Ensure compliance with delivery standards (such as architecture, information security, and testing)
• Identify data sources where the potential value is not fully realized and invent new means with which to interact and gather insights from it
• Deploy predictive models to assess part quality from time-series data, images, and more

Skills on Resume: 

• Data Warehousing (Hard Skills)
• ETL Process Management (Hard Skills)
• Business Requirement Mapping (Soft Skills)
• Documentation Management (Hard Skills)
• Collaboration (Soft Skills)
• Process Improvement (Soft Skills)
• Project Management (Soft Skills)
• Data Integrity Management (Hard Skills)

Job Summary: 

• Work with stakeholders directly and independently to gather requirements to design and develop solutions
• Develop high-quality, maintainable, and scalable solutions
• Own delivery of these solutions end to end, analysis and design
• Investigate new tools/technologies/ideas to promote further improvement of the system
• Promote and enforce best practices, existing development guidelines, and continuous code improvement
• Troubleshoot data-related problems
• Work on projects with a variety of teams all over the globe
• Develop data warehouse solutions per the given business requirements.
• Develop and/or enhance database schemas to fulfill the business requirements.
• Develop Extract Transform and Load (ETL) processes for ingesting data to the data Warehouse.
• Provide support to the enterprise solutions.
• Determines data storage needs.
• Design, develop, modify, debug, and/or maintain software code according to functional, non-functiona,l and technical design specifications.
• Creates and enhances data solutions enabling seamless delivery of data and is responsible for collecting, parsing, managing, and analyzing large sets of data.
• Leads the design of the logical data model and implements the physical database structure and constructs and implements operational data stores and data marts.
• Designs develops, automates, and support complex applications to extract, transform, and load data.
• Ensures data quality.
• Develops logical and physical data flow models for ETL applications.
• Translates data access, transformation, and movement requirements into functional requirements and mapping designs.

Skills on Resume: 

• Requirements Gathering (Soft Skills)
• Solution Development (Hard Skills)
• System Improvement (Hard Skills)
• Troubleshooting (Soft Skills)
• ETL Process Development (Hard Skills)
• Database Design (Hard Skills)
• Collaboration (Soft Skills)
• Data Management (Hard Skills)

Job Summary: 

• Develop ETL program testing and validation procedures and provide proper documentation
• Develop, create, and modify general ETL applications software or specialized utility programs.
• Develop Unix/Linux, Processes to Retrieve And Manipulate Data (Python, Shellscript, Perl)
• Develop Api Processes to Pull Third Party Data Using Python
• Identify and setup batch processes (control-m, glue, airflow)
• Working w/data scientists to design, develop and/or manipulate data to predict and measure outcomes and consequences of design
• Modify existing ETL applications to correct errors, allow them to adapt to new hardware, or improve performance.
• Analyze business user needs and develop ETL software solutions
• Propose new/modify data models following industry-standard data warehouse architecture methods
• Provide maintenance support to existing application code
• Define functional design for requirements implementation
• Develop SQL scripts using Teradata utilities (BTEQ, Fastload, Mload & Fastexport) to transform and load data from various sources
• Design and build data structures and processes to populate data warehouse tables using knowledge of relational and dimensional data modeling techniques
• Adhere to system performance standards.
• Provide rotating on-call system support
• Work closely with the business, reporting team, business analyst, and end users in end-to-end Business Intelligence solutions
• Peer review code to ensure that it meets coding standards for deployment
• Prepare deployment change control documentation
• Perform other duties as required and assigned by the manager and upper management.
• Follow legal policies as directed.

Skills on Resume: 

• ETL Validation (Hard Skills)
• Software Development (Hard Skills)
• Data Manipulation (Hard Skills)
• API Development (Hard Skills)
• Batch Setup (Hard Skills)
• Team Collaboration (Soft Skills)
• SQL Development (Hard Skills)
• Design Implementation (Soft Skills)

Job Summary: 

• Copy and extract business data and load it into a data warehousing environment.
• Proactively tailor data warehouse to meet changing needs.
• Monitor system performance and adjust prior to, after, and between updates.
• Design and implement complex ETL pipelines and other Power BI solutions.
• Interface with internal and external teams to extract, transform, and load data from a wide variety of data sources using SQL and AWS big data technologies.
• Explore, learn, and utilize current AWS technologies.
• Constructs and implements operational data stores and data marts
• Collaborating with internal partners to design scalable backend systems
• Managing and solving complex modeling needs
• Supporting sales initiatives and developing innovative technical solutions that meet client and market requirements
• Creating and maintaining new performance, secure and value-based public cloud infrastructure that meets design principles to support the development, testing, and operation of new products and services.
• Translating requirements into technical solutions for new data services including data acquisition, transformation, matching, enrichment, anonymization, secure access, and presentation.
• Building, testing and automating new data services that integrate multiple data sources.
• Ensuring the timely delivery of existing products and services to clients.
• Working with team colleagues, the test team and external partners to ensure performance and accuracy of outputs to meet client needs.
• Developing custom and self-service BI reporting capabilities using COTS tools such as Tableau.

Skills on Resume: 

• Data Extraction (Hard Skills)
• ETL Pipeline Design (Hard Skills)
• AWS Technologies (Hard Skills)
• Data Warehouse Management (Hard Skills)
• System Monitoring (Hard Skills)
• Collaboration (Soft Skills)
• Problem-Solving (Soft Skills)
• Technical Solution Development (Soft Skills)

Job Summary: 

• Working closely with tech lead to understand requirements
• Creating Low-level design documents and code components (mappings/reports) using Low-level design documents
• Creating unit test documents and performing unit testing
• Creating integration test cases and performing integration testing
• Performing peer reviews for project deliverables
• Analyzing failures, updating defect management tools and fixing defects
• Implementing project-specific standards
• Creating UNIX, SQL scripts, source/target definitions, mappings, workflows, sessions and transformations
• Scheduling and monitoring workflows
• Design, Build, and deploy ETL solutions based on requirements
• Translate requirements from the business and analyst into technical code
• Identify and test for bugs and bottlenecks in ETL solutions
• Provide support and fix issues with new and existing ETL solutions
• Create procedures and packages to meet the ETL requirements (including testing)
• Conduct performance analysis to optimize the impact on operational systems
• Contribute to master data management projects and provide feedback on data flows
• Engage in the Data Team for sharing knowledge & work in close collaboration with the architects
• Develop a technical design for extraction, transformation & load of data from multiple source systems into a pre-defined template prescribed by Oracle ERP
• Use Information Builder's Omnigen toolset to enable data profiling and analysis as well as transformation and load activities
• Identify & develop Data Quality rules, Match & Merge rules to support de-duplication and cleansing of data
• Support testing of data migration scripts/routines
• Prepare a data migration cut-over plan & execution of the same

Skills on Resume: 

• Requirement Analysis (Soft Skills)
• Low-Level Design (Hard Skills)
• Unit Testing (Hard Skills)
• Integration Testing (Hard Skills)
• Peer Review (Soft Skills)
• UNIX Scripting (Hard Skills)
• ETL Solution Deployment (Hard Skills)
• Performance Optimization (Hard Skills)

Job Summary: 

• Builds ETL processes that will map data from source systems to target systems utilizing SSIS in an automated manner.
• Responsible for all related extraction, transformation, and load of data functions within IT.
• Works with outside vendors to develop data transfer strategy both internally and externally for both new and existing systems.
• Develops a secure model for data transfer design along with Database administration and to the security level required to keep all data secure.
• Understands the relationships between business activities and application systems.
• Determine and report the impact of database changes and ETL processes on the application systems
• Keeps data secure by managing access, privileges, and information migration.
• Responsible for translating database design and diagnosing database performance issues
• Ensures integrity of all physical database objects and established database procedures.
• Develops, maintains, and improves database stored procedures.
• Implement and maintain backup/ recovery,  restart/refresh, and disaster recovery procedures.
• Develop and maintain ETL processes that are concurrent with the business requirements
• Work closely with the business team to align business requirements and translate them into technical executable solutions
• Analyze and present proposed technical solutions to business and enable business to analyze the potential benefits and risks from a business perspective
• Build codes, support testing, and fix defects
• Follow coding standards and best practices to develop code and check code quality
• Assess and create a deployment/rollback plan
• Maintain deployment tracker and perform sanity checks post-deployment to ensure a smooth move to production.

Skills on Resume: 

• ETL Development (Hard Skills)
• Data Security (Hard Skills)
• Vendor Collaboration (Soft Skills)
• Database Administration (Hard Skills)
• Business Alignment (Soft Skills)
• Performance Diagnosis (Hard Skills)
• Recovery (Hard Skills)
• Requirements Translation (Soft Skills)

Job Summary: 

• Design, develop, test, execute and document ETL pipelines spanning multiple databases and technologies.
• Maintain and improve the existing Data Warehouse processes.
• Apply data quality and profiling rules through the ETL process.
• Work with the business in designing and delivering high-quality data.
• Troubleshoot data issues and defects to determine root cause. 
• Investigate data to identify potential issues within the ETL pipelines and propose solutions.
• Prepare data models in accordance with reporting layer requirements.
• Extract data from the data warehouse to support regulatory commitments.
• Design & development of Informatica PowerCentre ETL routines
• Maintenance, Support & Performance Tuning of production Informatica PowerCentre ETL routines
• Recommendations for improving Data Warehouse design
• The general responsibility of service provision to all FNZ Ltd clients
• Ensuring overnight client Data Deliveries are available on time
• Collect requirements and propose technical solutions in cooperation with the client
• Implement and optimize data warehousing and ETL processes (disk-based and in-memory processing)
• Design physical and logical data models based on the star/snowflake schema or OLAP Cubes
• Automate tests and deploy the code using DevOps & CI/CD best practices.

Skills on Resume: 

• ETL Pipeline Development (Hard Skills)
• Data Warehouse Maintenance (Hard Skills)
• Data Quality Management (Hard Skills)
• Business Collaboration (Soft Skills)
• Troubleshooting (Soft Skills)
• Data Modeling (Hard Skills)
• Performance Tuning (Hard Skills)
• Client Service Provision (Soft Skills)

Job Summary: 

• Analyzing requirements and creating and/or updating the Data Models and transformations, from varying data sources, to expand and improve the reporting and analytics solution
• Assisting in the provision of ad hoc data analysis, and queries
• Investigating and analyzing Production Incidents, fix or remediate, when required, aligned to the prioritization provided by the Product Owner
• Identifying and championing opportunities for service improvements
• Engaging with the wider Informatica/ ETL communities, to identify and implement technical and service improvement opportunities, and ways to improve the utilization of Informatica across the wider Direct Line Group
• Analyze the user requirements (new / change requests) and develop solutions for ETL implementation.
• Follow the Microsoft framework
• Understand the existing data source setup and plan for ETL using SSIS and SQL server.
• Implementing and maintaining ETL process in platform recommended by the client using SSIS
• Monitoring the performance of the ETL jobs in the Platform and providing recommendations 
• Perform batch and real-time production support
• Design, build, and test data transformation jobs, including the modeling of very large data sets.
• Identify and implement the most efficient ways of performing data transformation tasks using best practice methods and tooling.
• Prepare and maintain documentation such as business requirements documents, design specifications, and test cases.
• Work with stakeholders (including data team leads and front-line managers) to understand business requirements and translate these into technical specifications.
• Review the work of other ETL developers and provide feedback and suggestions on areas for improvement and optimization.
• Contribute to the design and implementation of data model and ETL framework.

Skills on Resume: 

• Data Modeling (Hard Skills)
• Ad Hoc Analysis (Hard Skills)
• Incident Remediation (Soft Skills)
• Service Improvement (Soft Skills)
• ETL Development (Hard Skills)
• Performance Monitoring (Hard Skills)
• Data Transformation (Hard Skills)
• Requirement Analysis (Soft Skills)